Nor does there appear to be "column names" ... and this with the current tip of the trunk.
SQLite version 3.23.0 2018-03-16 07:48:43 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. 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: foreign key mismatch - "t1" referencing "t" sqlite> pragma foreign_key_check(t1); Error: foreign key mismatch - "t1" referencing "t" sqlite> pragma foreign_key_check(t); sqlite> .head on sqlite> pragma foreign_key_check; Error: foreign key mismatch - "t1" referencing "t" sqlite> select * from pragma_foreign_key_check; Error: foreign key mismatch - "t1" referencing "t" sqlite> .mode col sqlite> select * from pragma_foreign_key_check; Error: foreign key mismatch - "t1" referencing "t" sqlite> .head on sqlite> select * from pragma_foreign_key_check; Error: foreign key mismatch - "t1" referencing "t" sqlite> select * from pragma_foreign_key_check(); Error: foreign key mismatch - "t1" referencing "t" sqlite> pragma compile_options; compile_options ------------------------- ALLOW_COVERING_INDEX_SCAN ALLOW_URI_AUTHORITY COMPILER=gcc-7.2.0 DEFAULT_CACHE_SIZE=262144 DEFAULT_FOREIGN_KEYS DEFAULT_MMAP_SIZE=0 DEFAULT_PAGE_SIZE=4096 DEFAULT_PROXYDIR_PERMISSI DEFAULT_RECURSIVE_TRIGGER DEFAULT_WAL_AUTOCHECKPOIN DEFAULT_WAL_SYNCHRONOUS=1 ENABLE_8_3_NAMES=1 ENABLE_API_ARMOR ENABLE_COLUMN_METADATA ENABLE_COSTMULT ENABLE_CURSOR_HINTS ENABLE_DBSTAT_VTAB ENABLE_FTS3 ENABLE_FTS3_PARENTHESIS ENABLE_FTS4 ENABLE_FTS5 ENABLE_JSON1 ENABLE_LOAD_EXTENSION ENABLE_LOCKING_STYLE=1 ENABLE_MEMORY_MANAGEMENT ENABLE_MEMSYS5 ENABLE_PREUPDATE_HOOK ENABLE_RBU ENABLE_RTREE ENABLE_SESSION ENABLE_STAT4 ENABLE_STMTVTAB EXTRA_INIT=core_init HAVE_ISNAN LIKE_DOESNT_MATCH_BLOBS MAX_ATTACHED=15 SOUNDEX STAT4_SAMPLES=64 TEMP_STORE=2 THREADSAFE=1 USE_URI WIN32_MALLOC sqlite> --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >[email protected]] On Behalf Of Mark Wagner >Sent: Saturday, 17 March, 2018 12:51 >To: SQLite mailing list >Subject: [sqlite] pragma foreign_key_check > >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 _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
