Re: pgsql: Transform OR clauses to ANY expression

2024-04-08 Thread Jelte Fennema-Nio
On Mon, 8 Apr 2024 at 17:10, Alexander Korotkov wrote: > > On Mon, Apr 8, 2024 at 1:35 AM Melanie Plageman > wrote: > > /src/backend/optimizer/prep/prepqual.c:582:33: warning: declaration of > > ‘lc__state’ shadows a previous local [-Wshadow=compatible-local] > > 582 |

Re: pgsql: Transform OR clauses to ANY expression

2024-04-08 Thread Alexander Korotkov
On Mon, Apr 8, 2024 at 9:24 AM Kyotaro Horiguchi wrote: > At Mon, 08 Apr 2024 14:46:57 +0900 (JST), Kyotaro Horiguchi > wrote in > > At Sun, 07 Apr 2024 22:28:06 +, Alexander Korotkov > > wrote in > > > Transform OR clauses to ANY expression > > > > This commit introduces a message like

Re: pgsql: Transform OR clauses to ANY expression

2024-04-08 Thread Kyotaro Horiguchi
At Mon, 08 Apr 2024 14:46:57 +0900 (JST), Kyotaro Horiguchi wrote in > At Sun, 07 Apr 2024 22:28:06 +, Alexander Korotkov > wrote in > > Transform OR clauses to ANY expression > > This commit introduces a message like this: > > > gettext_noop("Set the minimum length of the list of OR

Re: pgsql: Transform OR clauses to ANY expression

2024-04-07 Thread Kyotaro Horiguchi
At Sun, 07 Apr 2024 22:28:06 +, Alexander Korotkov wrote in > Transform OR clauses to ANY expression This commit introduces a message like this: > gettext_noop("Set the minimum length of the list of OR clauses to attempt the > OR-to-ANY transformation."), Unlike the usual phrasing of

Re: pgsql: Transform OR clauses to ANY expression

2024-04-07 Thread Alexander Korotkov
On Mon, Apr 8, 2024 at 1:35 AM Melanie Plageman wrote: > On Sun, Apr 7, 2024 at 6:28 PM Alexander Korotkov > wrote: > > > > Transform OR clauses to ANY expression > > > > Replace (expr op C1) OR (expr op C2) ... with expr op ANY(ARRAY[C1, C2, > > ...]) > > on the preliminary stage of

Re: pgsql: Transform OR clauses to ANY expression

2024-04-07 Thread Melanie Plageman
On Sun, Apr 7, 2024 at 6:28 PM Alexander Korotkov wrote: > > Transform OR clauses to ANY expression > > Replace (expr op C1) OR (expr op C2) ... with expr op ANY(ARRAY[C1, C2, ...]) > on the preliminary stage of optimization when we are still working with the > expression tree. > > Here Cn is a

pgsql: Transform OR clauses to ANY expression

2024-04-07 Thread Alexander Korotkov
Transform OR clauses to ANY expression Replace (expr op C1) OR (expr op C2) ... with expr op ANY(ARRAY[C1, C2, ...]) on the preliminary stage of optimization when we are still working with the expression tree. Here Cn is a n-th constant expression, 'expr' is non-constant expression, 'op' is an