matrixone
matrixone copied to clipboard
matrixorigin
[Bug]: less than date type min value, load data and insert execute success.
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
drop table if exists t4; create table t4( col1 date, col2 datetime, col3 timestamp, col4 bool );
load data infile 'csv' into table t4; should execute failed.
csv data: 0999-01-01,0001-01-01,,0
insert into t4(col1) values ("0999-01-01"); should execute failed
Expected Behavior
No response
Steps to Reproduce
No response
Additional information
No response
now date type range is date[0001-01-01 to 9999-12-31], datetime range is date[0001-01-01 00:00:00 to 9999-12-31 23:59:59]
https://docs.matrixorigin.io/cn/0.5.1/MatrixOne/Reference/Data-Types/data-types/
now date type range is date[0001-01-01 to 9999-12-31]
Where can I look this up？
now date type range is date[0001-01-01 to 9999-12-31]
Where can I look this up？
sorry, you better to look in the mo code or ask me.
As product design, the range of date should be the same as mysql which is between 1000-01-01 and 9999-12-31
As product design, the range of date should be the same as mysql which is between 1000-01-01 and 9999-12-31
@bbbearxyz
pr #6245 all ready add date/datetime range check, if out of range, sys will report err. But in the extern table, only when select data from table, then the table parse data/datetime and report err . this is designed by @jianwan0214. Timestamp now don't do range check, in the code they said because of issue5305.
