[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-6766) Support Multicolumn Subqueries in Criteria API

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}