Fixed bug mdev-11907.

With the current design the function copy_funcs() should ignore
the items with window functions from the array **func_ptr.

1 files changed, 21 insertions, 0 deletions

diff --git a/mysql-test/t/win.test b/mysql-test/t/win.test
index ec083733f77..3cd17ae179d 100644
--- a/mysql-test/t/win.test
+++ b/mysql-test/t/win.test
@@ -1809,3 +1809,24 @@ select i, row_number() over () from t1 group by 1+2;
 select i, rank() over (order by i) rnk from t1 group by 1+2;
 
 drop table t1;
+
+--echo #
+--echo # MDEV-11907: window function as the second operand of division
+--echo #
+
+create table t1 (pk int, c int);
+insert into t1 values (1,1),(2,1),(3,1),(4,1),(5,2);
+
+set @sql_mode_save= @@sql_mode;
+set sql_mode='ERROR_FOR_DIVISION_BY_ZERO';
+
+select pk, c, c/count(*) over 
+           (partition by c order by pk
+            rows between 1 preceding and 2 following) as CNT
+from t1;
+show warnings;
+
+set sql_mode=@sql_mode_save;
+
+drop table t1;
+