Horton

Re: BUG #17976: Inconsistent results of SELECT using CASE WHEN clause

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Richard Guo <guofenglinux@gmail.com>, zuming.jiang@inf.ethz.ch, pgsql-bugs@lists.postgresql.org
Date: 2023-06-19T13:29:55Z
Lists: pgsql-bugs 
Amit Kapila <amit.kapila16@gmail.com> writes:
> Does this commit close the open item: "join removal can no longer skip
> updating EquivalenceClasses"? If so, can we update it?

Yeah.  I'd left that open because there are several perhaps-overlapping
issues in the same area, but that bug as-stated is gone.

			regards, tom lane

Commits

  1. When removing a left join, clean out references in EquivalenceClasses.

  2. doc: PG 16 relnotes, fix PREPARE/EXECUTE wording