Re: [BUGS] BUG #3426: Rows disappear from complex join

2007-07-03 Thread Tom Lane
"David Flater" <[EMAIL PROTECTED]> writes: >> From: Tom Lane [mailto:[EMAIL PROTECTED] >> Hm, I would've thought HEAD actually. What does select version() say? > PostgreSQL 8.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.2.0 > (It's definitely not 8.2.4 but perhaps 8.2.4 + 1/2) Yeah, we

Re: [BUGS] BUG #3426: Rows disappear from complex join

2007-07-03 Thread David Flater
> From: Tom Lane [mailto:[EMAIL PROTECTED] > > "David Flater" <[EMAIL PROTECTED]> 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

Re: [BUGS] BUG #3426: Rows disappear from complex join

2007-07-03 Thread David Flater
> From: Tom Lane [mailto:[EMAIL PROTECTED] > > "David Flater" <[EMAIL PROTECTED]> writes: > > 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

Re: [BUGS] BUG #3426: Rows disappear from complex join

2007-07-03 Thread Tom Lane
"David Flater" <[EMAIL PROTECTED]> writes: > 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?) Hm, I would've thought HEAD actually.

Re: [BUGS] BUG #3426: Rows disappear from complex join

2007-07-03 Thread Tom Lane
"David Flater" <[EMAIL PROTECTED]> 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

[BUGS] BUG #3426: Rows disappear from complex join

2007-07-03 Thread David Flater
The following bug has been logged online: Bug reference: 3426 Logged by: David Flater Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: GNU/Linux Description:Rows disappear from complex join Details: Hello, I am getting NO DATA on queries