Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
This script:
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a TIME);
|
INSERT INTO t1 VALUES (0.999e19);
|
SELECT * FROM t1;
|
correctly returns:
+-----------+
|
| a |
|
+-----------+
|
| 838:59:59 |
|
+-----------+
|
This script:
DROP TABLE IF EXISTS t1,t2;
|
CREATE TABLE t1 (a TIME);
|
CREATE TABLE t2 (a DOUBLE);
|
INSERT INTO t2 VALUES (0.999e19);
|
INSERT INTO t1 SELECT a FROM t2;
|
SELECT * FROM t1;
|
also correctly returns:
+-----------+
|
| a |
|
+-----------+
|
| 838:59:59 |
|
+-----------+
|
This script:
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a DOUBLE);
|
INSERT INTO t1 VALUES (0.999e19);
|
ALTER TABLE t1 MODIFY a TIME;
|
SELECT * FROM t1;
|
erroneously returns
+----------+
|
| a |
|
+----------+
|
| 00:00:00 |
|
+----------+
|
The expected result is 838:59:59, like in the previous two scripts.