OpenJPA
  1. OpenJPA
  2. OPENJPA-356

DB2 requires CASTs when parameters appear in SELECT clause

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.9.0, 0.9.6, 0.9.7, 1.0.0
    • Fix Version/s: 1.0.1, 1.1.0
    • Component/s: jdbc
    • Labels:
      None
    • Environment:
      Kodo JDO

      Description

      When executing a query that selects a literal value, OpenJPA converts the literal into a parameter in the SQL SELECT clause. In DB2, such parameters must be CAST to the appropriate type.

      Note that this is not reproducible via OpenJPA's JPA bindings, as JPQL does not allow literals in the SELECT clause. However, the OpenJPA query parse trees do allow this syntax, and Kodo's JDO bindings allow such constructs.

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Unassigned
            Reporter:
            Patrick Linskey
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development