Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown

Поиск
Список
Период
Сортировка
От Kuntal Ghosh
Тема Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown
Дата
Msg-id CAGz5QCKuD54qPVnQAUXEoQzWmpVNty8NNoMNnKzrSE3qBRCJDw@mail.gmail.com
обсуждение исходный текст
Ответы Re: BUG #19102: Assertion failure in generate_orderedappend_paths with aggregate pushdown
Список pgsql-bugs

On Mon, Nov 3, 2025 at 11:22 AM PG Bug reporting form <noreply@postgresql.org> wrote:

Server crashes with assertion failure:
TRAP: FailedAssertion("childrel->rows > 0", File: "allpaths.c", Line: 1983)

To fix the issue, we can replace the direct division with
clamp_row_est(childrel->rows) to safely handle zero, and remove the
incorrect assertion:

-   Assert(childrel->rows > 0);
-   path_fraction /= childrel->rows;
+   path_fraction /= clamp_row_est(childrel->rows);

Added a patch with the proposed fix and regression test.

--
Thanks & Regards,
Kuntal Ghosh
Вложения

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