Bug #110559 Syntax error when we use rank as alias

• Submitted: 30 Mar 2023 6:22
• Modified: 30 Mar 2023 6:44
• Reporter: Sunny Bhadana
• Status: Closed
• Category: MySQL Server: Errors
• Severity: S3 (Non-critical)
• Version: 8.0.28
• OS: Any
• CPU Architecture: Any

[30 Mar 2023 6:22] Sunny Bhadana

Description:
MySQL select query return an error about syntax error even there is no syntax error in query, this happened when we use rank as alias in select query

How to repeat:
Simple working query : 
select id from table

when we add alias as rank then syntax error appear like 
select id as rank from table

even there is no syntax error but still it shows error

[30 Mar 2023 6:44] Sunny Bhadana

Not a bug, read documentation later