Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#253 Underscore not escaped for LIKE

closed-fixed
Oleg Broytman
None
5
2009-09-20
2009-09-07
Mario Gala
No

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).

Discussion

  • Oleg Broytman
    Oleg Broytman
    2009-09-08

    • assigned_to: nobody --> phd
     
  • Oleg Broytman
    Oleg Broytman
    2009-09-20

    Fixed in the revisions 3981-3983 (branches 0.10, 0.11 and the trunk). Will be in the next round of releases.

     
  • Oleg Broytman
    Oleg Broytman
    2009-09-20

    • labels: 519512 -->
    • status: open --> closed-fixed