[Bug]: minus (-) operator doesn't support DATE/DATETIME type

[domingozhang]

Is there an existing issue for the same bug?

• [X] I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

select cast('2022-02-01' as date)-cast('2022-01-01' as date); Operator '-' with parameters [DATE DATE] will be implemented in future version.

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

[domingozhang]

minus operator needs to be supported in 0.6.0

[m-schen]

'+' is also

[aressu1985]

mysql> select cast('2022-02-01' as date)-cast('2022-01-01' as date); +-----------------------------------------------------+ | cast(2022-02-01 as date) - cast(2022-01-01 as date) | +-----------------------------------------------------+ | 31 | +-----------------------------------------------------+ 1 row in set (0.00 sec)

mysql>