Kern Sibbald wrote: > On Monday 24 August 2009 02:17:29 Sven Hartge wrote: >> Kern Sibbald wrote:
>>> Based on the information you provided below, I have reopened the bug >>> report and posted my suggested fix. Sorry that I missed the fact that >>> the Bacula developers added the offending "AUTOINCREMENT". I would >>> appreciate a confirmation to the bug report whether or not my suggested >>> fix works. >> I will be able to test these fixes this Monday. >> But since I came to the same conclusion WRT sed as you did (see >> <http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=542810#10>), I am >> positive this should work as intended. > OK, thanks. Good luck with the testing. I manually converted a sqlite2 database into a sqlite3 database using the following command: sqlite /var/lib/bacula/bacula.db .dump | sed 's/ INTEGER UNSIGNED AUTOINCREMENT,/ INTEGER,/' | sqlite3 /tmp/bacula-test.db Then I tested a SQL command like the one bacula would use to insert a file into the Filename table: [...] 2303708|1250979390.27316_0.ds9:2, 2303709|1250964997.6658_0.ds9:2, 2303710|1250961605.29727_0.ds9:2,S 2303711|wireshark-common.templates 2303712|wireshark-common.postrm 2303713|wireshark-common.config sqlite> insert into Filename (name) VALUES ('asdfghjkl'); sqlite> select * from Filename where name like 'asdfghjkl'; 2303714|asdfghjkl As you can see, it gets added correctly with autoincremented FilenameId. Grüße, Sven. -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
