nifi-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mikołaj Siedlarek (JIRA) <j...@apache.org>
Subject [jira] [Created] (NIFI-4393) AbstractDatabaseFetchProcessor handles SQL Server brackets incorrectly
Date Mon, 18 Sep 2017 21:12:00 GMT
Mikołaj Siedlarek created NIFI-4393:
---------------------------------------

             Summary: AbstractDatabaseFetchProcessor handles SQL Server brackets incorrectly
                 Key: NIFI-4393
                 URL: https://issues.apache.org/jira/browse/NIFI-4393
             Project: Apache NiFi
          Issue Type: Bug
          Components: Extensions
    Affects Versions: 1.4.0
            Reporter: Mikołaj Siedlarek
         Attachments: 0001-Handle-SQL-Server-square-brackets-in-AbstractDatabas.patch

SQL Server allows column names to contain whitespace, in which case they are written in SQL
queries inside square brackets. When using processors based on {{AbstractDatabaseFetchProcessor}},
such as {{QueryDatabaseTable}} they have to be specified in  "Maximum-value Columns" in square
brackets, because otherwise they would break a SELECT query. However, when such column name
is retrieved from ResultSetMetaData, the driver returns it without square brackets. This causes
a mismatch between the key used to save last seen maximum value in processor's state and the
one used to search for the value later.

I'm not sure whether the attached patch is very elegant, but it fixes the issue in a simplest
way possible.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message