Possibly, I saw that thread but may not have dug into the content
deeply enough. My apologies if this is the case, i'll check it out
further.
On Sep 10, 2008, at 3:38 PM, Tom Lane wrote:
Joe Uhl <[EMAIL PROTECTED]> writes:
We have a query that returns a different result in 8.2.5 and 8.3.0
Joe Uhl <[EMAIL PROTECTED]> 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
push
Joe Uhl <[EMAIL PROTECTED]> writes:
> We have a query that returns a different result in 8.2.5 and 8.3.0.
I think this is the same bug discussed yesterday:
http://archives.postgresql.org/pgsql-bugs/2008-09/msg00078.php
regards, tom lane
--
Sent via pgsql-bugs mailing
We have a query that returns a different result in 8.2.5 and 8.3.0.
This is the query, I apologize for the names and aliases, it is
hibernate-generated.
select * from action_items actionitem0_
left outer join action_item_states states1_ on
actionitem0_.id=states1_.action_item_id
where (
