Debian Codegraph @

mysql-test/suite/funcs_1/r/myisam_trig_09.result

raw
1 SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
2 USE test;
3 drop table if exists tb3;
4 create table tb3 (
5 f118 char not null DEFAULT 'a',
6 f119 char binary not null DEFAULT b'101',
7 f120 char ascii not null DEFAULT b'101',
8 f121 char(50),
9 f122 char(50),
10 f129 binary not null DEFAULT b'101',
11 f130 tinyint not null DEFAULT 99,
12 f131 tinyint unsigned not null DEFAULT 99,
13 f132 tinyint zerofill not null DEFAULT 99,
14 f133 tinyint unsigned zerofill not null DEFAULT 99,
15 f134 smallint not null DEFAULT 999,
16 f135 smallint unsigned not null DEFAULT 999,
17 f136 smallint zerofill not null DEFAULT 999,
18 f137 smallint unsigned zerofill not null DEFAULT 999,
19 f138 mediumint not null DEFAULT 9999,
20 f139 mediumint unsigned not null DEFAULT 9999,
21 f140 mediumint zerofill not null DEFAULT 9999,
22 f141 mediumint unsigned zerofill not null DEFAULT 9999,
23 f142 int not null DEFAULT 99999,
24 f143 int unsigned not null DEFAULT 99999,
25 f144 int zerofill not null DEFAULT 99999,
26 f145 int unsigned zerofill not null DEFAULT 99999,
27 f146 bigint not null DEFAULT 999999,
28 f147 bigint unsigned not null DEFAULT 999999,
29 f148 bigint zerofill not null DEFAULT 999999,
30 f149 bigint unsigned zerofill not null DEFAULT 999999,
31 f150 decimal not null DEFAULT 999.999,
32 f151 decimal unsigned not null DEFAULT 999.17,
33 f152 decimal zerofill not null DEFAULT 999.999,
34 f153 decimal unsigned zerofill,
35 f154 decimal (0),
36 f155 decimal (64),
37 f156 decimal (0) unsigned,
38 f157 decimal (64) unsigned,
39 f158 decimal (0) zerofill,
40 f159 decimal (64) zerofill,
41 f160 decimal (0) unsigned zerofill,
42 f161 decimal (64) unsigned zerofill,
43 f162 decimal (0,0),
44 f163 decimal (63,30),
45 f164 decimal (0,0) unsigned,
46 f165 decimal (63,30) unsigned,
47 f166 decimal (0,0) zerofill,
48 f167 decimal (63,30) zerofill,
49 f168 decimal (0,0) unsigned zerofill,
50 f169 decimal (63,30) unsigned zerofill,
51 f170 numeric,
52 f171 numeric unsigned,
53 f172 numeric zerofill,
54 f173 numeric unsigned zerofill,
55 f174 numeric (0),
56 f175 numeric (64)
57 ) charset latin1 engine = <engine_to_be_used>;
58 Warnings:
59 Warning 1287 'BINARY as attribute of a type' is deprecated and will be removed in a future release. Please use a CHARACTER SET clause with _bin collation instead
60 Warning 1287 'ASCII' is deprecated and will be removed in a future release. Please use CHARACTER SET charset_name instead
61 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
62 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
63 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
64 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
65 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
66 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
67 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
68 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
69 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
70 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
71 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
72 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
73 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
74 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
75 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
76 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
77 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
78 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
79 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
80 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
81 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
82 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
83 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
84 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
85 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
86 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
87 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
88 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
89 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
90 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
91 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
92 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
93 Warning 1681 The ZEROFILL attribute is deprecated and will be removed in a future release. Use the LPAD function to zero-pad numbers, or store the formatted numbers in a CHAR column.
94 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
95 Note 1265 Data truncated for column 'f150' at row 1
96 Note 1265 Data truncated for column 'f151' at row 1
97 Note 1265 Data truncated for column 'f152' at row 1
98 load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/memory_tb3.txt'
99 into table tb3;
100 Warnings:
101 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
102
103 Testcase 3.5.9.1/2:
104 -------------------
105 Warnings:
106 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
107 Create trigger trg1 BEFORE UPDATE on tb3 for each row
108 set new.f142 = 94087, @counter=@counter+1;
109 TotalRows
110 10
111 Affected
112 9
113 NotAffected
114 1
115 NewValuew
116 0
117 set @counter=0;
118 Update tb3 Set f142='1' where f130<100;
119 select count(*) as ExpectedChanged, @counter as TrigCounter
120 from tb3 where f142=94087;
121 ExpectedChanged TrigCounter
122 9 9
123 select count(*) as ExpectedNotChange from tb3
124 where f130<100 and f142<>94087;
125 ExpectedNotChange
126 0
127 select count(*) as NonExpectedChanged from tb3
128 where f130>=130 and f142=94087;
129 NonExpectedChanged
130 0
131 drop trigger trg1;
132 Warnings:
133 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
134
135 Testcase 3.5.9.3:
136 -----------------
137 Warnings:
138 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
139 Create trigger trg2_a before update on tb3 for each row
140 set @tr_var_b4_118=old.f118, @tr_var_b4_121=old.f121,
141 @tr_var_b4_122=old.f122, @tr_var_b4_136=old.f136,
142 @tr_var_b4_163=old.f163;
143 Create trigger trg2_b after update on tb3 for each row
144 set @tr_var_af_118=old.f118, @tr_var_af_121=old.f121,
145 @tr_var_af_122=old.f122, @tr_var_af_136=old.f136,
146 @tr_var_af_163=old.f163;
147 Create trigger trg2_c before delete on tb3 for each row
148 set @tr_var_b4_118=old.f118, @tr_var_b4_121=old.f121,
149 @tr_var_b4_122=old.f122, @tr_var_b4_136=old.f136,
150 @tr_var_b4_163=old.f163;
151 Create trigger trg2_d after delete on tb3 for each row
152 set @tr_var_af_118=old.f118, @tr_var_af_121=old.f121,
153 @tr_var_af_122=old.f122, @tr_var_af_136=old.f136,
154 @tr_var_af_163=old.f163;
155 @tr_var_b4_118 @tr_var_b4_121 @tr_var_b4_122 @tr_var_b4_136 @tr_var_b4_163
156 0 0 0 0 0
157 @tr_var_af_118 @tr_var_af_121 @tr_var_af_122 @tr_var_af_136 @tr_var_af_163
158 0 0 0 0 0
159 Insert into tb3 (f122, f136, f163)
160 values ('Test 3.5.9.3', 7, 123.17);
161 Update tb3 Set f136=8 where f122='Test 3.5.9.3';
162 select f118, f121, f122, f136, f163 from tb3 where f122='Test 3.5.9.3' order by f136;
163 f118 f121 f122 f136 f163
164 a NULL Test 3.5.9.3 00008 123.170000000000000000000000000000
165 select @tr_var_b4_118, @tr_var_b4_121, @tr_var_b4_122,
166 @tr_var_b4_136, @tr_var_b4_163;
167 @tr_var_b4_118 @tr_var_b4_121 @tr_var_b4_122 @tr_var_b4_136 @tr_var_b4_163
168 a NULL Test 3.5.9.3 7 123.170000000000000000000000000000
169 select @tr_var_af_118, @tr_var_af_121, @tr_var_af_122,
170 @tr_var_af_136, @tr_var_af_163;
171 @tr_var_af_118 @tr_var_af_121 @tr_var_af_122 @tr_var_af_136 @tr_var_af_163
172 a NULL Test 3.5.9.3 7 123.170000000000000000000000000000
173 @tr_var_b4_118 @tr_var_b4_121 @tr_var_b4_122 @tr_var_b4_136 @tr_var_b4_163
174 0 0 0 0 0
175 @tr_var_af_118 @tr_var_af_121 @tr_var_af_122 @tr_var_af_136 @tr_var_af_163
176 0 0 0 0 0
177 delete from tb3 where f122='Test 3.5.9.3';
178 select f118, f121, f122, f136, f163 from tb3 where f122='Test 3.5.9.3' order by f136;
179 f118 f121 f122 f136 f163
180 select @tr_var_b4_118, @tr_var_b4_121, @tr_var_b4_122,
181 @tr_var_b4_136, @tr_var_b4_163;
182 @tr_var_b4_118 @tr_var_b4_121 @tr_var_b4_122 @tr_var_b4_136 @tr_var_b4_163
183 a NULL Test 3.5.9.3 8 123.170000000000000000000000000000
184 select @tr_var_af_118, @tr_var_af_121, @tr_var_af_122,
185 @tr_var_af_136, @tr_var_af_163;
186 @tr_var_af_118 @tr_var_af_121 @tr_var_af_122 @tr_var_af_136 @tr_var_af_163
187 a NULL Test 3.5.9.3 8 123.170000000000000000000000000000
188 drop trigger trg2_a;
189 drop trigger trg2_b;
190 drop trigger trg2_c;
191 drop trigger trg2_d;
192 Warnings:
193 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
194
195 Testcase 3.5.9.4:
196 -----------------
197 Warnings:
198 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
199 Create trigger trg3_a before insert on tb3 for each row
200 set @tr_var_b4_118=new.f118, @tr_var_b4_121=new.f121,
201 @tr_var_b4_122=new.f122, @tr_var_b4_136=new.f136,
202 @tr_var_b4_151=new.f151, @tr_var_b4_163=new.f163;
203 Create trigger trg3_b after insert on tb3 for each row
204 set @tr_var_af_118=new.f118, @tr_var_af_121=new.f121,
205 @tr_var_af_122=new.f122, @tr_var_af_136=new.f136,
206 @tr_var_af_151=new.f151, @tr_var_af_163=new.f163;
207 Create trigger trg3_c before update on tb3 for each row
208 set @tr_var_b4_118=new.f118, @tr_var_b4_121=new.f121,
209 @tr_var_b4_122=new.f122, @tr_var_b4_136=new.f136,
210 @tr_var_b4_151=new.f151, @tr_var_b4_163=new.f163;
211 Create trigger trg3_d after update on tb3 for each row
212 set @tr_var_af_118=new.f118, @tr_var_af_121=new.f121,
213 @tr_var_af_122=new.f122, @tr_var_af_136=new.f136,
214 @tr_var_af_151=new.f151, @tr_var_af_163=new.f163;
215 @tr_var_b4_118 @tr_var_b4_121 @tr_var_b4_122 @tr_var_b4_136 @tr_var_b4_151 @tr_var_b4_163
216 0 0 0 0 0 0
217 @tr_var_af_118 @tr_var_af_121 @tr_var_af_122 @tr_var_af_136 @tr_var_af_151 @tr_var_af_163
218 0 0 0 0 0 0
219 Insert into tb3 (f122, f136, f151, f163)
220 values ('Test 3.5.9.4', 7, DEFAULT, 995.24);
221 select f118, f121, f122, f136, f151, f163 from tb3
222 where f122 like 'Test 3.5.9.4%' order by f163;
223 f118 f121 f122 f136 f151 f163
224 a NULL Test 3.5.9.4 00007 999 995.240000000000000000000000000000
225 select @tr_var_b4_118, @tr_var_b4_121, @tr_var_b4_122,
226 @tr_var_b4_136, @tr_var_b4_151, @tr_var_b4_163;
227 @tr_var_b4_118 @tr_var_b4_121 @tr_var_b4_122 @tr_var_b4_136 @tr_var_b4_151 @tr_var_b4_163
228 a NULL Test 3.5.9.4 7 999 995.240000000000000000000000000000
229 select @tr_var_af_118, @tr_var_af_121, @tr_var_af_122,
230 @tr_var_af_136, @tr_var_af_151, @tr_var_af_163;
231 @tr_var_af_118 @tr_var_af_121 @tr_var_af_122 @tr_var_af_136 @tr_var_af_151 @tr_var_af_163
232 a NULL Test 3.5.9.4 7 999 995.240000000000000000000000000000
233 @tr_var_b4_118 @tr_var_b4_121 @tr_var_b4_122 @tr_var_b4_136 @tr_var_b4_151 @tr_var_b4_163
234 0 0 0 0 0 0
235 @tr_var_af_118 @tr_var_af_121 @tr_var_af_122 @tr_var_af_136 @tr_var_af_151 @tr_var_af_163
236 0 0 0 0 0 0
237 Update ignore tb3 Set f122='Test 3.5.9.4-trig', f136=NULL, f151=DEFAULT, f163=NULL
238 where f122='Test 3.5.9.4';
239 Warnings:
240 Warning 1048 Column 'f136' cannot be null
241 Update tb3 Set f122='Test 3.5.9.4-trig', f136=0, f151=DEFAULT, f163=NULL
242 where f122='Test 3.5.9.4';
243 select f118, f121, f122, f136, f151, f163 from tb3
244 where f122 like 'Test 3.5.9.4-trig' order by f163;
245 f118 f121 f122 f136 f151 f163
246 a NULL Test 3.5.9.4-trig 00000 999 NULL
247 select @tr_var_b4_118, @tr_var_b4_121, @tr_var_b4_122,
248 @tr_var_b4_136, @tr_var_b4_151, @tr_var_b4_163;
249 @tr_var_b4_118 @tr_var_b4_121 @tr_var_b4_122 @tr_var_b4_136 @tr_var_b4_151 @tr_var_b4_163
250 a NULL Test 3.5.9.4-trig NULL 999 NULL
251 select @tr_var_af_118, @tr_var_af_121, @tr_var_af_122,
252 @tr_var_af_136, @tr_var_af_151, @tr_var_af_163;
253 @tr_var_af_118 @tr_var_af_121 @tr_var_af_122 @tr_var_af_136 @tr_var_af_151 @tr_var_af_163
254 a NULL Test 3.5.9.4-trig 0 999 NULL
255 drop trigger trg3_a;
256 drop trigger trg3_b;
257 drop trigger trg3_c;
258 drop trigger trg3_d;
259 delete from tb3 where f122='Test 3.5.9.4-trig';
260 Warnings:
261 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
262
263 Testcase 3.5.9.5: (implied in previous tests)
264 ---------------------------------------------
265 Warnings:
266 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
267 Warnings:
268 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
269
270 Testcase 3.5.9.6:
271 -----------------
272 Warnings:
273 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
274 create trigger trg4a before insert on tb3 for each row
275 set @temp1= old.f120;
276 ERROR HY000: There is no OLD row in on INSERT trigger
277 create trigger trg4b after insert on tb3 for each row
278 set old.f120= 'test';
279 ERROR HY000: Updating of OLD row is not allowed in trigger
280 drop trigger trg4a;
281 drop trigger trg4b;
282 Warnings:
283 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
284
285 Testcase 3.5.9.7: (implied in previous tests)
286 ---------------------------------------------
287 Warnings:
288 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
289 Warnings:
290 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
291
292 Testcase 3.5.9.8: (implied in previous tests)
293 ---------------------------------------------
294 Warnings:
295 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
296 Warnings:
297 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
298
299 Testcase 3.5.9.9:
300 -----------------
301 Warnings:
302 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
303 create trigger trg5a before DELETE on tb3 for each row
304 set @temp1=new.f122;
305 ERROR HY000: There is no NEW row in on DELETE trigger
306 create trigger trg5b after DELETE on tb3 for each row
307 set new.f122='test';
308 ERROR HY000: There is no NEW row in on DELETE trigger
309 drop trigger trg5a;
310 drop trigger trg5b;
311 Warnings:
312 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
313
314 Testcase 3.5.9.10: (implied in previous tests)
315 ----------------------------------------------
316 Warnings:
317 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
318 Warnings:
319 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
320
321 Testcase 3.5.9.11: covered by 3.5.9.9
322 -------------------------------------
323 Warnings:
324 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
325 Warnings:
326 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
327
328 Testcase 3.5.9.12: covered by 3.5.9.6
329 -------------------------------------
330 Warnings:
331 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
332 Warnings:
333 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
334
335 Testcase 3.5.9.13:
336 ------------------
337 Warnings:
338 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
339 create trigger trg6a before UPDATE on tb3 for each row
340 set old.f118='C', new.f118='U';
341 ERROR HY000: Updating of OLD row is not allowed in trigger
342 create trigger trg6b after INSERT on tb3 for each row
343 set old.f136=163, new.f118='U';
344 ERROR HY000: Updating of OLD row is not allowed in trigger
345 create trigger trg6c after UPDATE on tb3 for each row
346 set old.f136=NULL;
347 ERROR HY000: Updating of OLD row is not allowed in trigger
348 drop trigger trg6a;
349 drop trigger trg6b;
350 drop trigger trg6c;
351 Warnings:
352 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
353
354 Testcase 3.5.9.14: (implied in previous tests)
355 ----------------------------------------------
356 Warnings:
357 Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
358 DROP TABLE test.tb3;