summaryrefslogtreecommitdiff
path: root/mysql-test/r/shm.result
diff options
context:
space:
mode:
authorVladislav Vaintroub <wlad@montyprogram.com>2011-02-12 17:44:01 +0100
committerVladislav Vaintroub <wlad@montyprogram.com>2011-02-12 17:44:01 +0100
commit92c0c410f38e04de812e3ed73bf687ec823e580a (patch)
treefb9ba4b8cbbe929c7dc063384bfdcdac60219de2 /mysql-test/r/shm.result
parentfb47a163d48e8364bf61a99246ff5e79bc46836e (diff)
downloadmariadb-git-92c0c410f38e04de812e3ed73bf687ec823e580a.tar.gz
Fix test suite - adjust result files
Diffstat (limited to 'mysql-test/r/shm.result')
-rw-r--r--mysql-test/r/shm.result2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/shm.result b/mysql-test/r/shm.result
index a92efca148b..5c9eac07bb0 100644
--- a/mysql-test/r/shm.result
+++ b/mysql-test/r/shm.result
@@ -1429,7 +1429,7 @@ companynr companynr
explain select distinct t2.companynr,t4.companynr from t2,t4 where t2.companynr=t4.companynr+1;
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t4 index NULL PRIMARY 1 NULL 12 Using index; Using temporary
-1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer
+1 SIMPLE t2 ALL NULL NULL NULL NULL 1199 Using where; Using join buffer (flat, BNL join)
select t2.fld1,t2.companynr,fld3,period from t3,t2 where t2.fld1 = 38208 and t2.fld1=t3.t2nr and period = 1008 or t2.fld1 = 38008 and t2.fld1 =t3.t2nr and period = 1008;
fld1 companynr fld3 period
038008 37 reporters 1008