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