Hi, sqlsmith made it again, attached is the query (run against regression database) that makes the assert fail and the backtrace.
this happens in head only (or at least 11 is fine). -- Jaime Casanova www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
#0 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:51
#1 0x00007f2e7a60342a in __GI_abort () at abort.c:89
#2 0x000056414a49e983 in ExceptionalCondition
(conditionName=conditionName@entry=0x56414a6b2aae "!(strvalue != ((void *)0))",
errorType=errorType@entry=0x56414a4ef4fd "FailedAssertion",
fileName=fileName@entry=0x56414a6b2aa3 "snprintf.c",
lineNumber=lineNumber@entry=789) at assert.c:54
#3 0x000056414a4e8951 in dopr (target=target@entry=0x7ffe95ed9af0,
format=0x56414a53dc43 "\" does not exist",
format@entry=0x56414a53dc28 "column \"%s\" of relation \"%s\" does not
exist", args=<optimized out>) at snprintf.c:789
#4 0x000056414a4e8a2e in pg_vsnprintf (str=<optimized out>, count=<optimized
out>, count@entry=1024,
fmt=fmt@entry=0x56414a53dc28 "column \"%s\" of relation \"%s\" does not
exist", args=args@entry=0x7ffe95ed9b88) at snprintf.c:195
#5 0x000056414a4ec1f9 in pvsnprintf (buf=<optimized out>, len=len@entry=1024,
fmt=fmt@entry=0x56414a53dc28 "column \"%s\" of relation \"%s\" does not exist",
args=args@entry=0x7ffe95ed9b88) at psprintf.c:110
#6 0x000056414a2678b8 in appendStringInfoVA (str=str@entry=0x7ffe95ed9b70,
fmt=fmt@entry=0x56414a53dc28 "column \"%s\" of relation \"%s\" does not exist",
args=args@entry=0x7ffe95ed9b88) at stringinfo.c:136
#7 0x000056414a4a2950 in errmsg (fmt=fmt@entry=0x56414a53dc28 "column \"%s\"
of relation \"%s\" does not exist") at elog.c:796
#8 0x000056414a39f4c8 in convert_column_name (tableoid=tableoid@entry=0,
column=column@entry=0x56414b2c733c) at acl.c:2840
#9 0x000056414a3a160a in has_column_privilege_id_name (fcinfo=0x56414b2c2e90)
at acl.c:2789
#10 0x000056414a2254c3 in ExecInterpExpr (state=0x56414b2ba3a8,
econtext=0x56414b2b84d0, isnull=<optimized out>) at execExprInterp.c:678
#11 0x000056414a25dd8a in ExecEvalExprSwitchContext (isNull=0x7ffe95ed9dae,
econtext=0x56414b2b84d0, state=0x56414b2ba3a8)
at ../../../src/include/executor/executor.h:303
#12 ExecProject (projInfo=0x56414b2ba3a0) at
../../../src/include/executor/executor.h:337
#13 ExecWindowAgg (pstate=0x56414b2ad708) at nodeWindowAgg.c:2237
#14 0x000056414a22920a in ExecProcNode (node=0x56414b2ad708) at
../../../src/include/executor/executor.h:237
#15 ExecutePlan (execute_once=<optimized out>, dest=0x56414b2a92e0,
direction=<optimized out>, numberTuples=0, sendTuples=<optimized out>,
operation=CMD_SELECT,
use_parallel_mode=<optimized out>, planstate=0x56414b2ad708,
estate=0x56414b2abd38) at execMain.c:1749
#16 standard_ExecutorRun (queryDesc=0x56414b2b4178, direction=<optimized out>,
count=0, execute_once=<optimized out>) at execMain.c:364
#17 0x000056414a38c69c in PortalRunSelect (portal=portal@entry=0x56414b23a168,
forward=forward@entry=true, count=0, count@entry=9223372036854775807,
dest=dest@entry=0x56414b2a92e0) at pquery.c:932
#18 0x000056414a38dce0 in PortalRun (portal=portal@entry=0x56414b23a168,
count=count@entry=9223372036854775807, isTopLevel=isTopLevel@entry=true,
run_once=run_once@entry=true, dest=dest@entry=0x56414b2a92e0,
altdest=altdest@entry=0x56414b2a92e0, completionTag=0x7ffe95eda040 "") at
pquery.c:773
#19 0x000056414a38985b in exec_simple_query (
query_string=0x56414b1d54d8 "select \n sample_0.a as c0, \n
pg_catalog.has_column_privilege(\n cast(pg_catalog.pg_my_temp_schema() as
oid),\n cast(sample_0.b as text),\n cast(sample_0.b as text)) as c1, \n
(select slcolor "...) at postgres.c:1192
#20 0x000056414a38b5f4 in PostgresMain (argc=<optimized out>,
argv=argv@entry=0x56414b200818, dbname=<optimized out>, username=<optimized
out>) at postgres.c:4220
#21 0x000056414a06d1ef in BackendRun (port=0x56414b1f7080) at postmaster.c:4379
#22 BackendStartup (port=0x56414b1f7080) at postmaster.c:4051
#23 ServerLoop () at postmaster.c:1709
#24 0x000056414a30c90a in PostmasterMain (argc=3, argv=0x56414b1cf220) at
postmaster.c:1382
#25 0x000056414a06e8bf in main (argc=3, argv=0x56414b1cf220) at main.c:228
query_crash.sql
Description: application/sql
