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,
lastUpdated INTEGER,
ucgID INTEGER
);
CREATE UNIQUE INDEX IF NOT EXISTS 'userIdentityByID' ON
'user_identity' (id ASC);
CREATE UNIQUE INDEX IF NOT EXISTS 'userIdentityByUcgID' ON
'user_identity' (shortName ASC, ucgID ASC);
------ END ------
The problem is that a customer has a database where (shortName, ucgID)
have duplicates.
- When I try to insert manually a new record, the index is enforced;
- When I try to update a column, the index is enforced;
- If I try to reindex the table, it fails;
- If I drop the index and try to add it again, it fails.
At this point I really have no idea of what could have caused that. If
anyone has seen something similar before, please share. :)
Cheers,
--
-alex
http://www.artisancoder.com/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
