[ https://issues.apache.org/jira/browse/CALCITE-6285?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17822343#comment-17822343 ]
EveyWu commented on CALCITE-6285: ---------------------------------- I think the Spark version update causes the problem, -1 for which the function inserts a new element after the current last element. The original definition [3.4.0, |https://spark.apache.org/docs/3.4.0/api/sql/index.html#array_insert]Updated version definition [3.4.2|https://spark.apache.org/docs/3.4.2/api/sql/index.html#array_insert] > Function ARRAY_INSERT produces an incorrect result for negative indices > ----------------------------------------------------------------------- > > Key: CALCITE-6285 > URL: https://issues.apache.org/jira/browse/CALCITE-6285 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.36.0 > Reporter: Mihai Budiu > Priority: Minor > > Here is a test taken from the Spark documentation page: > https://spark.apache.org/docs/latest/api/sql/index.html#array_insert > {code} > SELECT array_insert(array(5, 3, 2, 1), -4, 4); > [5,4,3,2,1] > {code} > 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. -- This message was sent by Atlassian Jira (v8.20.10#820010)