What happens?

When creating a type in a different schema, I cannot seem to reference it across schemas

To Reproduce

CREATE SCHEMA s;
CREATE TYPE s.u AS STRUCT (a int, b int);
-- This works
CREATE TABLE s.t (
  u s.u
);

-- This doesn't work
CREATE TABLE main.t (
  u s.u
);

The error message is kind of ironic:

Catalog Error: Type with name u does not exist!
Did you mean "s.u"?

Related:

• Can't qualify a user defined type reference #8836

OS:

Microsoft Windows [Version 10.0.22631.4169]

DuckDB Version:

1.1.0

DuckDB Client:

JDBC

Hardware:

No response

Full Name:

Lukas Eder

Affiliation:

Data Geekery

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have tested with a stable release

Did you include all relevant data sets for reproducing the issue?

Yes

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

• Yes, I have