Re: BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables
Дата
Msg-id CAMbWs48JpVuP-89Pspros8JWy3EVMVPoVjF2-hnZHgatf=EKKw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables  (Richard Guo <guofenglinux@gmail.com>)
Ответы Re: BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения

On Fri, Aug 12, 2022 at 5:03 PM Richard Guo <guofenglinux@gmail.com> wrote:

On Fri, Aug 12, 2022 at 4:11 PM PG Bug reporting form <noreply@postgresql.org> wrote:
I got server crashed while executing the following query:
(echo "SELECT * FROM t1 ";for((i=2;i<100000;i++));do echo "CROSS JOIN t$i
";done; echo ";") | psql
with the following backtrace below:
Core was generated by `postgres: egorchin egorchin [local] SELECT           

Function transformFromClauseItem() is driven to stack overflow. We need
to add some check_stack_depth() checks here and maybe other more places.
 
Attach a patch to add the check for transformFromClauseItem.

Thanks
Richard
Вложения

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

Предыдущее
От: Richard Guo
Дата:
Сообщение: Re: BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17584: SQL crashes PostgreSQL when using ICU collation