Re: [Sqlalchemy-tickets] [sqlalchemy] #1400: LIKE doesn't correctly escape escape value
Brought to you by:
zzzeek
Menu
▾
▴
Re: [Sqlalchemy-tickets] [sqlalchemy] #1400: LIKE doesn't correctly escape escape value
|
From: sqlalchemy <mi...@zz...> - 2010-06-20 15:41:15
|
#1400: LIKE doesn't correctly escape escape value
--------------------+-------------------------------------------------------
Reporter: guest | Owner: zzzeek
Type: defect | Status: new
Priority: medium | Milestone: 0.6.2
Component: sql | Severity: major - 1-3 hours
Keywords: | Status_field: in queue
--------------------+-------------------------------------------------------
Changes (by zzzeek):
* milestone: 0.6.xx => 0.6.2
Comment:
So I don't actually know what the best solution is here. Would you like
us to detect "\" and double it up on MySQL (in which case, we should use
render_literal_value(), which needs to be implemented specifically for
MySQL to include this escaping behavior, possibly checking for ANSI
configuration, + tests)? Or just pass as bind params ? SQLite doesn't
appear to accept "\\" (error: "ESCAPE expression must be a single
character").
It seems to me like the obvious solution is to not use "\" as an escape
character, its a poor choice for platform agnostic behavior. That's why
this bug has never been high priority.
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/1400#comment:5>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|