You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/04/19 15:02:17 UTC
[GitHub] [shardingsphere] udrnrso opened a new issue, #16934: force index PRIMARY cause SQL syntax
udrnrso opened a new issue, #16934:
URL: https://github.com/apache/shardingsphere/issues/16934
## Bug Report
### Which version of ShardingSphere did you use?
5.1.0
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Expected behavior
update sql with force index as following should be ok
update t_test_table force index (PRIMARY)
set test_column='value'
### Actual behavior
throw SQL syntax error
### Reason analyze (If you can)
org.apache.shardingsphere.sql.parser.autogen.MySQLStatementParser.identifier
_input.LA(1) get PRIMARY 521
but PRIMARY is treat as exception
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
update t_test_table force index (PRIMARY)
set test_column='value'
### Example codes for reproduce this issue (such as a github link).
--
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #16934: force index PRIMARY cause SQL syntax
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #16934:
URL: https://github.com/apache/shardingsphere/issues/16934#issuecomment-1103610989
@udrnrso Thank you for your feedback, I will investigate this issue.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] tuichenchuxin closed issue #16934: force index PRIMARY cause SQL syntax
Posted by GitBox <gi...@apache.org>.
tuichenchuxin closed issue #16934: force index PRIMARY cause SQL syntax
URL: https://github.com/apache/shardingsphere/issues/16934
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org