There is nothing unusual about the output - it looks exactly as expected (without knowing what is inside the tables referenced).
As Igor already asked: Is there anything specific you find unusual? Is it the stats block that confuses you, but which you specifically requested with the ".stats on" command? Is it the fact that your version_control table is empty? Is it the fact that the .tables command does not work in upper case? Give us a clue! :) On 2015-02-24 07:42 PM, Jonathan Camilleri wrote: > Unusual output when trying a SQL Select statement from the command line > > SQLite version 3.8.8.2 2015-01-30 14:30:45 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> .open taxi-invoicing-db > sqlite> .stats on > sqlite> .tables > Address Invoice VERSION_CONTROL > Customer InvoiceLine > sqlite> select * from version_control; > Memory Used: 80840 (max 86816) bytes > Number of Outstanding Allocations: 182 (max 193) > Number of Pcache Overflow Bytes: 6904 (max 6904) bytes > Number of Scratch Overflow Bytes: 0 (max 0) bytes > Largest Allocation: 64000 bytes > Largest Pcache Allocation: 1176 bytes > Largest Scratch Allocation: 0 bytes > Lookaside Slots Used: 10 (max 54) > Successful lookaside attempts: 173 > Lookaside failures due to size: 41 > Lookaside failures due to OOM: 0 > Pager Heap Usage: 7508 bytes > Page cache hits: 7 > Page cache misses: 6 > Page cache writes: 0 > Schema Heap Usage: 4032 bytes > Statement Heap/Lookaside Usage: 2368 bytes > Fullscan Steps: 0 > Sort Operations: 0 > Autoindex Inserts: 0 > Virtual Machine Steps: 8 > sqlite> select count(1) from version_control; > 0 > Memory Used: 81824 (max 86816) bytes > Number of Outstanding Allocations: 184 (max 193) > Number of Pcache Overflow Bytes: 8080 (max 8080) bytes > Number of Scratch Overflow Bytes: 0 (max 0) bytes > Largest Allocation: 64000 bytes > Largest Pcache Allocation: 1176 bytes > Largest Scratch Allocation: 0 bytes > Lookaside Slots Used: 6 (max 54) > Successful lookaside attempts: 193 > Lookaside failures due to size: 46 > Lookaside failures due to OOM: 0 > Pager Heap Usage: 8672 bytes > Page cache hits: 1 > Page cache misses: 1 > Page cache writes: 0 > Schema Heap Usage: 4040 bytes > Statement Heap/Lookaside Usage: 1616 bytes > Fullscan Steps: 0 > Sort Operations: 0 > Autoindex Inserts: 0 > Virtual Machine Steps: 12 > sqlite> .tabls > Error: unknown command or invalid arguments: "tabls". Enter ".help" for > help > sqlite> .tables > Address Invoice VERSION_CONTROL > Customer InvoiceLine > sqlite> .vfsname ?AUX? > sqlite> > sqlite> .TABLES > Error: unknown command or invalid arguments: "TABLES". Enter ".help" for > help > sqlite> .tables > Address Invoice VERSION_CONTROL > Customer InvoiceLine > sqlite> select * from VERSION_CONTROL; > Memory Used: 82024 (max 86816) bytes > Number of Outstanding Allocations: 184 (max 196) > Number of Pcache Overflow Bytes: 8080 (max 8080) bytes > Number of Scratch Overflow Bytes: 0 (max 0) bytes > Largest Allocation: 64000 bytes > Largest Pcache Allocation: 1176 bytes > Largest Scratch Allocation: 0 bytes > Lookaside Slots Used: 10 (max 54) > Successful lookaside attempts: 448 > Lookaside failures due to size: 86 > Lookaside failures due to OOM: 0 > Pager Heap Usage: 8672 bytes > Page cache hits: 12 > Page cache misses: 0 > Page cache writes: 0 > Schema Heap Usage: 4040 bytes > Statement Heap/Lookaside Usage: 2368 bytes > Fullscan Steps: 0 > Sort Operations: 0 > Autoindex Inserts: 0 > Virtual Machine Steps: 8 > sqlite> > > See online doc at http://www.sqlite.org/cli.html > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
