forward slash at end-of-line in code block does not migrate

[ferry.huberts@…]

if I create a code block (drawing) like

               -------------
              /
             /
-------------

and do

sqlite3 "db/trac.db" ".dump" > dimpfile

to save the trac db (for migration)

and then do a

cat dumpfile | sqlite3 "${tracDb}"

then the figure becomes

               -------------
;
;
-------------

CentOS 5.5 (x86_64) trac 0.10.5-3.el5 sqlite 3.3.6-5

[Christian Boos]

It looks more like a sqlite issue…

Can you try the following check? Given a file testdump.txt containing:

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE test( t text );
INSERT INTO "test" VALUES('               -------------
              /
             /
-------------');
COMMIT;

Load this into a new db:

$ cat testdump.txt | sqlite3 ttt

And dump it back:

$  sqlite3 ttt .dump > testdump2.txt

Then, what does diff -u testdump.txt testdump2.txt give you?

[anonymous]

diff -u testdump.txt testdump2.txt

gives me

-PRAGMA foreign_keys=OFF;
 BEGIN TRANSACTION;
 CREATE TABLE test( t text );
 INSERT INTO "test" VALUES('               -------------
-              /
-             /
+;
+;
 -------------');
 COMMIT;

[Christian Boos]

Well, it's indeed an issue with SQLite, not with Trac. I've been able to reproduce this by recompiling a sqlite-3.3.6 version. However, I couldn't find that version on sqlite.org, so I had to pick it up from a … CentOS .rpm, so I can't tell for sure it's genuine SQLite bug or one introduced by CentOS modifications.

The ​release notes of 3.3.9 talks about some fixes in .dump, so that might be related.

In any case, you should upgrade to a ​newer version of SQLite which doesn't have the problem (I tested 3.6.6 which worked, for example).

[anonymous]

I create a RHEL bug report: ​https://bugzilla.redhat.com/show_bug.cgi?id=659349

[anonymous]

I also created a CentOS bug report: ​http://bugs.centos.org/view.php?id=4654

And now I'm adding some text here to get through the spam filter