<!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/1a7974b01ec03096311dcb245a916ba8?s=48&d=https%3A%2F%2Fsecure.gravatar.com%2Favatar%2F1a7974b01ec03096311dcb245a916ba8%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="randy.may" id="email_randy.may" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=randy.may" style="color:#6c797f;; color: #3b73af; text-decoration: none">Randy May</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" style="color: #3b73af; text-decoration: none">Hibernate ORM</a> / <a href="https://hibernate.atlassian.net/browse/HHH-12076" style="color: #3b73af; text-decoration: none"><img src="cid:jira-generated-image-avatar-feba22ce-8b87-4dbc-a482-8563079707e0" height="16" width="16" border="0" align="absmiddle" alt="Bug" style="vertical-align: text-bottom"></a> <a href="https://hibernate.atlassian.net/browse/HHH-12076" style="color: #3b73af; text-decoration: none">HHH-12076</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-12076" style="color: #3b73af; text-decoration: none">Query not built properly when joining a table based on class</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-feba22ce-8b87-4dbc-a482-8563079707e0" 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.1.9 </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, query-hql, query-sql </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"> 02/Nov/2017 06: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">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-3979fcc4-c6d0-4e9f-a4eb-05b0b00d8d24" 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="randy.may" id="email_randy.may" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=randy.may" style="color:#6c797f;; color: #3b73af; text-decoration: none">Randy May</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">Here is excerpt from the HQL that we are using (that worked properly in 3.2.7):</p>
<div class="code panel" style="border-width: 1px;; border: 1px solid #cccccc; background: #f5f5f5; font-size: 12px; line-height: 1.333; font-family: monospace; border: 1px solid #cccccc; -moz-border-radius: 3px; border-radius: 3px; margin: 9px 0">
<div class="codeContent panelContent" style="padding: 9px 12px">
<pre class="code-sql" style="margin: 10px 0 0; margin-top: 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal">
<span class="code-keyword" style="color: #000091">select</span> ... <span class="code-keyword" style="color: #000091">from</span> SettlementTask <span class="code-keyword" style="color: #000091">as</span> rootAlias <span class="code-keyword" style="color: #000091">join</span> rootAlias.linked <span class="code-keyword" style="color: #000091">as</span> _linked <span class="code-keyword" style="color: #000091">left</span> <span class="code-keyword" style="color: #000091">join</span> _linked.extensions <span class="code-keyword" style="color: #000091">as</span> _extensions <span class="code-keyword" style="color: #000091">with</span> _extensions.class=com.walkaway.claim.<span class="code-keyword" style="color: #000091">domain</span>.settlement.extension.i3.EwtAssessmentExtension
</pre>
</div>
</div> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">Here is the resulting SQL that is produced:</p>
<div class="code panel" style="border-width: 1px;; border: 1px solid #cccccc; background: #f5f5f5; font-size: 12px; line-height: 1.333; font-family: monospace; border: 1px solid #cccccc; -moz-border-radius: 3px; border-radius: 3px; margin: 9px 0">
<div class="codeContent panelContent" style="padding: 9px 12px">
<pre class="code-sql" style="margin: 10px 0 0; margin-top: 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal">
<span class="code-keyword" style="color: #000091">left</span> <span class="code-keyword" style="color: #000091">outer</span> <span class="code-keyword" style="color: #000091">join</span> claim_settlement_ext extensions7_ <span class="code-keyword" style="color: #000091">on</span> settlement3_.id=extensions7_.settlement_id <span class="code-keyword" style="color: #000091">and</span> (<span class="code-keyword" style="color: #000091">case</span> <span class="code-keyword" style="color: #000091">when</span> extensions7_1_.extension_id <span class="code-keyword" style="color: #000091">is</span> <span class="code-keyword" style="color: #000091">not</span> <span class="code-keyword" style="color: #000091">null</span> <span class="code-keyword" style="color: #000091">then</span> 1 <span class="code-keyword" style="color: #000091">when</span> extensions7_2_.extension_id <span class="code-keyword" style="color: #000091">is</span> <span class="code-keyword" style="color: #000091">not</span> <span class="code-keyword" style="color: #000091">null</span> <span class="code-keyword" style="color: #000091">then</span> 2 <span class="code-keyword" style="color: #000091">when</span> extensions7_3_.extension_id <span class="code-keyword" style="color: #000091">is</span> <span class="code-keyword" style="color: #000091">not</span> <span class="code-keyword" style="color: #000091">null</span> <span class="code-keyword" style="color: #000091">then</span> 3 <span class="code-keyword" style="color: #000091">when</span> extensions7_4_.extension_id <span class="code-keyword" style="color: #000091">is</span> <span class="code-keyword" style="color: #000091">not</span> <span class="code-keyword" style="color: #000091">null</span> <span class="code-keyword" style="color: #000091">then</span> 4 <span class="code-keyword" style="color: #000091">when</span> extensions7_5_.extension_id <span class="code-keyword" style="color: #000091">is</span> <span class="code-keyword" style="color: #000091">not</span> <span class="code-keyword" style="color: #000091">null</span> <span class="code-keyword" style="color: #000091">then</span> 5 <span class="code-keyword" style="color: #000091">when</span> extensions7_6_.extension_id <span class="code-keyword" style="color: #000091">is</span> <span class="code-keyword" style="color: #000091">not</span> <span class="code-keyword" style="color: #000091">null</span> <span class="code-keyword" style="color: #000091">then</span> 6 <span class="code-keyword" style="color: #000091">when</span> extensions7_.id <span class="code-keyword" style="color: #000091">is</span> <span class="code-keyword" style="color: #000091">not</span> <span class="code-keyword" style="color: #000091">null</span> <span class="code-keyword" style="color: #000091">then</span> 0 <span class="code-keyword" style="color: #000091">end</span>=1) <span class="code-keyword" style="color: #000091">left</span> <span class="code-keyword" style="color: #000091">outer</span> <span class="code-keyword" style="color: #000091">join</span> claim_settlement_ext_i3_ewt extensions7_1_ <span class="code-keyword" style="color: #000091">on</span> extensions7_.id=extensions7_1_.extension_id <span class="code-keyword" style="color: #000091">left</span> <span class="code-keyword" style="color: #000091">outer</span> <span class="code-keyword" style="color: #000091">join</span> claim_settlement_ext_walkaway_dr extensions7_2_ <span class="code-keyword" style="color: #000091">on</span> extensions7_.id=extensions7_2_.extension_id <span class="code-keyword" style="color: #000091">left</span> <span class="code-keyword" style="color: #000091">outer</span> <span class="code-keyword" style="color: #000091">join</span> claim_settlement_ext_walkaway_gap extensions7_3_ <span class="code-keyword" style="color: #000091">on</span> extensions7_.id=extensions7_3_.extension_id <span class="code-keyword" style="color: #000091">left</span> <span class="code-keyword" style="color: #000091">outer</span> <span class="code-keyword" style="color: #000091">join</span> claim_settlement_ext_walkaway_pr extensions7_4_ <span class="code-keyword" style="color: #000091">on</span> extensions7_.id=extensions7_4_.extension_id <span class="code-keyword" style="color: #000091">left</span> <span class="code-keyword" style="color: #000091">outer</span> <span class="code-keyword" style="color: #000091">join</span> claim_settlement_ext_walkaway_ccr extensions7_5_ <span class="code-keyword" style="color: #000091">on</span> extensions7_.id=extensions7_5_.extension_id <span class="code-keyword" style="color: #000091">left</span> <span class="code-keyword" style="color: #000091">outer</span> <span class="code-keyword" style="color: #000091">join</span> claim_settlement_ext_walkaway_vr extensions7_6_ <span class="code-keyword" style="color: #000091">on</span> extensions7_.id=extensions7_6_.extension_id
</pre>
</div>
</div> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">The error message we are seeing is:</p>
<blockquote style="margin: 10px 0 0; border-left: 1px solid #cccccc; color: #707070; margin-left: 19px; padding: 10px 20px">
<p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0; margin-top: 0">ERROR: missing FROM-clause entry for table "extensions7_1_"</p>
</blockquote> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">I am fully aware that the 'with' attribute has been deprecated in favour of the 'type' attribute, but this query did get generated properly in 3.2.7, and now in 5.2.9 it does not. </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-12076?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-12076#add-comment" 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-8288c10e-b8a8-421c-8af2-c95705ba524f" 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-12076#add-comment" 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#100070-<span title="3d6242514fd829d9fc183556659ebc31096a7be8" data-commit-id="3d6242514fd829d9fc183556659ebc31096a7be8}">sha1:3d62425</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-3ff293d7-ad72-4de1-b913-f2aa1625c63f" 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 src="https://u4043402.ct.sendgrid.net/wf/open?upn=YNXLe5Uzuivj8jGpuXra04BSJ-2BS7raa1puTAtyVUP-2F0vngXMYTK-2FS3Irgj0Y-2FFD4VYR7GYnu0VAYC8rBW2zo-2BhI1n0R48PcUEZLWtVfj2DPM9AyQeyvw7xWGImPs2A5cSCDpm7PX-2B8UN-2B1dJNqC0v8BP2R6-2FIu903AhNZa1jqY6Tz37YPwEAguvFU0ovAp1VaFZ-2BOphJcOm-2BzcskE-2B6TnvBVemWcrieqtdbUlFcmoH9srLLFQZRaQPNyIWPtC-2Buq" alt="" width="1" height="1" border="0" style="height:1px !important;width:1px !important;border-width:0 !important;margin-top:0 !important;margin-bottom:0 !important;margin-right:0 !important;margin-left:0 !important;padding-top:0 !important;padding-bottom:0 !important;padding-right:0 !important;padding-left:0 !important;"/>
</body>
</html>