diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2020-05-26 11:54:55 +0300 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2020-05-26 11:54:55 +0300 |
commit | ca38b6e42791a6edbd3cc0b626a8d06b7776e76b (patch) | |
tree | f0b9f34521554ce94ef9a5bd6c7e5f595459240f /mysql-test/main/win.test | |
parent | ea7830eef48333e28f98a9b91f05a95735b465a3 (diff) | |
parent | 7476e8c7cdd73d60294126a2840baee97e7644b6 (diff) | |
download | mariadb-git-ca38b6e42791a6edbd3cc0b626a8d06b7776e76b.tar.gz |
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/main/win.test')
-rw-r--r-- | mysql-test/main/win.test | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/main/win.test b/mysql-test/main/win.test index 32de28511c1..2abfc6ce657 100644 --- a/mysql-test/main/win.test +++ b/mysql-test/main/win.test @@ -2427,6 +2427,26 @@ SELECT MAX(1) OVER (), COUNT(a), abs(a) FROM t1 WHERE FALSE; drop table t1; --echo # +--echo # MDEV-22461: JOIN::make_aggr_tables_info(): Assertion `select_options & (1ULL << 17)' failed. +--echo # + +CREATE TEMPORARY TABLE t0 (a INT PRIMARY KEY ) ; +INSERT INTO t0 VALUES (1),(2),(3); + +SELECT a FROM t0 +WHERE a < 8 +GROUP BY 1.5 +WINDOW v2 AS ( PARTITION BY a ORDER BY a DESC ); + +SELECT a, ROW_NUMBER() OVER v2 +FROM t0 +WHERE a < 8 +GROUP BY 1.5 +WINDOW v2 AS ( PARTITION BY a ORDER BY a DESC ); + +drop table t0; + +--echo # --echo # End of 10.2 tests --echo # |