Wrong number of parameters to SDO_FILTER in jdbc oracle NG plugin when loose
bbox is true
-----------------------------------------------------------------------------------------
Key: GEOT-2383
URL: http://jira.codehaus.org/browse/GEOT-2383
Project: GeoTools
Issue Type: Bug
Components: data jdbc-ng
Affects Versions: 2.5.5
Reporter: Kris Geusebroek
I think I found a bug in the OracleNG plugin.
When the parameter Loose bbox is set to true and a bbox filter is used
the method doSDOFilter is called.
This results in the following query:
SELECT column1, GEOMETRY as GEOMETRY from table1 WHERE
SDO_FILTER(GEOMETRY, ?) = ' TRUE'
Which is an invalid query.
SDO_FILTER uses 3 parameters so it should be:
SELECT column1, GEOMETRY as GEOMETRY from table1 WHERE
SDO_FILTER(GEOMETRY, ?, 'querytype=WINDOW') = ' TRUE'
Workaround is to set the loose bbox parameter to false so the plugin
creates an SDO_RELATE version of the query like this:
SELECT column1, GEOMETRY as GEOMETRY from table1 WHERE
SDO_RELATE(GEOMETRY, ?, 'mask=anyinteract querytype=WINDOW') = ' TRUE'
--
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
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
