[CH] get_json_object diff when path like [*].xxx

[KevinyhZou]

Backend

CH (ClickHouse)

Bug description

query sql: select $.a[*].b from test_tbl
test_data: {"a":[1,3,{"b":"y", "a":"x"}]}

valina result: "y"
gluten result: y

query sql: select $.store.basket[0][*].b from test_tbl
test_data:{"store":{"fruit":[{"weight":8,"type":"apple"},{"weight":9,"type":"pear"}],"basket":[[1,2,{"b":"y","a":"x"}],[3,4],[5,6]],"book":[{"author":"Nigel Rees","title":"Sayings of the Century","category":"reference","price":8.95},{"author":"Herman Melville","title":"Moby Dick","category":"fiction","price":8.99, "isbn":"0-553-21311-3"},{"author":"J. R. R. Tolkien","title":"The Lord of the Rings","category":"fiction","reader":[{"age":25,"name":"bob"},{"age":26,"name":"jack"}],"price":22.99,"isbn":"0-395-19395-8"}],"bicycle":{"price":19.95,"color":"red"}}, "email":"amy@only_for_json_udf_test.net","owner":"amy","zip code":"94025", "fb:testid":"1234"}

valina result: ["y"]
gluten result: y

Spark version

Spark-3.3.x

Spark configurations

No response

System information

No response

Relevant logs

[KevinyhZou]

The first case is fixed by pr: #8540 , the second not fixed.