[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2771) Column alias not unique using multiple LEFT JOIN FETCHs

[Michael Landon (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_27776 ] 

Michael Landon commented on HHH-2771:
-------------------------------------

Stack trace of error:
SEVERE: ASA Error -830: Alias 'ApprovalID1__' is not unique
org.hibernate.exception.SQLGrammarException: could not execute query
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.loader.Loader.doList(Loader.java:2223)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
	at org.hibernate.loader.Loader.list(Loader.java:2099)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
	at test.mdlandon.TestIt.testIt(Unknown Source)
	at test.mdlandon.TestIt.main(Unknown Source)
Caused by: com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -830: Alias 'ApprovalID1__' is not unique
	at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2738)
	at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2069)
	at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
	at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:204)
	at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:187)
	at com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1562)
	at com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1547)
	at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:85)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
	at org.hibernate.loader.Loader.doQuery(Loader.java:674)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
	at org.hibernate.loader.Loader.doList(Loader.java:2220)
	... 9 more
Exception in thread "main" 

> Column alias not unique using multiple LEFT JOIN FETCHs
> -------------------------------------------------------
>
>                 Key: HHH-2771
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2771
>             Project: Hibernate3
>          Issue Type: Bug
>          Components: query-sql
>    Affects Versions: 3.2.4.sp1
>         Environment: Hibernate version 3.2.4.sp1, SQLAnywhere 9.0.2.3342
>            Reporter: Michael Landon
>            Priority: Minor
>         Attachments: reproduce.zip
>
>
> Using an HQL statement in which you LEFT JOIN FETCH a mixture of entity sets and a set of element values (e.g., integers), the resulting SQL includes non-unique aliases.

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