COPY from one sqlite db to another does not work

[guillesd]

What happens?

When copying from one sqlite db to another, an error is thrown:

Binder Error:
SQLite databases do not support creating new schemas

This doesn't make sense since you are copying from another sqlite db which doesn't have any schemas so COPY should not create any new schema in the first place

To Reproduce

ATTACH 'sqlite:db.duckdb' AS db (READ_ONLY);
ATTACH 'sqlite:backup.duckdb' AS backup;
COPY FROM DATABASE db TO backup;

OS:

MacOS

SQLite Version:

1.4.2

DuckDB Version:

1.4.2

DuckDB Client:

CLI

Full Name:

Guillermo

Affiliation:

DuckDB Labs

Have you tried this on the latest main branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree