wang1xinai opened a new issue, #8898: URL: https://github.com/apache/incubator-doris/issues/8898
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues. ### Version 5.1.0 ### What's Wrong? 问题：针对datetime类型的字段，进行where查询时，where create_time>"0000-00-00 00:00:00"返回结果为空 操作过程: use testdb; CREATE TABLE `test_tbl` ( `create_time` datetime NOT NULL COMMENT "创建时间" ) ENGINE=OLAP DUPLICATE KEY(`create_time`) COMMENT "test" DISTRIBUTED BY HASH(`create_time`) BUCKETS 1; insert into test_tbl values("2022-02-02 00:00:00"); insert into test_tbl values("2022-02-03 00:00:00"); insert into test_tbl values("2022-02-04 00:00:00"); insert into test_tbl values("2022-02-05 00:00:00"); insert into test_tbl values("2022-02-06 00:00:00"); select * from test_2.test_tbl; select * from test_2.test_tbl where create_time>"2022-02-02 00:00:00"; select * from test_2.test_tbl where create_time>"0000-00-00 00:00:00"; ### What You Expected? where create_time>"0000-00-00 00:00:00"返回结果正常 ### 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: [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]
