diff options
author | Alexander Barkov <bar@mariadb.com> | 2018-12-26 12:10:50 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2018-12-26 12:10:50 +0400 |
commit | d89d12e3b723ba7a5113b3cdffd1d4a48127ff0a (patch) | |
tree | 307f208284919808f4d2784b8d41d7b7beee2024 /mysql-test/main/func_hybrid_type.test | |
parent | 812bb1303c4a012edb8de9f6ad4c1d97d29533f6 (diff) | |
download | mariadb-git-d89d12e3b723ba7a5113b3cdffd1d4a48127ff0a.tar.gz |
MDEV-17759 Assertion `precision > 0' failed in decimal_bin_size upon CREATE TABLE .. SELECT
Diffstat (limited to 'mysql-test/main/func_hybrid_type.test')
-rw-r--r-- | mysql-test/main/func_hybrid_type.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/main/func_hybrid_type.test b/mysql-test/main/func_hybrid_type.test index 954c7de53fa..f754d660140 100644 --- a/mysql-test/main/func_hybrid_type.test +++ b/mysql-test/main/func_hybrid_type.test @@ -612,6 +612,22 @@ SHOW CREATE TABLE t1; DROP TABLE t1; --echo # +--echo # MDEV-17759 Assertion `precision > 0' failed in decimal_bin_size upon CREATE TABLE .. SELECT +--echo # + +SET sql_mode=''; +CREATE TABLE t1 (d DECIMAL(43,0) UNSIGNED); +INSERT INTO t1 VALUES (1); +CREATE TABLE t2 AS SELECT + IFNULL(SLEEP(0.01), NULL DIV d) AS f0, + IFNULL(SLEEP(0.01), '' DIV d) AS f1 +FROM t1; +SHOW CREATE TABLE t2; +DROP TABLE t1, t2; +SET sql_mode=DEFAULT; + + +--echo # --echo # End of 10.3 tests --echo # |