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

Join raises wrong result #1164

Closed
zimulala opened this issue Apr 26, 2016 · 0 comments
Closed

Join raises wrong result #1164

zimulala opened this issue Apr 26, 2016 · 0 comments
Assignees
Labels
type/bug The issue is confirmed as a bug.

Comments

@zimulala
Copy link
Contributor

  1. What did you do?
create table t(c1 int, c2 int);
create table t1(c1 int, c2 int);
insert into t values(1,1),(2,2);
insert into t1 values(2,3),(4,4);
select * from t left outer join t1 on t.c1 = t1.c1 where t.c1 = 1 or t1.c2 > 20;

2.What did you expect to see?
+------+------+------+------+
| c1 | c2 | c1 | c2 |
+------+------+------+------+
| 1 | 1 | NULL | NULL |
+------+------+------+------+

3.What did you see instead?
+------+------+------+------+
| c1 | c2 | c1 | c2 |
+------+------+------+------+
| 1 | 1 | NULL | NULL |
| 2 | 2 | NULL | NULL |
+------+------+------+------+

@coocood coocood added the type/bug The issue is confirmed as a bug. label Apr 26, 2016
hanfei19910905 pushed a commit that referenced this issue Apr 26, 2016
3pointer pushed a commit to 3pointer/tidb that referenced this issue Jun 28, 2021
xhebox pushed a commit to xhebox/tidb that referenced this issue Sep 28, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug The issue is confirmed as a bug.
Projects
None yet
Development

No branches or pull requests

3 participants