[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1050?page=c...
]
Lucas de Oliveira Arantes commented on HHH-1050:
------------------------------------------------
Same behavior as Nathan and others reported: query gets truncated at the 'union'
keyword. Using Hibernate 3.3.2.GA with PostgreSQL 8.4. Query is:
select pr1.value as val, it1.name as description from ProductPrice pr1, Item1 it1 where
pr1.relitem.class = 'Item1' and pr1.relitem.id = it1.id
union
select pr2.value as val, it2.observation as description from ProductPrice pr2, Item2 it2
where pr2.relitem.class = 'Item2' and pr2.relitem.id = it2.id
Any plans for this issue to be resolved?
Thanks!
HQL Unions
----------
Key: HHH-1050
URL:
http://opensource.atlassian.com/projects/hibernate/browse/HHH-1050
Project: Hibernate Core
Issue Type: New Feature
Components: query-hql
Reporter: Steve Ebersole
Assignee: Steve Ebersole
Fix For: antlr-rework
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