Re: BUG #3426: Rows disappear from complex join

> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
>
> "David Flater" <dflater(at)nist(dot)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.