Mailing-List: contact commits-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cayenne.apache.org
Message-ID: <7264779.400341279220272646.JavaMail.jira@thor>
Date: Thu, 15 Jul 2010 14:57:52 -0400 (EDT)
From: "Andrus Adamchik (JIRA)" <jira@apache.org>
To: commits@cayenne.apache.org
Subject: [jira] Closed: (CAY-1426) EJBQL: ESCAPE fails after positional
 parameter
In-Reply-To: <7680038.18951273058286670.JavaMail.jira@thor>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ 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.