duckdb / duckdb/duckdb-sqlite

COPY from one sqlite db to another does not work

Open
#167 1 comment 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.