[ https://issues.apache.org/jira/browse/NIFI-7316?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dustin Rodrigues reassigned NIFI-7316: -------------------------------------- Assignee: (was: Dustin Rodrigues) I'm closing the PR but leaving this JIRA issue open and unassigning it from me. > QueryRecord string vs char > -------------------------- > > Key: NIFI-7316 > URL: https://issues.apache.org/jira/browse/NIFI-7316 > Project: Apache NiFi > Issue Type: Bug > Reporter: Dustin Rodrigues > Priority: Major > Time Spent: 50m > Remaining Estimate: 0h > > When including a string in a QueryRecord SQL alias, it truncates the string > to one character when writing out to a Record with types. For instance, when > using the CSVReader and JsonRecordSetWriter and the expression {{select *, > 'red' AS color from flowfile}}, the type of red ends up being Types.CHAR > which is mapped to RecordFieldType.CHAR. When writing as JSON, the string > gets coerced to a char and becomes just "r". When writing as CSV however, > since no type coercion occurs, the value "red" gets written as expected. -- This message was sent by Atlassian Jira (v8.3.4#803005)