Hello Robert,
I and SQLsmith have discovered one more anomaly (reproduced starting from
e0e4c132e):
load 'test_plan_advice';
select object_type from
(select object_type from information_schema.element_types limit 1),
lateral
(select sum(1) over (partition by a) from generate_series(1, 2) g(a) where false);
triggers an internal error:
ERROR: XX000: no rtoffset for plan unnamed_subquery
LOCATION: pgpa_plan_walker, pgpa_walker.c:110
Could you please have a look?
Best regards,
Alexander
