MySQL function not implemented: TIMESTAMPADD

[dengn]

Function Information

Function Name: TIMESTAMPADD
Category: date

MySQL Function Description

MySQL TIMESTAMPADD function:
TIMESTAMPADD(unit, interval, datetime_expr) - Adds the integer expression interval to the date or datetime expression datetime_expr.

Expected Behavior

Expected behavior:
According to MySQL documentation, the function should return correct results.

Current Behavior in MatrixOne

This function is not implemented in MatrixOne.

Error Message: (20301, 'invalid input: column DAY does not exist')

Test Case

SELECT TIMESTAMPADD(DAY, 5, '2024-12-20') AS result1

MySQL Documentation

• MySQL Official Documentation

Request

Please implement the TIMESTAMPADD function to improve MySQL compatibility.

[fengttt]

I think timestampadd is OK. It is Add/Sub time that has range/precision bugs.

[matrix-meow]

Hello @dengn. The bug issue in the BVT test code has not been removed,issues automatically open.

[XuPeng-SH]

MO:

SELECT TIMESTAMPADD(DAY, 5, '2024-12-20') AS result1;
ERROR 20301 (HY000): invalid input: column DAY does not exist

MySQL:

SELECT TIMESTAMPADD(DAY, 5, '2024-12-20') AS result1;
+------------+
| result1    |
+------------+
| 2024-12-25 |
+------------+