diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2016-04-16 20:41:06 +0300 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2016-04-16 20:41:06 +0300 |
| commit | 957809b19098b677bc0512dd8fbc55c9bdb2a6bb (patch) | |
| tree | cd34b41d2908d3a36d6572ecee210b47cf0d957f /mysql-test/t/win.test | |
| parent | a81e711a06f60555ec80221385ed4e87ebb7e97f (diff) | |
| download | mariadb-git-bb-10.2-mdev9543.tar.gz | |
MDEV-9922: Assertion `!join->only_const_tables() && fsort' failedbb-10.2-mdev9543
When join output is just one row, we still need to compute window
function values for it. We could skip invoking filesort for it,
but it doesn't seem to be worth it to do such optimization.
Diffstat (limited to 'mysql-test/t/win.test')
| -rw-r--r-- | mysql-test/t/win.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/win.test b/mysql-test/t/win.test index df93ec41c2f..09ddf41b4f0 100644 --- a/mysql-test/t/win.test +++ b/mysql-test/t/win.test @@ -4,6 +4,7 @@ --disable_warnings drop table if exists t1,t2; +drop view if exists v1; --enable_warnings --echo # ######################################################################## @@ -1193,3 +1194,10 @@ insert into t1 values (1),(2); select i, sum(i) over (partition by i) from t1; drop table t1; +--echo # +--echo # MDEV-9922: Assertion `!join->only_const_tables() && fsort' failed in int create_sort_index +--echo # +create view v1 as select 1 as i; +select rank() over (order by i) from v1; +drop view v1; + |