<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">
<base href="https://hibernate.atlassian.net">
<title>Message Title</title>
</head>
<body class="jira" style="color: #333333; font-family: Arial, sans-serif; font-size: 14px; line-height: 1.429">
<table id="background-table" cellpadding="0" cellspacing="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; background-color: #f5f5f5; border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0" bgcolor="#f5f5f5">
<!-- header here -->
<tbody>
<tr>
<td id="header-pattern-container" style="padding: 0; border-collapse: collapse; padding: 10px 20px">
<table id="header-pattern" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<td id="header-avatar-image-container" valign="top" style="padding: 0; border-collapse: collapse; vertical-align: top; width: 32px; padding-right: 8px" width="32"> <img id="header-avatar-image" class="image_fix" src="https://avatar-cdn.atlassian.com/a6be07abea6a2cd20e3e71d2f6033b40?s=48&d=https%3A%2F%2Fsecure.gravatar.com%2Favatar%2Fa6be07abea6a2cd20e3e71d2f6033b40%3Fd%3Dmm%26s%3D48%26noRedirect%3Dtrue" height="32" width="32" border="0" style="border-radius: 3px; vertical-align: top"> </td>
<td id="header-text-container" valign="middle" style="padding: 0; border-collapse: collapse; vertical-align: middle; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px"> <a class="user-hover" rel="zoltan.csikos" style="color:#6c797f;; color: #3b73af; text-decoration: none" id="email_zoltan.csikos" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Ae3d752de-dd6a-4f8a-8b8d-40b7802627ed"> Zoltan Csikos </a> <strong>created</strong> an issue </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td id="email-content-container" style="padding: 0; border-collapse: collapse; padding: 0 20px">
<table id="email-content-table" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; border-spacing: 0; border-collapse: separate">
<tbody>
<tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<td class="email-content-rounded-top mobile-expand" style="padding: 0; border-collapse: collapse; color: #ffffff; padding: 0 15px 0 16px; height: 15px; background-color: #ffffff; border-left: 1px solid #cccccc; border-top: 1px solid #cccccc; border-right: 1px solid #cccccc; border-bottom: 0; border-top-right-radius: 5px; border-top-left-radius: 5px; height: 10px; line-height: 10px; padding: 0 15px 0 16px; mso-line-height-rule: exactly" height="10" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff" bgcolor="#ffffff">
<table class="page-title-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<td class="page-title-pattern-first-line " style="padding: 0; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; padding-top: 10px"> <a href="https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNGJjNzJmNGI3Mjc5NDU5YzlhYzllNDZlMTU1OGZhYTYiLCJwIjoiaiJ9" style="color: #3b73af; text-decoration: none">Hibernate ORM</a> / <a href="https://hibernate.atlassian.net/browse/HHH-13278?atlOrigin=eyJpIjoiNGJjNzJmNGI3Mjc5NDU5YzlhYzllNDZlMTU1OGZhYTYiLCJwIjoiaiJ9" style="color: #3b73af; text-decoration: none"><img src="cid:jira-generated-image-avatar-51553a92-7c26-4bf7-afaa-e52d721ed38f" height="16" width="16" border="0" align="absmiddle" alt="Bug" style="vertical-align: text-bottom"></a> <a href="https://hibernate.atlassian.net/browse/HHH-13278?atlOrigin=eyJpIjoiNGJjNzJmNGI3Mjc5NDU5YzlhYzllNDZlMTU1OGZhYTYiLCJwIjoiaiJ9" style="color: #3b73af; text-decoration: none">HHH-13278</a> </td>
</tr>
<tr>
<td style="vertical-align: top;; padding: 0; border-collapse: collapse; padding-right: 5px; font-size: 20px; line-height: 30px; mso-line-height-rule: exactly" class="page-title-pattern-header-container"> <span class="page-title-pattern-header" style="font-family: Arial, sans-serif; padding: 0; font-size: 20px; line-height: 30px; mso-text-raise: 2px; mso-line-height-rule: exactly; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-13278?atlOrigin=eyJpIjoiNGJjNzJmNGI3Mjc5NDU5YzlhYzllNDZlMTU1OGZhYTYiLCJwIjoiaiJ9" style="color: #3b73af; text-decoration: none">Hibernate EAGER loading triggers multiple queries instead of just one</a> </span> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand wrapper-special-margin" style="padding: 0; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff; padding-top: 10px; padding-bottom: 5px" bgcolor="#ffffff">
<table class="keyvalue-table" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Issue Type:</th>
<td class="has-icon" style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <img src="cid:jira-generated-image-avatar-51553a92-7c26-4bf7-afaa-e52d721ed38f" height="16" width="16" border="0" align="absmiddle" alt="Bug" style="vertical-align: text-bottom"> Bug </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Affects Versions:</th>
<td style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> 5.4.0 </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Assignee:</th>
<td style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> Unassigned </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Components:</th>
<td style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> hibernate-core </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Created:</th>
<td style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> 19/Feb/2019 08:29 AM </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Environment:</th>
<td style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> Windows 10 Home <br> JAVA JDK 1.8 <br> MySQL 5.7 <br> HIbernate 5.4.1 </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Priority:</th>
<td class="has-icon" style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <img src="cid:jira-generated-image-static-major-217dc0a6-e5e4-4c3c-b00d-f196b39aa854" height="16" width="16" border="0" align="absmiddle" alt="Major" style="vertical-align: text-bottom"> Major </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Reporter:</th>
<td style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <a class="user-hover" rel="zoltan.csikos" style="color:#6c797f;; color: #3b73af; text-decoration: none" id="email_zoltan.csikos" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Ae3d752de-dd6a-4f8a-8b8d-40b7802627ed"> Zoltan Csikos </a> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand issue-description-container" style="padding: 0; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff; padding-top: 5px; padding-bottom: 10px" bgcolor="#ffffff">
<table class="text-paragraph-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 2px">
<tbody>
<tr>
<td class="text-paragraph-pattern-container mobile-resize-text " style="padding: 0; border-collapse: collapse; padding: 0 0 10px"> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0; margin-top: 0">Hi,</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">we have a rather strange problem. We've tried to find solutions but honestly we couldn't even create the search phrase that would give us any useful results, so here it is.</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">We have a table structure like this:<br> A</p>
<div class="table-wrap">
<table class="confluenceTable" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; border-collapse: collapse; margin: 5px 0 5px 2px; width: auto">
<tbody>
<tr>
</tr>
</tbody>
</table>
</div> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">---------------</p>
<div class="table-wrap">
<table class="confluenceTable" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; border-collapse: collapse; margin: 5px 0 5px 2px; width: auto">
<tbody>
<tr>
<td class="confluenceTd" style="padding: 0; border-collapse: collapse; border: 1px solid #cccccc; padding: 3px 4px; font: normal 14px/20px Arial, sans-serif"> </td>
<td class="confluenceTd" style="padding: 0; border-collapse: collapse; border: 1px solid #cccccc; padding: 3px 4px; font: normal 14px/20px Arial, sans-serif"> </td>
</tr>
</tbody>
</table>
</div> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">B C D</p>
<div class="table-wrap">
<table class="confluenceTable" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; border-collapse: collapse; margin: 5px 0 5px 2px; width: auto">
<tbody>
<tr>
<td class="confluenceTd" style="padding: 0; border-collapse: collapse; border: 1px solid #cccccc; padding: 3px 4px; font: normal 14px/20px Arial, sans-serif"> </td>
</tr>
</tbody>
</table>
</div> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> D E</p>
<div class="table-wrap">
<table class="confluenceTable" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; border-collapse: collapse; margin: 5px 0 5px 2px; width: auto">
<tbody>
<tr>
</tr>
</tbody>
</table>
</div> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> E</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">the problem is with the D-E table structure, which is referenced twice. When we try to eager load this dataset, once hibernate loaded this structure once, it won't load it again, but stops at joining D without E and triggers a separate query to load the second D-E connection.</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">So the query hibernate puts together will look something like this:<br> ```<br> SELECT a.some_field, ...,<br> FROM A as a<br> LEFT OUTER JOIN B b on a.B_id = b.id<br> LEFT OUTER JOIN C c on a.C_id = c.id<br> LEFT OUTER JOIN D d on c.D_id = d.id<br> LEFT OUTER JOIN E e on d.E_id = e.id<br> LEFT OUTER JOIN D d on a.D_id = d.id<br> <<LEFT JOIN to E from A->D is missing here and sent separately>><br> ```</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">This structure repeats a lot in our original data structure, these are always OneToOne connections, never looping into each other, it's a clear tree structure where we re-use the same structures over and over again, but it's never too deep (max join depth is 5), it contains no loops and many times not all connections are used, so the generated query itself is large, but the dataset behind it often contains a lot of empty connections.</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">We've had a discussion about this here: <a href="https://discourse.hibernate.org/t/hibernate-with-eager-loading-issues-two-queries-instead-of-one/2293" class="external-link" rel="nofollow" style="color: #3b73af; text-decoration: none">https://discourse.hibernate.org/t/hibernate-with-eager-loading-issues-two-queries-instead-of-one/2293</a> where Vlad recommended to create a bug for this.</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">We also created a test case template which can be accessed here: <a href="https://github.com/csore-a-tamas/hibernate-test-case-templates" class="external-link" rel="nofollow" style="color: #3b73af; text-decoration: none">https://github.com/csore-a-tamas/hibernate-test-case-templates</a></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">The database scripts can be accessed here: <a href="https://github.com/csore-a-tamas/hibernatetest/blob/master/mysql_queries" class="external-link" rel="nofollow" style="color: #3b73af; text-decoration: none">https://github.com/csore-a-tamas/hibernatetest/blob/master/mysql_queries</a></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">Let us know if you need anything else from our side.</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">Thanks!</p> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff" bgcolor="#ffffff"> <script type="application/ld+json">
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"description": "View Issue",
"potentialAction": {
"@type": "ViewAction",
"target": "https://hibernate.atlassian.net/browse/HHH-13278?inbox=true&",
"name": "View Issue"
},
"publisher": {
"@type": "Organization",
"name": "Atlassian",
"url": "https://www.atlassian.com"
}
}
</script>
<table id="actions-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px">
<tbody>
<tr>
<td id="actions-pattern-container" valign="middle" style="padding: 0; border-collapse: collapse; padding: 10px 0 10px 24px; vertical-align: middle; padding-left: 0">
<table align="left" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<td class="actions-pattern-action-icon-container" style="padding: 0; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 0; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-13278#add-comment?atlOrigin=eyJpIjoiNGJjNzJmNGI3Mjc5NDU5YzlhYzllNDZlMTU1OGZhYTYiLCJwIjoiaiJ9" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none"> <img class="actions-pattern-action-icon-image" src="cid:jira-generated-image-static-comment-icon-1cdff206-cf7d-43fa-9c69-d9994efcb15a" alt="Add Comment" title="Add Comment" height="16" width="16" border="0" style="vertical-align: middle"> </a> </td>
<td class="actions-pattern-action-text-container" style="padding: 0; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 4px; padding-left: 5px"> <a href="https://hibernate.atlassian.net/browse/HHH-13278#add-comment?atlOrigin=eyJpIjoiNGJjNzJmNGI3Mjc5NDU5YzlhYzllNDZlMTU1OGZhYTYiLCJwIjoiaiJ9" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none">Add Comment</a> </td>
</tr>
</tbody>
</table> </td>
</tr>
</tbody>
</table> </td>
</tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<tr>
<td class="email-content-rounded-bottom mobile-expand" style="padding: 0; border-collapse: collapse; color: #ffffff; padding: 0 15px 0 16px; height: 5px; line-height: 5px; background-color: #ffffff; border-top: 0; border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; border-right: 1px solid #cccccc; border-bottom-right-radius: 5px; border-bottom-left-radius: 5px; mso-line-height-rule: exactly" height="5" bgcolor="#ffffff"> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td id="footer-pattern" style="padding: 0; border-collapse: collapse; padding: 12px 20px">
<table id="footer-pattern-container" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<td id="footer-pattern-mobile-separated-links" class="mobile-resize-text" width="100%" colspan="2" style="padding: 0; border-collapse: collapse; color: #999999; font-size: 12px; line-height: 18px; font-family: Arial, sans-serif; mso-line-height-rule: exactly; mso-text-raise: 2px"> Get Jira notifications on your phone! Download the Jira Cloud app for <a href="https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail" style="color: #3b73af; text-decoration: none">Android</a> or <a href="https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8" style="color: #3b73af; text-decoration: none">iOS</a>
<hr> </td>
</tr>
<tr>
<td id="footer-pattern-text" class="mobile-resize-text" width="100%" style="padding: 0; border-collapse: collapse; color: #999999; font-size: 12px; line-height: 18px; font-family: Arial, sans-serif; mso-line-height-rule: exactly; mso-text-raise: 2px"> This message was sent by Atlassian Jira <span id="footer-build-information">(v1001.0.0-SNAPSHOT#100098-<span title="f55111e7d0ea00c4ecd7302ff21e46e573895a83" data-commit-id="f55111e7d0ea00c4ecd7302ff21e46e573895a83}">sha1:f55111e</span>)</span> </td>
<td id="footer-pattern-logo-desktop-container" valign="top" style="padding: 0; border-collapse: collapse; padding-left: 20px; vertical-align: top">
<table style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<td id="footer-pattern-logo-desktop-padding" style="padding: 0; border-collapse: collapse; padding-top: 3px; opacity: 0.150"> <img id="footer-pattern-logo-desktop" src="cid:jira-generated-image-static-footer-desktop-logo-ffb7b3c5-e3ea-42d9-bf78-bb24f841872d" alt="Atlassian logo" title="Atlassian logo" width="192" height="24" class="image_fix"> </td>
</tr>
</tbody>
</table> </td>
</tr>
</tbody>
</table> </td>
</tr>
</tbody>
</table>
<img border="0" width="1" height="1" alt="" src="http://atlassian.et.e.sparkpost.com/q/WHm7j10q5KoS7AXq9xrajw~~/AAAAAQA~/RgReTWJjPlcLYXRsYXNzaWFudXNCCgAA4y5sXEMBaMVSIGhpYmVybmF0ZS1pc3N1ZXNAbGlzdHMuamJvc3Mub3JnWAQAAAAE">
</body>
</html>