Re: [sqlite] Is this an SQL parsing / ambiguity bug ?

On 3/10/20, Simon Slavin wrote: > On 9 Mar 2020, at 8:40pm, Vladimir Vysotsky wrote: > >> sqlite> insert into dst(id) select id from src on conflict do nothing; >> Error: near "do": syntax error > > SQLite does not understand "DO NOTHING". You probably want "ON CONFLICT > IGNORE". I think Vlad

Re: [sqlite] Is this an SQL parsing / ambiguity bug ?

On 9 Mar 2020, at 8:40pm, Vladimir Vysotsky wrote: > sqlite> insert into dst(id) select id from src on conflict do nothing; > Error: near "do": syntax error SQLite does not understand "DO NOTHING". You probably want "ON CONFLICT IGNORE".

[sqlite] Is this an SQL parsing / ambiguity bug ?

I found a case where an "on conflict" clause generates an unexpected error, could this be an SQL parsing bug or grammar ambiguity? trivee@work:~/test$ sqlite3 --version 3.29.0 2019-07-10 17:32:03 fc82b73eaac8b36950e527f12c4b5dc1e147e6f4ad2217ae43ad82882a88alt1 trivee@work:~/test$ sqlite3 test.db