What happens?

Is there any difference in attach syntax in version 1.2?

.open "mydb.db";
create table mytable (C1 VARCHAR(10));
insert into mytable values ('a');
select * from mytable; -- 1 row
attach 'mynewdb.db' as TOMERGE;
create table TOMERGE.mytable (C1 VARCHAR(10));
insert into TOMERGE.mytable SELECT * FROM mytable;
select * from TOMERGE.mytable; -- no rows: error!
DETACH TOMERGE;

To Reproduce

Previous stable version was working

OS:

Windows 10

DuckDB Version:

1.2

DuckDB Client:

command line

Hardware:

No response

Full Name:

L. Brasio

Affiliation:

none

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