Horton

Don't let transform_null_equals=on affect CASE foo WHEN NULL ... constructs.

Heikki Linnakangas <heikki.linnakangas@iki.fi>

View on postgr.es
Commit: aadfd6e5d660f497be3f64fc120c4339da6c7192
Author: Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date: 2011-10-08T08:21:16Z
Releases: 8.2.23 
Don't let transform_null_equals=on affect CASE foo WHEN NULL ... constructs.
transform_null_equals is only supposed to affect "foo = NULL" expressions
given directly by the user, not the internal "foo = NULL" expression
generated from CASE-WHEN.

This fixes bug #6242, reported by Sergey. Backpatch to all supported
branches.

Files

PathChange+/−
src/backend/parser/parse_expr.c modified +5 −2