I duplicated your problem on 3.6.23.1
But it works fine under 3.7.3
SQLite version 3.7.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> PRAGMA foreign_keys=OFF;
sqlite> BEGIN TRANSACTION;
sqlite> CREATE TABLE test( t text );
sqlite> INSERT INTO "test" VALUES(' -------------
...> /
...> /
...> -------------');
sqlite> COMMIT;
sqlite>
sqlite> .quit
D:\SQLite>echo .dump | sqlite3 test.db >test2.txt
D:\SQLite>diff test.txt test2.txt
D:\SQLite>
No difference...
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information Systems
________________________________
From: [email protected] on behalf of Ferry Huberts
Sent: Thu 12/2/2010 9:34 AM
To: [email protected]
Subject: EXTERNAL:[sqlite] [BUG] reading dump file containing lines (regex)
'[[:space:]]+/$' gives incorrect result
(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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
