1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/win.result b/mysql-test/r/win.result
index ca13c32e1f4..eb41f4faea5 100644
--- a/mysql-test/r/win.result
+++ b/mysql-test/r/win.result
@@ -1694,3 +1694,24 @@ EXPLAIN
   }
 }
 drop table t1;
+#
+# MDEV-9847: Window functions: crash with big_tables=1
+#
+create table t1(a int);
+insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+set @tmp=@@big_tables;
+set big_tables=1;
+select rank() over (order by a) from t1;
+rank() over (order by a)
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+set big_tables=@tmp;
+drop table t1;