~posulliv/drizzle/memcached_applier

« back to all changes in this revision

Viewing changes to tests/r/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:
350
350
1       SIMPLE  t1      ALL     a       NULL    NULL    NULL    5       Using where
351
351
explain select * from t1 force index (a) where a=0 or a=2;
352
352
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
353
 
1       SIMPLE  t1      range   a       a       4       NULL    4       Using where; Using MRR
 
353
1       SIMPLE  t1      range   a       a       4       NULL    4       Using where
354
354
explain select * from t1 where c=1;
355
355
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
356
356
1       SIMPLE  t1      ref     c,c_2   c       5       const   1