`ATTACH` fails with `~/some-db.sqlite3` path expansion
- 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.