From: <ji...@co...> - 2004-10-25 14:37:49
|
Message: A new issue has been created in JIRA. --------------------------------------------------------------------- View the issue: http://jira.codehaus.org/browse/GEOS-232 Here is an overview of the issue: --------------------------------------------------------------------- Key: GEOS-232 Summary: Intersects on Oracle is not working correctly Type: Bug Status: Open Priority: Major Original Estimate: 1 day Time Spent: Unknown Remaining: 1 day Project: GeoServer Components: WFS Oracle Versions: 1.2.3 Assignee: Sean Geoghegan Reporter: Thijs Brentjens Created: Mon, 25 Oct 2004 10:36 AM Updated: Mon, 25 Oct 2004 10:36 AM Environment: Oracle 10G, windows XP, Geoserver 1.2.3 Description: When using the Intersects filter as in: <?xml version="1.0" encoding="iso-8859-1"?> <GetFeature outputFormat="GML2" xmlns:gml="http://www.opengis.net/gml"> <Query typeName="scs:ADAM_ANDES"> <PropertyName>scs:GEOM</PropertyName> <Filter> <Intersects> <PropertyName>GEOM</PropertyName> <gml:Box srsName="http://www.opengis.net/gml/srs/epsg.xml#28992"> <gml:coordinates>120173,489015 120818,489717</gml:coordinates> </gml:Box> </Intersects> </Filter> </Query> </GetFeature> The JDBCFeatureSource sends this SQL to the Oracle database, according to the logfile: SELECT COUNT(*) as cnt FROM ADAM_ANDES WHERE NOT SDO_RELATE("GEOM",MDSYS.SDO_GEOMETRY(2003,90112,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(120173.0,489015.0,120173.0,489717.0,120818.0,489717.0,120818.0,489015.0,120173.0,489015.0)),'mask=disjoint querytype=WINDOW') = 'TRUE' This SQL is not working properly on Oracle 10G (when sending it from an Oracle client I've waited for minutes and the SQL was still executing). However, the SQL (with ANYINTERACT in stead of NOT DISJOINT) below returns cnt in around 0.5 seconds maximum on my configuration. SELECT COUNT(*) as cnt FROM ADAM_ANDES WHERE SDO_RELATE("GEOM",MDSYS.SDO_GEOMETRY(2003,90112,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(120173.0,489015.0,120173.0,489717.0,120818.0,489717.0,120818.0,489015.0,120173.0,489015.0)),'mask=anyinteract querytype=WINDOW') = 'TRUE' For Oracle users it would be a great improvement if this could be fixed. --------------------------------------------------------------------- JIRA INFORMATION: This message is automatically generated by JIRA. If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira |