| blob | 390843aaa7e1fcef6c1a64af68f0ae59a39b12f5 |
1 echo create table t1(f1 tinyint, f2 smallint, f3 int, f4 bigint, f5 char(10), f6 varchar(10), f7 date, f8 time, f9 float, f10 double, f11 timestamp);
2 create table t1(f1 tinyint, f2 smallint, f3 int, f4 bigint, f5 char(10), f6 varchar(10), f7 date, f8 time, f9 float, f10 double, f11 timestamp);
3 echo create index treetiny on t1(f1) tree;
4 create index treetiny on t1(f1) tree;
5 echo create index treesmall on t1(f2) tree;
6 create index treesmall on t1(f2) tree;
7 echo create index treeint on t1(f3) tree;
8 create index treeint on t1(f3) tree;
9 echo create index treebig on t1(f4) tree;
10 create index treebig on t1(f4) tree;
11 echo create index treechar on t1(f5) tree;
12 create index treechar on t1(f5) tree;
13 echo create index treevarchar on t1(f6) tree;
14 create index treevarchar on t1(f6) tree;
15 echo create index treedate on t1(f7) tree;
16 create index treedate on t1(f7) tree;
17 echo create index treetime on t1(f8) tree;
18 create index treetime on t1(f8) tree;
19 echo create index treefloat on t1(f9) tree;
20 create index treefloat on t1(f9) tree;
21 echo create index treedouble on t1(f10) tree;
22 create index treedouble on t1(f10) tree;
23 echo create index treetimestamp on t1(f11) tree;
24 create index treetimestamp on t1(f11) tree;
25 echo explain plan select * from t1;
26 explain plan select * from t1;
27 echo explain plan select * from t1 where f1 in (0,2,4);
28 explain plan select * from t1 where f1 in (0,2,4) ;
29 echo explain plan select * from t1 where f1 between 2 and 4;
30 explain plan select * from t1 where f1 between 2 and 4;
31 echo explain plan select * from t1 where f2 in (0,2,4);;
32 explain plan select * from t1 where f2 in (0,2,4);
33 echo explain plan select * from t1 where f2 between 2 and 4;
34 explain plan select * from t1 where f2 between 2 and 4;
35 echo explain plan select * from t1 where f3 in (1,2);
36 explain plan select * from t1 where f3 in (1,2) ;
37 echo explain plan select * from t1 where f3 between 1 and 4;
38 explain plan select * from t1 where f3 between 1 and 4;
39 echo explain plan select * from t1 where f4 in (1,2);
40 explain plan select * from t1 where f4 in (1,2) ;
41 echo explain plan select * from t1 where f4 between 1 and 4;
42 explain plan select * from t1 where f4 between 1 and 4;
43 echo explain plan select * from t1 where f5 in ('1','2');
44 explain plan select * from t1 where f5 in ('1','2') ;
45 echo explain plan select * from t1 where f5 like 'N%';
46 explain plan select * from t1 where f5 like 'N%';
47 echo explain plan select * from t1 where f5 like 'N_h';
48 explain plan select * from t1 where f5 like 'N_h';
49 echo explain plan select * from t1 where f6 in ('1','2');
50 explain plan select * from t1 where f6 in ('1','2') ;
51 echo explain plan select * from t1 where f6 like 'N%';
52 explain plan select * from t1 where f6 like 'N%';
53 echo explain plan select * from t1 where f6 like 'N_h';
54 explain plan select * from t1 where f6 like 'N_h';
55 echo explain plan select * from t1 where f7 in ('2003-11-12','2003-11-15');
56 explain plan select * from t1 where f7 in ('2003-11-12','2003-11-15');
57 echo explain plan select * from t1 where f7 between '2003-11-12' and '2003-11-15';
58 explain plan select * from t1 where f7 between '2003-11-12' and '2003-11-15';
59 echo explain plan select * from t1 where f8 in ('03:21:00','03:21:08');
60 explain plan select * from t1 where f8 in ('03:21:00','03:21:08');
61 echo explain plan select * from t1 where f8 between '03:21:00' and '03:21:08';
62 explain plan select * from t1 where f8 between '03:21:00' and '03:21:08';
63 echo explain plan select * from t1 where f9 in ('2.7','3.7');
64 explain plan select * from t1 where f9 in ('2.7','3.7');
65 echo explain plan select * from t1 where f9 between '2.7' and '3.7';
66 explain plan select * from t1 where f9 between '2.7' and '3.7';
67 echo explain plan select * from t1 where f10 in ('2.7','3.7');
68 explain plan select * from t1 where f10 in ('2.7','3.7');
69 echo explain plan select * from t1 where f10 between '2.7' and '3.7';
70 explain plan select * from t1 where f10 between '2.7' and '3.7';
71 echo explain plan select * from t1 where f11 in ('2003-11-12 01:01:01','2003-11-18 01:01:01');
72 explain plan select * from t1 where f11 in ('2003-11-12 01:01:01','2003-11-18 01:01:01');
73 echo explain plan select * from t1 where f11 between '2003-11-12 01:01:01' and '2003-11-18 01:01:01';
74 explain plan select * from t1 where f11 between '2003-11-12 01:01:01' and '2003-11-18 01:01:01';