Which issue does this PR close?

• Closes array_has function returns null for an empty list ([]) instead of false #16474

Rationale for this change

The array_has function incorrectly returns null for empty arrays, which should logically return false since an empty array cannot contain any element. This leads to inconsistencies and incorrect query results. The change ensures that array_has returns the correct boolean outcome when applied to empty arrays.

What changes are included in this PR?

• Updated the array_has_dispatch_for_scalar function to check the array validity buffer and differentiate between null and empty arrays.
• Ensured that empty arrays now return false and null arrays continue to return null.
• Added SQL logic tests (array_has_table_empty) to verify the updated behavior.

Are these changes tested?

Yes, new test cases were added to the SQL logic test file array.slt to verify that:

• Non-empty arrays with the target value return true.
• Empty arrays return false.
• Null arrays return null.

Are there any user-facing changes?

Yes:

• array_has([], value) now returns false instead of null, improving correctness and predictability for users.