Bugs item #2853734, was opened at 2009-09-07 21:38
Message generated for change (Settings changed) made by phd
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=540672&aid=2853734&group_id=74338
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
>Category: None
Group: None
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Mario Gala (mariogala)
Assigned to: Oleg Broytmann (phd)
Summary: Underscore not escaped for LIKE
Initial Comment:
The _LikeQuoted class (in sqlbuilder.py) is not escaping the underscore character '_' (whereas the percent character '%' is escaped correctly).
Indeed in MySQL the underscore character in a LIKE pattern represents a wildcard to match exactly one character (http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html), so it should be probably escaped there (at least for MySQL, not sure about other databases).
----------------------------------------------------------------------
>Comment By: Oleg Broytmann (phd)
Date: 2009-09-20 20:38
Message:
Fixed in the revisions 3981-3983 (branches 0.10, 0.11 and the trunk). Will
be in the next round of releases.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=540672&aid=2853734&group_id=74338
|