JOKERWING opened a new issue, #29826: URL: https://github.com/apache/doris/issues/29826
### 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 version doris-2.0.1 ### What's Wrong? 今天遇到一个很奇怪的问题。 有一个表，表里有一个字段名称为‘date’，数据类型为date。存储的数据为每年每月的1号，例如：2022-11-01、2023-01-01、2023-05-01.... 然后我运行了一个sql语句： `SELECT distinct date FROM test_date WHERE date = '2024-00-01' ` 执行这个sql本，不应该有结果的。但是，我确得到如下内容：  查询到了 2023-07-01到2023-12-01 这些日期。 很奇怪，能帮忙解答下这个问题吗？ ### What You Expected? 我不确定这是不是bug，但我想搞清楚这是为什么。 ### How to Reproduce? _No response_ ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] 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
