fix(query): fold constant subquery to build filter plan instead of join plan

fix(query): fold constant subquery to build filter plan instead of join plan #32993