[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1050?page=c...
]
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira