← 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: Brian Aker
  • Date: 2010-06-28 16:17:36 UTC
  • mfrom: (1637.4.1 drizzle)
  • Revision ID: brian@gaz-20100628161736-eormhb2mnd551i2h
Merge unused

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/blitzdb/tests/r/blitzdb-indexes.result
64
64
800
65
65
explain select c from t1 where b = 3;
66
66
id      select_type     table   type    possible_keys   key     key_len ref     rows    Extra
67
 
1       SIMPLE  t1      ref     b       b       5       const   4       Using where
 
67
1       SIMPLE  t1      ref     b       b       5       const   4       
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
97
71
drop table t1;