[NIFI-3902] CaptureChangeMySQL returns null column values if no DistributedMapCacheClient is selected

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.2.0
• Component/s: Extensions
• Assignee: Unassigned
• Reporter: Matt Burgess
• Created: 15/May/17 20:48
• Updated: 16/May/17 21:31

Description

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.