Using parenthesis is a valid way to apply "order by" and "limit" to individual select statements inside union (see http://dev.mysql.com/doc/refman/5.0/en/union.html). Hibernate should not fail in this case. Ideally it should support union in HQL as well.
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
Using parenthesis is a valid way to apply "order by" and "limit" to individual select statements inside union (see http://dev.mysql.com/doc/refman/5.0/en/union.html). Hibernate should not fail in this case. Ideally it should support union in HQL as well.