diff options
author | Alexander Barkov <bar@mariadb.com> | 2020-07-24 17:03:15 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2020-07-27 08:03:23 +0400 |
commit | 29851b677ebbd954278d5530bde8e77fb865988f (patch) | |
tree | 1326b7551f77ec4cadf78839bbded9b1279caa4b /mysql-test/t/type_float.test | |
parent | 8460db12b5adb7337935d9a8a895eb72203343fc (diff) | |
download | mariadb-git-29851b677ebbd954278d5530bde8e77fb865988f.tar.gz |
MDEV-23282 FLOAT(53,0) badly handles out-of-range values
truncate_double() did not take into account the max_value
limit in case when dec<NOT_FIXED_DEC.
Diffstat (limited to 'mysql-test/t/type_float.test')
-rw-r--r-- | mysql-test/t/type_float.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/type_float.test b/mysql-test/t/type_float.test index 228812c2ae5..a8ec1ca01d9 100644 --- a/mysql-test/t/type_float.test +++ b/mysql-test/t/type_float.test @@ -486,5 +486,19 @@ DROP TABLE t1; --echo # +--echo # MDEV-23282 FLOAT(53,0) badly handles out-of-range values +--echo # + +CREATE OR REPLACE TABLE t1 (c1 FLOAT NOT NULL, c2 FLOAT NOT NULL); +INSERT IGNORE INTO t1 VALUES (1e+40, -1e+40); +SELECT c1, c2 FROM t1; +DROP TABLE t1; + +CREATE OR REPLACE TABLE t1 (c1 FLOAT(53,0) NOT NULL, c2 FLOAT(53,0) NOT NULL); +INSERT IGNORE INTO t1 VALUES (1e+40, -1e+40); +SELECT c1, c2 FROM t1; +DROP TABLE t1; + +--echo # --echo # End of 10.1 tests --echo # |