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

[Diego Pires Plentz (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Diego Pires Plentz resolved HHH-2905.
-------------------------------------

      Assignee: Diego Pires Plentz
    Resolution: Incomplete

Testcase? Stacktrace? Patch?

> 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
>            Assignee: Diego Pires Plentz
>
> 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