Re: [sqlite] Bug Report - Analyzer app
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
Re: [sqlite] Bug Report - Analyzer app
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
Re: [sqlite] Bug Report - Analyzer app
Thank you kindly and forgive me for not seeing this earlier... It works perfectly. On 2013/11/06 22:53, Richard Hipp wrote: http://www.sqlite.org/src/info/42a11e7464 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Bug Report - Analyzer app
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