← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/group_min_max_innodb.result

  • Committer: arjen at com
  • Date: 2008-08-25 13:26:34 UTC
  • mto: This revision was merged to the branch mainline in revision 371.
  • Revision ID: arjen@lentz.com.au-20080825132634-yh2563i3xvltoavx
Initial mods for making all tests work again. Some tests adapted+added.
List of tests in Makefile now alphabetically sorted, dups removed.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/group_min_max_innodb.result
65
65
alter table t1 drop primary key, add primary key (f2, f1);
66
66
explain select distinct f1 a, f1 b from t1;
67
67
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
68
 
1       SIMPLE  t1      index   NULL    PRIMARY 5       NULL    4       Using index; Using temporary
 
68
1       SIMPLE  t1      index   NULL    PRIMARY 7       NULL    4       Using index; Using temporary
69
69
explain select distinct f1, f2 from t1;
70
70
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
71
 
1       SIMPLE  t1      range   NULL    PRIMARY 5       NULL    3       Using index for group-by; Using temporary
 
71
1       SIMPLE  t1      range   NULL    PRIMARY 7       NULL    3       Using index for group-by; Using temporary
72
72
drop table t1;