Mihai Budiu created CALCITE-6285: ------------------------------------ Summary: 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
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)