diff options
| author | Igor Babaev <igor@askmonty.org> | 2017-01-30 11:56:23 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2017-01-31 20:37:25 -0800 |
| commit | 81c1abe8cf3dda1fe097256a06daab3041409e14 (patch) | |
| tree | 7199863b71245597b3e18b9bddd19152eb192725 /mysql-test/t/win.test | |
| parent | 1d96b09890966a45a9c3e4e17f973ecaaefb6a8f (diff) | |
| download | mariadb-git-81c1abe8cf3dda1fe097256a06daab3041409e14.tar.gz | |
Fixed bug mdev-10875.
Now, after the implementation of mdev-8646
"Re-engineer the code for post-join operations"
create_sort_index() can be called for subqueries.
Diffstat (limited to 'mysql-test/t/win.test')
| -rw-r--r-- | mysql-test/t/win.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/win.test b/mysql-test/t/win.test index 7052368cf9c..b9490c82039 100644 --- a/mysql-test/t/win.test +++ b/mysql-test/t/win.test @@ -1426,3 +1426,19 @@ select * from v4; drop view v1,v2,v3,v4; drop table t0,t1; + +--echo # +--echo # MDEV-10875: window function in subquery +--echo # + +CREATE TABLE t1 (i INT); +INSERT INTO t1 VALUES (3),(1); + +CREATE TABLE t2 (c VARCHAR(8)); +INSERT INTO t2 VALUES ('foo'),('bar'),('foo'); + +SELECT COUNT(*) OVER (PARTITION BY c) FROM t2; + +SELECT * FROM t1 WHERE i IN ( SELECT COUNT(*) OVER (PARTITION BY c) FROM t2 ); + +DROP TABLE t1, t2; |