<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;">
                            &nbsp;                         <div id="email-action" style="padding: 0 0 8px 0;font-size:12px;line-height:18px;">
                                    <a class="user-hover" rel="katmai2000" id="email_katmai2000" href="https://hibernate.onjira.com/secure/ViewProfile.jspa?name=katmai2000" style="color:#6c797f;">Stephan van Hugten</a>
     edited a comment on <img src="https://hibernate.onjira.com/images/icons/removefeature.gif" height="16" width="16" border="0" align="absmiddle" alt="Deprecation"> <a style='color:#6c797f;text-decoration:none;' href='https://hibernate.onjira.com/browse/HHH-1673'>HHH-1673</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-1673'><strong>hql parsed with exception (with clause)</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 colspan="2" style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 16px 0;width:100%;">
        <div class="comment-block" style="background-color:#edf5ff;border:1px solid #dddddd;color:#000000;padding:12px;"><p>The current patch provided didn't do enough for me, so I dug a little deeper. I needed to use different aliases on the same table, so I changed the following methods in the HqlSqlWalker (version 3.3.2.GA): handleWithFragment, createFromJoinElement and WithClauseVisitor:visit.<br/>
I removed all the alias checking, but preserved the checking on joining across tables.<br/>
I also made the decision that, if you're using multiple aliases to point to the same table, I generate an 'OR', because otherwise parentheses are ignored in with clauses (something a Hibernate dev can fix?).</p>

<p>My testcase:<br/>
Entity CertificateTransaction has the previous CertificateTransaction as a field.<br/>
HQL:<br/>
LEFT JOIN CT.previousVersion pv with pv.certificates.length &gt; CT.certificates.length<br/>
AND    ct.previousVersion.id = pv.id<br/>
AND    ct.type = pv.type<br/>
LEFT JOIN CT.previousVersion pv2 with ct.previousVersion.id = pv2.id<br/>
AND    pv2.status = nl.certiq.ecs2.model.certificates.CertificateTransactionStatusType.REJECTED</p>

<p>generates something like (Pseudo code):</p>

<p>LEFT JOIN CT.previousVersion pv ON (pv.certificates.length &gt; CT.certificates.length<br/>
AND    ct.previousVersion.id = pv.id<br/>
AND    ct.type = pv.type)<br/>
OR (CT.previousVersion pv2 with ct.previousVersion.id = pv2.id<br/>
AND   ( pv2.status = 'REJECTED' ) </p>

<p>What do you think?          </p></div>
        <div style="color:#505050;padding:4px 0 0 0;">                </div>
    </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 JIRA administrators<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 -->