SQLite: Expected integer, got something else #15
Description
Using duckdb 0.5.1 on macOS 12.6.1 (Monterey), I attempt to select an INTEGER column from a SQLite database and get Error: Invalid Error: Expected integer, got something else
Details:
- Download the macOS installer from https://duckdb.org/docs/installation/ and unzip it
- Copy the resulting binary to my test directory
- Download a copy of the chinook SQLite database to the same directory
- Start the program with
./duckdb, then install/load sqlite_scanner (I don't know where these come from, nor their version) and open the SQLite database
Result: TEXT field works as expected; INTEGER field gives "Expected integer, got something else"
Here is the CLI session:
?137 pqtest % ./duckdb
v0.5.1 7c111322d
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D INSTALL sqlite_scanner;
D LOAD sqlite_scanner;
D CALL sqlite_attach('chinook.sqlite');
D select * from albums limit 5;
Error: Invalid Error: Expected integer, got something else
D select title from albums limit 5;
┌───────────────────────────────────────┐
│ title │
├───────────────────────────────────────┤
│ title │
│ For Those About To Rock We Salute You │
│ Balls to the Wall │
│ Restless and Wild │
│ Let There Be Rock │
└───────────────────────────────────────┘
D select album_id from albums limit 5;
Error: Invalid Error: Expected integer, got something else