python-diskcache icon indicating copy to clipboard operation
python-diskcache copied to clipboard

Support sqlite builds with DQS=off

Open knz opened this issue 1 year ago • 7 comments

If sqlite3 is built with double-quoted string literals disabled (which is recommended, see https://www.sqlite.org/compile.html#dqs), diskcache starts failing with the following crypting error:

no such column: "size"

This is because the syntax WHERE key = "size" in standard SQL refers to a column named "size", not a string literal. Parsing this as a string literal is a conditional sqlite extension.

This patch makes the code more robust by avoiding this optional sqlite feature.

knz avatar Apr 03 '24 16:04 knz

cc @grantjenks

knz avatar Apr 17 '24 16:04 knz