Horton

Adjust overly strict Assert

David Rowley <drowley@postgresql.org>

View on postgr.es
Commit: e1a0f6a983068675813074847e1d0d61bd37ac0e
Author: David Rowley <drowley@postgresql.org>
Date: 2019-07-21T22:29:41Z
Releases: 13.0 
Adjust overly strict Assert

3373c7155 changed how we determine EquivalenceClasses for relations and
added an Assert to ensure all relations mentioned in each EC's ec_relids
was a RELOPT_BASEREL.  However, the join removal code may remove a LEFT
JOIN and since it does not clean up EC members belonging to the removed
relations it can leave RELOPT_DEADREL rels in ec_relids.

Fix this by adjusting the Assert to allow RELOPT_DEADREL rels too.

Reported-by: sqlsmith via Andreas Seltenreich
Discussion: https://postgr.es/m/87y30r8sls.fsf@ansel.ydns.eu

Files

PathChange+/−
src/backend/optimizer/path/equivclass.c modified +2 −1

Discussion