Tracker passes double quoted string literals to SQLite
The SQL standard requires string literals to be 'single quoted' rather than "double quoted". For historic reasons, SQLite has always accepted double quoted strings as well, but this is considered a "quirk" and SQLite is taking first steps to deprecate and remove this behavior.
https://www.sqlite.org/quirks.html#dblquote
Recent versions of sqlite can be built with double quoted string literals disabled. This is not (yet) the default. https://www.sqlite.org/compile.html#dqs
If tracker is used with a version of SQLite built that way (-DSQLITE_DQS=0
), it errors out on startup with a rather cryptic error.
(tracker-miner-fs-3:501017): Tracker-CRITICAL **: 22:03:32.431: Couldn't reset indexed applications: SQL logic error
(tracker-miner-fs-3:501017): Tracker-CRITICAL **: 22:03:47.296: Could not initialize currently active mount points: SQL logic error
(tracker-miner-fs-3:501017): Tracker-CRITICAL **: 22:03:47.297: Could not query contents for indexed folder 'file:///home/bero': no such column: nie:interpretedAs