[jira] Updated: (CAY-1380) Support for Escaped LIKE Clauses in Expressions

["Andrus Adamchik (JIRA)" <ji...@apache.org>]

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

Andrus Adamchik updated CAY-1380:
---------------------------------

    Attachment: dummy-attachment.txt

please ignore, testing how attachments work

> Support for Escaped LIKE Clauses in Expressions
> -----------------------------------------------
>
>                 Key: CAY-1380
>                 URL: https://issues.apache.org/jira/browse/CAY-1380
>             Project: Cayenne
>          Issue Type: New Feature
>    Affects Versions: 3.1M1
>            Reporter: Andrew Lindesay
>         Attachments: dummy-attachment.txt
>
>
> 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 patch

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