diff options
author | Igor Babaev <igor@askmonty.org> | 2010-12-10 23:23:34 -0800 |
---|---|---|
committer | Igor Babaev <igor@askmonty.org> | 2010-12-10 23:23:34 -0800 |
commit | 7f52af655a04c4fecfe32bede79bd65cac0e043d (patch) | |
tree | 071fe4a63bdce21ee8a0a6cfe5e7aa4b3b26f354 /mysql-test/r/row.result | |
parent | eb70e64ceaa7aec6a35580643a3e5fc01b6a0630 (diff) | |
parent | 4e05898f539f299bbb12c49834502c1e471f2fc9 (diff) | |
download | mariadb-git-7f52af655a04c4fecfe32bede79bd65cac0e043d.tar.gz |
Merge.
Diffstat (limited to 'mysql-test/r/row.result')
-rw-r--r-- | mysql-test/r/row.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/row.result b/mysql-test/r/row.result index 789b9c4f383..80934a4e01f 100644 --- a/mysql-test/r/row.result +++ b/mysql-test/r/row.result @@ -377,7 +377,7 @@ a b a b c EXPLAIN EXTENDED SELECT * FROM t1,t2 WHERE (t1.a-1,t1.b)=(t2.a-1,t2.b+1); id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t1 index NULL PRIMARY 8 NULL 6 100.00 Using index -1 SIMPLE t2 index NULL PRIMARY 12 NULL 7 100.00 Using where; Using index; Using join buffer +1 SIMPLE t2 index NULL PRIMARY 12 NULL 7 100.00 Using where; Using index; Using join buffer (flat, BNL join) 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); |