diff options
author | unknown <monty@hundin.mysql.fi> | 2001-10-20 11:56:49 +0300 |
---|---|---|
committer | unknown <monty@hundin.mysql.fi> | 2001-10-20 11:56:49 +0300 |
commit | 440de598ee325364b89468c8bd66925956b0e66f (patch) | |
tree | d234a7c8b4a8d73b7e4b00b64ebf5278a158a753 /mysql-test/r/join_outer.result | |
parent | 0625a0dab87886c92c864e60dd9464c61451760a (diff) | |
download | mariadb-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.result | 8 |
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; |