huyuanfeng2018 opened a new issue, #2325: URL: https://github.com/apache/incubator-paimon/issues/2325
### Search before asking - [X] I searched in the [issues](https://github.com/apache/incubator-paimon/issues) and found nothing similar. ### Paimon version paimon 0.5 ### Compute Engine spark 3.3 ### Minimal reproduce step 1. cdc accesses a table in which the primary key is two fields, one is of int type and the other is of datatime type. 2. Use two different statements in spark `select count(*) from *** where collect_time < '2023-11-14 00:00:00' and collect_time >= '2023-11-13 00:00:00';` result : 1151980 `select count(*) from *** where date(collect_time) ='2023-11-13';` result: 1270271 ### What doesn't meet your expectations? I think the results should be the same twice. I also ran these two statements in trino and the results were the same. ### Anything else? _No response_ ### Are you willing to submit a PR? - [ ] I'm willing to submit a PR! -- 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]
