Re: BUG #4934: regression in IN with joins in subselect

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Benjamin Reed <ranger(at)opennms(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4934: regression in IN with joins in subselect
Date: 2009-07-23 17:43:40
Message-ID: 22276.1248371020@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Benjamin Reed <ranger(at)opennms(dot)org> writes:
> 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.

Thanks for the test case. This patch should fix it.

regards, tom lane

Attachment Content-Type Size
unknown_filename text/plain 1.9 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Anders Edstrom 2009-07-23 19:15:16 BUG #4938: upgrade to 8.4 issue
Previous Message Tom Lane 2009-07-23 16:22:22 Re: BUG #4936: Bad result for SQL query