cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <>
Subject [jira] Closed: (CAY-1380) Support for Escaped LIKE Clauses in Expressions
Date Fri, 09 Apr 2010 17:06:51 GMT


Andrus Adamchik closed CAY-1380.

       Resolution: Fixed
    Fix Version/s: 3.0.1

> Support for Escaped LIKE Clauses in Expressions
> -----------------------------------------------
>                 Key: CAY-1380
>                 URL:
>             Project: Cayenne
>          Issue Type: New Feature
>    Affects Versions: 3.1M1
>            Reporter: Andrew Lindesay
>            Assignee: Andrus Adamchik
>             Fix For: 3.0.1, 3.1M1
>         Attachments: CAY1380-patch-31jan2010-1405.diff, patch-CAY1380.diff
> At present in Cayenne, by using Expressions, it is not possible to escape LIKE clauses.
 So if somebody enters FOO%BAR into a client all you can do is to strip out the %.  This is
a bit tricky to work around.  The JDBC approach is allow you to append some extra text to
the operand in order to define an escape character like this;
> SELECT a FROM tabA WHERE a LIKE '%=_' {escape '='}
> So, I added an instance variable to "PatternMatchNode" to carry the escape char and then
modified "QueryAssemblerHelper" to append this to the operand if it is present.  See attached

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

View raw message