view delta rewrite failed

[ABingHuang]

Steps to reproduce the behavior (Required)

create materialized view mv_1
refresh manual
PROPERTIES (
"unique_constraints" = "customer.c_custkey;part.p_partkey",
"foreign_key_constraints" = "lineorder(lo_custkey) REFERENCES customer(c_custkey);lineorder(lo_partkey) REFERENCES part(p_partkey)"
)
as
select lo_orderkey, lo_linenumber, lo_custkey, lo_revenue, c_name,p_name
from
lineorder left outer join customer on lo_custkey = c_custkey
left outer join part on lo_partkey = p_partkey;

select lo_orderkey, lo_linenumber, lo_custkey, lo_revenue, p_name from lineorder left outer join part on lo_partkey = p_partkey where p_name='sky deep';

Expected behavior (Required)

query should be rewritten by mv_1

Real behavior (Required)

query is not rewritten by mv_1

StarRocks version (Required)

• You can get the StarRocks version by executing SQL select current_version()