On 7/9/18, Thomas Kurz <sqlite.2...@t-net.ruhr> wrote:
> 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
sqlite-users mailing list