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.

Sign up for GitHub

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

Jump to bottom

全局表left join关联分片表，数据重复问题 #43

Open
bbhy135258 opened this issue Apr 7, 2016 · 0 comments
Open

全局表left join关联分片表，数据重复问题 #43

bbhy135258 opened this issue Apr 7, 2016 · 0 comments

Comments

@bbhy135258
Copy link

全局表left join 关联分片表，在以下情况时会出现重复数据：全局表有记录，对应的分片表中没有记录。

按照一般情况，会输出全局表的数据，分片表字段均为null，但在mycat 1.5GA版本中，会出现N条重复记录，N=全局表存在的库的数目。
加入注解，可以解决数据重复问题。但是只是临时方案，请在以后版本中予以解决。感谢
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@bbhy135258