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 CAMbWs48JpVuP-89Pspros8JWy3EVMVPoVjF2-hnZHgatf=EKKw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables  (Richard Guo <guofenglinux@gmail.com>)
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 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
Attachment

pgsql-bugs by date:

Previous
From: Richard Guo
Date:
Subject: Re: BUG #17583: Server crashes on executing CROSS JOIN with very big number of tables
Next
From: PG Bug reporting form
Date:
Subject: BUG #17584: SQL crashes PostgreSQL when using ICU collation