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.
Attachments
Issue Links
Activity
| Component/s | Temporal Types [ 11000 ] |
| Affects Version/s | 10.3 [ 22126 ] | |
| Affects Version/s | 10.4 [ 22408 ] |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.2 [ 14601 ] |
| Component/s | Data types [ 13906 ] |
| Epic Link | MDEV-21071 [ 80504 ] |
| Workflow | MariaDB v3 [ 73334 ] | MariaDB v4 [ 139923 ] |
Hi,
I will be working on this bug, can you update the fix versions?