← Back to branch summary

~posulliv/drizzle/memcached_applier

« back to all changes in this revision

Viewing changes to tests/r/mix2_myisam.result

  • Committer: Jay Pipes
  • Date: 2009-08-03 14:23:22 UTC
  • mfrom: (1039.2.68 staging)
  • mto: This revision was merged to the branch mainline in revision 1078.
  • Revision ID: jpipes@serialcoder-20090803142322-1g67h7su9mocg9ig
Merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/mix2_myisam.result
1032
1032
29267
1033
1033
explain select * from t1 where c between 1 and 2500;
1034
1034
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
1035
 
1       SIMPLE  t1      range   c       c       5       NULL    #       Using where; Using MRR
 
1035
1       SIMPLE  t1      range   c       c       5       NULL    #       Using where
1036
1036
update t1 set c=a;
1037
1037
explain select * from t1 where c between 1 and 2500;
1038
1038
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
1039
 
1       SIMPLE  t1      range   c       c       5       NULL    #       Using where; Using MRR
 
1039
1       SIMPLE  t1      range   c       c       5       NULL    #       Using where
1040
1040
drop table t1,t2;
1041
1041
create TEMPORARY table t1 (id int primary key auto_increment, fk int, index index_fk (fk)) engine=MyISAM;
1042
1042
insert into t1 (id) values (null),(null),(null),(null),(null);