EVOLUTION-MANAGER

Edit File: 2970i.result

set default_storage_engine='innodb'; drop table if exists t2970; Warnings: Note 1051 Unknown table 'test.t2970' create table t2970 (a int, b int, c int, d int, key(a), key(a,b)); insert into t2970 values (1,1,1,1),(1,2,3,4); explain select a,count(b),max(b) from t2970 where a > 0 group by a order by a; id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t2970 range a,a_2 a_2 5 NULL 2 Using where; Using index drop table t2970;