Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6, 10.11, 11.4, 11.8, 12.1, 11.8.3
-
None
Description
Run the following statements, in which 1 should be returned.
CREATE TABLE t1 (c1 DECIMAL(10,0)) ENGINE = InnoDB; |
INSERT INTO t1 VALUES (-999999); |
SELECT CAST(c1 AS DECIMAL(10,2)) MOD c1 = 0 FROM t1; -- actual: {0}, expected: {1} |