matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: insert TIMESTAMP max value error;

Open tianyahui-python opened this issue 3 years ago • 0 comments

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

tianyahui-python avatar Aug 15 '22 06:08 tianyahui-python