Re: Bug (8.4beta): FailedAssertion("!(bms_is_subset(relids, qualscope))", File: "initsplan.c", Line: 915)

Tom Lane wrote:
> Stefan Huehner <stefan@huehner.org> writes:
>> I noticed the following bug when testing an application (openbravo 2.40) on postgresql 8.4:
>
> Thank you for the report, but I do not see any problem when trying the
> test case here.  Do you have any nondefault planner parameter settings?

hmm weird - the testcase crashes for me as well on 8.4B1:


(gdb) bt
#0  0xb7f69424 in __kernel_vsyscall ()
#1  0xb7df4640 in raise () from /lib/i686/cmov/libc.so.6
#2  0xb7df6018 in abort () from /lib/i686/cmov/libc.so.6
#3  0x0832cace in ExceptionalCondition (
     conditionName=0x845d954 "!(bms_is_subset(relids, qualscope))",
     errorType=0x8362014 "FailedAssertion", fileName=0x845d836
"initsplan.c", lineNumber=915)
     at assert.c:57
#4  0x08215586 in distribute_qual_to_rels (root=0xa29bd9c,
clause=0xa2aad0c, is_deduced=0 '\0',
     below_outer_join=0 '\0', jointype=JOIN_INNER, qualscope=0xa2ad254,
ojscope=0x0,
     outerjoin_nonnullable=0x0) at initsplan.c:915
#5  0x08215a28 in deconstruct_recurse (root=0xa29bd9c, jtnode=0xa2a8a18,
below_outer_join=0 '\0',
     qualscope=0xbf8823e8, inner_join_rels=0xbf8823e0) at initsplan.c:336
#6  0x08215b55 in deconstruct_recurse (root=0xa29bd9c, jtnode=0xa2a971c,
below_outer_join=0 '\0',
     qualscope=0xbf882468, inner_join_rels=0xbf88249c) at initsplan.c:394
#7  0x0821596b in deconstruct_recurse (root=0xa29bd9c, jtnode=0xa2a9784,
below_outer_join=0 '\0',
     qualscope=0xbf8824a0, inner_join_rels=0xbf88249c) at initsplan.c:305
#8  0x082161d5 in deconstruct_jointree (root=0xa29bd9c) at initsplan.c:238


Stefan