COPY from one sqlite db to another does not work
- Dominant language
- C
- Stars
- 291
- Forks
- 45
- Avg merge
- 10h 13m
- Merged PRs (30d)
- 18
Description
### What happens?
When copying from one sqlite db to another, an error is thrown:
```console
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
```sql
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?
- [x] 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?
- [x] I agree
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.