I am confused. Too much experimenting :(
On Tue, May 15, 2018 at 4:55 PM Simon Slavin <slav...@bigfraud.org> wrote:
> On 16 May 2018, at 12:25am, Mark Wagner <m...@google.com> wrote:
>
> > 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");
>
> You appear to be confused. How does the second INSERT violate the UNIQUE
> constraint ?
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
