diff options
| author | unknown <monty@mysql.com> | 2005-05-19 05:54:31 +0300 |
|---|---|---|
| committer | unknown <monty@mysql.com> | 2005-05-19 05:54:31 +0300 |
| commit | 44819149ad03d19a319f92fad44c8840880d9de2 (patch) | |
| tree | affceee64bc0220831cf06439a92fec21907adbf | |
| parent | 6cd52671d7c69d425ac695c11c79cd29b5a01c12 (diff) | |
| download | mariadb-git-44819149ad03d19a319f92fad44c8840880d9de2.tar.gz | |
portablity fix
| -rw-r--r-- | mysql-test/r/group_min_max.result | 2 | ||||
| -rw-r--r-- | mysql-test/t/group_min_max.test | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/group_min_max.result b/mysql-test/r/group_min_max.result index 09555bf3725..dea6bca2cdd 100644 --- a/mysql-test/r/group_min_max.result +++ b/mysql-test/r/group_min_max.result @@ -148,7 +148,7 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 range NULL idx_t1_1 147 NULL 17 Using index for group-by explain select a1,a2,b,max(c),min(c) from t2 group by a1,a2,b; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2 range NULL idx_t2_1 146 NULL # Using index for group-by +1 SIMPLE t2 range NULL idx_t2_1 # NULL # Using index for group-by explain select min(a2), a1, max(a2), min(a2), a1 from t1 group by a1; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 range NULL idx_t1_1 65 NULL 5 Using index for group-by diff --git a/mysql-test/t/group_min_max.test b/mysql-test/t/group_min_max.test index f705342b81c..76f959b983b 100644 --- a/mysql-test/t/group_min_max.test +++ b/mysql-test/t/group_min_max.test @@ -174,7 +174,7 @@ explain select a1, max(a2) from t1 group by a1; explain select a1, min(a2), max(a2) from t1 group by a1; explain select a1, a2, b, min(c), max(c) from t1 group by a1,a2,b; explain select a1,a2,b,max(c),min(c) from t1 group by a1,a2,b; ---replace_column 9 # +--replace_column 7 # 9 # explain select a1,a2,b,max(c),min(c) from t2 group by a1,a2,b; -- Select fields in different order explain select min(a2), a1, max(a2), min(a2), a1 from t1 group by a1; |