Re: [Geotools-devel] Adding more query hints to sqlserver store

2014-05-16 Thread Andrea Aime
On Fri, May 16, 2014 at 10:12 PM, Jody Garnett wrote: > That seems fine, but we may wish to police the hints we accept and pass > along. Not sure how open this one is to SQL injection. > No need for data store hints, as they are not something a external user can provide. For a query by query hint

Re: [Geotools-devel] Adding more query hints to sqlserver store

2014-05-16 Thread Jody Garnett
That seems fine, but we may wish to police the hints we accept and pass along. Not sure how open this one is to SQL injection. Do other database use this approach? Jody Garnett On Fri, May 16, 2014 at 11:07 AM, Andrea Aime wrote: > Hi, > some time ago I've added the ability to force the usage

[Geotools-devel] Adding more query hints to sqlserver store

2014-05-16 Thread Andrea Aime
Hi, some time ago I've added the ability to force the usage of a spatial index, now I'm getting requests to add even more hints. If we factor out the index usage ones, which are index specific, all of the others are just a comma separate list of static keywords: http://msdn.microsoft.com/en-US/lib