Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.6(EOL), 10.11, 11.4, 11.8, 12.2(EOL), 11.8.3
-
Unexpected results
-
Q2/2026 Server Development, Q3/2026 Server Maintenance
Description
Run the following statements, in which 0 should be returned.
CREATE TABLE t1 (c1 VARCHAR(20) UNIQUE); |
INSERT INTO t1 VALUES (-7222412721392380250); |
SELECT (CAST(c1 AS FLOAT) - (MIN(CAST(c1 AS FLOAT)))) FROM t1 GROUP BY c1; -- {2606907088896}, expected: {0} |
Attachments
Issue Links
- relates to
-
MDEV-38188 Incorrect date conversion for varchar column
-
- Confirmed
-