sqlite: cannot reference table due to type mismatch

[3bdallahz]

What happens?

Hi everyone,
I attach an sqlite in-memory database

I create two tables, the second one references the first one

I get this error

Binder Error: Failed to create foreign key: incompatible types between column "id" ("BIGINT") and column "t1_id" ("INTEGER")

To Reproduce

INSTALL sqlite;
LOAD sqlite;
ATTACH ':memory:' AS db2 (TYPE SQLITE);

use db2;

create table t1 (
id integer primary key,
name varchar
);

create table t2(
id integer primary key,
t1_id integer references t1(id)
);

OS:

macos

SQLite Version:

3.46.0

DuckDB Version:

v0.10.3

DuckDB Client:

cli

Affiliation:

no affiliation

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree