glassfish
  1. glassfish
  2. GLASSFISH-152

EJBQL: add support for grouping by entities to expression framework

    Details

    • Type: Task Task
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 9.0pe
    • Fix Version/s: 9.0pe
    • Component/s: entity-persistence
    • Labels:
      None
    • Environment:

      Operating System: All
      Platform: All

    • Issuezilla Id:
      152

      Description

      The PFD version of the EJB3 persistence spec adds support for grouping by
      relationship fields, e.g.
      SELECT c.country FROM Customer c GROUP BY c.country

      The query runtime does not (yet) support this. The generated SQL misses the
      expression in the GROUP BY clause
      SELECT t0.COUNTRY_ID, ... FROM CMP3_COUNTRY t0, CMP3_CUSTOMER t1
      WHERE (t0.COUNTRY_ID = t1.COUNTRY_ID) GROUP BY
      The relationship access in the GROUP BY expression is represented as an
      QueryKeyExpression instance. Method printSQL gets called to generated the SQL
      which does not handle the relationship case.

        Issue Links

          Activity

          Hide
          mb124283 added a comment -

          Fix is checked in by Tom Ware Feb-20.

          Show
          mb124283 added a comment - Fix is checked in by Tom Ware Feb-20.

            People

            • Assignee:
              tware
              Reporter:
              mb124283
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: