537
537
explain select t1.a,t2.b from t1,t2 where t1.a=t2.a group by t1.a,t2.b;
538
538
id select_type table type possible_keys key key_len ref rows Extra
539
539
1 SIMPLE t1 ALL NULL NULL NULL NULL 6 Using temporary; Using filesort
541
541
explain select t1.a,t2.b from t1,t2 where t1.a=t2.a group by t1.a,t2.b ORDER BY NULL;
542
542
id select_type table type possible_keys key key_len ref rows Extra
543
543
1 SIMPLE t1 ALL NULL NULL NULL NULL 6 Using temporary
546
546
create table t1 (a int, b int);
547
547
insert into t1 values (1, 4),(10, 40),(1, 4),(10, 43),(1, 4),(10, 41),(1, 4),(10, 43),(1, 4);