And how do you compile sqlite so it has the extension? The error I posted was actually with a loaded db, so that's not it.
I must be compiling or loading the extension wrong somehow. Also, I saw that it requires sqlite_db[vtab? not sure] and that table is also missing Wout. On Thu, Dec 13, 2018 at 12:43 AM Keith Medcalf <kmedc...@dessus.com> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
