[DRILL-5639] CAST( as CHAR(N) or VARCHAR(N)) ResultsetMetadata always returned as VARCHAR(65535)

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.10.0
• Component/s: Client - JDBC

Environment

Statement is explicitly CASTING to a CHAR type with precision but result described as VARCHAR with maximum precision.

select cast(C1 as CHAR(10)) from (values('ABC')) T (C1)

select cast(C1 as VARCHAR(10)) from (values('ABC')) T (C1)

ResultsetMetadata

ColumnIndex getColumnName getColumnTypeName getPrecision getScale isNullable getTableName getSchemaName getCatalogName getColumnClassName getColumnDisplaySize getColumnLabel getColumnType isAutoIncrement isCaseSensitive isCurrency isDefinitelyWritable isReadOnly isSearchable isSigned isWritable
1 EXPR$0 CHARACTER VARYING 65536 0 1 DRILL java.lang.String 65536 EXPR$0 12 false false false false true true false false

• Assignee: Unassigned
• Reporter: N Campbell
• Created: 30/Jun/17 15:35
• Updated: 30/Jun/17 15:40

Description

While Drill states it internally uses VARCHAR type, unclear if Drill had considered/attempted to ensure it would project a CHAR with blank padding.

https://drill.apache.org/docs/supported-data-types/