Skip to content

Different error message from MySQL when select a window function with group by #11518

Closed
@SunRunAway

Description

@SunRunAway

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do?
    If possible, provide a recipe for reproducing the error.
SELECT ROW_NUMBER() OVER() from table60_int_autoinc group by 1 ;
  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()'
  1. 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.'
  1. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?

Metadata

Metadata

Assignees

No one assigned

    Labels

    help wantedDenotes an issue that needs help from a contributor. Must meet "help wanted" guidelines.sig/plannerSIG: Plannertype/bugThe issue is confirmed as a bug.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions