On 9 Jul 2018, at 10:21pm, Thomas Kurz <sqlite.2...@t-net.ruhr> wrote:
> However, this is a bit confusing as e.g. this works fine: > > CREATE TABLE test (col1 TEXT UNIQUE ON CONFLICT IGNORE); By 'works fine' do you mean you didn't get a syntax error, or do you mean that the clause actually does what you want, both to accept and reject new rows ? The diagrams on <https://sqlite.org/lang_createtable.html> suggest that your clause is not handled correctly. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users