Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0.3, 5.5.32, 5.3.12
-
None
-
Not for Release Notes
Description
MariaDB [test]> DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a TIME); INSERT INTO t1 VALUES (100000000000000000); SHOW WARNINGS; SELECT * FROM t1;
|
Query OK, 0 rows affected (0.00 sec)
|
|
|
Query OK, 0 rows affected (0.07 sec)
|
|
|
Query OK, 1 row affected, 1 warning (0.00 sec)
|
|
|
+---------+------+----------------------------------------+
|
| Level | Code | Message |
|
+---------+------+----------------------------------------+
|
| Warning | 1265 | Data truncated for column 'a' at row 1 |
|
+---------+------+----------------------------------------+
|
1 row in set (0.00 sec)
|
|
|
+----------+
|
| a |
|
+----------+
|
| 00:00:00 |
|
+----------+
|
1 row in set (0.00 sec)
|
The expected result is 'maximum possible value', which is '838:59:59'.
MySQL 5.5 and 5.6 correctly insert the maximum possible value.