SQLite hangs on 64-bit integer

[poundifdef]

What happens?

When performing any query against a table with a 64-bit integer (in my case, a snowflake id), the operation hangs.

To Reproduce

1. Create SQLite db

$ sqlite3 db.sqlite
sqlite> CREATE TABLE t (id integer primary key);
sqlite> INSERT INTO t VALUES (1797657063271174144);

2. Open the SQLite file with the DuckDB CLI

The following hangs (it never returns.)

$ duckdb db.sqlite
D select * from t;

(...hangs...)

OS:

OSX M3

SQLite Version:

3.43.2

DuckDB Version:

v1.0.0 1f98600c2c

DuckDB Client:

cli

Full Name:

Jay Goel

Affiliation:

Scratch Data

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

[carlopi]

Thanks! I do reproduce, we will take a look