bug提交
Open
- Dominant language
- Java
- Stars
- 3.2k
- Forks
- 1.2k
- PR merge metrics
- No merged PRs in 30d
Description
当在cobar上操作的时候,如果不指定字段将插入很和字表相同数量的数据,而且两个表都会有,不会按照路由走,比如,我有两个表db2上的是id在512前的,db3上的是512后的
mysql> insert into tb2 values(1,'ssd');
Query OK, 2 rows affected (0.01 sec)
指定字段的时候不会产生这个问题
insert into tb2 (id,val)values(222,'ssd');
Query OK, 1 row affected (0.00 sec)
Contributor guide
Research direction
Start by reproducing the two INSERT statements shown in the issue against Cobar with the described db2/db3 routing split. Trace the routing path for an INSERT without a column list and compare it with the explicit-column case; done means the first statement affects only the shard selected by id and reports one affected row.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, mysql
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 28/100