Debian Codegraph @

mysql-test/suite/rpl/r/rpl_stm_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 Warnings:
12 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 replica.
13 create procedure test.p1()
14 begin
15 INSERT INTO test.t1 VALUES(2,'test');
16 UPDATE test.t1 SET blob_column=LOAD_FILE('../../std_data/words2.dat') WHERE a=2;
17 end|
18 CALL test.p1();
19 Warnings:
20 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 replica.
21 SELECT * FROM test.t1 ORDER BY blob_column;
22 a blob_column
23 1 abase
24 abased
25 abasement
26 abasements
27 abases
28 abash
29 abashed
30 abashes
31 abashing
32 abasing
33 abate
34 abated
35 abatement
36 abatements
37 abater
38 abates
39 abating
40 Abba
41 abbe
42 abbey
43 abbeys
44 abbot
45 abbots
46 Abbott
47 abbreviate
48 abbreviated
49 abbreviates
50 abbreviating
51 abbreviation
52 abbreviations
53 Abby
54 abdomen
55 abdomens
56 abdominal
57 abduct
58 abducted
59 abduction
60 abductions
61 abductor
62 abductors
63 abducts
64 Abe
65 abed
66 Abel
67 Abelian
68 Abelson
69 Aberdeen
70 Abernathy
71 aberrant
72 aberration
73
74 2 abase
75 abased
76 abasement
77 abasements
78 abases
79 abash
80 abashed
81 abashes
82 abashing
83 abasing
84 abate
85 abated
86 abatement
87 abatements
88 abater
89 abates
90 abating
91 Abba
92 abbe
93 abbey
94 abbeys
95 abbot
96 abbots
97 Abbott
98 abbreviate
99 abbreviated
100 abbreviates
101 abbreviating
102 abbreviation
103 abbreviations
104 Abby
105 abdomen
106 abdomens
107 abdominal
108 abduct
109 abducted
110 abduction
111 abductions
112 abductor
113 abductors
114 abducts
115 Abe
116 abed
117 Abel
118 Abelian
119 Abelson
120 Aberdeen
121 Abernathy
122 aberrant
123 aberration
124
125 include/sync_slave_sql_with_master.inc
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;
232 include/sync_slave_sql_with_master.inc
233 include/rpl_end.inc