Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
None
-
None
-
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.