cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <>
Subject [jira] Updated: (CAY-1380) Support for Escaped LIKE Clauses in Expressions
Date Fri, 29 Jan 2010 10:54:34 GMT


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:
>             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

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

View raw message