Make scalar and array handling for array_has consistent #36019

Job	Run time
cargo test (win64)	1h 13m 58s
cargo check	8m 48s
Check License Header	2m 21s
cargo test (macos-aarch64)	18m 31s
cargo test (macos)	15m 21s
build with wasm-pack	3m 34s
Check cargo fmt	42s
Verify MSRV (Min Supported Rust Version)	8m 51s
Verify Vendored Code	54s
cargo test (amd64)	11m 59s
cargo test datafusion-cli (amd64)	4m 48s
cargo doc	4m 35s
clippy	7m 23s
cargo test doc (amd64)	17m 31s
cargo examples (amd64)	14m 38s
Run sqllogictest with Postgres runner	4m 1s
cargo test pyarrow (amd64)	3m 9s
verify benchmark results (amd64)	14m 45s
check Cargo.toml formatting	2m 57s
check configs.md and ***_functions.md is up-to-date	3m 39s
cargo test hash collisions (amd64)	29m 37s
	4h 12m 2s

Provide feedback