Thank you, but I think there is a misunderstanding. I do want the constraint to be checked, but I want to ignore the attempt to insert values that would violate the check constraint.
According to the "on conflict" documentation (https://sqlite.org/lang_conflict.html), "The ON CONFLICT clause applies to UNIQUE, NOT NULL, CHECK, and PRIMARY KEY constraints." But I when I try this, I get a "syntax error near on": CREATE TABLE test (col1 TEXT CHECK (col1<>'') ON CONFLICT IGNORE); Am I using a wrong syntax? Or am I misinterpreting the documentation? Kind regards, Thomas ----- Original Message ----- From: Richard Hipp <d...@sqlite.org> To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Sent: Monday, July 9, 2018, 22:03:29 Subject: [sqlite] CHECK IGNORE? On 7/9/18, Thomas Kurz <sqlite.2...@t-net.ruhr> wrote: > is there a way to have Sqlite ignore check violations? https://www.sqlite.org/pragma.html#pragma_ignore_check_constraints -- D. Richard Hipp d...@sqlite.org _______________________________________________ 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
