array_contains returns null instead of false for empty array with literal value

[andygrove]

Description

array_contains(arr, 2) returns null instead of false when arr is an empty array (array()).

How to Reproduce

CREATE TABLE test(arr array<int>) USING parquet;
INSERT INTO test VALUES (array());
SELECT array_contains(arr, 2) FROM test;

Expected: false
Actual (Comet): null

Expected Behavior

Comet should return false for array_contains when the array is empty, matching Spark's behavior.

[comphead]

Looks like it is fixed in df52

  test("native reader - array_contains") {
    withSQLConf(
      CometConf.COMET_EXEC_ENABLED.key -> "true",
      SQLConf.USE_V1_SOURCE_LIST.key -> "parquet",
      CometConf.COMET_ENABLED.key -> "true",
      CometConf.COMET_EXPLAIN_FALLBACK_ENABLED.key -> "true",
      CometConf.COMET_NATIVE_SCAN_IMPL.key -> "native_datafusion") {
      testSingleLineQuery(
        """
          |select cast(array() as array<int>) as a
          |""".stripMargin,
        "select array_contains(a, 2) from tbl")
    }
  }

[comphead]

Depends on #3536