Thread: Bug in check for unreachable MERGE WHEN clauses

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

On Mon, 2 Jan 2023 at 12:13, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
>
> 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.
>

Pushed and back-patched.

Regards,
Dean