Column is repeated in generated SQL... why?

carl.sjoquist · **Joined:** Tue Oct 07, 2003 4:17 pm **Posts:** 9

I was experimenting with fetch="subselect" and noticed that the generated SQL repeats the id column (see below). I think I've noticed this in other situations too. Does anyone have an explanation? is it something I am doing wrong?
thanks
Carl

Hibernate version: v3.2

Mapping documents:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping
package="com.ncr.cacheTest">

<class name="Parent1" table="Parent1">

<id name="id">
<generator class="assigned"/>
</id>

<property name="parentName"
not-null="true"
column="parentName"/>


<set name="myCollection1"
lazy="true"
fetch="join"
inverse="true"
cascade="all-delete-orphan">
<key column="parent"/>
<one-to-many class="Col1"/>
</set>


<bag name="myCollection2"
lazy="true"
fetch="select"
inverse="true"
cascade="all-delete-orphan">
<key column="parent"/>
<one-to-many class="Col2"/>
</bag>


<list name="myCollection3"
lazy="true"
fetch="subselect"
inverse="false"
table="Parent_Col3"
cascade="persist, merge, save-update">
<key column="parent_id"/>
<index column="ord"/>
<many-to-many
column="col3_id"
class="Col3"
unique="false" />
</list>


<set name="myCollection4"
lazy="false"
fetch="subselect"
inverse="true"
cascade="all-delete-orphan">
<key column="parent"/>
<one-to-many class="Col4"/>
</set>

</class>

</hibernate-mapping>

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping
package="com.ncr.cacheTest">

<class name="Col4" table="Col4" >

<id name="id">
<generator class="assigned"/>
</id>

<timestamp name="datetime"
column="datetime"/>

<many-to-one name="parent"
not-null="true"/>

</class>

</hibernate-mapping>

... others not included

Code between sessionFactory.openSession() and session.close():

List list = s.createQuery("from Parent1").list();

Full stack trace of any exception that occurs:

Hibernate: select parent1x0_.id as id0_, parent1x0_.parentName as parentName0_ from Parent1 parent1x0_
17:48:32,253 DEBUG org.hibernate.cache.TransactionalCache caching: com.ncr.cacheTest.Parent1#1553
17:48:32,253 DEBUG org.hibernate.cache.TransactionalCache caching: com.ncr.cacheTest.Parent1#481
...
...
...
17:48:32,534 DEBUG org.hibernate.cache.TransactionalCache caching: com.ncr.cacheTest.Parent1#577
17:48:32,534 DEBUG org.hibernate.cache.TransactionalCache caching: com.ncr.cacheTest.Parent1#609
17:48:32,534 DEBUG org.hibernate.cache.TransactionalCache cache lookup: com.ncr.cacheTest.Parent1.myCollection4#609
17:48:32,534 DEBUG org.hibernate.cache.TransactionalCache cache miss
Hibernate: select mycollecti0_.parent as parent1_, mycollecti0_.id as id1_, mycollecti0_.id as id6_0_, mycollecti0_.datetime as datetime6_0_, mycollecti0_.parent as parent6_0_ from Col4 mycollecti0_ where mycollecti0_.parent in (select parent1x0_.id from Parent1 parent1x0_)
17:48:33,565 DEBUG org.hibernate.cache.TransactionalCache caching: com.ncr.cacheTest.Col4#1564
17:48:33,565 DEBUG org.hibernate.cache.TransactionalCache caching: com.ncr.cacheTest.Col4#495
17:48:33,643 DEBUG org.hibernate.cache.TransactionalCache caching: com.ncr.cacheTest.Col4#1022
...
...
...

Name and version of the database you are using: Teradata R2v6

The generated SQL (show_sql=true):

Hibernate: select parent1x0_.id as id0_, parent1x0_.parentName as parentName0_ from Parent1 parent1x0_

Hibernate: select mycollecti0_.parent as parent1_, mycollecti0_.id as id1_, mycollecti0_.id as id6_0_, mycollecti0_.datetime as datetime6_0_, mycollecti0_.parent as parent6_0_ from Col4 mycollecti0_ where mycollecti0_.parent in (select parent1x0_.id from Parent1 parent1x0_)