Hey, I've noticed that the SQL generated by the org.geotools.data.jdbc.FilterToSQL and org.geotools.jdbc.PreparedFilterToSQL classes is different when processing an Id filter.
The FilterToSQL class wraps the entire where clause in brackets, which the PreparedFilterToSQL does not. I've seen a significant performance impact if the brackets are not included when using Oracle. Thanks, Shaun
------------------------------------------------------------------------------
_______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
