I have the extension compiled in. When a database does not exist I get: SQLite version 3.27.0 2018-12-10 01:48:29 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> select * from sqlite_btreeinfo; Error: not an error
However, when a database is loaded is works fine: sqlite> .open tz.db sqlite> select * from sqlite_btreeinfo; table|sqlite_master|sqlite_master|1||1|23|1|1| table|sqlite_stat1|sqlite_stat1|2|CREATE TABLE sqlite_stat1(tbl,idx,stat)|1|16|1|1| table|sqlite_stat4|sqlite_stat4|3|CREATE TABLE sqlite_stat4(tbl,idx,neq,nlt,ndlt,sample)|1|1|1|1| table|tz_geopoly_rowid|tz_geopoly_rowid|4|CREATE TABLE "tz_geopoly_rowid"(rowid INTEGER PRIMARY KEY,nodeno,a0,a1)|1|2028|507|2| table|tz_geopoly_node|tz_geopoly_node|5|CREATE TABLE "tz_geopoly_node"(nodeno INTEGER PRIMARY KEY,data)|1|44|11|2| table|tz_geopoly_parent|tz_geopoly_parent|6|CREATE TABLE "tz_geopoly_parent"(nodeno INTEGER PRIMARY KEY,parentnode)|1|33|1|1| table|TZ_Version|TZ_Version|7|CREATE TABLE TZ_Version ( Version text collate nocase, PIPVersion text collate nocase )|1|2|1|1| table|TZ_Countries|TZ_Countries|8|CREATE TABLE TZ_Countries ( Code text not null collate nocase primary key, Country text not null collate nocase unique ) WITHOUT ROWID|0|34|2|2| index|sqlite_autoindex_TZ_Countries_2|TZ_Countries|9||0|32|2|2| table|TZ_Zones|TZ_Zones|10|CREATE TABLE TZ_Zones ( ID INTEGER PRIMARY KEY, Country_Code text collate nocase references TZ_Countries(Code), Area text collate nocase, Location text collate nocase, City text collate nocase, Zone text not null collate nocase unique )|1|658|7|2| index|sqlite_autoindex_TZ_Zones_1|TZ_Zones|11||0|720|4|2| table|TZ_ZoneData|TZ_ZoneData|12|CREATE TABLE TZ_ZoneData ( Zone_ID integer not null references TZ_Zones(ID), Abbreviation text collate nocase not null, StartTime integer not null, Offset integer not null, isDST integer not null )|1|35088|204|2| index|TZ_Country|TZ_Countries|13|CREATE INDEX TZ_Country on TZ_Countries (Country, Code)|0|32|2|2| index|TZ_ZonesCountry|TZ_Zones|14|CREATE INDEX TZ_ZonesCountry on TZ_Zones (Country_Code)|0|210|2|2| index|TZ_ZonesArea|TZ_Zones|15|CREATE INDEX TZ_ZonesArea on TZ_Zones (Area)|0|508|2|2| index|TZ_ZonesLocation|TZ_Zones|16|CREATE INDEX TZ_ZonesLocation on TZ_Zones (Location)|0|774|3|2| index|TZ_ZonesCity|TZ_Zones|17|CREATE INDEX TZ_ZonesCity on TZ_Zones (City)|0|438|2|2| index|TZ_ZoneDataID|TZ_ZoneData|18|CREATE INDEX TZ_ZoneDataID on TZ_ZoneData (Zone_ID)|0|36401|89|2| index|TZ_ZoneStart|TZ_ZoneData|19|CREATE INDEX TZ_ZoneStart on TZ_ZoneData (Zone_ID, StartTime, Offset, Abbreviation)|0|14616|84|3| index|TZ_ZoneOffset|TZ_ZoneData|20|CREATE INDEX TZ_ZoneOffset on TZ_ZoneData (Zone_ID, StartTime + Offset, Offset)|0|35903|161|2| sqlite> --- 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] On Behalf Of Wout Mertens >Sent: Wednesday, 12 December, 2018 13:41 >To: SQLite mailing list >Subject: [sqlite] sqlite_btreeinfo > >I can't figure out how to get access to the sqlite_btreeinfo vtable >that >was added in 3.22 :-( The only documentation is the C file and there >doesn't seem to be a compile flag for it. > >I went and downloaded the file from >https://sqlite.org/src/artifact/4f0ebf278f46e68e, then compiled it on >on >macOS with > >$ gcc -g -fPIC -dynamiclib btreeinfo.c -o btreeinfo.dylib >btreeinfo.c:414:5: warning: excess elements in struct initializer > 0 /* xShadowName */ > ^ >1 warning generated. > >and tried loading it but: > >sqlite> .load btreeinfo.dylib >sqlite> select * from sqlite_btreeinfo; >Error: no such table: sqlite_btreeinfo > >:-( > >Wout. >_______________________________________________ >sqlite-users mailing list >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