From: Jody G. (JIRA) <ji...@co...> - 2012-12-21 07:17:25
|
<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="#ffffff" style="background-color:#ffffff;color:#00AA00;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;line-height:1;"><img src="http://www.codehaus.org/codehaus-small.gif" 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://jira.codehaus.org/secure/useravatar?ownerId=jgarnett&avatarId=10310" 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="jgarnett" id="email_jgarnett" href="https://jira.codehaus.org/secure/ViewProfile.jspa?name=jgarnett" style="color:#005500;">Jody Garnett</a> created <img src="https://jira.codehaus.org/images/icons/bug.gif" height="16" width="16" border="0" align="absmiddle" alt="Bug"> <a style='color:#005500;text-decoration:none;' href='https://jira.codehaus.org/browse/GEOT-4357'>GEOT-4357</a> </div> <div id="email-summary" style="font-size:16px;line-height:20px;padding:2px 0 16px 0;"> <a style='color:#005500;text-decoration:none;' href='https://jira.codehaus.org/browse/GEOT-4357'><strong>Oracle optimisation not compatible with </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://jira.codehaus.org/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;">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;">Created:</strong> </td> <td style="color:#000000;font-family:Arial,FreeSans,Helvetica,sans-serif;font-size:12px;padding:0 0 10px 0;width:100%;"> 21/Dec/12 1:16 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;'>In looking at <a href="https://jira.codehaus.org/browse/GEOS-5516" title="GetFeatureInfo fails against 3D data">GEOS-5516</a> GetFeatureInfo manages to produce a query we cannot handle:</p> <div class="panel" style="border-width: 1px;"><div class="panelContent"> <p style='margin-top:0;margin-bottom:10px;'>Caused by: java.sql.SQLException: ORA-29902: error in executing ODCIIndexStart() routine<br/> ORA-13243: specified operator is not supported for 3- or higher-dimensional R-tree<br/> ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 333</p> </div></div> <p style='margin-top:0;margin-bottom:10px;'>Stack trace is so deep there is not much context for us:</p> <div class="preformatted panel" style="border-width: 1px;"><div class="preformattedContent panelContent"> <pre>at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.geotools.jdbc.JDBCDataStore.getAggregateValue(JDBCDataStore.java:1298) ... 95 more </pre> </div></div> <p style='margin-top:0;margin-bottom:10px;'>Which has us in this block of code:</p> <div class="code panel" style="border-width: 1px;"><div class="codeContent panelContent"> <pre class="code-java"><span class="code-keyword">if</span> ( dialect <span class="code-keyword">instanceof</span> PreparedStatementSQLDialect ) { st = selectAggregateSQLPS(function, att, featureType, query, cx); rs = ((PreparedStatement)st).executeQuery(); }</pre> </div></div> <p style='margin-top:0;margin-bottom:10px;'>Context:</p> <ul> <li>function: count</li> <li>query: <div class="panel" style="border-width: 1px;"><div class="panelContent"> <p style='margin-top:0;margin-bottom:10px;'>Query:<br/> feature type: POINT_TEST<br/> filter: [ GEOMETRY intersects POLYGON ((130.89027224999998 -16.448910635807145, 130.890813984375 -16.448910635807145, 130.890813984375 -16.449452365218924, 130.89027224999998 -16.449452365218924, 130.89027224999998 -16.448910635807145)) ]<br/> <span class="error">[properties: UFI, SUB_CLASS, NAME, PLACENAME_ID, SCALE, RELIABILITY_DATE, ACCURACY_HORIZONTAL, ACCURACY_VERTICAL, SOURCE, GEOMETRY]</span></p> </div></div></li> </ul> <p style='margin-top:0;margin-bottom:10px;'>And the <b>sql</b> produced by selectAggregateSQLPS is:</p> <div class="panel" style="border-width: 1px;"><div class="panelContent"> <p style='margin-top:0;margin-bottom:10px;'>SELECT count<img class="emoticon" src="https://jira.codehaus.org/images/icons/emoticons/star_yellow.gif" height="16" width="16" align="absmiddle" alt="" border="0"/> AS gt_result_ FROM (SELECT * FROM (SELECT * FROM POINT_TEST WHERE SDO_RELATE(GEOMETRY, ?, 'mask=anyinteract querytype=WINDOW') = 'TRUE' ) WHERE ROWNUM <= 50) gt_limited_</p> </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;">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:#005500;" href="https://jira.codehaus.org/browse/GEOT">GeoTools</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;">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://jira.codehaus.org/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="jgarnett" id="email_jgarnett" href="https://jira.codehaus.org/secure/ViewProfile.jspa?name=jgarnett" style="color:#005500;">Jody Garnett</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:#005500;' href='https://jira.codehaus.org/secure/ContactAdministrators!default.jspa'>JIRA administrators</a>.<br /> For more information on JIRA, see: <a style='color:#005500;' href='http://www.atlassian.com/software/jira'>http://www.atlassian.com/software/jira</a> </td> </tr> </table><!-- End #email-wrap --> </div><!-- End #email-body --> |