[CALCITE-4850] Wrong result retrieving from ARRAY with mixed INTEGER and DECIMAL elements

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.36.0
• Assignee: Ran Tao
• Reporter: Sergey Nuyanzin
• Created: 12/Oct/21 22:07
• Updated: 10/Nov/23 11:34
• Resolved: 09/Oct/23 16:18

Description

The issue is a follow-up for
https://issues.apache.org/jira/browse/CALCITE-4602?focusedCommentId=17427917&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-17427917

to reproduce

select array[1.1, 1];
+-------------+
|   EXPR$0    |
+-------------+
| [1.1, 0E+1] |
+-------------+

Issue Links

• Is contained by: CALCITE-5948 Use explicit casting if element type in ARRAY/MAP does not equal derived component type
• relates to: CALCITE-4602 ClassCastException retrieving from ARRAY that has mixed INTEGER and DECIMAL elements