[jira] [Assigned] (NIFI-4738) ExecuteSQL error when table uses 9-digit unsigned int

["Matt Burgess (JIRA)" <ji...@apache.org>]

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

Matt Burgess reassigned NIFI-4738:
----------------------------------

    Assignee: Matt Burgess

> ExecuteSQL error when table uses 9-digit unsigned int
> -----------------------------------------------------
>
>                 Key: NIFI-4738
>                 URL: https://issues.apache.org/jira/browse/NIFI-4738
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Extensions
>            Reporter: Matt Burgess
>            Assignee: Matt Burgess
>
> There is a logic bug in the fix for NIFI-3076 that causes unsigned 9-digit integers to be treated as ints when the DB (at least MySQL) will return a Long object. Although the fix for NIFI-3076 does work for MEDIUMINT, this is because the logic bug is not exposed when the MEDIUMINT is signed (as it satisfies the other condition of the if clause). But if a field is declared as INT(9) UNSIGNED, the logic will see if the precision is 9 digits or less, and treat it as an Integer if so. But an unsigned value with 9 digits will fit in a Long, and should be treated as such in the schema.
> Recommended fix is to replace the "<= MAX_DIGITS_PER_INT" with "< MAX_DIGITS_PER_INT".



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