Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
None
Description
create table t1 (i int); |
select rank() over (order by 1) from t1; |
ERROR 4007 (HY000): Window function is not allowed in window specification |
The error is very confusing.
Attachments
Issue Links
- relates to
-
MDEV-9896 Testing for window functions
-
- Open
-
If we change the integer in order by for 2 we have another bogus error:
MariaDB [test]> select rank() over (order by 2) from t1;
ERROR 1054 (42S22): Unknown column '2' in 'order clause'