On Thursday, November 23, 2023, Tom Lane <t...@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.
