Matt Burgess created NIFI-3902:
----------------------------------
Summary: CaptureChangeMySQL returns null column values if no
DistributedMapCacheClient is selected
Key: NIFI-3902
URL: https://issues.apache.org/jira/browse/NIFI-3902
Project: Apache NiFi
Issue Type: Bug
Components: Extensions
Affects Versions: 1.2.0
Reporter: Matt Burgess
The "Distributed Map Cache Client" property of the CaptureChangeMySQL processor
is not required, if it is not set then no column name or type information will
be available when generating output flow files from binary log events. However
if no type information is present and the column value is not a number or a
byte array, the value of that column will be null in the outgoing flow file.
It may not be possible to accurately represent the value if the type is not
known, but the value could be set to the String representation of the object's
value. At best it would correctly represent the value; at worst it would
indicate that the value is indeed not null but otherwise indeterminate.
The workaround (and best practice) is to use a DistributedMapCacheClient in the
CaptureChangeMySQL processor in order to retrieve the column name and
information for the CDC events.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
