diff options
Diffstat (limited to 'mysql-test/r/win.result')
-rw-r--r-- | mysql-test/r/win.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/win.result b/mysql-test/r/win.result index e8f74fa2f59..ff5c161b9d5 100644 --- a/mysql-test/r/win.result +++ b/mysql-test/r/win.result @@ -451,6 +451,25 @@ count(*) over (w2 rows between 2 following and current row) as CNT from t1 window w1 as (partition by c), w2 as (w1 order by pk); ERROR HY000: Unacceptable combination of window frame bound specifications +select +pk, c, +row_number() over (partition by c order by pk +range between unbounded preceding and current row) as r +from t1; +ERROR HY000: Window frame is not allowed with 'row_number' +select +pk, c, +rank() over w1 as r +from t1 +window w1 as (partition by c order by pk +rows between 2 preceding and 2 following); +ERROR HY000: Window frame is not allowed with 'rank' +select +pk, c, +dense_rank() over (partition by c order by pk +rows between 1 preceding and 1 following) as r +from t1; +ERROR HY000: Window frame is not allowed with 'dense_rank' drop table t0,t1; # # MDEV-9634: Window function produces incorrect value |