Thanks for the PR! Could you perhaps add the test from the issue, and verify locally that this actually fixes the issue?

Thanks for the PR! Could you perhaps add the test from the issue, and verify locally that this actually fixes the issue?

I have a simpler example than the issue. Let me add it.

Could you add the test from the issue as well to verify that it is fixed?

Could you add the test from the issue as well to verify that it is fixed?

#4258 Make the test results of the issue 4252 inconsistent

I modified the original query in the test code.
WHERE CAST(day AS DATE) >= '2022-01-01 00:00:00' --> WHERE day >= CAST('2022-01-01 00:00:00' AS DATE).
Because if issue 4258 is fixed, the original query will not get the expected result.

Thanks for the updates! Looks good to me.