http://www.sqlite.org/src/info/42a11e7464
On Wed, Nov 6, 2013 at 3:48 PM, RSmith <rsm...@rsweb.co.za> wrote: > Sorry to be a bother again, but no replies on this thread yet, and I'm > still getting un-importable result sets from the sqlite3_analyzer.exe > program. > > It's not exactly a high-profile bug, and I could just use a replace macro > of sorts, but I'd rather it work as intended. I'm thinking this would be an > easy fix, but may be very wrong - either way, kindly let us know if a fix > is on the table or not. > > Thanks! > Ryan > > > > On 2013/11/02 09:53, RSmith wrote: > >> Hi there, >> >> I use the sqlite3_analyzer.exe app get some data about tables (It's very >> useful by the way - thanks.) >> >> The newest version downloaded some days ago gave me import errors for the >> produced file, so I tried loading it manually, and then got the SQL which >> follows for one of my small DB files. The Object names in the Values seem >> to be unquoted, which is causing the failure for me: >> >> /* >> ---- Removed lots of non-importing stats above this line ---- >> ************************************************************ >> ******************* >> The entire text of this report can be sourced into any SQL database >> engine for further analysis. All of the text above is an SQL comment. >> The data used to generate this report follows: >> */ >> BEGIN; >> CREATE TABLE space_used( >> name clob, -- Name of a table or index in the database file >> tblname clob, -- Name of associated table >> is_index boolean, -- TRUE if it is an index, false for a table >> nentry int, -- Number of entries in the BTree >> leaf_entries int, -- Number of leaf entries >> payload int, -- Total amount of data stored in this table or index >> ovfl_payload int, -- Total amount of data stored on overflow pages >> ovfl_cnt int, -- Number of entries that use overflow >> mx_payload int, -- Maximum payload size >> int_pages int, -- Number of interior pages used >> leaf_pages int, -- Number of leaf pages used >> ovfl_pages int, -- Number of overflow pages used >> int_unused int, -- Number of unused bytes on interior pages >> leaf_unused int, -- Number of unused bytes on primary pages >> ovfl_unused int, -- Number of unused bytes on overflow pages >> gap_cnt int, -- Number of gaps in the page layout >> compressed_size int -- Total bytes stored on disk >> ); >> INSERT INTO space_used VALUES(sqlite_master,sqlite_ >> master,0,14,12,2473,0,0,534,1,3,0,898,520,0,3,4096); >> INSERT INTO space_used VALUES(DBases,DBases,0,5,5, >> 644,0,0,181,0,1,0,0,349,0,0,1024); >> INSERT INTO space_used VALUES(sqlite_autoindex_ >> DBases_1,DBases,1,5,5,64,0,0,14,0,1,0,0,937,0,0,1024); >> INSERT INTO space_used VALUES(DBTables,DBTables,0,15, >> 10,4458,0,0,923,1,6,0,977,1589,0,1,7168); >> INSERT INTO space_used VALUES(DBHistory,DBHistory,0, >> 0,0,0,0,0,0,0,1,0,0,1016,0,0,1024); >> INSERT INTO space_used VALUES(DBSettings,DBSettings, >> 0,7,7,266,0,0,98,0,1,0,0,715,0,0,1024); >> INSERT INTO space_used VALUES(sqlite_autoindex_ >> DBSettings_1,DBSettings,1,7,7,139,0,0,24,0,1,0,0,856,0,0,1024); >> INSERT INTO space_used VALUES(Idx_DBases_DBName, >> DBases,1,5,5,64,0,0,14,0,1,0,0,937,0,0,1024); >> INSERT INTO space_used VALUES(Idx_DBTables_DBID, >> DBTables,1,10,10,145,0,0,22,0,1,0,0,841,0,0,1024); >> INSERT INTO space_used VALUES(Idx_DBHistory, >> DBHistory,1,0,0,0,0,0,0,0,1,0,0,1016,0,0,1024); >> COMMIT; >> >> ------------------------------------------------------------ >> --------------- >> >> Importing this gets the usual "no such column: sqlite_master" error, but >> it all works well if I go add quotes everywhere. >> If it is already fixed, or if there is something I'm doing wrong, kindly >> point me in the right direction. >> Thank you >> >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
