Slow materialized view creation if it contains a heavy query introduced in version 24.1

[glebinc]

Describe the unexpected behaviour
Version 24.1 introduced a regression which manifests itself as taking a long time to create materialized view with a heavy query probably because of analyzing this query. Possibly related to #57855

How to reproduce

create table source(type String) engine=MergeTree order by type;

create view v_heavy as
with nums as (select number from numbers(1e5))
select count(*) n from (select number from numbers(1e5) n1 cross join nums);

create table target1(type String) engine=MergeTree order by type;
create table target2(type String) engine=MergeTree order by type;

create materialized view vm_target1 to target1 as select * from source where type='one';
-- this statement takes a long time in 24.1
create materialized view vm_target2 to target2 as select * from source where type='two' and (select n from v_heavy)>0;

Expected behavior
Creation of a materialized view should not take the same time as the query it contains.

[antonio2368]

Confirmed it's related to #57855