Matt Burgess created NIFI-4738:
----------------------------------
Summary: 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
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)
