Re: Odd Shortcut behaviour in PG14
| От | David G. Johnston |
|---|---|
| Тема | Re: Odd Shortcut behaviour in PG14 |
| Дата | |
| Msg-id | CAKFQuwbM5DpPcC3bVFcjACLvQoBqnPbowDoBEeUt5wA=Q687JQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Odd Shortcut behaviour in PG14 (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-general |
On Thursday, November 23, 2023, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"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.
My interpretation of:
“ The expectation being that if ekey=0 the lateral join will be ignored. “
David J.
В списке pgsql-general по дате отправления: