← Back to branch summary

~ubuntu-branches/ubuntu/trusty/mysql-5.6/trusty

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-02-12 11:54:27 UTC
  • Revision ID: package-import@ubuntu.com-20140212115427-oq6tfsqxl1wuwehi
Tags: upstream-5.6.15
Import upstream version 5.6.15

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_loadfile.result
 
1
include/master-slave.inc
 
2
Warnings:
 
3
Note    ####    Sending passwords in plain text without SSL/TLS is extremely insecure.
 
4
Note    ####    Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
 
5
[connection master]
 
6
DROP PROCEDURE IF EXISTS test.p1;
 
7
DROP TABLE IF EXISTS test.t1;
 
8
CREATE TABLE test.t1 (a INT, blob_column LONGBLOB, PRIMARY KEY(a));
 
9
INSERT INTO test.t1  VALUES(1,'test');
 
10
UPDATE test.t1 SET blob_column=LOAD_FILE('../../std_data/words2.dat') WHERE a=1;
 
11
create procedure test.p1()
 
12
begin
 
13
INSERT INTO test.t1  VALUES(2,'test');
 
14
UPDATE test.t1 SET blob_column=LOAD_FILE('../../std_data/words2.dat') WHERE a=2;
 
15
end|
 
16
CALL test.p1();
 
17
SELECT * FROM test.t1 ORDER BY blob_column;
 
18
a       blob_column
 
19
1       abase
 
20
abased
 
21
abasement
 
22
abasements
 
23
abases
 
24
abash
 
25
abashed
 
26
abashes
 
27
abashing
 
28
abasing
 
29
abate
 
30
abated
 
31
abatement
 
32
abatements
 
33
abater
 
34
abates
 
35
abating
 
36
Abba
 
37
abbe
 
38
abbey
 
39
abbeys
 
40
abbot
 
41
abbots
 
42
Abbott
 
43
abbreviate
 
44
abbreviated
 
45
abbreviates
 
46
abbreviating
 
47
abbreviation
 
48
abbreviations
 
49
Abby
 
50
abdomen
 
51
abdomens
 
52
abdominal
 
53
abduct
 
54
abducted
 
55
abduction
 
56
abductions
 
57
abductor
 
58
abductors
 
59
abducts
 
60
Abe
 
61
abed
 
62
Abel
 
63
Abelian
 
64
Abelson
 
65
Aberdeen
 
66
Abernathy
 
67
aberrant
 
68
aberration
 
69
 
 
70
2       abase
 
71
abased
 
72
abasement
 
73
abasements
 
74
abases
 
75
abash
 
76
abashed
 
77
abashes
 
78
abashing
 
79
abasing
 
80
abate
 
81
abated
 
82
abatement
 
83
abatements
 
84
abater
 
85
abates
 
86
abating
 
87
Abba
 
88
abbe
 
89
abbey
 
90
abbeys
 
91
abbot
 
92
abbots
 
93
Abbott
 
94
abbreviate
 
95
abbreviated
 
96
abbreviates
 
97
abbreviating
 
98
abbreviation
 
99
abbreviations
 
100
Abby
 
101
abdomen
 
102
abdomens
 
103
abdominal
 
104
abduct
 
105
abducted
 
106
abduction
 
107
abductions
 
108
abductor
 
109
abductors
 
110
abducts
 
111
Abe
 
112
abed
 
113
Abel
 
114
Abelian
 
115
Abelson
 
116
Aberdeen
 
117
Abernathy
 
118
aberrant
 
119
aberration
 
120
 
 
121
SELECT * FROM test.t1 ORDER BY blob_column;
 
122
a       blob_column
 
123
1       abase
 
124
abased
 
125
abasement
 
126
abasements
 
127
abases
 
128
abash
 
129
abashed
 
130
abashes
 
131
abashing
 
132
abasing
 
133
abate
 
134
abated
 
135
abatement
 
136
abatements
 
137
abater
 
138
abates
 
139
abating
 
140
Abba
 
141
abbe
 
142
abbey
 
143
abbeys
 
144
abbot
 
145
abbots
 
146
Abbott
 
147
abbreviate
 
148
abbreviated
 
149
abbreviates
 
150
abbreviating
 
151
abbreviation
 
152
abbreviations
 
153
Abby
 
154
abdomen
 
155
abdomens
 
156
abdominal
 
157
abduct
 
158
abducted
 
159
abduction
 
160
abductions
 
161
abductor
 
162
abductors
 
163
abducts
 
164
Abe
 
165
abed
 
166
Abel
 
167
Abelian
 
168
Abelson
 
169
Aberdeen
 
170
Abernathy
 
171
aberrant
 
172
aberration
 
173
 
 
174
2       abase
 
175
abased
 
176
abasement
 
177
abasements
 
178
abases
 
179
abash
 
180
abashed
 
181
abashes
 
182
abashing
 
183
abasing
 
184
abate
 
185
abated
 
186
abatement
 
187
abatements
 
188
abater
 
189
abates
 
190
abating
 
191
Abba
 
192
abbe
 
193
abbey
 
194
abbeys
 
195
abbot
 
196
abbots
 
197
Abbott
 
198
abbreviate
 
199
abbreviated
 
200
abbreviates
 
201
abbreviating
 
202
abbreviation
 
203
abbreviations
 
204
Abby
 
205
abdomen
 
206
abdomens
 
207
abdominal
 
208
abduct
 
209
abducted
 
210
abduction
 
211
abductions
 
212
abductor
 
213
abductors
 
214
abducts
 
215
Abe
 
216
abed
 
217
Abel
 
218
Abelian
 
219
Abelson
 
220
Aberdeen
 
221
Abernathy
 
222
aberrant
 
223
aberration
 
224
 
 
225
DROP PROCEDURE IF EXISTS test.p1;
 
226
DROP TABLE test.t1;
 
227
include/rpl_reset.inc
 
228
SELECT repeat('x',20) INTO OUTFILE 'MYSQLTEST_VARDIR/tmp/bug_39701.data';
 
229
DROP TABLE IF EXISTS t1;
 
230
CREATE TABLE t1 (t text);
 
231
CREATE PROCEDURE p(file varchar(4096)) 
 
232
BEGIN
 
233
INSERT INTO t1 VALUES (LOAD_FILE(file));
 
234
END|
 
235
include/stop_slave.inc
 
236
CALL p('MYSQLTEST_VARDIR/tmp/bug_39701.data');
 
237
include/start_slave.inc
 
238
include/diff_tables.inc [master:t1, slave:t1]
 
239
DROP TABLE t1;
 
240
DROP PROCEDURE p;
 
241
include/rpl_end.inc