Re: BUG #3426: Rows disappear from complex join - Mailing list pgsql-bugs

From David Flater
Subject Re: BUG #3426: Rows disappear from complex join
Date
Msg-id 000c01c7bd99$4ffe4ba0$7f3a0681@sdct.nist.gov
Whole thread Raw
In response to Re: BUG #3426: Rows disappear from complex join  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>
> "David Flater" <dflater@nist.gov> writes:
> > I am getting NO DATA on queries that attempt to match one of the "outer"
> > rows generated by an outer join.
>
> Your test case works fine for me on CVS HEAD and 8.2 branch tip.  I
> think it is another manifestation of this bug:
> http://archives.postgresql.org/pgsql-bugs/2007-05/msg00187.php
> which was fixed here:
> http://archives.postgresql.org/pgsql-committers/2007-05/msg00305.php

I installed postgresql-snapshot.tar.bz2 2007-07-03 10:18:42 from
stable_snapshot and confirm that the problem does not reproduce there.  (I
assume that this snapshot is 8.2 branch tip and CVS HEAD is 8.3 dev?)

Thanks,
--
David Flater, National Institute of Standards and Technology, U.S.A.

pgsql-bugs by date:

Previous
From: "David Flater"
Date:
Subject: Re: BUG #3426: Rows disappear from complex join
Next
From: Tom Lane
Date:
Subject: Re: BUG #3426: Rows disappear from complex join