[ https://issues.apache.org/jira/browse/OPENJPA-478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Albert Lee closed OPENJPA-478. ------------------------------ Close issue in preparation for 2.2.0 release. > Contradictory text in manual section 10.2.6. JPQL GROUP BY, HAVING > ------------------------------------------------------------------ > > Key: OPENJPA-478 > URL: https://issues.apache.org/jira/browse/OPENJPA-478 > Project: OpenJPA > Issue Type: Bug > Components: docs > Affects Versions: 1.2.2, 2.1.0 > Environment: linux, firefox, etc.. > Reporter: Andy Schlaikjer > Assignee: Milosz Tylenda > Priority: Minor > Fix For: 2.2.0 > > > 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] -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira