On Wed, 2 Apr 2025 at 00:51, David Geier <geidav...@gmail.com> wrote: > The hashed IN optimization is only applied to the first encountered > ScalarArrayOpExpr during the expression tree traversal in > convert_saop_to_hashed_saop_walker(). Reason being that the walker > returns true which aborts the traversal.
> I've also attached a patch with a fix. Thanks for the report and fix. On first inspection your patch looks fine. I'll have a closer look tomorrow. David