[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-2905) Sybase not allow to use alias in subquery

Sybase not allow to use alias in subquery ----------------------------------------- Key: HHH-2905 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2905 Project: Hibernate Core Issue Type: Bug Components: query-criteria Affects Versions: 3.2.2 Reporter: Sammi Ting Assignee: Gail Badner I have the same question as the post in forum: http://forum.hibernate.org/viewtopic.php?t=949233 However, the forum is just so errorneous that not allow me to register nor display the page. My problem: I am using sybase as persistant storage and using Hibernate to perform ORM. Due to Spring implementation, I selected to use DetachedCriteria and want to have a simple subquery to perform a tiny task. However, sybase seems not allow alias in subquery and make my sql invalid (generated by Hibernate). If I try to remove the alias from subquery and run the sql, it returns result gracefully. Any workaround to disable alias? (I am using sybase dialect)