← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/blitzdb/tests/t/index.test

  • Committer: Lee Bieber
  • Date: 2010-11-03 16:54:55 UTC
  • mfrom: (1239.3.138 varchar-idx-fix)
  • mto: This revision was merged to the branch mainline in revision 1901.
  • Revision ID: kalebral@gmail.com-20101103165455-23utmt0l4g890v8j
Merge Toru - fix blitzdb VARCHAR issue

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/blitzdb/tests/t/index.test
476
476
select count(*) from t1;
477
477
drop table t1;
478
478
 
 
479
# +-----------------+
 
480
# | INDEX: VARTEXT1 |
 
481
# +-----------------+
 
482
create table t1 (a varchar(32), index(a)) engine = blitzdb;
 
483
insert into t1 values ('ccc'), ('bbb'), ('aaa');
 
484
insert into t1 values ('eee'), ('ddd'), ('fff');
 
485
--sorted_result
 
486
select * from t1;
 
487
select * from t1 where a = 'aaa';
 
488
select * from t1 where a = 'bbb';
 
489
select * from t1 where a = 'ccc';
 
490
select * from t1 where a = 'ddd';
 
491
select * from t1 where a = 'eee';
 
492
delete from t1 where a = 'ddd';
 
493
delete from t1 where a = 'eee';
 
494
select * from t1;
 
495
select count(*) from t1;
 
496
drop table t1;
 
497
 
479
498
# +------------------------------+
480
499
# | UNIQUE INDEX: DUPLICATE NULL |
481
500
# +------------------------------+