Repository navigation
Optimize array_has() for scalar needle #20377
Description
Is your feature request related to a problem or challenge?
For the scalar needle case, array_has is reasonably fast but it could be optimized by avoiding the per-row work that is currently done to construct the result set (construct a slice into a BooleanArray and count the set bits).
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response
Activity
neilconway commentedon Feb 16, 2026
take
neilconway commentedon Feb 16, 2026
See also #18181, although in that case the observed performance issue is actually with
array_has_any.perf: Optimize `array_has()` for scalar needle (#20374)
perf: Optimize `array_has()` for scalar needle (apache#20374)