summaryrefslogtreecommitdiff
path: root/mysql-test/r/row.result
diff options
context:
space:
mode:
authorIgor Babaev <igor@askmonty.org>2010-12-10 23:23:34 -0800
committerIgor Babaev <igor@askmonty.org>2010-12-10 23:23:34 -0800
commit7f52af655a04c4fecfe32bede79bd65cac0e043d (patch)
tree071fe4a63bdce21ee8a0a6cfe5e7aa4b3b26f354 /mysql-test/r/row.result
parenteb70e64ceaa7aec6a35580643a3e5fc01b6a0630 (diff)
parent4e05898f539f299bbb12c49834502c1e471f2fc9 (diff)
downloadmariadb-git-7f52af655a04c4fecfe32bede79bd65cac0e043d.tar.gz
Merge.
Diffstat (limited to 'mysql-test/r/row.result')
-rw-r--r--mysql-test/r/row.result2
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);