alibaba / alibaba/cobar

bug提交

Open
#85 1 comment 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.