Re: [sqlite] SQLite version 3.6.10 - Warning
On Fri, Jan 16, 2009 at 09:43:36AM +0100, Christophe Leske wrote: > sqlite> .o cl1.sql ^^ This says: send output of queries to a file called "cl1.sql". > sqlite> .dump cl1% And this says: dump the named table. > sqlite> select * from cl1; And the output of this will still go to a file called "cl1.sql". > sqlite> > > Also, a .show statement returns nothing either. It seems as if the > database does simply not exist anymore. Look: % sqlite3 /tmp/xdb SQLite version 3.6.9 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t(a); sqlite> insert into t values (1); sqlite> .o /tmp/xyz sqlite> .dump t sqlite> select * from t; sqlite> .show sqlite> .o stdout sqlite> select * from t; 1 sqlite> .dump t BEGIN TRANSACTION; CREATE TABLE t(a); INSERT INTO "t" VALUES(1); COMMIT; sqlite> .show echo: off explain: off headers: off mode: list nullvalue: "" output: stdout separator: "|" width: sqlite> ^D % sqlite3 /tmp/xdb SQLite version 3.6.9 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .dump t BEGIN TRANSACTION; CREATE TABLE t(a); INSERT INTO "t" VALUES(1); COMMIT; sqlite> ^D % Nico -- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.10 - Warning
> After you complete your ".dump" do: > > .output stdout > Ok, that was stupid, my apologies. Yet somehow this used to work i think... Still, when rereading the dumped table, it does not reread the values correctly for the rtree table. I am sorry, I must go now, I can provide further information on the 25th. Thank you for your patience, -- Christophe Leske www.multimedial.de - i...@multimedial.de http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.10 - Warning
On Jan 16, 2009, at 3:42 AM, Christophe Leske wrote: > >> Try instead: >> >>.dump cl1% > Apparently, this doesn´t help either. Once I tried to export the > table, the application refuses to show the entries in the table. > > The database i am opening here is correct, it holds data in cl1 > prior to opening it for this step here: > > Microsoft Windows XP [Version 5.1.2600] > (C) Copyright 1985-2001 Microsoft Corp. > > C:\Arbeit\Arbeit\__Projekte\2007\MMCD\SRC\globe\DB>sqlite3 > countries2.db > SQLite version 3.6.10 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .o cl1.sql > sqlite> .dump cl1% > sqlite> select * from cl1; > sqlite> > > Also, a .show statement returns nothing either. It seems as if the > database does simply not exist anymore. > Everything is still working normally. But the output is all going into the file named "cl1.sql", as you requested on the first line. After you complete your ".dump" do: .output stdout To cause output to go to the screen again. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.10 - Warning
On Jan 16, 2009, at 3:43 AM, Christophe Leske wrote: > > Do you want me to mail you the corrupted database for further > inspection? I also understand that this is not the right place for > bugreports eventually. No. Email me the original, uncorrupted database and instructions for how to make the corruption occur. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.10 - Warning
> Try instead: > > .dump cl1% Apparently, this doesn´t help either. Once I tried to export the table, the application refuses to show the entries in the table. The database i am opening here is correct, it holds data in cl1 prior to opening it for this step here: Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Arbeit\Arbeit\__Projekte\2007\MMCD\SRC\globe\DB>sqlite3 countries2.db SQLite version 3.6.10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .o cl1.sql sqlite> .dump cl1% sqlite> select * from cl1; sqlite> Also, a .show statement returns nothing either. It seems as if the database does simply not exist anymore. Furthermore, i got a corrupted version of the database here as the result of my operations as well - this used to be the same database than the one above, yet after exporting and reimporting the data for the cl1 table, it is now corrupted. C:\Arbeit\Arbeit\__Projekte\2007\MMCD\SRC\globe\DB>sqlite3 countries-corrupted.d b SQLite version 3.6.10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .s sqlite> .s cl1; sqlite> We also experience crashes with the new version, but this may be due to the component we are using (i am not sure it is supporting the new version of sqlite.dll) Do you want me to mail you the corrupted database for further inspection? I also understand that this is not the right place for bugreports eventually. Christophe Leske www.multimedial.de - i...@multimedial.de http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.10 - Warning
> Try instead: > > .dump cl1% Apparently, this doesn´t help either. Once I tried to export the table, the application refuses to show the entries in the table. The database i am opening here is correct, it holds data in cl1 prior to opening it for this step here: Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Arbeit\Arbeit\__Projekte\2007\MMCD\SRC\globe\DB>sqlite3 countries2.db SQLite version 3.6.10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .o cl1.sql sqlite> .dump cl1% sqlite> select * from cl1; sqlite> Also, a .show statement returns nothing either. It seems as if the database does simply not exist anymore. Furthermore, i got a corrupted version of the database here as the result of my operations as well - this used to be the same database than the one above, yet after exporting and reimporting the data for the cl1 table, it is now corrupted. C:\Arbeit\Arbeit\__Projekte\2007\MMCD\SRC\globe\DB>sqlite3 countries-corrupted.d b SQLite version 3.6.10 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .s sqlite> .s cl1; sqlite> We also experience crashes with the new version, but this may be due to the component we are using (i am not sure it is supporting the new version of sqlite.dll) Do you want me to mail you the corrupted database for further inspection? I also understand that this is not the right place for bugreports eventually. Christophe Leske www.multimedial.de - i...@multimedial.de http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.10 - Warning
On Jan 15, 2009, at 12:43 PM, Christophe Leske wrote: > Hi, > > if my findings are not mistaken, then the commandline executable of > the > new version has some serious problems: > > I have a database (which seems correct so far) from which I would like > to dump a table called "cl1" which is a virtual table using an rtree: > > sqlite> .o cl1.sql > sqlite> .d cl1 Try instead: .dump cl1% > > sqlite> drop table cl1; > SQL error: no such table: main.cl1_node > > After exporting the table, it seems that there is some corruption > going on? > > Also, when trying to import the data, the data is not read back > correctly (the number ordering gets out of whack). > > I am in the midst of signing off my project, but how can I > contribute ? > > -- > Christophe Leske > > www.multimedial.de - i...@multimedial.de > http://www.linkedin.com/in/multimedial > Lessingstr. 5 - 40227 Duesseldorf - Germany > 0211 261 32 12 - 0177 249 70 31 > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] SQLite version 3.6.10 - Warning
Hi, if my findings are not mistaken, then the commandline executable of the new version has some serious problems: I have a database (which seems correct so far) from which I would like to dump a table called "cl1" which is a virtual table using an rtree: sqlite> .o cl1.sql sqlite> .d cl1 sqlite> drop table cl1; SQL error: no such table: main.cl1_node After exporting the table, it seems that there is some corruption going on? Also, when trying to import the data, the data is not read back correctly (the number ordering gets out of whack). I am in the midst of signing off my project, but how can I contribute ? -- Christophe Leske www.multimedial.de - i...@multimedial.de http://www.linkedin.com/in/multimedial Lessingstr. 5 - 40227 Duesseldorf - Germany 0211 261 32 12 - 0177 249 70 31 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users