Should be fixed now. Thanks for the bug report. On 6/26/17, Paul Sanderson <sandersonforens...@gmail.com> wrote: > https://sqlite.org/dbstat.html > > The DBStat web page defines that schema of the virtual table as follows > with path defined as an integer > > CREATE TABLE dbstat( > name STRING, -- Name of table or index > path INTEGER, -- Path to page from root > pageno INTEGER, -- Page number > pagetype STRING, -- 'internal', 'leaf' or 'overflow' > ncell INTEGER, -- Cells on page (0 for overflow) > payload INTEGER, -- Bytes of payload on this page > unused INTEGER, -- Bytes of unused space on this page > mx_payload INTEGER, -- Largest payload size of all cells on this page > pgoffset INTEGER, -- Offset of page in file > pgsize INTEGER, -- Size of the page > schema TEXT HIDDEN -- The database being analyzed > ); > > the sqlite3.c source shows it correctly with path defined as TEXT > > #define VTAB_SCHEMA > \ > "CREATE TABLE xx( " > \ > " name TEXT, /* Name of table or index */" > \ > " path TEXT, /* Path to page from root */" > \ > " pageno INTEGER, /* Page number */" > \ > " pagetype TEXT, /* 'internal', 'leaf' or 'overflow' */" > \ > " ncell INTEGER, /* Cells on page (0 for overflow) */" > \ > " payload INTEGER, /* Bytes of payload on this page */" > \ > " unused INTEGER, /* Bytes of unused space on this page */" > \ > " mx_payload INTEGER, /* Largest payload size of all cells */" > \ > " pgoffset INTEGER, /* Offset of page in file */" > \ > " pgsize INTEGER, /* Size of the page */" > \ > " schema TEXT HIDDEN /* Database schema being analyzed */" > \ > ");" > > > > > > Paul > www.sandersonforensics.com > skype: r3scue193 > twitter: @sandersonforens > Tel +44 (0)1326 572786 > http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit > -Forensic Toolkit for SQLite > email from a work address for a fully functional demo licence > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
-- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users