Simon, On Mon, Dec 3, 2012 at 11:03 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 3 Dec 2012, at 6:53pm, Igor Korot <ikoro...@gmail.com> wrote: > >> Yes, using standard sqlite3 shell from command prompt in Windows 7 64-bit. >> After .dump/.read no queries to the table in question produced output. >> >> When restarted the shell everything worked. > > I've not come across that before. Try > > .timer ON > SELECT command > .dump command > SELECT command > .read command > SELECT command > > Do you get timings for all the commands including the last SELECT ?
Here is the session: sqlite> CREATE TABLE test(id1 integer, id2 double); sqlite> INSERT INTO test( 1, 1.0 ); Error: near "1": syntax error sqlite> INSERT INTO test VALUES( 1, 1.0 ); sqlite> INSERT INTO test VALUES( 2, 2.0 ); sqlite> INSERT INTO test VALUES( 3, 3.0 ); sqlite> .timer ON sqlite> SELECT * FROM test; 1|1.0 2|2.0 3|3.0 CPU Time: user 0.000000 sys 0.000000 .output testdump.log .dump test sqlite> SELECT * FROM test; CPU Time: user 0.000000 sys 0.000000 sqlite> DROP TABLE test; CPU Time: user 0.000000 sys 0.000000 sqlite> .read testdump.log CPU Time: user 0.000000 sys 0.000000 CPU Time: user 0.000000 sys 0.000000 CPU Time: user 0.000000 sys 0.015600 CPU Time: user 0.000000 sys 0.000000 CPU Time: user 0.000000 sys 0.000000 CPU Time: user 0.000000 sys 0.000000 CPU Time: user 0.000000 sys 0.015600 Error: incomplete SQL: 1|1.0 2|2.0 3|3.0 sqlite> SELECT * FROM test; CPU Time: user 0.000000 sys 0.000000 sqlite> I didn't get errors when I did that with my table. Other than that its all the same. > > Might also be interesting to type yourself a short text file with just one > INSERT or DELETE command in and see whether that problem happens for all > files or is related to the kind of file produced by .dump . That's will be the next step. Lets' first analyze the output above. Thank you. > > Simon. > _______________________________________________ > 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
