Re: Odd Shortcut behaviour in PG14 - Mailing list pgsql-general

From Tom Lane
Subject Re: Odd Shortcut behaviour in PG14
Date
Msg-id 3163408.1700764749@sss.pgh.pa.us
Whole thread Raw
In response to Odd Shortcut behaviour in PG14  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Odd Shortcut behaviour in PG14  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thursday, November 23, 2023, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> This question is unanswerable as given.  You have not even defined
>> what you mean by "fail" (error? wrong query result?), let alone
>> provided enough detail for someone else to reproduce the problem.

> The OP complains about the apparent inconsistent optimizing away of the SRF
> function call of crypto_secretbox_open in the lateral when the join
> predicate is known to be false.

Hmm, your crystal ball apparently works better than mine today,
because I sure do not see where that information was presented.

            regards, tom lane



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Odd Shortcut behaviour in PG14
Next
From: "David G. Johnston"
Date:
Subject: Re: Odd Shortcut behaviour in PG14