9:28 a.m.
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
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:30 a.m.
New subject: [Hibernate-JIRA] Updated: (HHH-2771) Column alias not unique using multiple LEFT JOIN FETCHs
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2771?page=c...
]
Michael Landon updated HHH-2771:
--------------------------------
Attachment: reproduce.zip
Testcase necessary to reproduce this issue.
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:32 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2771) Column alias not unique using multiple LEFT JOIN FETCHs
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2771?page=c...
]
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:17 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2771) Column alias not unique using multiple LEFT JOIN FETCHs
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2771?page=c...
]
ANU commented on HHH-2771:
--------------------------
Can you post the query that gets generated with duplicate aliases?
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:06 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-2771) Column alias not unique using multiple LEFT JOIN FETCHs
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-2771?page=c...
]
Michael Landon commented on HHH-2771:
-------------------------------------
Here's the debug output from stdout:
Hibernate: select zonesconta0_.ZoneID as ZoneID0_0_, others1_.OtherID as OtherID2_1_,
zonesconta0_.ZoneName as ZoneName0_0_, zones2_.ApprovalID as ApprovalID1__, zones2_.ZoneID
as ZoneID1__, others1_.ZoneID as ZoneID2_1_, others1_.OtherName as OtherName2_1_,
others1_.OtherID as OtherID0__, zones2_.ApprovalID as ApprovalID1__, zones2_.ZoneID as
ZoneID1__ from mdlandon_zones_container zonesconta0_ left outer join
mdlandon_other_container others1_ on zonesconta0_.ZoneID=others1_.OtherID left outer join
mdlandon_approval_zone zones2_ on zonesconta0_.ZoneID=zones2_.ApprovalID
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6248
days inactive
6268
days old
hibernate-issues@lists.jboss.org
4 comments
2 participants
participants (2)
-
ANU (JIRA) -
Michael Landon (JIRA)