Message Title

Eskil Bylund created an issue

HHH-9029

Issue Type:	Bug
Affects Versions:	4.3.0.Final, 4.1.9
Assignee:	Unassigned
Attachments:	0001-Fix-missing-parenthesis-around-composite-properties-.patch
Components:	query-hql
Created:	07/Mar/14 6:11 AM
Priority:	Minor
Reporter:	Eskil Bylund

The attached patch fixes and issue where Hibernate would omit parentheses around the fields of a composite id.

 
                                                    SELECT e FROM EntityWithCompositeId e
WHERE EXISTS (SELECT 1 FROM EntityWithCompositeId)
AND e.id = :id

would result in

 
                                                    select entitywith0_.id1 as id1_0_, entitywith0_.id2 as id2_0_, entitywith0_.description as descript3_0_ from EntityWithCompositeId entitywith0_ where (exists (select 1 from EntityWithCompositeId entitywith1_)) and entitywith0_.id1, entitywith0_.id2=(?, ?)

when the query should be

 
                                                    select entitywith0_.id1 as id1_0_, entitywith0_.id2 as id2_0_, entitywith0_.description as descript3_0_ from EntityWithCompositeId entitywith0_ where (exists (select 1 from EntityWithCompositeId entitywith1_)) and (entitywith0_.id1, entitywith0_.id2)=(?, ?)

Add Comment

This message was sent by Atlassian JIRA