Re: [sqlsmith] Failed assertion at relnode.c

On Thu, Mar 14, 2019 at 11:53 PM tushar <tushar(dot)ahuja(at)enterprisedb(dot)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(at)entry=0xa44ae8
> "!(bms_is_subset(appendrel->lateral_relids, required_outer))",
> errorType=errorType(at)entry=0x8e1de9 "FailedAssertion",
> fileName=fileName(at)entry=0xa441e4 "relnode.c",
> lineNumber=lineNumber(at)entry=1521) at assert.c:54
> #3 0x00000000006f2e0c in get_appendrel_parampathinfo
> (appendrel=appendrel(at)entry=0x7f2a300e0b10,
> required_outer=required_outer(at)entry=0x0) at relnode.c:1521
> #4 0x00000000006e7d1d in create_append_path (root=root(at)entry=0x0,
> rel=rel(at)entry=0x7f2a300e0b10, subpaths=subpaths(at)entry=0x0,
> partial_subpaths=partial_subpaths(at)entry=0x0,
> required_outer=required_outer(at)entry=0x0,
> parallel_workers=parallel_workers(at)entry=0,
> parallel_aware=parallel_aware(at)entry=false,
> partitioned_rels=partitioned_rels(at)entry=0x0,
> rows=rows(at)entry=-1) at pathnode.c:1239
> #5 0x00000000006a7fc7 in set_dummy_rel_pathlist
> (rel=rel(at)entry=0x7f2a300e0b10) at allpaths.c:1976

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

Thanks,
Amit