You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2019/01/24 09:30:03 UTC

[GitHub] zjcnb commented on issue #1783: exception will thrown if sql contains use index(index_name) in mysql

zjcnb commented on issue #1783: exception will thrown if sql contains use index(index_name) in mysql
URL: https://github.com/apache/incubator-shardingsphere/issues/1783#issuecomment-457127872
 
 
   hi, @jmbkeyes 
   
      According to what you said
      
        i have try it with use USE INDEX for mysql , i don't met exception. 
   
        my sharding-jdbc version is : 3.1.0 
        my sql is :  SELECT * FROM lsj_zjc_user USE INDEX (code_index) WHERE code = #{code}(simple sql)
       my mysql index is : code_index_lsj_zjc_user0(code) and code_index_lsj_zjc_user1(code)
       you can Improved your sharding version try it again!
    
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on 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