]> granicus.if.org Git - postgresql/commit
Teach predtest.c that "foo" implies "foo IS NOT NULL".
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 1 Aug 2015 18:31:46 +0000 (14:31 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 1 Aug 2015 18:31:46 +0000 (14:31 -0400)
commitdea1491ffb448d20764a5f2cec8ae33b64dd39f8
treeeda14aed79882f552320715dc78f14681bc4b2d3
parenta6492ff8970b06b9e27cc314c7d1aa574fcc7b04
Teach predtest.c that "foo" implies "foo IS NOT NULL".

Per complaint from Peter Holzer.  It's useful to cover this special case,
since for a boolean variable "foo", earlier parts of the planner will have
reduced variants like "foo = true" to just "foo", and thus we may fail
to recognize the applicability of a partial index with predicate
"foo IS NOT NULL".

Back-patch to 9.5, but not further; given the lack of previous complaints
this doesn't seem like behavior to change in stable branches.
src/backend/optimizer/util/predtest.c