pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Benoit Ryder <b.ryder@ateme.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #18429: Inconsistent results on similar queries with join lateral
Date: Fri, 12 Apr 2024 15:01:50 -0400
Message-ID: <481322.1712948510@sss.pgh.pa.us> (raw)
In-Reply-To: <CAKFQuwZVGb335kR9hUednKd-Rnkf4t29nRsTS2Wgn0jJzfu7jA@mail.gmail.com>
References: <18429-8982d4a348cc86c6@postgresql.org>
	<CAKFQuwaTm7gWL7S3KVFJCit92-JSFBoQ3Ax-msU+5P5YAw=C2w@mail.gmail.com>
	<441100.1712933417@sss.pgh.pa.us>
	<MR1P264MB1971C01DA74122691EBBEE9FF9042@MR1P264MB1971.FRAP264.PROD.OUTLOOK.COM>
	<450117.1712937002@sss.pgh.pa.us>
	<CAKFQuwZVGb335kR9hUednKd-Rnkf4t29nRsTS2Wgn0jJzfu7jA@mail.gmail.com>

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Fri, Apr 12, 2024 at 8:50 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I'm not seeing a bulletproof way offhand, other than "update to v16".

> Q1 is trivially fixed by specifying "WITH c2 AS MATERIALIZED ( ... )", No?

Q1 as stated, yeah.  But the question was about generically avoiding
this bug, and I'm not yet sure about how to do that in cases not
involving a WITH boundary (eg Q3,Q4).

			regards, tom lane





view thread (15+ messages)  latest in thread

Message-ID: <481322.1712948510@sss.pgh.pa.us>
Permalink:  ../481322.1712948510@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/481322.1712948510@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, b.ryder@ateme.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #18429: Inconsistent results on similar queries with join lateral
  In-Reply-To: <481322.1712948510@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox