[jira] Closed: (CAY-1426) EJBQL: ESCAPE fails after positional parameter

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

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

Andrus Adamchik closed CAY-1426.
--------------------------------

         Assignee: Andrus Adamchik
    Fix Version/s: 3.0.1
                   3.1M1
       Resolution: Fixed

> EJBQL: ESCAPE fails after positional parameter
> ----------------------------------------------
>
>                 Key: CAY-1426
>                 URL: https://issues.apache.org/jira/browse/CAY-1426
>             Project: Cayenne
>          Issue Type: Improvement
>          Components: Core Library
>    Affects Versions: 3.0RC3
>            Reporter: Andrew Lindesay
>            Assignee: Andrus Adamchik
>            Priority: Minor
>             Fix For: 3.0.1, 3.1M1
>
>         Attachments: 0001-CAY-1426.patch, CAY-1426.-Fixed-incorrect-parsing-of-LIKE-ESCAPE-with-input-parameter.patch, unit-test-java-snippet.txt
>
>
> The EJBQL specification allows for an escape character to be supplied for the generated SQL.  For example, the following would be valid;
> ...WHERE (((r.applicableTimestamp>=?1) AND (r.applicableTimestamp<?2)) AND (UPPER(r.message) LIKE ?3 ESCAPE '|')) ORDER...
> The EJBQL parser is presently failing;
> 	... 70 more
> Caused by: org.apache.cayenne.ejbql.parser.ParseException: Encountered " "ESCAPE" "ESCAPE "" at line 1, column 130.
> Was expecting:
>     ")" ...
>     
> 	at org.apache.cayenne.ejbql.parser.EJBQL.generateParseException(EJBQL.java:9419)

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