Orca generates subplan for uncorrelated subquery about gporca HOT 2 OPEN

insert into foo values(1), (2);
insert into bar select i from generate_series(1,1000)i;
analyze;

explain select * from foo where a >= (select avg(b) from bar);
                                        QUERY PLAN
------------------------------------------------------------------------------------------
 Nested Loop  (cost=0.00..1324042.42 rows=1 width=8)
   Join Filter: foo.a::numeric >= (pg_catalog.avg((avg(bar.b))))
   ->  Aggregate  (cost=0.00..431.01 rows=1 width=8)
         ->  Gather Motion 3:1  (slice2; segments: 3)  (cost=0.00..431.01 rows=1 width=8)
               ->  Aggregate  (cost=0.00..431.01 rows=1 width=8)
                     ->  Table Scan on bar  (cost=0.00..431.01 rows=334 width=4)
   ->  Materialize  (cost=0.00..431.00 rows=1 width=8)
         ->  Gather Motion 3:1  (slice1; segments: 3)  (cost=0.00..431.00 rows=2 width=8)
               ->  Table Scan on foo  (cost=0.00..431.00 rows=1 width=8)
 Settings:  optimizer=on
 Optimizer status: PQO version 2.54.2
(11 rows)

truncate foo, bar;
set optimizer_segments=40;

explain select * from foo where a >= (select avg(b) from bar);
                                                 QUERY PLAN
------------------------------------------------------------------------------------------------------------
 Gather Motion 3:1  (slice4; segments: 3)  (cost=0.00..1324033.11 rows=1 width=8)
   ->  Nested Loop  (cost=0.00..1324033.11 rows=1 width=8)
         Join Filter: foo.a::numeric >= (pg_catalog.avg((avg(bar.b))))
         ->  Broadcast Motion 3:3  (slice3; segments: 3)  (cost=0.00..431.00 rows=14 width=8)
               ->  Table Scan on foo  (cost=0.00..431.00 rows=1 width=8)
         ->  Materialize  (cost=0.00..431.00 rows=1 width=8)
               ->  Redistribute Motion 1:3  (slice2)  (cost=0.00..431.00 rows=1 width=8)
                     ->  Aggregate  (cost=0.00..431.00 rows=1 width=8)
                           ->  Gather Motion 3:1  (slice1; segments: 3)  (cost=0.00..431.00 rows=1 width=8)
                                 ->  Aggregate  (cost=0.00..431.00 rows=1 width=8)
                                       ->  Table Scan on bar  (cost=0.00..431.00 rows=1 width=4)
 Settings:  optimizer=on; optimizer_segments=40
 Optimizer status: PQO version 2.54.2
(13 rows)