On 7/9/18, Thomas Kurz <[email protected]> wrote: > Hello, > > is there a way to have Sqlite ignore check violations? > > I would like to do: > > CREATE TABLE .... (name TEXT NOT NULL CHECK (name<>'') ON CONFLICT IGNORE > > but the "on conflict" is not accepted here.
It does not appear that SQLite has ever acted upon "ON CONFLICT" exceptions on CHECK constraints. Such clauses are accepted for CHECK constraints not associated with a particular column. For example: CREATE TABLE t1(x INT, CHECK(x!=5) ON CONFLICT IGNORE); However, the parser silently discards the ON CONFLICT clause. I think this has always been the case. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
