Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

bug提交 #85

Open
q770857088 opened this issue Apr 13, 2018 · 1 comment
Open

bug提交 #85

q770857088 opened this issue Apr 13, 2018 · 1 comment

Comments

@q770857088
Copy link

当在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)

@hexianmao
Copy link
Member

是的,因为cobar在解析sql时没发现分区字段,会走你配置的默认路由策略。

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants