The documentation for foreign_key_check says I should be receiving 4 columns per violation. I only seem to be getting 1. Am I doing it wrong? Perhaps it's a version issue?
Thanks sqlite> .dump PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE t (id int primary key, value); CREATE 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 mismatch - "t1" referencing "t" sqlite> sqlite> .version SQLite 3.20.1 2017-08-24 16:21:36 8d3a7ea6c5690d6b7c3767558f4f01b511c55463e3f9e64506801fe9b74dce34 _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
