You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Pinaki Poddar (JIRA)" <ji...@apache.org> on 2008/11/10 21:57:44 UTC

[jira] Created: (OPENJPA-764) Query parsing error with IN expression and String functions such as UPPER()

Query parsing error with IN expression and String functions such as UPPER()
---------------------------------------------------------------------------

                 Key: OPENJPA-764
                 URL: https://issues.apache.org/jira/browse/OPENJPA-764
             Project: OpenJPA
          Issue Type: Bug
            Reporter: Pinaki Poddar
             Fix For: 2.0.0


Following JPQL query causes parse exception
           "select a from A a where UPPER(a.name) IN (:list)"
while the following does not
           "select a from A a where a.name IN (:list)"

Parse tree definition seems to be the cause.

Originally reported in Nabble mailing list post[1]

[1] http://n2.nabble.com/ParseException-when-using-UPPER-Keyword-with-an-IN-CLAUSE-tc1480819.html

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

[jira] Resolved: (OPENJPA-764) Query parsing error with IN expression and String functions such as UPPER()

Posted by "Pinaki Poddar (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-764?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pinaki Poddar resolved OPENJPA-764.
-----------------------------------

    Resolution: Fixed

> Query parsing error with IN expression and String functions such as UPPER()
> ---------------------------------------------------------------------------
>
>                 Key: OPENJPA-764
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-764
>             Project: OpenJPA
>          Issue Type: Bug
>            Reporter: Pinaki Poddar
>             Fix For: 2.0.0
>
>
> Following JPQL query causes parse exception
>            "select a from A a where UPPER(a.name) IN (:list)"
> while the following does not
>            "select a from A a where a.name IN (:list)"
> Parse tree definition seems to be the cause.
> Originally reported in Nabble mailing list post[1]
> [1] http://n2.nabble.com/ParseException-when-using-UPPER-Keyword-with-an-IN-CLAUSE-tc1480819.html

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