← Back to branch summary

~stewart/drizzle/embedded-innodb-create-select-transaction-arrgh

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_loadfile.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:
mysql-test/suite/rpl/r/rpl_loadfile.result
 
1
stop slave;
 
2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
3
reset master;
 
4
reset slave;
 
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
 
6
start slave;
 
7
DROP PROCEDURE IF EXISTS test.p1;
 
8
DROP TABLE IF EXISTS test.t1;
 
9
CREATE TABLE test.t1 (a INT, blob_column LONGBLOB, PRIMARY KEY(a));
 
10
INSERT INTO test.t1  VALUES(1,'test');
 
11
UPDATE test.t1 SET blob_column=LOAD_FILE('../std_data_ln/words2.dat') WHERE a=1;
 
12
create procedure test.p1()
 
13
begin
 
14
INSERT INTO test.t1  VALUES(2,'test');
 
15
UPDATE test.t1 SET blob_column=LOAD_FILE('../std_data_ln/words2.dat') WHERE a=2;
 
16
end|
 
17
CALL test.p1();
 
18
SELECT * FROM test.t1 ORDER BY blob_column;
 
19
a       blob_column
 
20
1       abase
 
21
abased
 
22
abasement
 
23
abasements
 
24
abases
 
25
abash
 
26
abashed
 
27
abashes
 
28
abashing
 
29
abasing
 
30
abate
 
31
abated
 
32
abatement
 
33
abatements
 
34
abater
 
35
abates
 
36
abating
 
37
Abba
 
38
abbe
 
39
abbey
 
40
abbeys
 
41
abbot
 
42
abbots
 
43
Abbott
 
44
abbreviate
 
45
abbreviated
 
46
abbreviates
 
47
abbreviating
 
48
abbreviation
 
49
abbreviations
 
50
Abby
 
51
abdomen
 
52
abdomens
 
53
abdominal
 
54
abduct
 
55
abducted
 
56
abduction
 
57
abductions
 
58
abductor
 
59
abductors
 
60
abducts
 
61
Abe
 
62
abed
 
63
Abel
 
64
Abelian
 
65
Abelson
 
66
Aberdeen
 
67
Abernathy
 
68
aberrant
 
69
aberration
 
70
 
 
71
2       abase
 
72
abased
 
73
abasement
 
74
abasements
 
75
abases
 
76
abash
 
77
abashed
 
78
abashes
 
79
abashing
 
80
abasing
 
81
abate
 
82
abated
 
83
abatement
 
84
abatements
 
85
abater
 
86
abates
 
87
abating
 
88
Abba
 
89
abbe
 
90
abbey
 
91
abbeys
 
92
abbot
 
93
abbots
 
94
Abbott
 
95
abbreviate
 
96
abbreviated
 
97
abbreviates
 
98
abbreviating
 
99
abbreviation
 
100
abbreviations
 
101
Abby
 
102
abdomen
 
103
abdomens
 
104
abdominal
 
105
abduct
 
106
abducted
 
107
abduction
 
108
abductions
 
109
abductor
 
110
abductors
 
111
abducts
 
112
Abe
 
113
abed
 
114
Abel
 
115
Abelian
 
116
Abelson
 
117
Aberdeen
 
118
Abernathy
 
119
aberrant
 
120
aberration
 
121
 
 
122
SELECT * FROM test.t1 ORDER BY blob_column;
 
123
a       blob_column
 
124
1       abase
 
125
abased
 
126
abasement
 
127
abasements
 
128
abases
 
129
abash
 
130
abashed
 
131
abashes
 
132
abashing
 
133
abasing
 
134
abate
 
135
abated
 
136
abatement
 
137
abatements
 
138
abater
 
139
abates
 
140
abating
 
141
Abba
 
142
abbe
 
143
abbey
 
144
abbeys
 
145
abbot
 
146
abbots
 
147
Abbott
 
148
abbreviate
 
149
abbreviated
 
150
abbreviates
 
151
abbreviating
 
152
abbreviation
 
153
abbreviations
 
154
Abby
 
155
abdomen
 
156
abdomens
 
157
abdominal
 
158
abduct
 
159
abducted
 
160
abduction
 
161
abductions
 
162
abductor
 
163
abductors
 
164
abducts
 
165
Abe
 
166
abed
 
167
Abel
 
168
Abelian
 
169
Abelson
 
170
Aberdeen
 
171
Abernathy
 
172
aberrant
 
173
aberration
 
174
 
 
175
2       abase
 
176
abased
 
177
abasement
 
178
abasements
 
179
abases
 
180
abash
 
181
abashed
 
182
abashes
 
183
abashing
 
184
abasing
 
185
abate
 
186
abated
 
187
abatement
 
188
abatements
 
189
abater
 
190
abates
 
191
abating
 
192
Abba
 
193
abbe
 
194
abbey
 
195
abbeys
 
196
abbot
 
197
abbots
 
198
Abbott
 
199
abbreviate
 
200
abbreviated
 
201
abbreviates
 
202
abbreviating
 
203
abbreviation
 
204
abbreviations
 
205
Abby
 
206
abdomen
 
207
abdomens
 
208
abdominal
 
209
abduct
 
210
abducted
 
211
abduction
 
212
abductions
 
213
abductor
 
214
abductors
 
215
abducts
 
216
Abe
 
217
abed
 
218
Abel
 
219
Abelian
 
220
Abelson
 
221
Aberdeen
 
222
Abernathy
 
223
aberrant
 
224
aberration
 
225
 
 
226
DROP PROCEDURE IF EXISTS test.p1;
 
227
DROP TABLE test.t1;