StreamHashJoin distribution enforcement panic

[chenzl25]

Describe the bug

A case was found in the bushy tree join ordering #8316. Thank @KveinAxel found the case which is too complex to reproduce, so I rewrite it into a simple one.

CREATE TABLE part (
        p_partkey INTEGER,
        p_name VARCHAR,
        p_mfgr VARCHAR,
        p_brand VARCHAR,
        p_type VARCHAR,
        p_size INTEGER,
        p_container VARCHAR,
        p_retailprice NUMERIC,
        p_comment VARCHAR,
        PRIMARY KEY (p_partkey)
);

CREATE TABLE partsupp (
        ps_partkey INTEGER,
        ps_suppkey INTEGER,
        ps_availqty INTEGER,
        ps_supplycost NUMERIC,
        ps_comment VARCHAR,
        PRIMARY KEY (ps_partkey, ps_suppkey)
);

explain create materialized view v as 
select partsupp.* from part join partsupp on part.p_comment = partsupp.ps_comment 
join part p1 on p1.p_partkey = part.p_partkey and p1.p_partkey = partsupp.ps_partkey; -- panic!

To Reproduce

No response

Expected behavior

No response

Additional context

No response