diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2021-03-08 10:16:20 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-03-08 10:16:20 +0200 |
| commit | a5d3c1c819b0c4ba93943f11f592d4379afcdc81 (patch) | |
| tree | a8e7aa820874fea794f9f9cdb7a09f37021923a5 /mysql-test/main/win.test | |
| parent | f6cb9e6e2dd0fb2e29a09030e74de7946139e1f4 (diff) | |
| parent | a26e7a37266d8296094dabca52f0f6646fd73926 (diff) | |
| download | mariadb-git-a5d3c1c819b0c4ba93943f11f592d4379afcdc81.tar.gz | |
Merge 10.4 into 10.5
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 d8065e15fee..0bdfe48a82b 100644 --- a/mysql-test/main/win.test +++ b/mysql-test/main/win.test @@ -2522,6 +2522,26 @@ DROP VIEW v1; DROP TABLE t1,t2; --echo # +--echo # MDEV-25032 Window functions without column references get removed from ORDER BY +--echo # + +create table t1 (id int, score double); +insert into t1 values +(1, 5), +(1, 6), +(1, 6), +(1, 6), +(1, 7), +(1, 8.1), +(1, 9), +(1, 10); +select id, row_number() over () rn +from t1 +order by rn desc; + +drop table t1; + +--echo # --echo # End of 10.2 tests --echo # |