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
