[GitHub] [incubator-shardingsphere] SteNicholas commented on issue #3842: Insert failed when inserted sql columns contains “system” (missing prepared paramters)

[GitBox <gi...@apache.org>]

SteNicholas commented on issue #3842: Insert failed when inserted sql columns contains “system” (missing prepared paramters)
URL: https://github.com/apache/incubator-shardingsphere/issues/3842#issuecomment-570033914
 
 
   > @SteNicholas
   > 
   > > @xiyelife In [MySQL reserved keywords](https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-S), `SYSTEM` is regarded as reserved keyword. Therefore, you couldn't use `SYSTEM` in InsertStatement.
   > 
   > Reserverd keywords can be used in the sql's columns for mysql, such as id/name and so on.
   
   `MySQLKeyword.g4` includes `SYSTEM` keyword, but `unreservedWord_` doesn't include `SYSTEM`. Do you see the  [MySQL reserved keywords](https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-8-0-detailed-S)? In MySQL 8.0, `SYSTEM` is reserved keyword. Therefore, the `SYSTEM` doesn't put into `unreservedWord_`. I have already questioned @terrymanu yesterday for this keyword. Out decision is that `SYSTEM` isn't put into `unreservedWord_`. Thanks.

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services