McClone opened a new issue, #35190: URL: https://github.com/apache/doris/issues/35190
### 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 2.0.8 ### What's Wrong? ELECT count(*) as cc FROM ( SELECT DISTINCT ac FROM xdr_source_log_login WHERE retm > '2024-05-01' and flag = 1 and sess <> 'logout' and scity <> '' and ac <> '' and sip in ( SELECT DISTINCT wall_ip FROM xdr_wall WHERE wall_reason LIKE '%被多IP登录失败且一天内这些IP没有登录成功%' and wall_time > '2024-05-14' and wall_time < '2024-05-21' ) ) T ### 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: 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
