db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Fox (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (TORQUE-96) Can not use * or ? in LIKE clauses
Date Mon, 24 Sep 2012 07:08:28 GMT

     [ https://issues.apache.org/jira/browse/TORQUE-96?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Thomas Fox closed TORQUE-96.
----------------------------

    
> 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
>             Fix For: 4.0-beta1
>
>
> 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
sign
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

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


Mime
View raw message