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

Reply via email to