[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1050) HQL Unions

[John C. Checco, CISSP (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1050?page=comments#action_24687 ] 

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.



> HQL Unions
> ----------
>
>          Key: HHH-1050
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1050
>      Project: Hibernate3
>         Type: New Feature

>   Components: query-hql
>     Reporter: Steve Ebersole
>     Assignee: Steve Ebersole
>      Fix For: 3.2.1

>
>
> Add the ability to define unions in HQL.  Support will be initially limited to only:
> 1) scalar queries : select id from Animal union select id from Car
> 2) the same entity : from Animal where ... union from Animal where ...
> Support both UNION and UNION ALL

-- 
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.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira