projects / users / rhaas / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: d952373) | patch
Fix MERGE's test for unreachable WHEN clauses.
authorDean Rasheed <dean.a.rasheed@gmail.com>
Tue, 10 Jan 2023 14:17:47 +0000 (14:17 +0000)
committerDean Rasheed <dean.a.rasheed@gmail.com>
Tue, 10 Jan 2023 14:17:47 +0000 (14:17 +0000)
commitf026c16a2c5a3ee5d7aa6f85333ec80c905913ba
tree4bc010d468cee93ccae63304a915a6c4fb2066f4tree
parentd952373a987bad331c0e499463159dd142ced1efcommit | diff
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
src/backend/parser/parse_merge.c diff | blob | blame | history
src/test/regress/expected/merge.out diff | blob | blame | history
src/test/regress/sql/merge.sql diff | blob | blame | history
Robert Haas's development tree.