Debian Codegraph @

mysql-test/suite/rpl/r/rpl_loadfile.result

raw
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 connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA 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 include/sync_slave_sql_with_master.inc
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;
228 include/sync_slave_sql_with_master.inc
229 include/rpl_reset.inc
230 SELECT repeat('x',20) INTO OUTFILE 'MYSQLTEST_VARDIR/tmp/bug_39701.data';
231 DROP TABLE IF EXISTS t1;
232 CREATE TABLE t1 (t text);
233 CREATE PROCEDURE p(file varchar(4096))
234 BEGIN
235 INSERT INTO t1 VALUES (LOAD_FILE(file));
236 END|
237 include/stop_slave.inc
238 CALL p('MYSQLTEST_VARDIR/tmp/bug_39701.data');
239 include/start_slave.inc
240 include/sync_slave_sql_with_master.inc
241 include/diff_tables.inc [master:t1, slave:t1]
242 DROP TABLE t1;
243 DROP PROCEDURE p;
244 include/rpl_end.inc