diff options
| author | Igor Babaev <igor@askmonty.org> | 2010-10-30 06:07:45 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2010-10-30 06:07:45 -0700 |
| commit | 0b72fd88a11213f64dc146e7ceab942aeb8c40d0 (patch) | |
| tree | bdaeaf77b5e5350619c8f7652b5cc7d241fedb7e /mysql-test/r/func_group.result | |
| parent | d48a8b60345c5b5f95c2ce590f7032a7c9f87c4b (diff) | |
| parent | 05092b7323b2cf435ef43f38120438e62f6eb880 (diff) | |
| download | mariadb-git-0b72fd88a11213f64dc146e7ceab942aeb8c40d0.tar.gz | |
Merge.
Diffstat (limited to 'mysql-test/r/func_group.result')
| -rw-r--r-- | mysql-test/r/func_group.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index 1c04ab304fa..44025842243 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -614,7 +614,7 @@ explain select max(t1.a3), min(t2.a2) from t1, t2 where t1.a2 = 2 and t1.a3 < 'MIN' and t2.a3 > 'CA'; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 range k1 k1 7 NULL 1 Using where; Using index -1 SIMPLE t2 range k1 k1 3 NULL 4 Using where; Using index; Using join buffer +1 SIMPLE t2 range k1 k1 3 NULL 4 Using where; Using index; Using join buffer (flat, BNL join) explain select min(a4 - 0.01) from t1; id select_type table type possible_keys key key_len ref rows Extra @@ -651,7 +651,7 @@ explain select concat(min(t1.a1),min(t2.a4)) from t1, t2 where t2.a4 <> 'AME'; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 range k2 k2 4 NULL 6 Using where; Using index -1 SIMPLE t1 index NULL PRIMARY 3 NULL 15 Using index; Using join buffer +1 SIMPLE t1 index NULL PRIMARY 3 NULL 15 Using index; Using join buffer (flat, BNL join) drop table t1, t2; create table t1 (a char(10)); insert into t1 values ('a'),('b'),('c'); |