matrixone
matrixone copied to clipboard
[Bug]: insert TIMESTAMP max value error;
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
create table t2 (time1 Date,time2 DateTime,time3 TIMESTAMP);
insert into t2 values ('1000-01-01', '0001-01-01 00:00:00.000000', '2038-01-19 03:14:07.999999');
ERROR 1105 (HY000): Data truncation: Incorrect TIMESTAMP value: '2038-01-19 03:14:07.99999' for column 'time3' at row 0
related to: https://docs.matrixorigin.io/cn/0.5.0/MatrixOne/Reference/Data-Types/data-types/#_4
Expected Behavior
mysql> insert into t2 values ('1000-01-01', '0001-01-01 00:00:00.000000', '2038-01-19 03:14:07.999999'); Query OK, 1 row affected (0.01 sec)
Steps to Reproduce
No response
Additional information
No response