[hibernate-dev] SQM - subqueries and order-by

Steve Ebersole steve at hibernate.org
Mon Nov 21 12:16:31 EST 2016


SQL 92, 93 and 99 (i have not checked 2003) all limit order-by to only be
allowable in the root query.

Unfortunately the current HQL grammar allows subqueries to be ordered.  So
I wanted to start a discussion of whether we want to support this as we
transition to SQM and 6.0.  The real problem with supporting ordering of a
subquery is that neither HQL nor JPQL support pagination of a subquery
which is honestly the only time that ordering the subquery makes any sense.

So IMO we have 2 choices:

   1. Add a new pagination syntax to the HQL language and continue to allow
   ordering of subqueries
   2. drop support for ordering subqueries.

Thoughts?


More information about the hibernate-dev mailing list