(also see http://trac.edgewall.org/ticket/9885)
this is reproducable on:
CentOS 5.5 (x86_64)
sqlite 3.3.6-5
create a file 'testdump.txt' with:
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE test( t text );
INSERT INTO "test" VALUES(' -------------
/
/
-------------');
COMMIT;
Load it into a new db with:
cat testdump.txt | sqlite3 ttt
And dump it with:
sqlite3 ttt .dump > testdump2.txt
Now compare the 2 files:
diff -u testdump.txt testdump2.txt
And see:
-PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE test( t text );
INSERT INTO "test" VALUES(' -------------
- /
- /
+;
+;
-------------');
COMMIT;
The diff on the PRAGMA line is not really relevant, but the other 2 lines are!
grtz
--
Ferry Huberts
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
