Changing the Oracle NG SQL Query filter
---------------------------------------
Key: GEOT-2290
URL: http://jira.codehaus.org/browse/GEOT-2290
Project: GeoTools
Issue Type: Bug
Components: data jdbc-ng
Reporter: Alessio Fabiani
Assignee: Andrea Aime
Priority: Critical
Performing some tests with Oracle NG plugin, some strange behaviour has been
detected when computing spatial queries against geometry stored into Oracle DB.
As an example, for MultiPolygon geometries with 4326 SRID the actual resulting
query built by Oracle NG plugin is something like that:
SELECT FID,THE_GEOM as THE_GEOM FROM <TABLE> WHERE SDO_FILTER(THE_GEOM,
MDSYS.SDO_GEOMETRY(2003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(x0,y0,x1,y0,x1,y1,x1,y0,x0,y0))
) = 'TRUE'
which returns just a small subset of all the features.
Modifying the query with the following one:
SELECT FID,THE_GEOM as THE_GEOM FROM <TABLE> WHERE MDSYS.SDO_FILTER(THE_GEOM,
MDSYS.SDO_GEOMETRY(2003,4326,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(LL_x,LL_y,UR_x,UR_y)),'mask=ANYINTERACT
querytype=WINDOW') = 'TRUE'
the result is correct.
--
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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Geotools-devel mailing list
Geotools-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
