Re: BUG #13908: Query returns too few rows

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>, Seth P <seth-p(at)outlook(dot)com>
Subject: Re: BUG #13908: Query returns too few rows
Date: 2016-02-04 23:28:32
Message-ID: 7909.1454628512@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> *The second-level Hash Join combines/sees, in both cases, 7,993 and
> 1,275,138 records but depending on the LEFT/RIGHT order of the sub-nodes
> appears to provide a different result.*

Hmm, that's pretty fishy; and given all the hacking that's gone on lately
on hash join, 9.5 introducing a bug there wouldn't be all that astonishing.
But I decline to try to find it without a self-contained test case.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2016-02-05 02:03:59 Re: BUG #13908: Query returns too few rows
Previous Message David G. Johnston 2016-02-04 23:04:54 Re: BUG #13908: Query returns too few rows