[SQL-CVS] [ sqlobject-Bugs-2853734 ] Underscore not escaped for LIKE

[SourceForge.net <no...@so...>]

Bugs item #2853734, was opened at 2009-09-07 18:38
Message generated for change (Tracker Item Submitted) made by mariogala
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: MySQL
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Mario Gala (mariogala)
Assigned to: Nobody/Anonymous (nobody)
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).


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=540672&aid=2853734&group_id=74338