OpenJPA
  1. OpenJPA
  2. OPENJPA-478

Contradictory text in manual section 10.2.6. JPQL GROUP BY, HAVING

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 1.2.2, 2.1.0
    • Fix Version/s: 2.2.0
    • Component/s: docs
    • Labels:
      None
    • Environment:
      linux, firefox, etc..

      Description

      In section 10.2.6. JPQL GROUP BY, HAVING (http://openjpa.apache.org/docs/latest/manual/jpa_langref.html#jpa_langref_group) the last paragraph seems contradictory:

      """
      If there is no GROUP BY clause and the HAVING clause is used, the result is treated as a single group, and the select list can only consist of aggregate functions. When a query declares a HAVING clause, it must always also declare a GROUP BY clause.
      """

      The first sentences seems to imply that a query may incorporate a HAVING clause without a GROUP BY clause, but the second sentence indicates otherwise.

      Looking at section 10.2.12 JPQL BNF (http://openjpa.apache.org/docs/latest/manual/jpa_langref.html#jpa_langref_bnf), it seems as though the BNF contradicts the last sentence:

      """
      select_statement ::= select_clause from_clause [where_clause] [groupby_clause] [having_clause] [orderby_clause]
      """

      otherwise the BNF would be something like this:

      select_statement ::= select_clause from_clause [where_clause] [groupby_clause [having_clause]] [orderby_clause]

        Activity

        Andy Schlaikjer created issue -
        Milosz Tylenda made changes -
        Field Original Value New Value
        Assignee Milosz Tylenda [ milosz ]
        Milosz Tylenda made changes -
        Fix Version/s 2.2.0 [ 12315910 ]
        Affects Version/s 2.1.0 [ 12314542 ]
        Affects Version/s 1.2.2 [ 12313681 ]
        Priority Major [ 3 ] Minor [ 4 ]
        Summary contradictory text in manual section 10.2.6. JPQL GROUP BY, HAVING Contradictory text in manual section 10.2.6. JPQL GROUP BY, HAVING
        Milosz Tylenda made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Albert Lee made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            Milosz Tylenda
            Reporter:
            Andy Schlaikjer
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development