On Thursday, November 23, 2023, Tom Lane <
tgl@sss.pgh.pa.us> wrote:
Zahir Lalani <ZahirLalani@oliver.agency> writes:
> Got a really weird problem with shortcut processing on one server.
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.
I agree that they could make others lives easier by giving more evidence and self-contained example; but the assertions being made are complete.
David J.