[ https://issues.apache.org/jira/browse/FLINK-31778?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17714871#comment-17714871 ]
Ilya Soin commented on FLINK-31778: ----------------------------------- Hi [~jark], done: https://github.com/apache/flink/pull/22412 > Casting array of rows produces incorrect result > ----------------------------------------------- > > Key: FLINK-31778 > URL: https://issues.apache.org/jira/browse/FLINK-31778 > Project: Flink > Issue Type: Bug > Components: Table SQL / Planner > Affects Versions: 1.16.1, 1.15.4 > Reporter: Ilya Soin > Assignee: Ilya Soin > Priority: Major > Labels: pull-request-available > Attachments: image-2023-04-12-15-23-46-669.png, screenshot-2.png > > > {code:java} > select CAST(commissions AS ARRAY<ROW<amount DOUBLE>>) as commissions > from (select ARRAY[ROW(123), ROW(234)] commissions){code} > Expected output: > {code:java} > +----+--------------------------------+ > | op | commissions | > +----+--------------------------------+ > | +I | [(123.0), (234.0)] | > +----+--------------------------------+ > {code} > Actual output: > {code:java} > +----+--------------------------------+ > | op | commissions | > +----+--------------------------------+ > | +I | [(234.0), (234.0)] | > +----+--------------------------------+ {code} > Full working example: > https://gist.github.com/soin08/5e0038dbefeba9192706e05a78ef3bc1 -- This message was sent by Atlassian Jira (v8.20.10#820010)