[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4119) Duplicate alias
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-4119?page=c...
]
roger cheng commented on HHH-4119:
----------------------------------
I just saw a comment in 'processQuery(AST select, AST query)' of class
org.hibernate.hql.ast.HqlSqlWalker:
//TODO: the only reason we need this stuff now is collection filters,
// we should get rid of derived select clause completely!
If the derived select clause can be got rid of, the duplicate alias is not problem, and
can you give some temporary proposal to resolve this issue,
thank you very much.
Duplicate alias
----------------
Key: HHH-4119
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4119
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.2.5
Environment: Hibernate 3.2.5, database sybase 12.52
Reporter: roger cheng
Attachments: SybaseIssue.tar.gz
The mapping file I used:
<hibernate-mapping package="com.novell.uddi3.hibernate.entities">
<class name="BusinessVO" table="businessvo">
<id name="id" type="string">
<generator class="assigned" />
</id>
<list name="Contacts" cascade="delete"
lazy="true">
<key column="bid" />
<list-index column="sortorder"/>
<one-to-many class="ContactVO" />
</list>
</class>
<class name="ContactVO" table="contacts">
<id name="id">
<generator class="native"/>
</id>
<array name="PersonName" cascade="all"
table="personnames" fetch="join">
<key column="cid" />
<list-index column="sortorder"/>
<composite-element class="org.uddi.v3.core.PersonName">
<property name="_value" type="string"
column="personname" length="4000"/>
</composite-element>
</array>
</class>
</hibernate-mapping>
When I execute a hsql like following:
Query q = session.createQuery("from BusinessVO b" +
" left join fetch b.Contacts c" +
" left join fetch c.PersonName");
BusinessVO vo = (BusinessVO)q.uniqueResult();
From the console, the following sql was created:
select
businessvo0_.id as id0_0_,
contacts1_.id as id1_1_,
personname2_.cid as cid1__,
personname2_.personname as personname1__,
personname2_.sortorder as sortorder1__,
contacts1_.bid as bid0__,
contacts1_.id as id0__,
contacts1_.sortorder as sortorder0__,
personname2_.cid as cid1__,
personname2_.personname as personname1__,
personname2_.sortorder as sortorder1__
from
businessvo businessvo0_
left outer join
contacts contacts1_
on businessvo0_.id=contacts1_.bid
left outer join
personnames personname2_
on contacts1_.id=personname2_.cid
The alias 'cid1__, personename1__, sortorder1__' are duplicate, is this a bug of
hibernate?
--
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