~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/r/mysqlbinlog_base64.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
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;