Re: Two division by 0 errors in optimizer/plan/planner.c and optimizer/path/costsize.c

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Two division by 0 errors in optimizer/plan/planner.c and optimizer/path/costsize.c
Дата
Msg-id 11392.1459117324@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Two division by 0 errors in optimizer/plan/planner.c and optimizer/path/costsize.c  (Piotr Stefaniak <postgres@piotr-stefaniak.me>)
Список pgsql-hackers
Дерево обсуждения 
Piotr Stefaniak <postgres@piotr-stefaniak.me> writes:
> On the exact same note, something like this (again reduced from what 
> sqlsmith produced):
> leads to vardata.rel->tuples being zero here:
>     if (vardata.rel)
>         ndistinct *= vardata.rel->rows / vardata.rel->tuples;

Ugh.  That's a bit worse because it'll be 0/0, ie you get a NaN.
Thanks for the report.
        regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Two division by 0 errors in optimizer/plan/planner.c and optimizer/path/costsize.c
Следующее
От: Andres Freund
Дата:
Сообщение: Re: silent data loss with ext4 / all current versions