[Hibernate-issues] [Hibernate-JIRA] Assigned: (HHH-1858) wrong sql generated against many-to-any association table

[Steve E. (JIRA) <no...@at...>]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1858?page=all ]

Steve Ebersole reassigned HHH-1858:
-----------------------------------

    Assign To: Steve Ebersole

> wrong sql generated against many-to-any association table
> ---------------------------------------------------------
>
>          Key: HHH-1858
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1858
>      Project: Hibernate3
>         Type: Bug

>   Components: query-hql
>     Versions: 3.1 rc 1
>  Environment: tested against postgresql 8.1, OracleXE/10Gr, using hidernate3.&.rc1 and hibernate console3.1.0.beta5 (hibernate3.2.0.cr1)
>     Reporter: Erwan Le Goulven
>     Assignee: Steve Ebersole

>
>
> Specifying a column name different than 'id'  in <many-to-any> relation leads to uncorrect hql generated.
> <class name="com.lectra.mapgentest.domain.test.manytomany.ItemImpl" table="ITEM" lazy="true" dynamic-update="true">
> ...
> ..
>         <set name="classifs" table="CLASSIFIABLE_CLASSIFS_ITEM" lazy="true" inverse="false">
>             <key foreign-key="none">
>                 <column name="items_id" index="ITEM_MYTESTIN_IDX" />
>             </key>
>             <many-to-any id-type="java.lang.Long" meta-type="string">
>                 <meta-value value="ClassifFolder" class="com.lectra.mapgentest.domain.test.manytomany.ClassifFolderImpl" />
>                 <meta-value value="ClassifAxe" class="com.lectra.mapgentest.domain.test.manytomany.ClassifAxeImpl" />
>                 <column name="classifs_type" />
>                 <column name="classifs_id" />
>             </many-to-any>
>         </set>
> ..
> ...
> </class>
> Sample hql triggering error :
> from ItemImpl i
> inner join i.classifs c
> where c.id is not null
> Generated sq :
> select
>   itemimpl0_.id as id71_,
>   itemimpl0_.parent_id as parent2_71_ 
>  from
>   ITEM itemimpl0_ 
>  inner join
>   CLASSIFIABLE_CLASSIFS_ITEM classifs1_ 
>    on itemimpl0_.id=classifs1_.items_id 
>  where
>   classifs1_.id is not null
> The same trouble might occur on <any> relation, and the column name resolution is not done when dealing with hql constraints against the "any" side

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