'%s' escaping support for sqlite3
|Reported by:||master||Owned by:||Luke Plant|
|Component:||Database layer (models, ORM)||Version:||master|
|Severity:||Release blocker||Keywords:||sqlite escape|
|Cc:||Triage Stage:||Ready for checkin|
|Has patch:||no||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
Somewhere between 1.2beta1 and svn r13307, the string processing of convert_query() changed.
Now the regex to escape '%%s' content for sqlite3 SQL is wrong and produces '%?'.
It doesn't throw any exception but it means nothing to the DB and you may have 'None' column values returned.
Note : for a complete working sqlite solution, you still have to apply the patch in #12268.
Change History (14)
comment:2 Changed 6 years ago by
|Patch needs improvement:||set|
|Triage Stage:||Unreviewed → Accepted|
comment:8 Changed 6 years ago by
|Patch needs improvement:||unset|
|Triage Stage:||Accepted → Ready for checkin|