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

[N Campbell (JIRA)]

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)