[sqlite] [BUG] reading dump file containing lines (regex) '[[:space:]]+/$' gives incorrect result

[Ferry Huberts]

(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