<style>
/* Changing the layout to use less space for mobiles */
@media screen and (max-device-width: 480px), screen and (-webkit-min-device-pixel-ratio: 2) {
#email-body { min-width: 30em !important; }
#email-page { padding: 8px !important; }
#email-banner { padding: 8px 8px 0 8px !important; }
#email-avatar { margin: 1px 8px 8px 0 !important; padding: 0 !important; }
#email-fields { padding: 0 8px 8px 8px !important; }
#email-gutter { width: 0 !important; }
}
</style>
<div id="email-body">
<table id="email-wrap" align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#f0f0f0;color:#000000;width:100%;">
<tr valign="top">
<td id="email-page" style="padding:16px !important;">
<table align="center" border="0" cellpadding="0" cellspacing="0" style="background-color:#ffffff;border:1px solid #bbbbbb;color:#000000;width:100%;">
<tr valign="top">
<td bgcolor="#3e4c4e" style="background-color:#3e4c4e;color:#ffffff;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;line-height:1;"><img src="https://www.jboss.org/dms/hibernate/images/jira/jiraheader_hibernate.png" alt="" style="vertical-align:top;" /></td>
</tr><tr valign="top">
<td id="email-banner" style="padding:32px 32px 0 32px;">
<table align="left" border="0" cellpadding="0" cellspacing="0" width="100%" style="width:100%;">
<tr valign="top">
<td style="color:#505050;font-family:Arial,FreeSans,Helvetica,sans-serif;padding:0;">
<img id="email-avatar" src="https://hibernate.onjira.com/secure/useravatar?avatarId=10162" alt="" height="48" width="48" border="0" align="left" style="padding:0;margin: 0 16px 16px 0;" />
<div id="email-action" style="padding: 0 0 8px 0;font-size:12px;line-height:18px;">
<a class="user-hover" rel="dealus" id="email_dealus" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=dealus" style="color:#6c797f;">Nicolas Carlot</a>
created <img src="https://hibernate.onjira.com/images/icons/bug.gif" height="16" width="16" border="0" align="absmiddle" alt="Bug"> <a style='color:#6c797f;text-decoration:none;' href='https://hibernate.onjira.com/browse/HHH-7449'>HHH-7449</a>
</div>
<div id="email-summary" style="font-size:16px;line-height:20px;padding:2px 0 16px 0;">
<a style='color:#6c797f;text-decoration:none;' href='https://hibernate.onjira.com/browse/HHH-7449'><strong>Bad request built from a criteria with a specific mapping</strong></a>
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr valign="top">
<td id="email-fields" style="padding:0 32px 32px 32px;">
<table border="0" cellpadding="0" cellspacing="0" style="padding:0;text-align:left;width:100%;" width="100%">
<tr valign="top">
<td id="email-gutter" style="width:64px;white-space:nowrap;"></td>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Issue Type:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<img src="https://hibernate.onjira.com/images/icons/bug.gif" height="16" width="16" border="0" align="absmiddle" alt="Bug"> Bug
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Affects Versions:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
3.6.9 </td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Assignee:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
Unassigned </td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Components:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
query-criteria </td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Created:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
13/Jul/12 8:10 AM
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Description:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<p style='margin-top:0;margin-bottom:10px;'>It seems hibernate criteria is wrongly solved when the model has a specific shape:</p>
<p style='margin-top:0;margin-bottom:10px;'><hibernate-mapping default-cascade="persist,merge,save-update" default-access="org.jspresso.framework.model.persistence.hibernate.property.EntityPropertyAccessor"><br/>
<class persister="org.jspresso.framework.model.persistence.hibernate.entity.persister.EntityProxyJoinedSubclassEntityPersister" dynamic-update="true" table="MOVEMENT" dynamic-insert="true" name="fr.model.Movement"><br/>
<id name="id" type="string"><br/>
<column name="ID" length="36"/><br/>
<generator class="assigned"/><br/>
</id><br/>
<many-to-one insert="false" foreign-key="MOVEMENT_CURRENT_COMPOSITION_FK" update="false" not-null="true" name="currentComposition"><br/>
<column name="CURRENT_COMPOSITION_ID"/><br/>
</many-to-one><br/>
</class><br/>
</hibernate-mapping></p>
<p style='margin-top:0;margin-bottom:10px;'><hibernate-mapping default-cascade="persist,merge,save-update" default-access="org.jspresso.framework.model.persistence.hibernate.property.EntityPropertyAccessor"><br/>
<class persister="org.jspresso.framework.model.persistence.hibernate.entity.persister.EntityProxyJoinedSubclassEntityPersister" dynamic-update="true" table="COMPOSITION" dynamic-insert="true" name="fr.gefco.geri.model.Composition"><br/>
<id name="id" type="string"><br/>
<column name="ID" length="36"/><br/>
<generator class="assigned"/><br/>
</id><br/>
<list name="movements"><br/>
<key column="CURRENT_COMPOSITION_ID"/><br/>
<list-index column="COMPOSITION_MOVEMENTS_SEQ"/><br/>
<one-to-many class="fr.gefco.geri.model.Movement"/><br/>
</list><br/>
</class><br/>
</hibernate-mapping></p>
<p style='margin-top:0;margin-bottom:10px;'><hibernate-mapping default-cascade="persist,merge,save-update" default-access="org.jspresso.framework.model.persistence.hibernate.property.EntityPropertyAccessor"><br/>
<class persister="org.jspresso.framework.model.persistence.hibernate.entity.persister.EntityProxyJoinedSubclassEntityPersister" dynamic-update="true" table="TRAIN" dynamic-insert="true" name="fr.gefco.geri.model.Train"><br/>
<id name="id" type="string"><br/>
<column name="ID" length="36"/><br/>
<generator class="assigned"/><br/>
</id><br/>
<many-to-one unique="true" foreign-key="TRAIN_COMPOSITION_FK" name="composition"><br/>
<column name="COMPOSITION_ID"/><br/>
</many-to-one><br/>
</class><br/>
</hibernate-mapping></p>
<p style='margin-top:0;margin-bottom:10px;'>While using this mapping, the following criteria generates wrong SQL:<br/>
DetachedCriteria movementCriteria = DetachedCriteria.forClass(Movement.class);<br/>
movementCriteria.add(Restrictions.isNotNull(Movement.RTD));<br/>
movementCriteria.add(Restrictions.eq(Movement.PARKED, false));<br/>
DetachedCriteria compositionCriteria = movementCriteria.createCriteria(Movement.CURRENT_COMPOSITION);<br/>
compositionCriteria.add(Restrictions.eq(Composition.TRAIN, trainFilter));<br/>
DetachedCriteria wtoCriteria = movementCriteria.createCriteria(Movement.WAGON_TRANSPORT_ORDER);<br/>
wtoCriteria.add(Restrictions.eq(WagonTransportOrder.STATE, WagonTransportOrder.STATE_STARTED));<br/>
wtoCriteria.add(Restrictions.eq(WagonTransportOrder.LOAD_WEIGHT, 0.d));</p>
<p style='margin-top:0;margin-bottom:10px;'>While this version is ok:<br/>
EnhancedDetachedCriteria movementCriteria = EnhancedDetachedCriteria.forClass(Movement.class); //wtoCriteria.createCriteria(WagonTransportOrder.CURRENT_MOVEMENT);<br/>
movementCriteria.add(Restrictions.isNotNull(Movement.RTD));<br/>
movementCriteria.add(Restrictions.eq(Movement.PARKED, false));<br/>
DetachedCriteria compositionCriteria = movementCriteria.getSubCriteriaFor(movementCriteria, Movement.CURRENT_COMPOSITION);<br/>
DetachedCriteria trainCriteria = movementCriteria.getSubCriteriaFor(compositionCriteria, Composition.TRAIN);<br/>
trainCriteria.add(Restrictions.idEq(trainFilter.getId()));<br/>
DetachedCriteria wtoCriteria = movementCriteria.getSubCriteriaFor(movementCriteria, Movement.WAGON_TRANSPORT_ORDER);<br/>
wtoCriteria.add(Restrictions.eq(WagonTransportOrder.STATE, WagonTransportOrder.STATE_STARTED));<br/>
wtoCriteria.add(Restrictions.eq(WagonTransportOrder.LOAD_WEIGHT, 0.d));</p>
<p style='margin-top:0;margin-bottom:10px;'>Those 2 versions of the criteria should be processed the same way, and build the same SQL request.<br/>
This is not the case.</p>
<p style='margin-top:0;margin-bottom:10px;'>Case1:<br/>
select * from MOVEMENT this_<br/>
inner join WAGON_TRANSPORT_ORDER wagontrans2_<br/>
on this_.WAGON_TRANSPORT_ORDER_ID=wagontrans2_.ID<br/>
inner join COMPOSITION compositio1_<br/>
on this_.CURRENT_COMPOSITION_ID=compositio1_.ID<br/>
where this_.RTD is not null<br/>
and this_.PARKED=?<br/>
and compositio1_.ID=? <- WTF ?<br/>
and wagontrans2_.STATE=?<br/>
and wagontrans2_.LOAD_WEIGHT=?</p>
<p style='margin-top:0;margin-bottom:10px;'>With errors as the request is executed:<br/>
12:00:08,491 TRACE <span class="error">[org.hibernate.type.descriptor.sql.BasicBinder]</span> binding parameter <span class="error">[1]</span> as <span class="error">[BIT]</span> - false<br/>
12:00:08,491 TRACE <span class="error">[org.hibernate.type.descriptor.sql.BasicBinder]</span> binding parameter <span class="error">[2]</span> as <span class="error">[VARCHAR]</span> - STARTED<br/>
12:00:08,491 TRACE <span class="error">[org.hibernate.type.descriptor.sql.BasicBinder]</span> binding parameter <span class="error">[3]</span> as <span class="error">[DOUBLE]</span> - 0.0<br/>
12:00:08,492 WARN <span class="error">[org.hibernate.util.JDBCExceptionReporter]</span> SQL Error: 0, SQLState: 07001<br/>
12:00:08,492 ERROR <span class="error">[org.hibernate.util.JDBCExceptionReporter]</span> No value specified for parameter 4</p>
<p style='margin-top:0;margin-bottom:10px;'>Case2:<br/>
select from MOVEMENT this_ <br/>
inner join WAGON_TRANSPORT_ORDER wagontrans3_ <br/>
on this_.WAGON_TRANSPORT_ORDER_ID=wagontrans3_.ID <br/>
inner join COMPOSITION compositio1_ <br/>
on this_.CURRENT_COMPOSITION_ID=compositio1_.ID <br/>
inner join TRAIN train2_ <br/>
on compositio1_.ID=train2_.COMPOSITION_ID <br/>
where this_.RTD is not null <br/>
and this_.PARKED=? <br/>
and train2_.ID = ? <br/>
and wagontrans3_.STATE=? <br/>
and wagontrans3_.LOAD_WEIGHT=?</p>
</td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Environment:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
Mysql
</td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Project:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<a style="color:#6c797f;" href="https://hibernate.onjira.com/browse/HHH">Hibernate ORM</a>
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Labels:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
criteria
</td>
</tr>
<tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Priority:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<img src="https://hibernate.onjira.com/images/icons/priority_major.gif" height="16" width="16" border="0" align="absmiddle" alt="Major"> Major
</td>
</tr> <tr valign="top">
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 10px 10px 0;white-space:nowrap;">
<strong style="font-weight:normal;color:#505050;">Reporter:</strong>
</td>
<td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;">
<a class="user-hover" rel="dealus" id="email_dealus" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=dealus" style="color:#6c797f;">Nicolas Carlot</a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td><!-- End #email-page -->
</tr>
<tr valign="top">
<td style="color:#505050;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:10px;line-height:14px;padding: 0 16px 16px 16px;text-align:center;">
This message is automatically generated by JIRA.<br />
If you think it was sent incorrectly, please contact your <a style='color:#6c797f;' href='https://hibernate.onjira.com/secure/ContactAdministrators!default.jspa'>JIRA administrators</a>.<br />
For more information on JIRA, see: <a style='color:#6c797f;' href='http://www.atlassian.com/software/jira'>http://www.atlassian.com/software/jira</a>
</td>
</tr>
</table><!-- End #email-wrap -->
</div><!-- End #email-body -->