On Thursday, November 23, 2023, Tom Lane <t...@sss.pgh.pa.us> wrote: > "David G. Johnston" <david.g.johns...@gmail.com> writes: > > On Thursday, November 23, 2023, Tom Lane <t...@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.
