[GitHub] [doris] wangshuo128 commented on issue #13560: [Bug] wrong materialized view select cause query result incorrect.

[GitBox <gi...@apache.org>]

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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org