"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: > On Thursday, November 23, 2023, Tom Lane <tgl@xxxxxxxxxxxxx> 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
