[Hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1267) HQL: order-by clause column list

[Antoine B. (JIRA) <no...@at...>]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1267?page=comments#action_22602 ] 

Antoine Baudoux commented on HHH-1267:
--------------------------------------

I have this problem with FrontBase. Do you have an idea of when this issue wil be resolved? This is very annoying, I cant do any sorting in HQL or in the criteria API. If you dont plan to solve this rapidly, can you tell me where to patch the code? Thanks!

> HQL: order-by clause column list
> --------------------------------
>
>          Key: HHH-1267
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1267
>      Project: Hibernate3
>         Type: Improvement

>   Components: core
>     Reporter: Steve Ebersole
>     Assignee: Steve Ebersole
>     Priority: Minor
>      Fix For: 3.2.0

>
>
> HQL currently always results in using qualified column names in the order-by clause.  Some databases (ok DB2) actually do not support this in all cases.  And really according to the SQL spec, it is not the specified thing to do.  Essentially the SQL spec says that if select-clause column aliases are used, those column aliases (or the column indexes) should be used in the order-by clause.
> This should be the non-default behavior as it'll be more intensive of the query parser to achieve this.

-- 
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