diff options
| author | unknown <igor@olga.mysql.com> | 2007-06-04 05:55:27 -0700 |
|---|---|---|
| committer | unknown <igor@olga.mysql.com> | 2007-06-04 05:55:27 -0700 |
| commit | 4be1d7869d2e9a077da2983fb075c9c9791d05c1 (patch) | |
| tree | e68bbf13d91bf2d688210581acfc3f85d196a5c9 /mysql-test/r/subselect.result | |
| parent | 5a19274ea8af855214d25069fc65fd15668e4dc6 (diff) | |
| download | mariadb-git-4be1d7869d2e9a077da2983fb075c9c9791d05c1.tar.gz | |
Post-merge fix.
Diffstat (limited to 'mysql-test/r/subselect.result')
| -rw-r--r-- | mysql-test/r/subselect.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index c9b502a7e8e..8d4a5ee32be 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -4075,9 +4075,9 @@ CREATE TABLE t1 (a int); INSERT INTO t1 VALUES (1), (2); EXPLAIN EXTENDED SELECT * FROM (SELECT count(*) FROM t1 GROUP BY a) as res; -id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY <derived2> ALL NULL NULL NULL NULL 2 -2 DERIVED t1 ALL NULL NULL NULL NULL 2 Using temporary; Using filesort +id select_type table type possible_keys key key_len ref rows filtered Extra +1 PRIMARY <derived2> ALL NULL NULL NULL NULL 2 100.00 +2 DERIVED t1 ALL NULL NULL NULL NULL 2 100.00 Using temporary; Using filesort Warnings: Note 1003 select `res`.`count(*)` AS `count(*)` from (select count(0) AS `count(*)` from `test`.`t1` group by `test`.`t1`.`a`) `res` DROP TABLE t1; |