Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Not a Bug
-
11.8.3
-
None
-
Not for Release Notes
Description
Run the following cases, where MySQL and MariaDB return different results.
-- mariadb
|
DROP TABLE t1; |
CREATE TABLE t1 (c1 DECIMAL(10,0)); |
INSERT INTO t1 VALUES (-1); |
SELECT CAST(c1 AS UNSIGNED) FROM t1; -- {0} |
 |
-- mysql
|
DROP TABLE t1; |
CREATE TABLE t1 (c1 DECIMAL(10,0)); |
INSERT INTO t1 VALUES (-1); |
SELECT CAST(c1 AS UNSIGNED) FROM t1; -- {18446744073709551615} |