Re: Strange behavior for query comparing 8.2.5 and 8.3.0 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Strange behavior for query comparing 8.2.5 and 8.3.0
Date
Msg-id 9486.1221075840@sss.pgh.pa.us
Whole thread Raw
In response to Strange behavior for query comparing 8.2.5 and 8.3.0  (Joe Uhl <joeuhl@gmail.com>)
List pgsql-bugs
Joe Uhl <joeuhl@gmail.com> writes:
> We have a query that returns a different result in 8.2.5 and 8.3.0.
> ...
> The result in 8.3.0 is what we expect.

I guess I read a little too fast, because I overlooked that comment.
It's the 8.3.0 plan that is broken in my opinion --- it shouldn't be
pushing down the IS NULL conditions.  If you think that 8.2.5 is giving
a wrong answer then you need to provide a test case demonstrating that.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange behavior for query comparing 8.2.5 and 8.3.0
Next
From: Joe Uhl
Date:
Subject: Re: Strange behavior for query comparing 8.2.5 and 8.3.0