Hello !
Maybe I found a bug in sqlite3 unique index, see example bellow:
====bug-unique.sql
drop table if exists test;
create table test(
id integer primary key,
v1 integer not null,
v2 integer not null constraint not_equal check(v1 != v2),
unique(v1, v2),
unique(v2, v1)
);
insert into test values(1, 1, 2);
insert into test values(2, 2, 1);
select * from test;
====
sqlite3 < bug-unique.sql
====output
1|1|2
2|2|1
====
I was expecting to have an error trying to insert the second row but
sqlite3 accepted the duplicated index without error.
Cheers !
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users