You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "N Campbell (JIRA)" <ji...@apache.org> on 2017/06/30 15:36:01 UTC
[jira] [Created] (DRILL-5639) CAST( as CHAR(N) or VARCHAR(N))
ResultsetMetadata always returned as VARCHAR(65535)
N Campbell created DRILL-5639:
---------------------------------
Summary: CAST( as CHAR(N) or VARCHAR(N)) ResultsetMetadata always returned as VARCHAR(65535)
Key: DRILL-5639
URL: https://issues.apache.org/jira/browse/DRILL-5639
Project: Apache Drill
Issue Type: Improvement
Components: Client - JDBC
Affects Versions: 1.10.0
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
Reporter: N Campbell
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)