xerial/sqlite-jdbc

Add option to disable the double-quoted string literal misfeature by default

JesseChavez opened this issue · 1 comments

Is your feature request related to a problem? Please describe.

It would be good to have a configuration property to disable the misfeature described in the title

Having this will disable undesired behaviour described by the SQLite creator in the following link

https://www.sqlite.org/quirks.html#double_quoted_string_literals_are_accepted

Here is a like of a specific undesired behaviour

rails/rails#27782

Describe the solution you'd like

Something we can pass in the connection url would be good.

e.g.

jdbc:sqlite:db.sqlite?strict_strings=true

Additional context

Here is a example how a configuration property was added to library that uses SQLite's C API.

sparklemotion/sqlite3-ruby#317

can you explain what you are referring to by "the double-quoted string literal misfeature" ?