Division by zero in planner.c:grouping_planner()

Поиск
Список
Период
Сортировка
От Piotr Stefaniak
Тема Division by zero in planner.c:grouping_planner()
Дата
Msg-id BLU436-SMTP73C3D863C3D43CA54AAD7AF28C0@phx.gbl
обсуждение исходный текст
Ответы Re: Division by zero in planner.c:grouping_planner()  (Qingqing Zhou <zhouqq.postgres@gmail.com>)
Список pgsql-hackers
Hello,

with the change below, make installcheck fails -- at the updatable_views
step, I believe. Apparently it's the "SELECT * FROM v1 WHERE a=3;" that
triggers this.

diff --git a/src/backend/optimizer/plan/planner.c 
b/src/backend/optimizer/plan/planner.c
index 6ee411e..cbdee7c 100644
--- a/src/backend/optimizer/plan/planner.c
+++ b/src/backend/optimizer/plan/planner.c
@@ -1661,6 +1661,7 @@ grouping_planner(PlannerInfo *root, double 
tuple_fraction)                         * Plain non-grouped, non-aggregated query: an 
absolute tuple                         * fraction can be divided by the number of tuples.                         */
+                       Assert(path_rows != 0);                        if (tuple_fraction >= 1.0)
        tuple_fraction /= path_rows;                }
 



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

Предыдущее
От: Corey Huinker
Дата:
Сообщение: Re: dblink: add polymorphic functions.
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Remaining 'needs review' patchs in July commitfest