Richard Guo <guofengli...@gmail.com> writes: > Oh, wait ... It occurred to me that we may have this same issue with > Memoize cache keys. In get_memoize_path we collect the cache keys from > innerpath's ppi_clauses and innerrel's lateral_vars, and the latter may > contain nullingrel markers that need adjustment. As an example, > consider the query below
> explain (costs off) > select * from onek t1 > left join onek t2 on true > left join lateral > (select * from onek t3 where t3.two = t2.two offset 0) s > on t2.unique1 = 1; > ERROR: wrong varnullingrels (b 3) (expected (b)) for Var 2/3 Good catch --- I'll take a closer look tomorrow. regards, tom lane