Re: BUG #4934: regression in IN with joins in subselect - Mailing list pgsql-bugs

From Benjamin Reed
Subject Re: BUG #4934: regression in IN with joins in subselect
Date
Msg-id 4A67854C.60605@opennms.org
Whole thread Raw
In response to Re: BUG #4934: regression in IN with joins in subselect  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #4934: regression in IN with joins in subselect  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #4934: regression in IN with joins in subselect  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On 7/22/09 4:39 PM, Tom Lane wrote:
> "Benjamin Reed" <ranger@opennms.org> writes:
>> I've hit a regression vs. PostgreSQL 8.2 and 8.3 (and probably others)
>> related to subselects.  This query:
>
> It's not going to be possible to examine this with just the query.
> You need to provide a self-contained test case.

Attached is a test case, including the query that causes the error at
the end.  On 8.3, it returns 1 row (192.168.1.1), on 8.4 including the
git 8.4 branch, it returns none.

--
Benjamin Reed
The OpenNMS Group
http://www.opennms.org/


Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #4934: regression in IN with joins in subselect
Next
From: Tom Lane
Date:
Subject: Re: BUG #4934: regression in IN with joins in subselect