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]
