Horton

Re: Hashed IN only applied to first encountered IN

David Rowley <dgrowleyml@gmail.com>

View thread View on postgr.es
From: David Rowley <dgrowleyml@gmail.com>
To: David Geier <geidav.pg@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2025-04-01T12:31:19Z
Lists: pgsql-hackers 
On Wed, 2 Apr 2025 at 00:51, David Geier <geidav.pg@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

Commits

  1. Fix planner's failure to identify multiple hashable ScalarArrayOpExprs