leosocy issues

Repositories
Issues
Comments

Results 2 issues of


                                            leosocy

为什么不支持`USE INDEX`语法

表结构为 ![image](https://user-images.githubusercontent.com/19223292/70241198-9da57680-17a9-11ea-8013-33fa5cc1e28f.png) 执行语句`select * from test_shard_hash use index (idx_name);` sql日志为 ```txt 2019/12/05 21:52:17 - OK - 0.9ms - 127.0.0.1:64083->127.0.0.1:3306:show create table test_shard_hash_0000 2019/12/05 21:53:17 - OK - 1.1ms - 127.0.0.1:64083->127.0.0.1:3306:select...

fix: adapt for a mysql's Server Status bug

MySQL Server存在一个SERVER_STATUS的[bug](https://bugs.mysql.com/bug.php?id=66884)。如果根据Response的响应，`SERVER_STATUS_AUTOCOMMIT`这一位永远为1，kingshard也就不会去[设置conn](https://github.com/flike/kingshard/blob/master/backend/backend_conn.go#L116)的autocommit。