wangshuo128 commented on issue #13560:
URL: https://github.com/apache/doris/issues/13560#issuecomment-1296846019
> The following query will hit the rollup and cause wrong result
select t1.dt,
t1.key1,
t1.key2,
sum(t1.value1) as value1,
sum(t2.value2) as value2
from test_join_left_table t1
left join test_join_right_table_has_mv t2
on t1.dt = t2.dt
and t1.key1 = t2.key1
group by t1.dt,
t1.key1,
t1.key2
order by t1.dt,
t1.key1,
t1.key2;
Hi, @morningman, I tested the SQL with the latest master code. The query
wouldn't use materialized view index, please see the test code:
https://github.com/wangshuo128/doris/blob/doris-13560/fe/fe-core/src/test/java/org/apache/doris/nereids/rules/mv/MvBugTest.java.
Did I miss anything?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
