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

Tom Lane wrote:
> Stefan Huehner <stefan(at)huehner(dot)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