Debian Codegraph @

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