<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://secure.gravatar.com/avatar/e8e9b204779033d066c1e3259d5abe87?d=mm&s=48" 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="nick.sree" id="email_nick.sree" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=nick.sree" style="color:#6c797f;">nick</a>
created <img src="https://hibernate.atlassian.net/images/icons/issuetypes/bug.png" height="16" width="16" border="0" align="absmiddle" alt="Bug"> <a style='color:#6c797f;text-decoration:none;' href='https://hibernate.atlassian.net/browse/HHH-8192'>HHH-8192</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.atlassian.net/browse/HHH-8192'><strong>Distinct With Order By producing ORA-01791</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.atlassian.net/images/icons/issuetypes/bug.png" 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.5.5 </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%;">
core, query-hql, query-sql </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%;">
19/Apr/13 12:55 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;'>This is my HQL query</p>
<div class="preformatted panel" style="border-width: 1px;"><div class="preformattedContent panelContent">
<pre>
select distinct contractorDet.contractor from ContractorDetail contractorDet where contractorDet.status.description=? and contractorDet.status.moduletype=? and (upper(contractorDet.contractor.code) like ? or upper(contractorDet.contractor.name) like ?) order by contractorDet.contractor.code,contractorDet.contractor.name
</pre>
</div></div>
<p style='margin-top:0;margin-bottom:10px;'>This generates the following SQL </p>
<div class="preformatted panel" style="border-width: 1px;"><div class="preformattedContent panelContent">
<pre>
SELECT DISTINCT contractor1_.ID AS ID139_,
contractor1_.CREATEDBY AS CREATEDBY139_,
contractor1_.MODIFIEDBY AS MODIFIEDBY139_,
contractor1_.CREATEDDATE AS CREATEDD4_?_,
contractor1_.MODIFIEDDATE AS MODIFIED5_?_,
contractor1_.CODE AS CODE139_,
contractor1_.NAME AS NAME139_,
contractor1_.CORRESPONDENCE_ADDRESS AS CORRESPO8_?_,
contractor1_.PAYMENT_ADDRESS AS PAYMENT9_?_,
contractor1_.CONTACT_PERSON AS CONTACT10_?_,
contractor1_.EMAIL AS EMAIL139_,
contractor1_.NARRATION AS NARRATION139_,
contractor1_.PAN_NUMBER AS PAN13_?_,
contractor1_.TIN_NUMBER AS TIN14_?_,
contractor1_.BANK_ID AS BANK15_?_,
contractor1_.IFSC_CODE AS IFSC16_?_,
contractor1_.BANK_ACCOUNT AS BANK17_?_,
contractor1_.PWD_APPROVAL_CODE AS PWD18_?_
FROM EGW_CONTRACTOR_DETAIL contractor0_,
EGW_CONTRACTOR contractor1_,
EGW_STATUS egwstatus2_,
EGW_CONTRACTOR contractor4_
WHERE contractor0_.CONTRACTOR_ID=contractor1_.ID
AND contractor0_.STATUS_ID =egwstatus2_.ID
AND contractor0_.CONTRACTOR_ID =contractor4_.ID
AND egwstatus2_.DESCRIPTION ='Active'
AND egwstatus2_.MODULETYPE ='Contractor'
AND (upper(contractor4_.CODE) LIKE '%100%'
OR upper(contractor4_.NAME) LIKE '%100%')
ORDER BY contractor4_.CODE,
contractor4_.NAME;
</pre>
</div></div>
<p style='margin-top:0;margin-bottom:10px;'>And this is throwing <br/>
<font color="red"></font> <br/>
ERROR<br/>
<span class="error">[org.hibernate.util.JDBCExceptionReporter]</span> (http-0.0.0.0-9980-1)<br/>
ORA-01791: not a SELECTed expression <br/>
<font color="red"></font> </p>
<p style='margin-top:0;margin-bottom:10px;'>But the same HQL query generating the following SQL when we used hibernate-3.3.1 GA and its working fine.</p>
<div class="preformatted panel" style="border-width: 1px;"><div class="preformattedContent panelContent">
<pre>
SELECT DISTINCT contractor1_.ID AS ID270_,
contractor1_.CREATEDBY AS CREATEDBY270_,
contractor1_.MODIFIEDBY AS MODIFIEDBY270_,
contractor1_.CREATEDDATE AS CREATEDD4_270_,
contractor1_.MODIFIEDDATE AS MODIFIED5_270_,
contractor1_.CODE AS CODE270_,
contractor1_.NAME AS NAME270_,
contractor1_.CORRESPONDENCE_ADDRESS AS CORRESPO8_270_,
contractor1_.PAYMENT_ADDRESS AS PAYMENT9_270_,
contractor1_.CONTACT_PERSON AS CONTACT10_270_,
contractor1_.EMAIL AS EMAIL270_,
contractor1_.NARRATION AS NARRATION270_,
contractor1_.PAN_NUMBER AS PAN13_270_,
contractor1_.TIN_NUMBER AS TIN14_270_,
contractor1_.BANK_ID AS BANK15_270_,
contractor1_.IFSC_CODE AS IFSC16_270_,
contractor1_.BANK_ACCOUNT AS BANK17_270_,
contractor1_.PWD_APPROVAL_CODE AS PWD18_270_
FROM EGW_CONTRACTOR_DETAIL contractor0_,
EGW_CONTRACTOR contractor1_,
EGW_STATUS egwstatus2_
WHERE contractor0_.CONTRACTOR_ID=contractor1_.ID
AND contractor0_.STATUS_ID =egwstatus2_.ID
AND egwstatus2_.DESCRIPTION ='Active'
AND egwstatus2_.MODULETYPE ='Contractor'
AND (upper(contractor1_.CODE) LIKE '%100%'
OR upper(contractor1_.NAME) LIKE'%100%')
ORDER BY contractor1_.CODE,
contractor1_.NAME ;
</pre>
</div></div>
</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%;">
Jboss AS 4.3.2 GA, HIbernate 3.5.5, Oracle 10g
</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.atlassian.net/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%;">
hibernate
query
ORA-01791
</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.atlassian.net/images/icons/priorities/major.png" 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="nick.sree" id="email_nick.sree" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=nick.sree" style="color:#6c797f;">nick</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 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 -->