Re: segmentation fault with simple UPDATE statement (postgres 10.5)

Hello

I can reproduce on my local PostgreSQL 10.6 (Debian 10.6-1.pgdg80+1)
But not on 11.1

GDB show backtrace:

#0 slot_getattr (slot=0x0, attnum=1, isnull=0x5585781963f8 "")
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/access/common/heaptuple.c:1143
#1 0x00005585774d72fc in ExecEvalExprSwitchContext (isNull=0x5585781963f8 "",
econtext=0x5585781977b8, state=<optimized out>)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/include/executor/executor.h:308
#2 ExecSetParamPlan (node=0x558578197a18,
econtext=econtext(at)entry=0x5585781977b8)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/executor/nodeSubplan.c:988
#3 0x00005585774ab928 in ExecEvalParamExec (state=state(at)entry=0x5585781a96d0,
op=op(at)entry=0x5585781a9798, econtext=econtext(at)entry=0x5585781977b8)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/executor/execExprInterp.c:1855
#4 0x00005585774ae596 in ExecInterpExpr (state=0x5585781a96d0,
econtext=0x5585781977b8, isnull=<optimized out>)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/executor/execExprInterp.c:1013
#5 0x00005585774d3241 in ExecEvalExprSwitchContext (isNull=0x7ffe0ab21437 "",
econtext=0x5585781977b8, state=0x5585781a96d0)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/include/executor/executor.h:308
#6 ExecProject (projInfo=0x5585781a96c8)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/include/executor/executor.h:342
#7 ExecResult (pstate=<optimized out>)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/executor/nodeResult.c:136
#8 0x00005585774cfcbd in ExecProcNode (node=0x558578197908)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/include/executor/executor.h:250
#9 ExecModifyTable (pstate=0x558578197418)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/executor/nodeModifyTable.c:1643
#10 0x00005585774b1d23 in ExecProcNode (node=0x558578197418)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/include/executor/executor.h:250
#11 ExecutePlan (execute_once=<optimized out>, dest=0x558578190158,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_UPDATE, use_parallel_mode=<optimized out>,
planstate=0x558578197418, estate=0x5585781961d8)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/executor/execMain.c:1723
#12 standard_ExecutorRun (queryDesc=0x558578170728, direction=<optimized out>,
count=0, execute_once=<optimized out>)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/executor/execMain.c:364
#13 0x00005585775ef735 in ProcessQuery (plan=<optimized out>,
sourceText=0x55857814f438 "UPDATE t1\n SET (a) = (SELECT b FROM t2 WHERE t2.b = t1.a)\n WHERE 'X' NOT IN ('Y', 'Z');", params=0x0, queryEnv=0x0,
dest=0x558578190158, completionTag=0x7ffe0ab218c0 "")
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/tcop/pquery.c:161
#14 0x00005585775ef98b in PortalRunMulti (portal=portal(at)entry=0x558578180178,
isTopLevel=isTopLevel(at)entry=1 '\001',
setHoldSnapshot=setHoldSnapshot(at)entry=0 '\000',
dest=dest(at)entry=0x558578190158, altdest=altdest(at)entry=0x558578190158,
completionTag=completionTag(at)entry=0x7ffe0ab218c0 "")
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/tcop/pquery.c:1286
#15 0x00005585775f0645 in PortalRun (portal=portal(at)entry=0x558578180178,
count=count(at)entry=9223372036854775807,
isTopLevel=isTopLevel(at)entry=1 '\001', run_once=run_once(at)entry=1 '\001',
dest=dest(at)entry=0x558578190158, altdest=altdest(at)entry=0x558578190158,
completionTag=0x7ffe0ab218c0 "")
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/tcop/pquery.c:799
#16 0x00005585775ec33c in exec_simple_query (
query_string=0x55857814f438 "UPDATE t1\n SET (a) = (SELECT b FROM t2 WHERE t2.b = t1.a)\n WHERE 'X' NOT IN ('Y', 'Z');")
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/tcop/postgres.c:1122
#17 0x00005585775ee1cd in PostgresMain (argc=<optimized out>,
argv=argv(at)entry=0x5585780fb900, dbname=0x5585780fb7f8 "postgres",
username=<optimized out>)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/tcop/postgres.c:4117
#18 0x0000558577324500 in BackendRun (port=0x5585780f2060)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/postmaster/postmaster.c:4405
#19 BackendStartup (port=0x5585780f2060)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/postmaster/postmaster.c:4077
#20 ServerLoop ()
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/postmaster/postmaster.c:1755
#21 0x000055857757befd in PostmasterMain (argc=5, argv=<optimized out>)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/postmaster/postmaster.c:1363
#22 0x00005585773258eb in main (argc=5, argv=0x5585780b3760)
at /build/postgresql-10-svt3W6/postgresql-10-10.6/build/../src/backend/main/

regards, Sergei