[
https://issues.apache.org/jira/browse/NIFI-3902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16013146#comment-16013146
]
Matt Burgess commented on NIFI-3902:
------------------------------------
The column types are expected to be integers corresponding to the SQL Type
Constants:
http://docs.oracle.com/javase/8/docs/api/constant-values.html#java.sql.Types.BIT,
so that works as intended and is not part of this bug.
> 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)
