Re: [sqlsmith] Failed assertion at relnode.c

On Thu, Mar 14, 2019 at 11:53 PM tushar <tushar.ahuja@enterprisedb.com> wrote:
>
> Hi,
>
> While running sqlsmith against 12devel, got the the following
> assertion-  (issue is reproducible  on v10/v11 as well)
>
> TRAP: FailedAssertion("!(bms_is_subset(appendrel->lateral_relids,
> required_outer))", File: "relnode.c", Line: 1521)
>
> stack trace -
>
> #0  0x00007f2a2f349277 in raise () from /lib64/libc.so.6
> #1  0x00007f2a2f34a968 in abort () from /lib64/libc.so.6
> #2  0x0000000000893727 in ExceptionalCondition
> (conditionName=conditionName@entry=0xa44ae8
> "!(bms_is_subset(appendrel->lateral_relids, required_outer))",
>      errorType=errorType@entry=0x8e1de9 "FailedAssertion",
> fileName=fileName@entry=0xa441e4 "relnode.c",
> lineNumber=lineNumber@entry=1521) at assert.c:54
> #3  0x00000000006f2e0c in get_appendrel_parampathinfo
> (appendrel=appendrel@entry=0x7f2a300e0b10,
> required_outer=required_outer@entry=0x0) at relnode.c:1521
> #4  0x00000000006e7d1d in create_append_path (root=root@entry=0x0,
> rel=rel@entry=0x7f2a300e0b10, subpaths=subpaths@entry=0x0,
> partial_subpaths=partial_subpaths@entry=0x0,
>      required_outer=required_outer@entry=0x0,
> parallel_workers=parallel_workers@entry=0,
> parallel_aware=parallel_aware@entry=false,
> partitioned_rels=partitioned_rels@entry=0x0,
>      rows=rows@entry=-1) at pathnode.c:1239
> #5  0x00000000006a7fc7 in set_dummy_rel_pathlist
> (rel=rel@entry=0x7f2a300e0b10) at allpaths.c:1976

Looks same as bug #15694 that Tom seems to be taking care of.

Thanks,
Amit