CoderXionghs opened a new issue, #24009: URL: https://github.com/apache/doris/issues/24009
### 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 doris 2.0.0-rc04 ### What's Wrong? Unique模型多次查询结果不一致。我创建了一张doris unique 表，如下所示 create table test（ code int not null， type int not null， id varchar (32) not null ） unique key (code,type,I'd) …… 1: 我执行select count (*) 统计，同一条sql 语句执行多次，结果总是跳来跳去。(doris 中间发生节点掉线，掉线后就遇到这个不一致情况） 2： 我重新创建了一张与test 表结构一样的test_copy表，然后select into 把test表数据导入到这张表，从test_copy表每次select count结果又是稳定的。 3：我参照网上资料，设置变量use_fix_replica=1，再从test表统计，结果是稳定的了。 我的疑问❓ 是什么原因导致unique模型不准确？设置use_fix_replica=1后，结果是准确的，为什么不让它默认生效呢？ 是不是use_fix_replica会带来其他负面影响，又是什么影响呢？ ### What You Expected? 什么原因呢？ ### 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: [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]
