Prohibit using window functions of some types with

window frames in full accordance with the SQL standard.

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