ruanyg opened a new issue, #19478:
URL: https://github.com/apache/shardingsphere/issues/19478

   ### Which version of ShardingSphere did you use?
   5.0.0
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   ShardingSphere-Proxy
   
   ### Behavior
   these keywords shown below can't be used as column name within a mysql 
select sql
   ```
   GROUPS
   RANK
   CUBE
   NTH_VALUE
   SYSTEM
   MYSQL_MAIN
   ROW_NUMBER
   OVER
   PERCENT_RANK
   BIT_XOR
   LAG
   UTC_DATE
   UTC_TIME
   ROW
   GROUPING
   OF
   ROWS
   EMPTY
   FIRST_VALUE
   FUNCTION
   DENSE_RANK
   CUME_DIST
   WINDOW
   JSON_TABLE
   LEAD
   RECURSIVE
   NTILE
   LATERAL
   EXCEPT
   UTC_TIMESTAMP
   ```
   
   ### Reason analyze (If you can)
   in grammatical level they aren't regarded as _identifier_
   
   ### Steps to reproduce the behavior, such as: SQL to execute, sharding rule 
configuration, when exception occur etc.
   Just execute a select sql having one or more keywords described before as 
column name, for example
   `select rank from student;`
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: 
[email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to