On Mon, 16 Jan 2023 at 22:27, Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> I happened to notice we have the case in memoize.sql that tests for
> memoize node with LATERAL joins, which is
>
> -- Try with LATERAL joins
> SELECT explain_memoize('
> SELECT COUNT(*),AVG(t2.unique1) FROM tenk1 t1,
> LATERAL (SELECT t2.unique1 FROM tenk1 t2 WHERE t1.twenty = t2.unique1) t2
> WHERE t1.unique1 < 1000;', false);
>
> ISTM this is not the right query for the test.
> Attach a trivial patch for the change.
Good catch. I've applied this back to v14.
David