pgsql: Fix an oversight I introduced on 2003-12-28: find_nots/push_nots

Поиск
Список
Период
Сортировка
От tgl@svr1.postgresql.org (Tom Lane)
Тема pgsql: Fix an oversight I introduced on 2003-12-28: find_nots/push_nots
Дата
Msg-id 20050729214004.1706152AAC@svr1.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
Fix an oversight I introduced on 2003-12-28: find_nots/push_nots should
continue to recurse after eliminating a NOT-below-a-NOT, since the
contained subexpression will now be part of the top-level AND/OR structure
and so deserves to be simplified.  The real-world impact of this is
probably minimal, since it'd require at least three levels of NOT to make
a difference, but it's still a bug.
Also remove some redundant tests for NULL subexpressions.

Modified Files:
--------------
    pgsql/src/backend/optimizer/prep:
        prepqual.c (r1.49 -> r1.50)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/prep/prepqual.c.diff?r1=1.49&r2=1.50)

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

Предыдущее
От: bklawans@pgfoundry.org (User Bklawans)
Дата:
Сообщение: bizgres - bizgres: Changed the default image url from "/images" to
Следующее
От: tgl@svr1.postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Back-patch fix for NOT-below-a-NOT case.