Re: [sqlite] Bug Report - Analyzer app

2013-11-06 Thread RSmith 

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

Re: [sqlite] Bug Report - Analyzer app

2013-11-06 Thread Richard Hipp 
http://www.sqlite.org/src/info/42a11e7464


On Wed, Nov 6, 2013 at 3:48 PM, RSmith  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

2013-11-06 Thread RSmith 
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

[sqlite] Bug Report - Analyzer app

2013-11-02 Thread RSmith 

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