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

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