[GitHub] [incubator-shardingsphere] jingshouyan commented on issue #2473: Insert statement rewrite missing symbol ` on column

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

jingshouyan commented on issue #2473: Insert statement rewrite missing symbol ` on column
URL: https://github.com/apache/incubator-shardingsphere/issues/2473#issuecomment-497252844
 
 
   DEMO_USER has a column named "key" which is the keyword of mysql.
   It cause an exception without symbol \`
   ```
   org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [INSERT INTO `DEMO_USER` (`id`,`name`,`age`,`tags`,`NICK_NAME_TT4`,`ENCRYPT_TEST`,`key`,`acc1`,`acc2`,`localDate`,`createdAt`,`updatedAt`,`deletedAt`)  VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)]; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key, acc1, acc2, localDate, createdAt, updatedAt, deletedAt) VALUES ('U57345@abc' at line 1
   
   ```

----------------------------------------------------------------
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