projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 18b8125) | patch
Fix MERGE's test for unreachable WHEN clauses.
authorDean Rasheed <dean.a.rasheed@gmail.com>
Tue, 10 Jan 2023 14:16:27 +0000 (14:16 +0000)
committerDean Rasheed <dean.a.rasheed@gmail.com>
Tue, 10 Jan 2023 14:16:27 +0000 (14:16 +0000)
commit38255f2d0059a101c3fb791d6523a9e66e55aa66
tree448b2d1782e7b384d2e48e28724f728641e049fdtree
parent18b81258ab60cdd172329fe80dd2314d587bd551commit | 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
This is the main PostgreSQL git repository.