Re: [sqlite] Auto index with wrong number of entries

Good idea. The result was : ok Of note, we found in our dump and import duplicate 4 entries that violated uniqueness of the primary key. (2 entries of 4 different primary keys, with only 1 other field having a different int.) We identified which one belongs and commented out the others. How did

Re: [sqlite] Auto index with wrong number of entries

On 29 Jun 2011, at 2:04pm, Adam DeVita wrote: > On Tue, Jun 28, 2011 at 11:34 AM, Simon Slavin wrote: > >> Use the sqlite3 command-line shell to dump the database to SQL commands, >> then create a new database by reading it back in. >> >> While the data is in the SQL

Re: [sqlite] Auto index with wrong number of entries

Success! On Tue, Jun 28, 2011 at 11:34 AM, Simon Slavin wrote: > > On 28 Jun 2011, at 4:22pm, Adam DeVita wrote: > > > I can see the data that I want to export. How do I fix these indexes? > > Use the sqlite3 command-line shell to dump the database to SQL commands, >

Re: [sqlite] Auto index with wrong number of entries

On 28 Jun 2011, at 4:22pm, Adam DeVita wrote: > I can see the data that I want to export. How do I fix these indexes? Use the sqlite3 command-line shell to dump the database to SQL commands, then create a new database by reading it back in. While the data is in the SQL command file, you can

[sqlite] Auto index with wrong number of entries

Good day, Following a data collection & reporting error from a workstation, I have found that pragma integrity_check reported that 2 of my tables have a few thousand entries missing in their auto indexes. wrong number of entries in index sqlite_auto_index_tablename_1 rowid 87973 missing from