shardingsphere: Insert failed when inserted sql columns contains “system” (missing prepared paramters)
Which version of ShardingSphere did you use?
4.0.0-RC3
Which project did you use? Sharding-JDBC or Sharding-Proxy?
sharding-jdbc
Expected behavior
Insert successfully when inserted sql columns contains “system”
Actual behavior
sharding parse SQL error: line 2:7 no viable alternative at input ‘(system’
Reason analyze (If you can)
Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
SQL:
insert into template (system, code, name ) values ( ?, ?, ? )
Example codes for reproduce this issue (such as a github link).
About this issue
- Original URL
- State: closed
- Created 5 years ago
- Comments: 16 (16 by maintainers)
@xiyelife In MySQL reserved keywords,
SYSTEMis regarded as reserved keyword. Therefore, you couldn’t useSYSTEMin InsertStatement.