xerial / sqlite-jdbc

SQLite JDBC Driver
Apache License 2.0
2.83k stars 619 forks source link

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

Open JesseChavez opened 2 months ago

JesseChavez commented 2 months ago

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

https://github.com/rails/rails/issues/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.

https://github.com/sparklemotion/sqlite3-ruby/pull/317

gotson commented 2 months ago

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