Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
11.8.3
-
Unexpected results
-
Q1/2026 Server Maintenance
Description
An inconsistent result is returned when casting a truncate value into time.
DROP TABLE t1; |
CREATE TABLE t1 (c1 CHAR(20)); |
INSERT INTO t1 VALUES (9430886); |
SELECT (CAST(c1 AS TIME)) FROM t1; -- {NULL} |
DROP TABLE t1; |
CREATE TABLE t1 (c1 MEDIUMINT UNSIGNED); |
INSERT INTO t1 VALUES (9430886); |
SELECT (CAST(c1 AS TIME)) FROM t1; -- actual: {838:59:59}, expected: {null} |
Attachments
Issue Links
- is duplicated by
-
MDEV-38208 Inconsistent behavior for INT and BIGINT when comparing with TIME value
-
- Closed
-