[
https://issues.apache.org/jira/browse/NIFI-3481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15892449#comment-15892449
]
ASF GitHub Bot commented on NIFI-3481:
--------------------------------------
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?
> DB Adapter for MS SQL
> ---------------------
>
> Key: NIFI-3481
> URL: https://issues.apache.org/jira/browse/NIFI-3481
> Project: Apache NiFi
> Issue Type: Improvement
> Components: Core Framework
> Affects Versions: 1.2.0
> Reporter: Peter Wicks
> Assignee: Peter Wicks
> Priority: Minor
>
> Adding a new DB Adapter for MS SQL. MS SQL does paging of queries
> differently then other RDBMS', including a lack of "LIMIT".
> This adds functionality for TOP and OFFSET/FETCH for paging of results with
> the GenerateTableFetch.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
