[jira] [Created] (FLINK-22967) CodeGenException: Unsupported cast for nested Decimals

[Shang Yuanchun (Jira)]

Maciej Bryński created FLINK-22967:
--------------------------------------

             Summary: CodeGenException: Unsupported cast for nested Decimals
                 Key: FLINK-22967
                 URL: https://issues.apache.org/jira/browse/FLINK-22967
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Planner
    Affects Versions: 1.13.0
            Reporter: Maciej Bryński


This query is failing in SQL Client
{code:java}
Flink SQL> CREATE TABLE abc (
>     test ROW<a ARRAY<ROW<id STRING, amount DECIMAL(18, 4) >>>
> ) WITH ( 'connector' = 'datagen');
[INFO] Table has been created.

Flink SQL> select * from abc;
[ERROR] Could not execute SQL statement. Reason:
org.apache.flink.table.planner.codegen.CodeGenException: Unsupported cast from 'ROW<`a` ARRAY<ROW<`id` STRING, `amount` DECIMAL(18, 4)>>>' to 'ROW<`a` ARRAY<ROW<`id` STRING, `amount` DECIMAL(38, 18)>>>'.

{code}
 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)