On Mar 12, 2012, at 11:11 PM, Alex Queiroz wrote: > The problem is that a customer has a database where (shortName, ucgID) > have duplicates.
Hmmm… really? That would be most peculiar... In any case, what does the following statement returns? select shortName, ucgID, count( * ) from user_identity group by shortName, ucgID having count( * ) > 1 If it returns anything… are you sure you have a unique index in the first place? PRAGMA index_info( userIdentityByUcgID ) If both answers are yes, well, then, congratulation… you managed to badly confuse SQLite :D _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users