Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.2, 10.3, 10.4, 10.5
-
None
Description
KB lists NTILE as the function that could operate on window frames - https://mariadb.com/kb/en/window-frames/
but currently it returns error:
MariaDB [test]> SELECT ntile(1) OVER (ORDER BY score RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM student_test;
|
ERROR 4017 (HY000): Window frame is not allowed with 'ntile'
|