diff options
author | Alexander Barkov <bar@mariadb.org> | 2017-05-21 09:28:12 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.org> | 2017-05-21 09:28:12 +0400 |
commit | 8c479820da2ef10438485864a65ceb3ac750c228 (patch) | |
tree | 4eeff5cd42f456ec0330f9dc8594e5ca03f47a82 /mysql-test/t/func_math.test | |
parent | a8caa8e04a27f7463abd4fd588a4ce1799e600c7 (diff) | |
download | mariadb-git-8c479820da2ef10438485864a65ceb3ac750c228.tar.gz |
MDEV-12856 Wrong .. metadata for DIV + MDEV-12857..errors on CREATE..SELECT..DIV
This is a joint patch for:
MDEV-12856 Wrong result set metadata for DIV
MDEV-12857 Out-of-range errors on CREATE..SELECT 2222222222 DIV 1
Diffstat (limited to 'mysql-test/t/func_math.test')
-rw-r--r-- | mysql-test/t/func_math.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/func_math.test b/mysql-test/t/func_math.test index 03e9923bc52..fd000211145 100644 --- a/mysql-test/t/func_math.test +++ b/mysql-test/t/func_math.test @@ -624,3 +624,19 @@ CREATE OR REPLACE TABLE t1 AS SELECT ROUND(10e0,NULL) AS c3; SHOW CREATE TABLE t1; DROP TABLE t1; + +--echo # +--echo # MDEV-12857 Out-of-range errors on CREATE..SELECT 2222222222 DIV 1 +--echo # + +SET sql_mode=STRICT_ALL_TABLES; +CREATE OR REPLACE TABLE t1 AS SELECT + 2 DIV 1 AS d01, + 222222222 DIV 1 AS d09, + 2222222222 DIV 1 AS d10; +SHOW CREATE TABLE t1; +--vertical_results +SELECT * FROM t1; +--horizontal_results +DROP TABLE t1; +SET sql_mode=DEFAULT; |