What sqllite engine version is supported?

44 views

Skip to first unread message

unread,

Oct 1, 2019, 4:30:14 PM10/1/19

to sqlite3-ruby

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

Reply all

Reply to author

Forward

0 new messages