← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/embedded_innodb/tests/t/basic_index_lookup.test

  • Committer: Jay Pipes
  • Date: 2010-04-08 16:27:25 UTC
  • mfrom: (1405.6.10 replication-pairs)
  • mto: This revision was merged to the branch mainline in revision 1457.
  • Revision ID: jpipes@serialcoder-20100408162725-sugbgn38oxjqclq2
Merge trunk and replication-pairs with conflict resolution

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/embedded_innodb/tests/t/basic_index_lookup.test
 
1
create table t1 (a int primary key);
 
2
insert into t1 values (1),(2),(3),(4),(100),(200);
 
3
explain select * from t1 order by a;
 
4
select * from t1 order by a;
 
5
explain select * from t1 where a>4;
 
6
select * from t1 where a>4;
 
7
explain select * from t1 where a<4;
 
8
select * from t1 where a<4;
 
9
explain select * from t1 where a=4;
 
10
select * from t1 where a=4;
 
11
drop table t1;
 
12
 
 
13
create table t1 (a int primary key, b varchar(100));
 
14
insert into t1 values (1, "hello"), (2, "world"), (3, "Beaker"), (4, "Cricket");
 
15
EXPLAIN SELECT b FROM t1 WHERE a=1;
 
16
SELECT b FROM t1 WHERE a=1;
 
17
EXPLAIN SELECT b FROM t1 WHERE a=2;
 
18
SELECT b FROM t1 WHERE a=2;
 
19
EXPLAIN SELECT b FROM t1 WHERE a=3;
 
20
SELECT b FROM t1 WHERE a=3;
 
21
EXPLAIN SELECT b FROM t1 WHERE a=4;
 
22
SELECT b FROM t1 WHERE a=4;
 
23
DROP TABLE t1;