#6984 closed defect (fixed)
OGR-IDB optimitation spatial filter
Reported by: | Andrés Ricagno | Owned by: | Andrés Ricagno |
---|---|---|---|
Priority: | normal | Milestone: | |
Component: | OGR_SF | Version: | 2.1.2 |
Severity: | normal | Keywords: | OGR IDB |
Cc: |
Description
We are testing the OGR IDB connector and note that the spatial filter is not implemented directly to RDBMS. I was making adaptations to the driver to optimize the query using spatial index and st_intersects function.
Attachments (3)
Change History (11)
comment:1 by , 7 years ago
by , 7 years ago
Attachment: | ogridbtablelayer.patch added |
---|
patch for ogridbtablelayer.cpp to use st_intersects function on filter option
comment:3 by , 7 years ago
Using sql.c_str() as the argument of sql.Printf() might be dangerous since the input and output buffers are the same... Better copy first the current sql into a temporary string before
comment:5 by , 7 years ago
Resolution: | fixed |
---|---|
Status: | closed → reopened |
Sql error when ogrinfo was called without spat parameter
by , 7 years ago
Attachment: | ogridbtablelayer.3.patch added |
---|
Fix sql error, when there is no spatial filter, sqlExec was empty
comment:7 by , 7 years ago
@aricgano I've committed in r39967 a different way of addressing the issue. I didn't compile it though, so please test ! (and for a next time, please provide a patch against latest trunk)
Do you intend to provide a patch since you implied you implemented it ?