db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "CG Monroe (JIRA)" <j...@apache.org>
Subject [jira] Created: (TORQUE-96) Can not use * or ? in LIKE clauses
Date Wed, 13 Jun 2007 17:07:31 GMT
Can not use * or ? in LIKE clauses

                 Key: TORQUE-96
                 URL: https://issues.apache.org/jira/browse/TORQUE-96
             Project: Torque
          Issue Type: Bug
          Components: Runtime
    Affects Versions: 3.3-RC3, 3.3
            Reporter: CG Monroe
            Priority: Minor

If you have a ? or * in a like criteria, they get replaced with "_" and "%" in the SqlExpression
class.  However, this causes problems if you want to search for these characters.

If you try to escape them with a \, the SQL generated is invalid for some DB's (Like MS SQL).
 This causes an SQLException to be thrown with text like:

Invalid escape sequence. Valid characters after ESC are: an ESC pair, underscore, percent

My memory is that % and _ are the SQL standard wild card/match characters.  So, is the bug
here that since ? and * are non-standard
they should not be processed?

If for some reason they need to be processed, do we go down the road of having a Torque escape
character so that these characters can be searched?  

But this leads to possibly requiring stuff like "\\\\" in criterias to get an escaped \\ to
the SQL parser so that single \ can be passed.  This can be very confusing and would need
to be documented correctly somewhere.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org

View raw message