I tried to use this statement


"INSERT INTO words values (?, ?)
on conflict(word) do update set
instances = instances + ?"


This works fine on sqlite 2.29, and should work since 2.24. However, I get 
this error


/var/lib/gems/2.3.0/gems/sqlite3-1.4.1/lib/sqlite3/database.rb:147:in 
`initialize': near "on": syntax error (SQLite3::SQLException)


Is this not supported?

using gem sqlite3 1.4.1 and I have sqlite 2.29 installed at 
/usr/local/bin/sqlite3

-- 
You received this message because you are subscribed to the Google Groups 
"sqlite3-ruby" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sqlite3-ruby/0829a50d-e108-4f2b-be11-237a30467b08%40googlegroups.com.

Reply via email to