kingshard issues

sqlparser 不支持 binary方法

执行sql ``` REPLACE INTO `a`.`b` ( `id`, `content` ) VALUES ( '000034621b86494c8702995d5e9b0c14', binary '[{\"value\": \"\", \"title\": \"申请内容\"}, {\"value\": \"\", \"title\": \"审批详情\"}]' ); ``` sqlparser解析失败

stong1994

能支持下按range分库分表和按时间分库分表么

比如按天按周按月按年这种分表规则，生产环境经常有这种冷热数据的分表场景

ayamzh

mysql客户端登陆失败 [ClientConn] "readHandshakeResponse" "error"

3

大大麻烦看一下这个问题，谢谢🙏 代码用的最新的 master ## 客户端登陆报错： > 2020/10/26 17:04:27 - ERROR - server.go:[386] - [server] "onConn" "ERROR 1045 (28000): Access denied for user 'kingshard'@'127.0.0.1:53898' (using password: Yes)" "" conn_id=0 2020/10/26 17:04:51...

jinjinzhong

why set autocommit(0) when connection is still in unautocommit status??

1

https://github.com/flike/kingshard/blob/f17b3939474659568b3aa14aa89beeef8da4f24b/proxy/server/conn_query.go#L139 ```go if !c.isAutoCommit() { // not in autocommit ?? // then set it again ?? if err = co.SetAutoCommit(0); err != nil { return } } else { //...

pingworld

support default for insert

https://dev.mysql.com/doc/refman/5.7/en/insert.html

huangnauh

请问下支持insert xxx on duplicate update...语句么

1

请问下支持insert xxx on duplicate update...语句么

ayamzh

SHOW TABLES 命令报解析错误

1

执行预处理时， SHOW TABLES FROM `xxx` WHERE `Tables_in_cdb` = ? 时，报错为： Error 1105: parse sql "show tables from `xxx`" error

yyyiue

使用laravel报错

1

![image](https://user-images.githubusercontent.com/6236245/96951962-47a40380-1520-11eb-83bb-cbc3270b07be.png) ![image](https://user-images.githubusercontent.com/6236245/96952012-5c809700-1520-11eb-9a74-b69372d5505d.png) 求解决

Sentiger