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