SELECT rowid FROM (mytable) WHERE (mystuff)
returns
37 identical rows(!) where Rowid = 1
Alessandro
From:
a.azzol...@custom.it
To:
<sqlite-users@sqlite.org>
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 <d...@sqlite.org>
To:
General Discussion of SQLite Database <sqlite-users@sqlite.org>
Date:
22/08/2011 16.11
Subject:
Re: [sqlite] Autoincrement failure
On Mon, Aug 22, 2011 at 9:56 AM, <a.azzol...@custom.it> 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
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
