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

2022-12-14 Thread Uhrig, Stefan via GeoTools-Devel
Hi Andrea, hi Jody, Thanks for your responses and insights. Looking at the SQLServerDialect class, I understand the reasons for blocking search hints on virtual tables. Unlike in SQL Server, hints can only be added at the very end of a query or subquery in HANA. For example, it is not

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

2022-12-14 Thread Andrea Aime
HI Stefan, a virtual table can be built around any resultset returning statement (e.g., a stored procedure), and the JDBCDataStore machinery makes no attempt to understand the SQL being provided, it just uses it as a subquery in the from clause. Query hints, at least in the databases that I'm