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


Reply via email to