[Geotools-devel] JDBCDataStore blocks search hints on virtual tables

2022-12-13 Thread Uhrig, Stefan via GeoTools-Devel
Hi all, Recently, a group of GeoServer users on HANA requested the possibility to append hints to SQL queries. Luckily, there was already SQLDialect#handleSelectHints(). So, I could just override the method in HanaDialect and append the hints to the query, which I did in [GEOT-7230]

Re: [Geotools-devel] JDBCDataStore blocks search hints on virtual tables

2022-12-13 Thread Jody Garnett
I am sure it was just lack of scope; since the virtual tables can be any SQL query - it was probably not obvious how to integrate a select hint? If you have a join for example which select would you like to add the hint to? Or would you like to create a subquery and do the select on the result?