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

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема pgsql: Don't let transform_null_equals=on affect CASE foo WHEN NULL ...
Дата
Msg-id E1RCSLZ-0007uY-1h@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
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.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/1ef60dab7049ffac52dee60b5788b6c7bc1f9d67

Modified Files
--------------
src/backend/parser/parse_expr.c |    7 +++++--
1 files changed, 5 insertions(+), 2 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: pgsql: Don't let transform_null_equals=on affect CASE foo WHEN NULL ...
Следующее
От: Cédric Villemain
Дата:
Сообщение: Re: pgsql: Support index-only scans using the visibility map to avoid heap