[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-6766) Support Multicolumn Subqueries in Criteria API
Strong Liu (JIRA)
noreply at atlassian.com
Wed Oct 26 11:35:21 EDT 2011
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-6766?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Strong Liu resolved HHH-6766.
-----------------------------
Resolution: Fixed
Fix Version/s: 4.0.0.next
> Support Multicolumn Subqueries in Criteria API
> ----------------------------------------------
>
> Key: HHH-6766
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6766
> Project: Hibernate Core
> Issue Type: Improvement
> Components: query-criteria
> Reporter: Lukasz Antoniak
> Assignee: Lukasz Antoniak
> Labels: criteria, criterion, query, restrictions
> Fix For: 4.0.0.next
>
>
> Support queries like:
> {code:sql}
> SELECT *
> FROM entity1 e1
> WHERE (e1.attr1, e1.attr2) = ( SELECT e2.attr1
> , e2.attr2
> FROM entity2 e2
> WHERE e2.attr3 = ?
> );
> {code}
> HQL supports such expressions:
> {code:java}
> session.createQuery( "select w from Woman w where (w.height, w.weight) = (select m.height, m.weight from Man m where m.name = 'Lukasz' )" ).list();
> {code}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list