hailong wang created FLINK-14046:
------------------------------------

             Summary: DDL property 'format.fields.#.type' should ignore case 
                 Key: FLINK-14046
                 URL: https://issues.apache.org/jira/browse/FLINK-14046
             Project: Flink
          Issue Type: Improvement
          Components: Table SQL / API
    Affects Versions: 1.9.0
            Reporter: hailong wang
             Fix For: 1.10.0


When define DDL as follow:
{code:java}
create table RubberOrders(
  b int
) with (
 'connector.type' = 'filesystem',
 'format.type' = 'csv',                        
 'connector.path' = '##',
 'format.fields.0.name' = 'b',
 'format.fields.0.type' = 'int'
)
{code}
It has an exception:
{code:java}
Could not parse type information at position 0: Unsupported type: int
Input type string: int 
at 
org.apache.flink.table.utils.TypeStringUtils$TokenConverter.parsingError(TypeStringUtils.java:491)
 at 
org.apache.flink.table.utils.TypeStringUtils$TokenConverter.convertType(TypeStringUtils.java:318)
 at 
org.apache.flink.table.utils.TypeStringUtils$TokenConverter.convert(TypeStringUtils.java:261)
 at 
org.apache.flink.table.utils.TypeStringUtils.readTypeInfo(TypeStringUtils.java:169)
 at 
org.apache.flink.table.descriptors.DescriptorProperties.lambda$validateType$32(DescriptorProperties.java:1149)
 at 
org.apache.flink.table.descriptors.DescriptorProperties.validateOptional(DescriptorProperties.java:1357)
 at 
org.apache.flink.table.descriptors.DescriptorProperties.validateType(DescriptorProperties.java:1143)
 at 
org.apache.flink.table.descriptors.DescriptorProperties.lambda$validateTableSchema$26(DescriptorProperties.java:1011)
 at 
org.apache.flink.table.descriptors.DescriptorProperties.validateFixedIndexedProperties(DescriptorProperties.java:998)
 at 
org.apache.flink.table.descriptors.DescriptorProperties.validateTableSchema(DescriptorProperties.java:1017)
{code}
For the reason we did not ignore case in TypeStringUtils.convertType method.

 



--
This message was sent by Atlassian Jira
(v8.3.2#803003)

Reply via email to