From d89d12e3b723ba7a5113b3cdffd1d4a48127ff0a Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Wed, 26 Dec 2018 12:10:50 +0400 Subject: MDEV-17759 Assertion `precision > 0' failed in decimal_bin_size upon CREATE TABLE .. SELECT --- mysql-test/main/func_hybrid_type.test | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'mysql-test/main/func_hybrid_type.test') 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 @@ -611,6 +611,22 @@ CREATE TABLE t1 AS SELECT 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 # -- cgit v1.2.1