Closed
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
- What did you do?
If possible, provide a recipe for reproducing the error.
SELECT ROW_NUMBER() OVER() from table60_int_autoinc group by 1 ;
- What did you expect to see?
mysql> SELECT ROW_NUMBER() OVER() from table60_int_autoinc group by 1 ;
ERROR 1056 (42000): Can't group on 'ROW_NUMBER() OVER()'
- What did you see instead?
mysql> SELECT ROW_NUMBER() OVER() from table60_int_autoinc group by 1 ;
ERROR 3593 (HY000): You cannot use the window function 'ROW_NUMBER' in this context.'
- What version of TiDB are you using (
tidb-server -V
or runselect tidb_version();
on TiDB)?