diff options
| author | unknown <igor@olga.mysql.com> | 2007-08-03 08:46:01 -0700 |
|---|---|---|
| committer | unknown <igor@olga.mysql.com> | 2007-08-03 08:46:01 -0700 |
| commit | 4b8ecfce5ec0b664a335b471429ec7623c2849cc (patch) | |
| tree | 57acf233e4e48d444a94d365caafa6d0b80fcb0a /mysql-test/r/group_by.result | |
| parent | d6bef8a5c5e4912025ba01146b10e343e974289a (diff) | |
| parent | c90493749aa8736c76b5765cda0ca925864bbe37 (diff) | |
| download | mariadb-git-4b8ecfce5ec0b664a335b471429ec7623c2849cc.tar.gz | |
Merge olga.mysql.com:/home/igor/mysql-5.1-opt
into olga.mysql.com:/home/igor/dev-opt/mysql-5.1-opt-bug28404
mysql-test/r/group_by.result:
Auto merged
sql/sql_select.cc:
Auto merged
sql/sql_select.h:
Auto merged
Diffstat (limited to 'mysql-test/r/group_by.result')
| -rw-r--r-- | mysql-test/r/group_by.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/group_by.result b/mysql-test/r/group_by.result index faa1bc1d661..13ddccaee92 100644 --- a/mysql-test/r/group_by.result +++ b/mysql-test/r/group_by.result @@ -1161,7 +1161,7 @@ CREATE TABLE t2 (a INT, b INT, KEY(a)); INSERT INTO t2 VALUES (1, 1), (2, 2), (3,3), (4,4); EXPLAIN SELECT a, SUM(b) FROM t2 GROUP BY a LIMIT 2; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2 index NULL a 5 NULL 4 +1 SIMPLE t2 index NULL a 5 NULL 2 EXPLAIN SELECT a, SUM(b) FROM t2 IGNORE INDEX (a) GROUP BY a LIMIT 2; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2 ALL NULL NULL NULL NULL 4 Using temporary; Using filesort |