Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.2.0
    • Fix Version/s: 1.2.0
    • Component/s: Core Framework
    • Labels:
      None

      Description

      NIFI-3481 introduced a DatabaseAdapter implementation for Microsoft SQL Server 2012+, it is not compatible with MS SQL 2008 because of its use of OFFSET and FETCH, e.g.

      This case is to introduce support for earlier versions of SQL Server to the database fetching processors such as QueryDatabaseTable and GenerateTableFetch. It may be the case that the generated SQL is awkward and less-than-ideal (more like Oracle's pagination query), but this will enable those processors to interact with SQL Server versions prior to 2012.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mattyb149 Matt Burgess
                Reporter:
                mattyb149 Matt Burgess
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: