[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3118) order by with sub-select

[Magnus Sandberg (JIRA)]

order by with sub-select
------------------------

                 Key: HHH-3118
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3118
             Project: Hibernate3
          Issue Type: Improvement
          Components: query-hql
    Affects Versions: 3.2.3
            Reporter: Magnus Sandberg


I'd like to order by a column that is created with a sub-select:

select a.b, (select c from [...]) from [...] where [...];

naming the sub-select column does not work:

select a.b, (select c from [...]) as to_order from [...] where [...] order by to_order;

gives a "no such column" exception.

I think hql should accept order by from named columns.



-- 
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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira