TE TABLE t (id int primary key, value);
> sqlite> CREATE TABLE t1 (id integer primary key, v references t(value));
> sqlite> INSERT INTO t1 VALUES(1,1);
> sqlite> COMMIT;
> sqlite> pragma foreign_key_check;
> Error: foreign key mismatch - "t1" referencing
REATE TABLE t (id int primary key, value unique);
sqlite> CREATE TABLE t1 (id integer primary key, v references t(value));
sqlite> INSERT INTO t1 VALUES(1,1);
sqlite> COMMIT;
sqlite> pragma foreign_key_check;
t1|1|t|0
sqlite> .mode col
sqlite> .head on
sqlite> pragma foreign_k
e.
sqlite> PRAGMA foreign_keys=OFF;
sqlite> BEGIN TRANSACTION;
sqlite> CREATE TABLE t (id int primary key, value);
sqlite> CREATE TABLE t1 (id integer primary key, v references t(value));
sqlite> INSERT INTO t1 VALUES(1,1);
sqlite> COMMIT;
sqlite> pragma foreign_key_check;
Error:
Mark Wagner wrote:
> The documentation for foreign_key_check says I should be receiving 4
> columns per violation. I only seem to be getting 1.
>
> CREATE TABLE t (id int primary key, value);
> CREATE TABLE t1 (id integer primary key, v references t(value));
> sqlite> pra
TE TABLE t1 (id integer primary key, v references t(value));
INSERT INTO t1 VALUES(1,1);
COMMIT;
sqlite>
sqlite> pragma foreign_key_check;
Error: foreign key mismatch - "t1" referencing "t"
sqlite>
sqlite> pragma foreign_key_check(t1);
Error: foreign key mismat
5 matches
Mail list logo