← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: lbieber
  • Date: 2010-07-27 13:22:28 UTC
  • mfrom: (1667.2.1 staging)
  • Revision ID: lbieber@orisndriz03-20100727132228-kmxj32ubano8bdmz
Merge Toru's latest changes for BlitzDB

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/blitzdb/tests/r/blitzdb-indexes.result
68
68
select c from t1 where b = 3;
69
69
c
70
70
300
 
71
select * from t1 where a = 1;
 
72
a       b       c
 
73
1       1       100
 
74
select * from t1 where b = 1;
 
75
a       b       c
 
76
1       1       100
 
77
delete from t1 where a = 1;
 
78
select * from t1 where a = 1;
 
79
a       b       c
 
80
select * from t1 where b = 1;
 
81
a       b       c
 
82
select * from t1 where a >= 2 and a <= 4;
 
83
a       b       c
 
84
2       2       200
 
85
3       3       300
 
86
4       4       400
 
87
select * from t1 where b >= 2 and b <= 4;
 
88
a       b       c
 
89
2       2       200
 
90
3       3       300
 
91
4       4       400
 
92
delete from t1 where a >= 2 and a <= 4;
 
93
select * from t1 where a >= 2 and a <= 4;
 
94
a       b       c
 
95
select * from t1 where b >= 2 and b <= 4;
 
96
a       b       c
71
97
drop table t1;