Github user mattyb149 commented on the issue:
https://github.com/apache/nifi/pull/1510
Related to the discussion above, I am using SQL Server 2000 with
GenerateTableFetch and am getting errors with the generated SQL. GTF does
pagination, so it skips the "TOP" logic above and generates something like the
following:
`SELECT * FROM t1 ORDER BY id OFFSET 2 ROWS FETCH NEXT 2 ROWS ONLY`
Which does not work. With respect to the new keywords in MSSQL 2012, I
would think either this adapter should require 2012 (updating the name,
description, and leverage the new commands), or use the aforementioned (yet
awkward like Oracle's) query for offset/limit/pagination to support more users.
Thoughts?
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
