On May 24, 2019 2:22:46 p.m. EDT, "J. King" <jk...@jkingweb.ca> wrote: >First, a documentation bug: > ><https://sqlite.org/pragma.html#pragma_foreign_key_list> does not >indicate that a schema may in fact be prepended to the pragma the same >as its siblings. > >Second, the following is surprising: > >SQLite version 3.28.0 2019-04-16 19:49:53 >Enter ".help" for usage hints. >Connected to a transient in-memory database. >Use ".open FILENAME" to reopen on a persistent database. >sqlite> create table other (a); >sqlite> create temp table t(a references other(a)); >sqlite> create table t(a); >sqlite> pragma foreign_key_list(t); >0|0|other|a|a|NO ACTION|NO ACTION|NONE > >Surely it should not be printing anything? > >-- >J. King >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
After further experimention and re-reading the documentation I realize SQLite is working as intended. The documentation error stands, however. -- J. King _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users