diff options
Diffstat (limited to 'mysql-test/r/row.result')
| -rw-r--r-- | mysql-test/r/row.result | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/mysql-test/r/row.result b/mysql-test/r/row.result index 9b796c24354..7483f37970f 100644 --- a/mysql-test/r/row.result +++ b/mysql-test/r/row.result @@ -354,12 +354,12 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 ref PRIMARY PRIMARY 4 test.t1.a 1 Using index SELECT * FROM t1,t2 WHERE t1.a=1 and t1.b=t2.b; a b a b c -1 1 1 1 2 -1 1 3 1 3 -1 2 1 2 2 1 1 1 1 1 +1 1 1 1 2 1 1 3 1 1 +1 1 3 1 3 1 2 1 2 1 +1 2 1 2 2 SELECT * FROM t1,t2 WHERE (t1.a,t1.b)=(t2.a,2); a b a b c 1 2 1 1 1 @@ -388,10 +388,10 @@ Warnings: Note 1003 select `test`.`t1`.`a` AS `a`,`test`.`t1`.`b` AS `b`,`test`.`t2`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t2`.`c` AS `c` from `test`.`t1` join `test`.`t2` where `test`.`t1`.`a` - 1 = `test`.`t2`.`a` - 1 and `test`.`t1`.`b` = `test`.`t2`.`b` + 1 SELECT * FROM t1,t2 WHERE (t1.a-1,t1.b)=(t2.a-1,t2.b+1); a b a b c -1 2 1 1 2 -3 2 3 1 3 1 2 1 1 1 +1 2 1 1 2 3 2 3 1 1 +3 2 3 1 3 EXPLAIN SELECT * FROM t2 WHERE a=3 AND b=2; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 ref PRIMARY PRIMARY 8 const,const 1 Using index |