Horton

Bug in check for unreachable MERGE WHEN clauses

Dean Rasheed <dean.a.rasheed@gmail.com>

View thread View on postgr.es
From: Dean Rasheed <dean.a.rasheed@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2023-01-02T12:13:59Z
Lists: pgsql-hackers

Attachments

Re-reading my latest MERGE patch, I realised there is a trivial,
pre-existing bug in the check for unreachable WHEN clauses, which
means it won't spot an unreachable WHEN clause if it doesn't have an
AND condition.

So the checks need to be re-ordered, as in the attached.

Regards,
Dean

Commits

  1. Fix MERGE's test for unreachable WHEN clauses.