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

From Stefan Huehner
Subject Re: Bug (8.4beta): FailedAssertion("!(bms_is_subset(relids, qualscope))", File: "initsplan.c", Line: 915)
Date
Msg-id 20090507130013.GB16758@huehner.org
Whole thread Raw
In response to Re: Bug (8.4beta): FailedAssertion("!(bms_is_subset(relids, qualscope))", File: "initsplan.c", Line: 915)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Wed, May 06, 2009 at 03:47:46PM -0400, Tom Lane wrote:
> I wrote:
> > I suppose the change I made here
> > http://archives.postgresql.org/pgsql-committers/2009-04/msg00329.php
> > to improve constant-join-qual handling is what is preventing the
> > assertion failure, though I'm still not quite sure why (I'd better look
> > closer to see if there is still some form of the bug lurking).
>

<snipp>

> Kind of a long-winded explanation of what will be a one-line patch,
> but there you have it.

Hi,

i did retest the original failing query on current head.

Sepcifically:

git clone up to and including the on liner patch by you:

86a4abb3a187bf2cc548aedd58125274ac724b1c
Tweak distribute_qual_to_rels so that when we decide a pseudoconstant ...

and cannot reproduce the failure anymore in this version. :)

Thanks for the timely investigation of the issue

Regards,
Stefan

pgsql-bugs by date:

Previous
From: Simon Riggs
Date:
Subject: Re: BUG #4796: Recovery followed by backup creates unrecoverable WAL-file
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #4796: Recovery followed by backup creates unrecoverable WAL-file