I can confirm that it also doesn’t work with SQLite version 3.24.0 on a completely different machine.
> On Feb 27, 2019, at 9:23 AM, Joshua Thomas Wise <joshuathomasw...@gmail.com> > wrote: > > Joshuas-MBP:sqldark josh$ sqlite3 > SQLite version 3.25.0 2018-09-15 04:01:47 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> SELECT sqlite_version(); > 3.25.0 > sqlite> ATTACH ':memory:' AS 'information_schema'; > sqlite> CREATE VIEW information_schema.schemata(schema_name) AS > ...> SELECT name FROM pragma_database_list(); > sqlite> select * from schemata; > Error: no such table: information_schema.pragma_database_list > sqlite> select * from pragma_database_list(); > 0|main| > 2|information_schema| > > It worked when using `pragma_database_list()` directly, but not from inside > the view. > > > >> On Feb 26, 2019, at 9:26 PM, Keith Medcalf <kmedc...@dessus.com >> <mailto:kmedc...@dessus.com>> wrote: >> >> >> Unable to reproduce: >> >>> sqlite >> SQLite version 3.28.0 2019-02-25 18:43:54 >> Enter ".help" for usage hints. >> Connected to a transient in-memory database. >> Use ".open FILENAME" to reopen on a persistent database. >> sqlite> ATTACH ':memory:' AS 'information_schema'; >> sqlite> CREATE VIEW information_schema.schemata(schema_name) AS >> ...> SELECT name FROM pragma_database_list(); >> sqlite> >> sqlite> select * from schemata; >> main >> information_schema >> sqlite> .exit >> >> What version of SQLite are you using? >> What do the following commands do? >> >> pragma database_list; >> >> select * from pragma_database_list(); >> >> >> --- >> 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- >>> boun...@mailinglists.sqlite.org <mailto:boun...@mailinglists.sqlite.org>] >>> On Behalf Of Joshua Thomas Wise >>> Sent: Tuesday, 26 February, 2019 19:06 >>> To: sqlite-users@mailinglists.sqlite.org >>> <mailto:sqlite-users@mailinglists.sqlite.org> >>> Subject: [sqlite] Documentation is lying to me >>> >>> In this SQLite3 documentation >>> (https://www.sqlite.org/pragma.html#pragfunc >>> <https://www.sqlite.org/pragma.html#pragfunc>), it says that >>> information_schema could be implemented by doing something like this: >>> >>> ATTACH ':memory:' AS 'information_schema'; >>> CREATE VIEW information_schema.schemata(schema_name) AS >>> SELECT name FROM pragma_database_list(); >>> >>> However, when attempting to do this, we get an error: "no such table: >>> information_schema.pragma_database_list”. >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users@mailinglists.sqlite.org >>> <mailto:sqlite-users@mailinglists.sqlite.org> >>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> <mailto:sqlite-users@mailinglists.sqlite.org> >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
