Postgres Pro
Downloads
Home   >   mailing lists

Bug in check for unreachable MERGE WHEN clauses - Mailing list pgsql-hackers

From Dean Rasheed
Subject Bug in check for unreachable MERGE WHEN clauses
Date
Msg-id CAEZATCVQ=7E2z4cSBB49jjeGGsB6WeoYQY32NDeSvcHiLUZ=ow@mail.gmail.com
Whole thread Raw
Responses Re: Bug in check for unreachable MERGE WHEN clauses
List pgsql-hackers
Tree view 
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
Attachment

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Add BufFileRead variants with short read and EOF detection
Next
From: Amit Kapila
Date:
Subject: Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION