I’m connecting to Crate via ODBC. Is there any obvious reason why LIMIT would not be working?
I’m trying this via PowerBI Desktop, and (more importantly for me regarding the end goal) from SQL server - by adding a Linked Server.
I’ve tried the official PSQL ODBC Driver, the one from Dev Art, and the one from Progress. I seem to get the same behaviour, no matter which options I experiment with.
The entire table contents of the table is transferred over the wire (its visible in the trace… it takes forever to return on a large table), despite issuing a SELECT TOP N command.
My assumption is that the ODBC driver should be converting that into a LIMIT argument, and that argument is in the subset of standard SQL that is implemented by the Crate PSQL interface.
I noticed this in PowerBI when setting up the ODBC
which made me feel hopeful, since clicking DETECT chose the right option, but no change in behaviour.
Am I missing something obvious here?
Much appreciated.