John Goerzen wrote: > Thanks for the report. I am initially unsure what to do about it > either, and have opened an upstream report at the above URL.
<http://bugs.bacula.org/view.php?id=1351> Quote from Kern Sibbald: | Converting from SQLite2 to SQLite3 is easy. You simply "export" or | dump the SQLite2 database to an ASCII file (example in the default | Bacula catalog backup script) then import it using SQLite3 (see | comments at the bottom of the Bacula catalog backup script) This is incorrect. Try to create a table with the following schema in sqlite3: CREATE TABLE Filename ( FilenameId INTEGER UNSIGNED AUTOINCREMENT, Name TEXT DEFAULT "", PRIMARY KEY(FilenameId) ); o...@ds9:/home/oweh > sqlite3 /tmp/test-db.db SQLite version 3.6.17 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE Filename ( ...> FilenameId INTEGER UNSIGNED AUTOINCREMENT, ...> Name TEXT DEFAULT "", ...> PRIMARY KEY(FilenameId) ...> ); SQL error: near "AUTOINCREMENT": syntax error sqlite> Only if I remove the "UNSIGNED AUTOINCREMENT" the table will be syntactically correct _and_ behave in the correct and intended way. Grüße, Sven. -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
