Bugs in foreign_key_list pragma

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Bugs in foreign_key_list pragma

J. King-3
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

Re: Bugs in foreign_key_list pragma

J. King-3
On May 24, 2019 2:22:46 p.m. EDT, "J. King" <[hidden email]> 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
>[hidden email]
>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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users