[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5199) Formula should use aliases in order by

[Gail Badner (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5199?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=36952#action_36952 ] 

Gail Badner commented on HHH-5199:
----------------------------------

Is this still an issue using 3.5.1? If so, please do the following:

    * svn co http://anonsvn.jboss.org/repos/hibernate/core/trunk/
    * update an existing test or add a new test to testsuite
    * attach a patch with the updated/added unit test using svn diff
    * if you have a fix, please attach a patch with your fix using svn diff

Also, please let us know which (if any) dialects tested at http://hudson.jboss.org/hudson/job/hibernate-core-testsuite/ are affected.

Thanks,
Gail

> Formula should use aliases in order by
> --------------------------------------
>
>                 Key: HHH-5199
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5199
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 3.3.1
>            Reporter: Stephane Epardaud
>
> Same bug as HB-958 but filed for hibernate 3. Not every database supports formulas or functions in WHERE clauses, and while we would love to get rid of them, it's not always realistic.
> It should not be hard to reuse the alias generated for formulas from the SELECT clause.
> Reminder:
> - This does not work on every DB:
> {noformat}
> SELECT length(id) FROM t ORDER BY length(id);
> {noformat}
> - This works on several DBs:
> {noformat}
> SELECT length(id) AS l FROM t ORDER BY l;
> {noformat}
> If there are any DBs where hibernate is broken because of that, it should be a Dialect feature.
> In the original bug report, Gavin mentioned trivial workarounds. It would be helpful to show them in the bug report too, since they might not be obvious (I've no clue for instance).

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