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/r/win.result | |
| 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/r/win.result')
| -rw-r--r-- | mysql-test/r/win.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/win.result b/mysql-test/r/win.result index c8c55b91016..1c46f43a22c 100644 --- a/mysql-test/r/win.result +++ b/mysql-test/r/win.result @@ -2382,3 +2382,19 @@ pk c CNT 10 2 0.5000 drop view v1,v2,v3,v4; drop table t0,t1; +# +# MDEV-10875: window function in subquery +# +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; +COUNT(*) OVER (PARTITION BY c) +2 +1 +2 +SELECT * FROM t1 WHERE i IN ( SELECT COUNT(*) OVER (PARTITION BY c) FROM t2 ); +i +1 +DROP TABLE t1, t2; |