[Bug] get query plan failed when where clause contains datetime/date type

[qg-lin]

Search before asking

• I had searched in the issues and found no similar issues.

Version

25.0.1

What's Wrong?

Get query plan failed when where clause contains datetime/date type because of incorrect sql.
origin sql:
col("statisticsDate") >= date_sub(to_date(lit(DateUtils.getYesterday)), 30)

exception:

What You Expected?

generate the correct sql to get query plan when contains datetime/date type.

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

• I agree to follow this project's Code of Conduct