Re: [sqlite] Unique indexes apparently not working

Hello, On Mon, Mar 12, 2012 at 11:52 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 12 Mar 2012, at 10:11pm, Alex Queiroz <asand...@gmail.com> wrote: > >> - If I try to reindex the table, it fails; >> - If I drop the index and try to add it again,

Re: [sqlite] Unique indexes apparently not working

Hello, On Mon, Mar 12, 2012 at 11:34 PM, Petite Abeille wrote: > > > Hmmm… really? That would be most peculiar... > Indeed. I have now run this: sqlite> PRAGMA integrity_check; rowid 192697 missing from index userIdentityByUcgID rowid 192701 missing from index

Re: [sqlite] Unique indexes apparently not working

Hallo, On Mon, Mar 12, 2012 at 11:16 PM, Petite Abeille <petite.abei...@gmail.com> wrote: > > On Mar 12, 2012, at 11:11 PM, Alex Queiroz wrote: > >>       id                      INTEGER PRIMARY KEY, >> CREATE UNIQUE INDEX IF NOT EXISTS 'userIdentityByID'       ON

[sqlite] Unique indexes apparently not working

Hello, I have a problem with a customer database that is very strange. This is part of the DB's schema: - BEGIN - CREATE TABLE IF NOT EXISTS user_identity ( id INTEGER PRIMARY KEY, shortName TEXT, domainName TEXT,