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.result | |
| 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.result')
| -rw-r--r-- | mysql-test/main/win.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/main/win.result b/mysql-test/main/win.result index a7b215b5052..f1628f43e8c 100644 --- a/mysql-test/main/win.result +++ b/mysql-test/main/win.result @@ -3724,6 +3724,25 @@ MAX(1) OVER () COUNT(a) abs(a) 1 0 NULL drop table t1; # +# MDEV-22461: JOIN::make_aggr_tables_info(): Assertion `select_options & (1ULL << 17)' failed. +# +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 ); +a +1 +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 ); +a ROW_NUMBER() OVER v2 +1 1 +drop table t0; +# # End of 10.2 tests # # |