【 使用环境 】 测试环境
【 使用版本 】5.7.25-OceanBase-v4.3.5.3
【问题描述】实时物化视图不支持left join？我看我的版本也是4.3.5,是要升级版本吗，要是这样的话还是和flink有点差异，生产能替换flink嘛
【复现路径】CREATE MATERIALIZED VIEW mv_sales_items_join
PARTITION BY HASH(order_id) PARTITIONS 2
REFRESH FAST ENABLE ON QUERY COMPUTATION AS
SELECT
s.order_id AS order_id,
s.user_id AS customer_id,
s.item_id AS item_id,
s.item_count AS quantity,
s.region AS region,
i.order_id AS i_id,
i.product_id AS i_item_id,
i.price_per_item AS price_per_item,
i.pic_url AS pic_url
FROM sales s
left join items i
ON s.order_id = i.order_id;
执行以下 SQL 失败
CREATE MATERIALIZED VIEW mv_sales_items_join – PARTITION BY HASH(order_id) PARTITIONS 2 REFRESH FAST ENABLE ON QUERY COMPUTATION AS SELECT s.order_id AS order_id, s.user_id AS customer_id, s.item_id AS item_id, s.item_count AS quantity, s.region AS region, i.order_id AS i_id, i.product_id AS i_item_id, i.price_per_item AS price_per_item, i.pic_url AS pic_url FROM sales s left join items i ON s.order_id = i.order_id
失败原因：
ErrorCode = 9783, SQLState = HY000, Details = cannot ENABLE ON QUERY COMPUTATION for the materialized view mv_sales_items_join: on query computation is not supported for materialized view with OUTER JOIN