[GitHub] nifi issue #1510: NIFI-3481 DB Adapter for MS SQL

[mattyb149 <gi...@git.apache.org>]

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 infrastructure@apache.org or file a JIRA ticket
with INFRA.
---