Jrebel-i opened a new issue, #35267: URL: https://github.com/apache/doris/issues/35267
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version The query result is incorrect because the matched materialized view is queried. Procedure ### What's Wrong? ![image](https://github.com/apache/doris/assets/62320242/d0bb3c4a-1e00-4368-94f8-00900b39806c) ```sql CREATE TABLE IF NOT EXISTS test.test_mv_bug ( id int not null, name varchar(100) not null , age int not null , sex int null, day_num DATE ) ENGINE=OLAP DUPLICATE KEY(id) COMMENT "测试物化视图bug" PARTITION BY RANGE(day_num)() DISTRIBUTED BY HASH(id) PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "dynamic_partition.enable" = "true", "dynamic_partition.time_unit" = "DAY", "dynamic_partition.prefix" = "p", "dynamic_partition.buckets" = "3", "dynamic_partition.create_history_partition" = "true", "dynamic_partition.history_partition_num" = "5", "dynamic_partition.start" = "-4", "dynamic_partition.end" = "1", "storage_format" = "V2" ); -- 创建物化视图 create materialized view test_mv_bug_mv_ss_2 as select day_num,age,sex from test.test_mv_bug GROUP BY day_num,age,sex; insert into `test`.`test_mv_bug` values(1,'zhangsan',1,0,'2024-05-20'),(2,'wangwu',1,0,'2024-05-20'),(3,'zhaoliu',1,0,'2024-05-20'),(4,'tianqi',2,0,'2024-05-20'),(5,'laoba',2,0,'2024-05-20'),(6,'lijiu',2,0,'2024-05-20'); select count(*) from test.test_mv_bug where day_num='2024-05-20'; ``` ### What You Expected? Query result is correct ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- 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-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org