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

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 )=?