You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Matt Burgess (Jira)" <ji...@apache.org> on 2021/02/25 14:58:00 UTC

[jira] [Resolved] (NIFI-1019) PutSQL Breaks when putting an nvavarchar, int, bigint with not a valid java.sql.type

     [ https://issues.apache.org/jira/browse/NIFI-1019?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Matt Burgess resolved NIFI-1019.
--------------------------------
    Resolution: Duplicate

> PutSQL Breaks when putting an nvavarchar, int, bigint with not a valid java.sql.type
> ------------------------------------------------------------------------------------
>
>                 Key: NIFI-1019
>                 URL: https://issues.apache.org/jira/browse/NIFI-1019
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Extensions
>    Affects Versions: 0.3.0
>         Environment: MsSQL
>            Reporter: Scott
>            Priority: Major
>
> / nifi-nar-bundles / nifi-standard-bundle / nifi-standard-processors / src / main / java / org / apache / nifi / processors / standard / PutSQL.java
> When putting data into SQL server using PutSQL Processor the sql types are validated against a regular expression, this regex should also allow negative numbers, as some java.sql.types are negative for example bigint and nvarchar -5 and -9 iirc.
> line 147: regex should be "-?\\d+"



--
This message was sent by Atlassian Jira
(v8.3.4#803005)