[CALCITE-6285] Function ARRAY_INSERT produces an incorrect result for negative indices

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.36.0
• Fix Version/s: 1.37.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Mihai Budiu
• Reporter: Mihai Budiu
• Created: 29/Feb/24 18:01
• Updated: 06/May/24 22:19
• Resolved: 09/Apr/24 15:47

Description

Here is a test taken from the Spark documentation page:
https://spark.apache.org/docs/latest/api/sql/index.html#array_insert

SELECT array_insert(array(5, 3, 2, 1), -4, 4);
[5,4,3,2,1]

The result produced by Calcite is:

[4,5,3,2,1]

The strange thing is that there are tests for negative indices. I wonder if the original tests are wrong, or the behavior of this function in Spark was changed since the tests were written.

Issue Links

• links to: GitHub Pull Request #3748