[FLINK-31778] Casting array of rows produces incorrect result

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.16.1, 1.15.4
• Component/s: Table SQL / Planner
• Labels: pull-request-available stale-assigned
• Assignee: Ilya Soin
• Reporter: Ilya Soin
• Created: 12/Apr/23 12:08
• Updated: 01/Oct/23 16:56
• Resolved: 29/Sep/23 17:55

Description

select CAST(commissions AS ARRAY<ROW<amount DOUBLE>>) as commissions             from (select ARRAY[ROW(123), ROW(234)] commissions)

Expected output:

+----+--------------------------------+
| op |                    commissions |
+----+--------------------------------+
| +I |             [(123.0), (234.0)] |
+----+--------------------------------+
 

Actual output:

+----+--------------------------------+
| op |                    commissions |
+----+--------------------------------+
| +I |             [(234.0), (234.0)] |
+----+--------------------------------+ 

Full working example: https://gist.github.com/soin08/5e0038dbefeba9192706e05a78ef3bc1

Issue Links

• duplicates: FLINK-32296 Flink SQL handle array of row incorrectly
• links to: GitHub Pull Request #22411
• links to: GitHub Pull Request #22412