You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@nifi.apache.org by "Matt Burgess (Jira)" <ji...@apache.org> on 2021/11/03 23:32:00 UTC

[jira] [Commented] (NIFI-8392) ResultSetRecordSet maps JDBC CHAR type to a RecordFieldType of CHAR instead of STRING

    [ https://issues.apache.org/jira/browse/NIFI-8392?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17438343#comment-17438343 ] 

Matt Burgess commented on NIFI-8392:
------------------------------------

The JDBC CHAR type refers to a fixed-length string (versus VARCHAR), so indeed it should be a string in the NiFi record

> ResultSetRecordSet maps JDBC CHAR type to a RecordFieldType of CHAR instead of STRING
> -------------------------------------------------------------------------------------
>
>                 Key: NIFI-8392
>                 URL: https://issues.apache.org/jira/browse/NIFI-8392
>             Project: Apache NiFi
>          Issue Type: Bug
>            Reporter: Lucas Read
>            Assignee: Matt Burgess
>            Priority: Major
>
> So in {{ResultSetRecordSet}} it looks like we map JDBC CHAR type to a RecordFieldType of CHAR:
>  
> {code:java}
> case Types.CHAR:
>  return RecordFieldType.CHAR;
> {code}
> Needs to be changed so that Types.CHAR maps to RecordFieldType.STRING



--
This message was sent by Atlassian Jira
(v8.3.4#803005)