Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 DROP PROCEDURE IF EXISTS test.p1;
5 DROP TABLE IF EXISTS test.t1;
6 CREATE TABLE test.t1 (a INT, blob_column LONGBLOB, PRIMARY KEY(a));
7 INSERT INTO test.t1 VALUES(1,'test');
8 UPDATE test.t1 SET blob_column=LOAD_FILE('../../std_data/words2.dat') WHERE a=1;
9 create procedure test.p1()
10 begin
11 INSERT INTO test.t1 VALUES(2,'test');
12 UPDATE test.t1 SET blob_column=LOAD_FILE('../../std_data/words2.dat') WHERE a=2;
13 end|
14 CALL test.p1();
15 SELECT * FROM test.t1 ORDER BY blob_column;
16 a blob_column
17 1 abase
18 abased
19 abasement
20 abasements
21 abases
22 abash
23 abashed
24 abashes
25 abashing
26 abasing
27 abate
28 abated
29 abatement
30 abatements
31 abater
32 abates
33 abating
34 Abba
35 abbe
36 abbey
37 abbeys
38 abbot
39 abbots
40 Abbott
41 abbreviate
42 abbreviated
43 abbreviates
44 abbreviating
45 abbreviation
46 abbreviations
47 Abby
48 abdomen
49 abdomens
50 abdominal
51 abduct
52 abducted
53 abduction
54 abductions
55 abductor
56 abductors
57 abducts
58 Abe
59 abed
60 Abel
61 Abelian
62 Abelson
63 Aberdeen
64 Abernathy
65 aberrant
66 aberration
67
68 2 abase
69 abased
70 abasement
71 abasements
72 abases
73 abash
74 abashed
75 abashes
76 abashing
77 abasing
78 abate
79 abated
80 abatement
81 abatements
82 abater
83 abates
84 abating
85 Abba
86 abbe
87 abbey
88 abbeys
89 abbot
90 abbots
91 Abbott
92 abbreviate
93 abbreviated
94 abbreviates
95 abbreviating
96 abbreviation
97 abbreviations
98 Abby
99 abdomen
100 abdomens
101 abdominal
102 abduct
103 abducted
104 abduction
105 abductions
106 abductor
107 abductors
108 abducts
109 Abe
110 abed
111 Abel
112 Abelian
113 Abelson
114 Aberdeen
115 Abernathy
116 aberrant
117 aberration
118
119 connection slave;
120 connection slave;
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 connection master;
226 DROP PROCEDURE IF EXISTS test.p1;
227 DROP TABLE test.t1;
228 connection slave;
229 include/rpl_reset.inc
230 connection master;
231 SELECT repeat('x',20) INTO OUTFILE 'MYSQLTEST_VARDIR/tmp/bug_39701.data';
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 connection slave;
238 include/stop_slave.inc
239 connection master;
240 CALL p('MYSQLTEST_VARDIR/tmp/bug_39701.data');
241 connection slave;
242 include/start_slave.inc
243 connection master;
244 connection slave;
245 include/diff_tables.inc [master:t1, slave:t1]
246 connection master;
247 DROP TABLE t1;
248 DROP PROCEDURE p;
249 include/rpl_end.inc