summaryrefslogtreecommitdiff
path: root/mysql-test/main/win.test
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2020-06-05 16:51:26 +0300
committerMarko Mäkelä <marko.makela@mariadb.com>2020-06-05 16:51:26 +0300
commit680463a8d991389f4ea5942e87764137c55c0eb4 (patch)
tree427f8946aa9085c7f6346e1047144995cb7c459e /mysql-test/main/win.test
parent05693cf2149f8792863a32325090e789015286fc (diff)
parentefc70da5fd0459ff44153529d13651741cc32bc4 (diff)
downloadmariadb-git-680463a8d991389f4ea5942e87764137c55c0eb4.tar.gz
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/win.test')
-rw-r--r--mysql-test/main/win.test13
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/main/win.test b/mysql-test/main/win.test
index 2d3032aab37..6a9a93e903b 100644
--- a/mysql-test/main/win.test
+++ b/mysql-test/main/win.test
@@ -2447,6 +2447,19 @@ WINDOW v2 AS ( PARTITION BY a ORDER BY a DESC );
drop table t0;
--echo #
+--echo # MDEV-16230:Server crashes when Analyze format=json is run with a window function with
+--echo # empty PARTITION BY and ORDER BY clauses
+--echo #
+
+CREATE TABLE t1(a INT, b INT);
+INSERT INTO t1 VALUES (1,1),(2,2),(3,3);
+
+--source include/analyze-format.inc
+ANALYZE FORMAT=JSON SELECT row_number() OVER() FROM t1;
+SELECT row_number() OVER() FROM t1;
+DROP TABLE t1;
+
+--echo #
--echo # End of 10.2 tests
--echo #