[ https://issues.apache.org/jira/browse/FLINK-15124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kurt Young updated FLINK-15124: ------------------------------- Fix Version/s: 1.10.0 > types with precision can't be executed in sql client with blink planner > ----------------------------------------------------------------------- > > Key: FLINK-15124 > URL: https://issues.apache.org/jira/browse/FLINK-15124 > Project: Flink > Issue Type: Bug > Components: Table SQL / Client, Table SQL / Planner > Affects Versions: 1.10.0 > Reporter: Kurt Young > Priority: Major > Fix For: 1.10.0 > > > I created a table in sql client with blink planner: > {noformat} > create table t ( > a int, > b varchar, > c decimal(10, 5)) > with ( > 'connector.type' = 'filesystem', > 'format.type' = 'csv', > 'format.derive-schema' = 'true', > 'connector.path' = 'xxxxxxx' > ); > {noformat} > The table description looks good: > {noformat} > Flink SQL> describe t; > root > |-- a: INT > |-- b: STRING > |-- c: DECIMAL(10, 5){noformat} > But the select query failed: > {noformat} > Flink SQL> select * from t; > [ERROR] Could not execute SQL statement. Reason: > org.apache.flink.table.planner.codegen.CodeGenException: Incompatible types > of expression and result type. > Expression[GeneratedExpression(field$3,isNull$3,,DECIMAL(38, 18),None)] type > is [DECIMAL(38, 18)], result type is [DECIMAL(10, 5)] > {noformat} > -- This message was sent by Atlassian Jira (v8.3.4#803005)