Details
-
New Feature
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.0.2
-
None
-
1.0.3
Description
This isn't a dealbreaker, by any means – but I'm curious why ColumnStore restricts the range by 400 years?
ColumnStore supports:
A date and time combination. Supported range is 1400-01-01 00:00:00 to 9999-12-31 23:59:59.
That differs from MySQL 5.5+ which supports
The DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'.
ColumnStore reports (when attempting a value out of range):
ERROR 1815 (HY000) at line 306: Internal error: The default value is out of range for the specified data type.
|