On Mon, Aug 22, 2011 at 11:17 AM, <[email protected]> wrote: > SELECT rowid FROM (mytable) WHERE (mystuff) > > returns > > 37 identical rows(!) where Rowid = 1 >
What is your schema? If you run "PRAGMA integrity_check"? > > > > Alessandro > > > > > From: > [email protected] > To: > <[email protected]> > Date: > 22/08/2011 16.26 > Subject: > Re: [sqlite] Autoincrement failure > > > > sqlite> .dump sqlite_sequence > PRAGMA foreign_keys=OFF; > BEGIN TRANSACTION; > COMMIT; > sqlite> > > > Any idea? > > Thanks > Alessandro > > > > From: > Richard Hipp <[email protected]> > To: > General Discussion of SQLite Database <[email protected]> > Date: > 22/08/2011 16.11 > Subject: > Re: [sqlite] Autoincrement failure > > > > On Mon, Aug 22, 2011 at 9:56 AM, <[email protected]> wrote: > > > Hallo, > > > > Have you ever seen a SQLite3 DB file with autoincrement algoritm broken? > > Every new record seems to be added with rowid=1 overwriting existing > > info... > > > > Any idea about the causes of this issue > > and about extracting lost data (if present)? > > > > Please run from the sqlite3.exe shell: > > .dump sqlite_sequence > > Tell us what you see. > > > > > > Many thanks > > Alessandro > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
