Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql: Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate - Mailing list pgsql-committers

From Alexander Korotkov
Subject Re: pgsql: Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate
Date
Msg-id CAPpHfdtJks3MoVnDKtYde7+esU3kgemSuSqEEOiQ4EB5xg0qjw@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate  (Melanie Plageman <melanieplageman@gmail.com>)
List pgsql-committers
Tree view 
On Fri, Apr 4, 2025 at 6:47 PM Melanie Plageman
<melanieplageman@gmail.com> wrote:
>
> On Fri, Apr 4, 2025 at 9:17 AM Alexander Korotkov
> <akorotkov@postgresql.org> wrote:
> >
> > Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate
> >
> > This commit implements the automatic conversion of 'x IN (VALUES ...)' into
> > ScalarArrayOpExpr.  That simplifies the query tree, eliminating the appearance
> > of an unnecessary join.
>
> I haven't looked at this patch, but it seems likely that it is related
> to the recent failures I noticed in CI in the subselect test when the
> regress suite is run by 002_pg_upgrade.pl


Thank you for pointing.  I'm looking right now.

------
Regards,
Alexander Korotkov
Supabase

pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Stabilize regression test from c0962a113.
Next
From: Peter Geoghegan
Date:
Subject: pgsql: Further optimize nbtree search scan key comparisons.