I am confused. Too much experimenting :( On Tue, May 15, 2018 at 4:55 PM Simon Slavin <[email protected]> wrote:
> On 16 May 2018, at 12:25am, Mark Wagner <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
