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)

Most upvoted comments

@xiyelife In MySQL reserved keywords, SYSTEM is regarded as reserved keyword. Therefore, you couldn’t use SYSTEM in InsertStatement.