diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2022-02-25 10:43:38 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2022-02-25 10:43:38 +0200 |
| commit | 00b70bbb51b9f2a3646c1ceedc6a27eeb1bdd6ac (patch) | |
| tree | 69d6515f2f36a7774e4b8b06c2173dffa0ec6e6d /mysql-test/main/win.test | |
| parent | 7ab3db142bffa733587f6788c13b7d057a1bc13e (diff) | |
| parent | a3da3c8a0b1113d941f837cce0615673b95fb9f2 (diff) | |
| download | mariadb-git-00b70bbb51b9f2a3646c1ceedc6a27eeb1bdd6ac.tar.gz | |
Merge 10.2 into 10.3
Diffstat (limited to 'mysql-test/main/win.test')
| -rw-r--r-- | mysql-test/main/win.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/main/win.test b/mysql-test/main/win.test index a71a9c31085..01b09f255ab 100644 --- a/mysql-test/main/win.test +++ b/mysql-test/main/win.test @@ -2731,6 +2731,16 @@ SELECT i, LAST_VALUE(COUNT(i)) OVER (PARTITION BY i ORDER BY j) FROM t1 GROUP BY DROP TABLE t1; --echo # +--echo # MDEV-15208: server crashed, when using ORDER BY with window function and UNION +--echo # + +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (1),(1),(1),(1),(1),(2),(2),(2),(2),(2),(2); +--error ER_AGGREGATE_ORDER_FOR_UNION +SELECT 1 UNION SELECT a FROM t1 ORDER BY (row_number() over ()); +DROP TABLE t1; + +--echo # --echo # End of 10.2 tests --echo # |