summaryrefslogtreecommitdiff
path: root/mysql-test/r/join_outer.result
diff options
context:
space:
mode:
authorunknown <monty@hundin.mysql.fi>2001-10-20 11:56:49 +0300
committerunknown <monty@hundin.mysql.fi>2001-10-20 11:56:49 +0300
commit440de598ee325364b89468c8bd66925956b0e66f (patch)
treed234a7c8b4a8d73b7e4b00b64ebf5278a158a753 /mysql-test/r/join_outer.result
parent0625a0dab87886c92c864e60dd9464c61451760a (diff)
downloadmariadb-git-440de598ee325364b89468c8bd66925956b0e66f.tar.gz
Update test results after merge
mysql-test/r/join_outer.result: Update test results mysql-test/r/null.result: Update test results
Diffstat (limited to 'mysql-test/r/join_outer.result')
-rw-r--r--mysql-test/r/join_outer.result8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result
index 79f12ce9b2c..e23ab27b6aa 100644
--- a/mysql-test/r/join_outer.result
+++ b/mysql-test/r/join_outer.result
@@ -625,3 +625,11 @@ SELECT * from t1 left join t2 on t1.id=t2.id where t2.id IS NULL;
id name id idx
2 no NULL NULL
drop table t1,t2;
+create table t1 (bug_id mediumint, reporter mediumint);
+create table t2 (bug_id mediumint, who mediumint, index(who));
+insert into t2 values (1,1),(1,2);
+insert into t1 values (1,1),(2,1);
+SELECT * FROM t1 LEFT JOIN t2 ON (t1.bug_id = t2.bug_id AND t2.who = 2) WHERE (t1.reporter = 2 OR t2.who = 2);
+bug_id reporter bug_id who
+1 1 1 2
+drop table t1,t2;