← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_stm_loadfile.result

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-03-17 14:56:02 UTC
  • Revision ID: james.westby@ubuntu.com-20100317145602-x7e30l1b2sb5s6w6
Tags: upstream-5.1.45
Import upstream version 5.1.45

Show diffs side-by-side

added added

removed removed

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