diff options
Diffstat (limited to 'mysql-test/main/func_group_innodb.result')
-rw-r--r-- | mysql-test/main/func_group_innodb.result | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/mysql-test/main/func_group_innodb.result b/mysql-test/main/func_group_innodb.result index a4c9b574585..f00c0cad995 100644 --- a/mysql-test/main/func_group_innodb.result +++ b/mysql-test/main/func_group_innodb.result @@ -130,15 +130,13 @@ select 1, max(1) from t1i where 1=99; 1 NULL explain select count(*), min(7), max(7) from t1m, t1i; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1m system NULL NULL NULL NULL 0 Const row not found -1 SIMPLE t1i ALL NULL NULL NULL NULL 1 +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL no matching row in const table select count(*), min(7), max(7) from t1m, t1i; count(*) min(7) max(7) 0 NULL NULL explain select count(*), min(7), max(7) from t1m, t2i; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1m system NULL NULL NULL NULL 0 Const row not found -1 SIMPLE t2i ALL NULL NULL NULL NULL 1 +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL no matching row in const table select count(*), min(7), max(7) from t1m, t2i; count(*) min(7) max(7) 0 NULL NULL |