[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