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