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)
