Re: Re[2]: BUG #17561: Server crashes on executing row() with very long argument list

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Егор Чиндяскин <kyzevan23(at)mail(dot)ru>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Re[2]: BUG #17561: Server crashes on executing row() with very long argument list
Date: 2022-08-01 10:03:44
Message-ID: CAMbWs48GiU-qucoJwH-p0pUY0OnrxZPXQjv7+HGzEPv6D18Vpg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Aug 1, 2022 at 3:17 PM Егор Чиндяскин <kyzevan23(at)mail(dot)ru> wrote:

> Thank you, Tom! The fix works for that case, but there is another one.
> I got server crashed while executing the following script:
>
> (echo "SELECT * FROM json_to_record('{\"0\":0 ";for((i=1;i<100001;i++));do
> echo ",\"$i\":$i";done; echo "}') as x("; echo "\"0\"
> int";for((i=1;i<100001;i++));do echo ",\"$i\" int";done;echo ")") | psql
>

Thanks for the report! This is another place that we construct a tupdesc
with more than MaxAttrNumber attributes, via RangeFunctions this time.

Regarding the fix, how about we check the length of coldeflist against
MaxTupleAttributeNumber in transformRangeFunction()?

Thanks
Richard

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Guo 2022-08-01 10:33:31 Re: Re[2]: BUG #17561: Server crashes on executing row() with very long argument list
Previous Message Stanisław Skonieczny 2022-08-01 09:06:24 Re: BUG #17560: Planner can not find plan with lowest cost