OK, at the risk of exposing my lack of edification, I'm wondering if
someone can explain why this simple test of unique column constraints
doesn't work. At least it doesn't work as I expected it would (i.e. that
the second insert would yield a unique constraint violation).
create table t (k integer primary key, s text UNIQUE);
insert into t (s) values ("foo");
insert into t (s) values ("bar");
select * from t;
k s
---------- ----------
1 foo
2 bar
Adding to my confusion is this:
insert into t values (3, "bar");
Error: UNIQUE constraint failed: t.s
3.22.0 2018-01-22 18:45:57
0c55d179733b46d8d0ba4d88e01a25e10677046ee3da1d5b1581e86726f2alt1
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
