[CALCITE-5707] Add ARRAY_CONTAINS for Spark dialect

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.34.0
• Fix Version/s: 1.35.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Jacky Lau
• Reporter: Jacky Lau
• Created: 17/May/23 06:40
• Updated: 27/Jul/23 10:22
• Resolved: 10/Jun/23 20:38

Description

ARRAY_CONTAINS - Returns true if the array contains the value

For more details
https://spark.apache.org/docs/latest/sql-ref-functions-builtin.html

// code placeholder

spark: array_contains(array[1, null], null) -> null
flink: array_contains(array[1, null], null) -> true 

Issue Links

• links to: GitHub Pull Request #3207