diff options
author | Alexander Barkov <bar@mariadb.com> | 2020-05-14 12:33:22 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2020-05-14 12:33:22 +0400 |
commit | f7cf60991d7d4f78ee91004d522f9417cca0f7b9 (patch) | |
tree | 59834687f718361a45c2736be3783191e31fb3dc /mysql-test/main/func_math.test | |
parent | ef65c39ab36f8f2747daf8088dbaae5c4ca59194 (diff) | |
parent | 4dc690dc28d69abcc2be683819d8ab0798df0c9e (diff) | |
download | mariadb-git-f7cf60991d7d4f78ee91004d522f9417cca0f7b9.tar.gz |
Merge remote-tracking branch 'origin/10.2' into 10.3
Diffstat (limited to 'mysql-test/main/func_math.test')
-rw-r--r-- | mysql-test/main/func_math.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/main/func_math.test b/mysql-test/main/func_math.test index bd98252d964..7bd0b0e5a4f 100644 --- a/mysql-test/main/func_math.test +++ b/mysql-test/main/func_math.test @@ -715,6 +715,18 @@ SELECT 9223372036854775808 MOD -9223372036854775808; SELECT -9223372036854775808 MOD 9223372036854775808; SELECT -9223372036854775808 MOD -9223372036854775808; +--echo # +--echo # MDEV-22502 MDB crashes in CREATE TABLE AS SELECT when the precision of returning type = 0 +--echo # + +CREATE TABLE t1 (d decimal(5,5)); +INSERT INTO t1 VALUES (0.55555); +SELECT TRUNCATE(d,0) FROM t1; +CREATE TABLE t2 AS SELECT TRUNCATE(d,0) FROM t1; +SELECT * FROM t2; +SHOW CREATE TABLE t2; +DROP TABLE t1, t2; + --echo # --echo # MDEV-22503 MDB limits DECIMAL column precision to 16 doing CTAS with floor/ceil over DECIMAL(X,Y) where X > 16 |