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

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Егор Чиндяскин <kyzevan23(at)mail(dot)ru>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables
Date: 2022-08-12 09:03:21
Message-ID: CAMbWs499ytQiH4mLMhRxRWP-iEUz3-DSinpAD-cUCtVo_23Wtg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Aug 12, 2022 at 4:11 PM PG Bug reporting form <
noreply(at)postgresql(dot)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.

Thanks
Richard

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Guo 2022-08-12 09:22:57 Re: BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables
Previous Message John Naylor 2022-08-12 07:19:15 Re: BUG #17581: DB Restriction Option Is Not Working