[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-2120) composite-id in a parent-child mapping build a wrong query

[Max Rydahl Andersen (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2120?page=all ]
     
Max Rydahl Andersen closed HHH-2120:
------------------------------------

    Resolution: Won't Fix

That generated sql is perfect valid ansi sql syntax. Some databases does not support that.

Thus in Hibernate 3.2 we implemented handling for property with composite columns for the db's that need individual colum comparison.

A backport will not happen.

> composite-id in a parent-child mapping build a wrong query
> ----------------------------------------------------------
>
>          Key: HHH-2120
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2120
>      Project: Hibernate3
>         Type: Bug

>   Components: query-hql
>     Versions: 3.0.5, 3.1.3
>  Environment: hibernate 3.0.5 or hibernate 3.1.3 as in the distribution tar.gz. . Y probe it in Oracle 9 and MySQL with the same result.
>     Reporter: German de la Cruz
>     Priority: Blocker
>  Attachments: CompositeIdTest.java
>
>
> When I run the attached code (You can see it is the same class in tests in distribution file, but with a new method called testQuery2 that can reproduce the bug) Hibernate generate the following query.
> Since I've probed it in two differents db's, I can't say it's a Dialect problem.
> I can't reproduce it in hibernate-3.2.CR4 (It works fine). Then what I need is a backport to 3.0.5 and 3.1.3
> HQL:
>     from LineItem ol where ol.order=:order
> Generated SQL:
>     select
>         lineitem0_.customerId as customerId2_,
>         lineitem0_.orderNumber as orderNum2_2_,
>         lineitem0_.productId as productId2_,
>         lineitem0_.quantity as quantity2_ 
>     from
>         LineItem lineitem0_ 
>     where
>         (
>             lineitem0_.customerId, lineitem0_.orderNumber
>         )=?

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