Edgewall Software
Modify

Opened 11 years ago

Closed 11 years ago

Last modified 11 years ago

#9885 closed defect (worksforme)

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

Reported by: ferry.huberts@… Owned by:
Priority: normal Milestone:
Component: general Version:
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

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

Attachments (0)

Change History (5)

comment:1 by Christian Boos, 11 years ago

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?

comment:2 by anonymous, 11 years ago

diff -u testdump.txt testdump2.txt

gives me

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

comment:3 by Christian Boos, 11 years ago

Resolution: worksforme
Status: newclosed

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).

Last edited 11 years ago by Christian Boos (previous) (diff)

comment:5 by anonymous, 11 years ago

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

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.