← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/heap.result

  • Committer: Monty Taylor
  • Date: 2010-08-21 02:55:13 UTC
  • mfrom: (1711.6.12 staging)
  • Revision ID: mordred@inaugust.com-20100821025513-3xyidjf8dodeh4gy
Remove btree heap index.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/heap.result
587
587
1       SIMPLE  t1      ref     t       t       43      const   #       Using where
588
588
explain select count(*) from t1 where v like 'a%';
589
589
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
590
 
1       SIMPLE  t1      range   v       v       43      NULL    #       Using where
 
590
1       SIMPLE  t1      ALL     v       NULL    NULL    NULL    #       Using where
591
591
explain select count(*) from t1 where v between 'a' and 'a ';
592
592
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
593
593
1       SIMPLE  t1      ref     v       v       43      const   #       Using where