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.... - For more information on JIRA, see: http://www.atlassian.com/software/jira