Package: sqlite3 Version: 3.5.9-3 Severity: minor I was trying to dump my f-spot photos.db as such:
$ sqlite3 ~/.gnome2/f-spot/photos.db .dump > /tmp/dump and it mostly works fine. However, it contains these statements: DELETE FROM sqlite_sequence; INSERT INTO "sqlite_sequence" VALUES('photos',3829); CREATE TABLE photos ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, ... ); which obviously fail when run in that order, since no previously created table in the dump has an AUTOINCREMENT column: $ sqlite3 /tmp/recovered.db < /tmp/dump SQL error near line 6333: no such table: sqlite_sequence SQL error near line 6334: no such table: sqlite_sequence Unfortunately, I'm not able to reproduce this with a newly created database, so it seems that my photos.db is somehow corrupt. Even if I re-create the exact same information by fixing the dump manually and running it through sqlite3, I get a database that sqlite3 .dump will dump in the right order. I can provide the bad photos.db (bzip2 is about 220K) privately to you or sqlite3 upstream on request, but would prefer to not post it publicly on the bts. -- System Information: Debian Release: lenny/sid APT prefers unstable APT policy: (500, 'unstable'), (1, 'experimental') Architecture: powerpc (ppc) Kernel: Linux 2.6.27-rc4-wl-15592-g32e8a98-dirty (PREEMPT) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages sqlite3 depends on: ii libc6 2.7-13 GNU C Library: Shared libraries ii libreadline5 5.2-3 GNU readline and history libraries ii libsqlite3-0 3.5.9-3 SQLite 3 shared library sqlite3 recommends no packages. Versions of packages sqlite3 suggests: pn sqlite3-doc <none> (no description available) -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]