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.
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Description |
{code} 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' {code} The expected result to return a value with 6 fractional digits without errors. |
{code} 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' {code} The expected result to return a value with 6 fractional digits without errors. A "truncated" warning should be fine. |
Priority | Minor [ 4 ] | Blocker [ 1 ] |
Description |
{code} 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' {code} The expected result to return a value with 6 fractional digits without errors. A "truncated" warning should be fine. |
{code} 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' {code} The expected result to return a value with 6 fractional digits without errors. A "truncated" warning should be fine. This is a bug in |
Fix Version/s | 10.0.4 [ 13101 ] |
Description |
{code} 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' {code} The expected result to return a value with 6 fractional digits without errors. A "truncated" warning should be fine. This is a bug in |
{code} 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' {code} The expected result to return a value with 6 fractional digits without errors. A "truncated" warning should be fine. The problem is repeatable even when 0 nanoseconds present: {code} MariaDB [test]> SELECT TIME'10:10:10.1234560'; ERROR 1525 (HY000): Incorrect TIME value: '10:10:10.1234560' {code} This is a bug in |
Description |
{code} 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' {code} The expected result to return a value with 6 fractional digits without errors. A "truncated" warning should be fine. The problem is repeatable even when 0 nanoseconds present: {code} MariaDB [test]> SELECT TIME'10:10:10.1234560'; ERROR 1525 (HY000): Incorrect TIME value: '10:10:10.1234560' {code} This is a bug in |
{code} 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' {code} 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: {code} MariaDB [test]> SELECT TIME'10:10:10.1234560'; ERROR 1525 (HY000): Incorrect TIME value: '10:10:10.1234560' {code} This is a bug in |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Workflow | defaullt [ 28360 ] | MariaDB v2 [ 44410 ] |
Workflow | MariaDB v2 [ 44410 ] | MariaDB v3 [ 63754 ] |
Workflow | MariaDB v3 [ 63754 ] | MariaDB v4 [ 146926 ] |
Fixed in 10.0.4