pgsql: Fix MERGE's test for unreachable WHEN clauses. - Mailing list pgsql-committers

From Dean Rasheed
Subject pgsql: Fix MERGE's test for unreachable WHEN clauses.
Date
Msg-id E1pFFUI-002yl7-Uh@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix MERGE's test for unreachable WHEN clauses.

The former code would only detect an unreachable WHEN clause if it had
an AND condition. Fix, so that unreachable unconditional WHEN clauses
are also detected.

Back-patch to v15, where MERGE was added.

Discussion: https://postgr.es/m/CAEZATCVQ=7E2z4cSBB49jjeGGsB6WeoYQY32NDeSvcHiLUZ=ow@mail.gmail.com

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/38255f2d0059a101c3fb791d6523a9e66e55aa66

Modified Files
--------------
src/backend/parser/parse_merge.c    | 6 +++---
src/test/regress/expected/merge.out | 2 +-
src/test/regress/sql/merge.sql      | 2 +-
3 files changed, 5 insertions(+), 5 deletions(-)


pgsql-committers by date:

Previous
From: Erik Rijkers
Date:
Subject: Re: pgsql: Fix the display of lock information for specktoken.
Next
From: Amit Kapila
Date:
Subject: Re: pgsql: Fix the display of lock information for specktoken.