glassfish
  1. glassfish
  2. GLASSFISH-166

EJBQL: check SELECT clause requirements for GROUP BY query

    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:
      166

      Description

      The EJBQL compiler needs to check whether the SELECT clause of a GROUP BY query
      matches the requirement as specified in section "4.7 GROUP BY, HAVING" of the spec:
      The requirements for the SELECT clause when GROUP BY is used follow those of
      SQL: namely, any item that appears in the SELECT clause (other than as an
      argument to an aggregate function) must also appear in the GROUP BY clause. In
      forming the groups, null values are treated as the same for grouping purposes.

        Activity

        Hide
        mb124283 added a comment -

        Started adding validation of GROUP BY and HAVING node.

        Show
        mb124283 added a comment - Started adding validation of GROUP BY and HAVING node.
        Hide
        mb124283 added a comment -

        Added validation of the SELECT clause and the HAVING clause for GROUP BY queries.

        Show
        mb124283 added a comment - Added validation of the SELECT clause and the HAVING clause for GROUP BY queries.

          People

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

            Dates

            • Created:
              Updated:
              Resolved: