Allow first/last value functions to have frame definitions

Add a test case to check this behavior.

1 files changed, 10 insertions, 1 deletions

diff --git a/sql/item_windowfunc.h b/sql/item_windowfunc.h
index ba5955084e2..cf484e3129d 100644
--- a/sql/item_windowfunc.h
+++ b/sql/item_windowfunc.h
@@ -657,10 +657,19 @@ public:
     case Item_sum::PERCENT_RANK_FUNC:
     case Item_sum::CUME_DIST_FUNC:
     case Item_sum::NTILE_FUNC:
+      return true;
+    default: 
+      return false;
+    }
+  }
+
+  bool requires_special_cursors() const
+  {
+    switch (window_func()->sum_func()) {
     case Item_sum::FIRST_VALUE_FUNC:
     case Item_sum::LAST_VALUE_FUNC:
       return true;
-    default: 
+    default:
       return false;
     }
   }