duckdb / duckdb/duckdb-sqlite

`ATTACH` fails with `~/some-db.sqlite3` path expansion

Open
#145 3 comments 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?

```
[nix-shell:~]$ duckdb
v1.2.2 7c039464e4
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D INSTALL sqlite;
D LOAD sqlite;
D ATTACH '~/netflix.db' AS netflix (TYPE SQLITE);
D .tables
Invalid Error:
Unable to open database "~/netflix.db": unable to open database file
```

```
[nix-shell:~]$ sqlite3 ~/netflix.db
SQLite version 3.45.3 2024-04-15 13:34:05
Enter ".help" for usage hints.
sqlite> .tables
Netflix
sqlite> select * from Netflix limit 10;
2430508|8548|3|2005-10-31
1895600|8548|2|2005-12-12
2285825|8548|2|2005-11-03
1131364|8548|3|2005-11-25
1227322|8548|1|2005-11-22
902279|8548|5|2005-11-30
95673|8548|3|2005-10-12
1203779|8548|3|2005-11-21
890085|8548|1|2005-10-13
1888522|8548|3|2005-10-12
```

### To Reproduce

Download and unzip the dataset from https://archive.org/details/netflixprize-dataset-sql.

### OS:

x64

### SQLite Version:

3.45.3 works (unkown which version created it)

### DuckDB Version:

v1.2.2

### DuckDB Client:

CLI

### Full Name:

Aryeh Hillman

### Affiliation:

self

### 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.