Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15577: Query returns different results when executedmultiple times - Mailing list pgsql-bugs

From David Rowley
Subject Re: BUG #15577: Query returns different results when executedmultiple times
Date
Msg-id CAKJS1f_-bU1rMby_qYXOvyAf9Mz8JEojA2tat1iU7mhdrySYoA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15577: Query returns different results when executedmultiple times  (Thomas Munro <thomas.munro@enterprisedb.com>)
Responses Re: BUG #15577: Query returns different results when executedmultiple times  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-bugs
Tree view 
On Tue, 8 Jan 2019 at 13:43, Thomas Munro <thomas.munro@enterprisedb.com> wrote:
> It's as if it thought it was executing a semi-join.

EXPLAIN VERBOSE would show the inner_unique flag. If that's set it
would act as a semi-join.


-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

pgsql-bugs by date:

Previous
From: Thomas Munro
Date:
Subject: Re: BUG #15577: Query returns different results when executedmultiple times
Next
From: Thomas Munro
Date:
Subject: Re: BUG #15577: Query returns different results when executedmultiple times