Hi everyone, I think that I found another issue related to type affinity on real columns:
CREATE TABLE test (c0 REAL); CREATE UNIQUE INDEX index_0 ON test(TYPEOF(c0)); INSERT OR IGNORE INTO test(c0) VALUES (0.1); INSERT OR IGNORE INTO test(c0) VALUES (FALSE); REINDEX; In this example, the REINDEX fails with "UNIQUE constraint failed: index 'index_0'". FALSE is converted to 0.0, so two REALs are stored. Best, Manuel _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users