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