[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1050?page=c... ] John C. Checco, CISSP commented on HHH-1050: -------------------------------------------- I would vote for implementing the entire resultset manipulation operations: UNION / UNION ALL MINUS / EXCEPT / EXCEPT ALL INTERSECT / INTERSECT ALL I have been working around the union/intersect problem by wrapping the HSQL statements separately and using the "IN" operator. The problem here is that each DB has its limits on how many elements can be used for the IN set (oracle has 10000, sqlsvr has 2000). i've run into this limit already so it would be great to have HQL support this. I also realize that not every DB implementation supports these operations, but I would expect the HQL engine to recognize that and replace it with runtime-based resultset manipulations. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira