Re: BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables - Mailing list pgsql-bugs

From Richard Guo
Subject Re: BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables
Date
Msg-id CAMbWs499ytQiH4mLMhRxRWP-iEUz3-DSinpAD-cUCtVo_23Wtg@mail.gmail.com
Whole thread Raw
In response to BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables
List pgsql-bugs

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.

Thanks
Richard

pgsql-bugs by date:

Previous
From: John Naylor
Date:
Subject: Re: BUG #17581: DB Restriction Option Is Not Working
Next
From: Richard Guo
Date:
Subject: Re: BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables