Re: Odd Shortcut behaviour in PG14

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Odd Shortcut behaviour in PG14
Дата
Msg-id
3163408.1700764749@sss.pgh.pa.us
Ответ на
Odd Shortcut behaviour in PG14 (David G. Johnston)
Список
Дерево обсуждения
Odd Shortcut behaviour in PG14 Zahir Lalani <ZahirLalani@oliver.agency>
Re: Odd Shortcut behaviour in PG14 Adrian Klaver <adrian.klaver@aklaver.com>
Re: Odd Shortcut behaviour in PG14 Tom Lane <tgl@sss.pgh.pa.us>
Odd Shortcut behaviour in PG14 "David G. Johnston" <david.g.johnston@gmail.com>
Re: Odd Shortcut behaviour in PG14 Tom Lane <tgl@sss.pgh.pa.us>
Re: Odd Shortcut behaviour in PG14 "David G. Johnston" <david.g.johnston@gmail.com>
Re: Odd Shortcut behaviour in PG14 Ron Johnson <ronljohnsonjr@gmail.com>
Re: Odd Shortcut behaviour in PG14 Tom Lane <tgl@sss.pgh.pa.us>
RE: Odd Shortcut behaviour in PG14 Zahir Lalani <ZahirLalani@oliver.agency>
Re: Odd Shortcut behaviour in PG14 Tom Lane <tgl@sss.pgh.pa.us>
RE: Odd Shortcut behaviour in PG14 Zahir Lalani <ZahirLalani@oliver.agency>
Re: Odd Shortcut behaviour in PG14 Tom Lane <tgl@sss.pgh.pa.us>
RE: Odd Shortcut behaviour in PG14 Zahir Lalani <ZahirLalani@oliver.agency>
Re: Odd Shortcut behaviour in PG14 Ron Johnson <ronljohnsonjr@gmail.com>
"David G. Johnston"  writes:
> On Thursday, November 23, 2023, Tom Lane  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 по дате отправления
От: David G. Johnston
Дата:
Сообщение: Odd Shortcut behaviour in PG14
От: David G. Johnston
Дата:
FAQ