[gdal-dev] ogr option-spat

[Frank Warmerdam]

GOUBET LIONEL wrote:
> Here are more precisions:
> 
>    1. I work with OSGEO4W with plugins oci.
>    2. My datatable is a table Oracle spatial with a column geometry.
>    3. If I launch ogr.exe with *-sql select * from myTable* or with
>       *-sql select * from myTable -spat XMIN YMIN XMAX YMAX =>* the
>       result is the same.
> 
> That's the reasons why I don't understand.

Lionel,

On review this is a bug in the Oracle driver.  It ignores spatial filters
passed to the ExecuteSQL() call.  If you file a ticket on this I should
be able to fix it fairly easily.  Some other RDBMS drivers may have similar
issues when passing in arbitrary SQL as opposed to "direct" table access.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent