[jira] [Resolved] (FLINK-15124) types with precision can't be executed in sql client with blink planner

["Jark Wu (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-15124?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jark Wu resolved FLINK-15124.
-----------------------------
    Resolution: Fixed

[hotfix][table-runtime-blink] Fix the watermark assigner operator should emit max watermark in close
 - 1.10.0: 8591e33217c8b5301850aa89e40c7478b5a83d75
 - 1.11.0: 9e916642ffcc9dcc5ca2ab6d8a609ab3894ad960

[FLINK-15124][table] Fix types with precision defined in DDL can't be executed
 - 1.10.0: e1b1fc417d4a7aa4aba50875084f5cf84cc58a22
 - 1.11.0: 3e5a045cdc8a32e1d59bff43b70ce9e36df20d62


> 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
>            Assignee: Jark Wu
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.10.0
>
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> 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)