search

r-dbi / odbc

Connect to ODBC databases (using the DBI interface)
https://odbc.r-dbi.org/
Other
391 stars 107 forks source link

use Teradata-specific top-n syntax #755

Closed simonpcouch closed 9 months ago

simonpcouch commented 9 months ago

Internal support ticket reports errors when previewing tables from the Connections pane with Teradata:

Error in new_result(...):
expected something between the word 'TABLE_NAME' and the 'LIMIT' keyword.

Internally, odbc uses that LIMIT keyword when previewing tables for the Connections pane. Looks like Teradata may need its own top-n syntax.