~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/blitzdb/tests/r/blitzdb-index.result

  • Committer: lbieber
  • Date: 2010-09-22 21:12:51 UTC
  • mfrom: (1782.4.3 refactor)
  • mto: This revision was merged to the branch mainline in revision 1787.
  • Revision ID: lbieber@orisndriz08-20100922211251-yuy3nkgpzb3t8jrd
Merge Brian - Remove 3 byte indexes

Show diffs side-by-side

added added

removed removed

Lines of Context:
480
480
1984-09-25      23      twenty five
481
481
explain select * from t1 where a = '1984-09-22';
482
482
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
483
 
1       SIMPLE  t1      const   PRIMARY PRIMARY 3       const   1       
 
483
1       SIMPLE  t1      const   PRIMARY PRIMARY 4       const   1       
484
484
select * from t1 where a = '1984-09-22';
485
485
a       b       c
486
486
1984-09-22      22      twenty two