~drizzle-trunk/drizzle/development

1 by brian
clean slate
1
create table t1 (a int);
2
insert into t1 values (1);
3
insert into t1 values (2);
4
insert into t1 values (3);
5
update t1 set a=a+2 where a=2;
6
update t1 set a=a+2 where a=3;
7
create table t2 (word varchar(20));
8
load data infile '../std_data_ln/words.dat' into table t2;
9
flush logs;
10
drop table t1;
11
drop table t2;
12
select * from t1;
13
a
14
1
15
4
16
5
17
select * from t2;
18
word
19
Aarhus
20
Aaron
21
Ababa
22
aback
23
abaft
24
abandon
25
abandoned
26
abandoning
27
abandonment
28
abandons
29
Aarhus
30
Aaron
31
Ababa
32
aback
33
abaft
34
abandon
35
abandoned
36
abandoning
37
abandonment
38
abandons
39
abase
40
abased
41
abasement
42
abasements
43
abases
44
abash
45
abashed
46
abashes
47
abashing
48
abasing
49
abate
50
abated
51
abatement
52
abatements
53
abater
54
abates
55
abating
56
Abba
57
abbe
58
abbey
59
abbeys
60
abbot
61
abbots
62
Abbott
63
abbreviate
64
abbreviated
65
abbreviates
66
abbreviating
67
abbreviation
68
abbreviations
69
Abby
70
abdomen
71
abdomens
72
abdominal
73
abduct
74
abducted
75
abduction
76
abductions
77
abductor
78
abductors
79
abducts
80
Abe
81
abed
82
Abel
83
Abelian
84
Abelson
85
Aberdeen
86
Abernathy
87
aberrant
88
aberration
89
flush logs;
90
drop table t2;
91
create table t2 (word varchar(20));
92
load data infile '../std_data_ln/words.dat' into table t2;
93
insert into t2 select * from t2;
94
insert into t2 select * from t2;
95
insert into t2 select * from t2;
96
insert into t2 select * from t2;
97
insert into t2 select * from t2;
98
insert into t2 select * from t2;
99
insert into t2 select * from t2;
100
insert into t2 select * from t2;
101
insert into t2 select * from t2;
102
select count(*) from t2;
103
count(*)
104
35840
105
flush logs;
106
select count(*) from t2;
107
count(*)
108
35840
109
drop table t1;
110
drop table t2;