diff options
Diffstat (limited to 'mysql-test/main/type_hex_hybrid.result')
| -rw-r--r-- | mysql-test/main/type_hex_hybrid.result | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/mysql-test/main/type_hex_hybrid.result b/mysql-test/main/type_hex_hybrid.result index 91490375e7e..26ff385a709 100644 --- a/mysql-test/main/type_hex_hybrid.result +++ b/mysql-test/main/type_hex_hybrid.result @@ -195,5 +195,42 @@ ROUND(0xFFFFFFFFFFFFFFFF,-10) ROUND(0xFFFFFFFFFFFFFFFF,-11) 18446744070000000000 18446744100000000000 DROP TABLE t1; # +# MDEV-23366 ROUND(18446744073709551615,rand()*0) returns a wrong result +# +SELECT +ROUND(0xFFFFFFFFFFFFFFFF,NULL) AS c1, +ROUND(0xFFFFFFFFFFFFFFFF,rand()*0) AS c2, +ROUND(0xFFFFFFFFFFFFFFFF,-1) AS c3, +ROUND(0xFFFFFFFFFFFFFFFF,-19) AS c4, +ROUND(0xFFFFFFFFFFFFFFFF,rand()*0-19) AS c5; +c1 NULL +c2 18446744073709551615 +c3 18446744073709551620 +c4 20000000000000000000 +c5 20000000000000000000 +CREATE OR REPLACE TABLE t1 AS +SELECT +ROUND(0xFFFFFFFFFFFFFFFF,NULL) AS c1, +ROUND(0xFFFFFFFFFFFFFFFF,rand()*0) AS c2, +ROUND(0xFFFFFFFFFFFFFFFF,-1) AS c3, +ROUND(0xFFFFFFFFFFFFFFFF,-19) AS c4, +ROUND(0xFFFFFFFFFFFFFFFF,rand()*0-19) AS c5; +SELECT * FROM t1; +c1 NULL +c2 18446744073709551615 +c3 18446744073709551620 +c4 20000000000000000000 +c5 20000000000000000000 +SHOW CREATE TABLE t1; +Table t1 +Create Table CREATE TABLE `t1` ( + `c1` bigint(20) unsigned DEFAULT NULL, + `c2` decimal(21,0) unsigned NOT NULL, + `c3` decimal(21,0) unsigned NOT NULL, + `c4` decimal(21,0) unsigned NOT NULL, + `c5` decimal(21,0) unsigned NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +DROP TABLE t1; +# # End of 10.4 tests # |