Richard Guo <guofenglinux@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
