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

[German de la Cruz (JIRA)]

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