Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Blocker
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 10.0.4
-
Component/s: None
-
Labels:None
Description
MariaDB [test]> SELECT TIME'10:10:10.1234567';
|
ERROR 1525 (HY000): Incorrect TIME value: '10:10:10.1234567'
|
MariaDB [test]> SELECT TIMESTAMP'2001-01-01 10:10:10.1234567';
|
ERROR 1525 (HY000): Incorrect DATETIME value: '2001-01-01 10:10:10.1234567'
|
The expected result is to return a value with 6 fractional digits without errors.
A "truncated" warning (or a note) is probably not necessary,
because decimal numbers do not produce warnings/notes when precision is too high.
The problem is repeatable even when 0 nanoseconds present:
MariaDB [test]> SELECT TIME'10:10:10.1234560';
|
ERROR 1525 (HY000): Incorrect TIME value: '10:10:10.1234560'
|
This is a bug in MDEV-3838, should be fixed before the release.