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

[Trevor Harrison (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_28075 ] 

Trevor Harrison commented on HHH-1050:
--------------------------------------

I'm not sure if I'm reading this entry correctly, but it seems like this has been added since Jan 2006 (according to the change history).

However, when I use union select's in 3.2.4.sp1, the generated sql query is truncated at "union".

Could someone confirm that this was implemented, and that the correct syntax is "select myobj from MyClass myobj where blahblah union select myobj2 from MyClass myobj2 where blahblah2"?



> HQL Unions
> ----------
>
>                 Key: HHH-1050
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1050
>             Project: Hibernate3
>          Issue Type: New Feature
>          Components: query-hql
>            Reporter: Steve Ebersole
>            Assignee: Steve Ebersole
>
> 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