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

On 2022-Jul-29, PG Bug reporting form wrote:

> When executing the following query:
> (echo "SELECT row("; for ((i=1;i<100001;i++)); do echo "'$i',$i,"; done;
> echo "'0',0);"; ) | psql
> I got server crash with the following backtrace
...
> #5 0x0000557e1694f850 in ExceptionalCondition
> (conditionName=conditionName(at)entry=0x557e169b2e62 "attributeNumber >= 1",
> errorType=errorType(at)entry=0x557e169b0e7f "BadArgument",
> fileName=fileName(at)entry=0x557e169b2d7c "tupdesc.c",
> lineNumber=lineNumber(at)entry=598) at assert.c:69
> #6 0x0000557e1642790a in TupleDescInitEntry
> (desc=desc(at)entry=0x7f42a4c8b050,
> attributeNumber=attributeNumber(at)entry=-32768,
> attributeName=attributeName(at)entry=0x0, oidtypeid=23, typmod=typmod(at)entry=-1,
> attdim=attdim(at)entry=0)
> at tupdesc.c:598
> #7 0x0000557e1664c509 in ExecTypeFromExprList (exprList=0x7f42a7830cf0) at
> execTuples.c:2009

Hah, of course. I suppose we'd need something like this ... haven't
looked for other problem spots.

--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/