summaryrefslogtreecommitdiff
path: root/mysql-test/t/win.test
diff options
context:
space:
mode:
authorVarun Gupta <varun.gupta@mariadb.com>2020-07-27 13:53:33 +0530
committerVarun Gupta <varun.gupta@mariadb.com>2020-07-27 13:53:33 +0530
commita6410deba99d5060a8c3fc0d5f267100125dc6ac (patch)
tree33879ee74a22882b4c612a6e31d63cbf185eb4a0 /mysql-test/t/win.test
parent5f1ec5cbb78a427ff260888bef5e19daa36b10e2 (diff)
downloadmariadb-git-a6410deba99d5060a8c3fc0d5f267100125dc6ac.tar.gz
MDEV-18916: crash in Window_spec::print_partition() with decimals
Removed an unnecessary ifndef which was printing the window name for a named window only in the case of debug build. The print() for the window function should behave in the same way on both release and debug builds.
Diffstat (limited to 'mysql-test/t/win.test')
-rw-r--r--mysql-test/t/win.test9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/t/win.test b/mysql-test/t/win.test
index deed7de2d23..b749b235082 100644
--- a/mysql-test/t/win.test
+++ b/mysql-test/t/win.test
@@ -2498,5 +2498,14 @@ SELECT ROW_NUMBER() OVER w2 FROM t1 WINDOW w2 AS (PARTITION BY -1,0,1,2,3,4,5,6)
DROP TABLE t1;
--echo #
+--echo # MDEV-18916: crash in Window_spec::print_partition() with decimals
+--echo #
+
+--error ER_TOO_BIG_SCALE
+SELECT cast((rank() over w1) as decimal (53,56));
+--error ER_WRONG_WINDOW_SPEC_NAME
+SELECT cast((rank() over w1) as decimal (53,30));
+
+--echo #
--echo # End of 10.2 tests
--echo #