Uploaded image for project: 'OpenJPA'
  1. OpenJPA
  2. OPENJPA-764

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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0.0-M2
    • Component/s: None
    • Labels:
      None

      Description

      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

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              ppoddar@apache.org Pinaki Poddar
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: