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

[Sammi Ting (JIRA)]

Sybase not allow to use alias in subquery
-----------------------------------------

                 Key: HHH-2905
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2905
             Project: Hibernate3
          Issue Type: Bug
          Components: query-criteria
    Affects Versions: 3.2.2
            Reporter: Sammi Ting


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)


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