← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/innodb.result

  • Committer: Brian Aker
  • Date: 2009-07-27 23:00:57 UTC
  • mto: This revision was merged to the branch mainline in revision 1103.
  • Revision ID: brian@gaz-20090727230057-qjsm1r35akliao2c
Disable MRR

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/innodb.result
1221
1221
623
1222
1222
explain select * from t1 where c between 1 and 2500;
1223
1223
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
1224
 
1       SIMPLE  t1      range   c       c       5       NULL    #       Using where; Using MRR
 
1224
1       SIMPLE  t1      range   c       c       5       NULL    #       Using where
1225
1225
update t1 set c=a;
1226
1226
explain select * from t1 where c between 1 and 2500;
1227
1227
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra