Comments (1)
Your description is very clear. This is not a bug.
The value of the shard key must in the first location of values in kingshard. In your case, kingshard forward SQLs using id. If you want shard SQLs using k. You need write SQL like this 'insert into sbtest1(k,id,c,pad) values (4,40,'k was 4 at insert','ks');'
from kingshard.
Related Issues (20)
- kingshard支持2张以上的表关联吗?
- this maybe append nil db to n.Slave[]
- error
- 单独的select * from table_xxx for update 语句应该配置一个选项来决定是否走主库查询
- 求一个完整的Dockerfile HOT 1
- 请问各位 分库分表情况下 这种SQL语句能执行吗
- 还维护吗?好久没更新了 HOT 2
- 读区mysql package递归替换迭代是否更优
- 请问节点和子表的对应关系可以配置吗
- hash方式分表分库分表时,如果key 是一个int64的值,只会达到第一个节点的第一个表上,请问这个该怎么修改 HOT 1
- 云服务器ping时出错 HOT 2
- timeout设置问题.
- 4年不更新了 HOT 1
- 这个好像好久不更新了 HOT 2
- When does kingshard support mysql8.0? My company now uses mysql8.0. HOT 1
- kingshard QQ群还活跃吗? HOT 1
- 谁能把这项目救活?
- 在用kingshard的活跃用户在这里登记一下吧,咱们一起交流交流 HOT 2
- SQLSTATE[HY000]: General error: 1105 command *sqlparser.Set not supported now HOT 1
- 分表问题 HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from kingshard.