bug: cannot generate dynamic filter when it should be able to

[lmatz]

create table T (t timestamp, a int[]);
explain create materialized view mv as select unnest(a), t from T where t >= (select MAX(t - interval '1' hour) t from T);
ERROR:  QueryError: Not supported: streaming nested-loop join

create table T (t timestamp, a int);

explain create materialized view mv as select a, t from T where t >= (select MAX(t - interval '1' hour) t from T);
                                                 QUERY PLAN                                                 
------------------------------------------------------------------------------------------------------------
 StreamMaterialize { columns: [a, t, t._row_id(hidden)], pk_columns: [t._row_id], pk_conflict: "no check" }
 └─StreamProject { exprs: [t.a, t.t, t._row_id] }
   └─StreamDynamicFilter { predicate: (t.t >= max(max($expr1))) }
     ├─StreamTableScan { table: t, columns: [t, a, _row_id] }
     └─StreamExchange { dist: Broadcast }
       └─StreamProject { exprs: [max(max($expr1))] }
         └─StreamGlobalSimpleAgg { aggs: [max(max($expr1)), count] }
           └─StreamExchange { dist: Single }
             └─StreamHashAgg { group_key: [$expr2], aggs: [max($expr1), count] }
               └─StreamProject { exprs: [$expr1, t._row_id, Vnode(t._row_id) as $expr2] }
                 └─StreamProject { exprs: [(t.t - '01:00:00':Interval) as $expr1, t._row_id] }
                   └─StreamTableScan { table: t, columns: [t, _row_id] }
(12 rows)


explain create materialized view mv as select a, t from T where t >= (select MAX(t) t from T) - interval '1' hour;
ERROR:  QueryError: Not supported: streaming nested-loop join