Debian Codegraph @

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

raw
1 USE test;
2 drop table if exists tb3;
3 create table tb3 (
4 f118 char not null DEFAULT 'a',
5 f119 char binary not null DEFAULT b'101',
6 f120 char ascii not null DEFAULT b'101',
7 f121 char(50),
8 f122 char(50),
9 f129 binary not null DEFAULT b'101',
10 f130 tinyint not null DEFAULT 99,
11 f131 tinyint unsigned not null DEFAULT 99,
12 f132 tinyint zerofill not null DEFAULT 99,
13 f133 tinyint unsigned zerofill not null DEFAULT 99,
14 f134 smallint not null DEFAULT 999,
15 f135 smallint unsigned not null DEFAULT 999,
16 f136 smallint zerofill not null DEFAULT 999,
17 f137 smallint unsigned zerofill not null DEFAULT 999,
18 f138 mediumint not null DEFAULT 9999,
19 f139 mediumint unsigned not null DEFAULT 9999,
20 f140 mediumint zerofill not null DEFAULT 9999,
21 f141 mediumint unsigned zerofill not null DEFAULT 9999,
22 f142 int not null DEFAULT 99999,
23 f143 int unsigned not null DEFAULT 99999,
24 f144 int zerofill not null DEFAULT 99999,
25 f145 int unsigned zerofill not null DEFAULT 99999,
26 f146 bigint not null DEFAULT 999999,
27 f147 bigint unsigned not null DEFAULT 999999,
28 f148 bigint zerofill not null DEFAULT 999999,
29 f149 bigint unsigned zerofill not null DEFAULT 999999,
30 f150 decimal not null DEFAULT 999.999,
31 f151 decimal unsigned not null DEFAULT 999.17,
32 f152 decimal zerofill not null DEFAULT 999.999,
33 f153 decimal unsigned zerofill,
34 f154 decimal (0),
35 f155 decimal (64),
36 f156 decimal (0) unsigned,
37 f157 decimal (64) unsigned,
38 f158 decimal (0) zerofill,
39 f159 decimal (64) zerofill,
40 f160 decimal (0) unsigned zerofill,
41 f161 decimal (64) unsigned zerofill,
42 f162 decimal (0,0),
43 f163 decimal (63,30),
44 f164 decimal (0,0) unsigned,
45 f165 decimal (63,30) unsigned,
46 f166 decimal (0,0) zerofill,
47 f167 decimal (63,30) zerofill,
48 f168 decimal (0,0) unsigned zerofill,
49 f169 decimal (63,30) unsigned zerofill,
50 f170 numeric,
51 f171 numeric unsigned,
52 f172 numeric zerofill,
53 f173 numeric unsigned zerofill,
54 f174 numeric (0),
55 f175 numeric (64)
56 ) charset latin1 engine = <engine_to_be_used>;
57 Warnings:
58 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
59 Warning 1287 'ASCII' is deprecated and will be removed in a future release. Please use CHARACTER SET charset_name instead
60 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.
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 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
71 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.
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 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
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 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.
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 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
80 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.
81 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
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 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.
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 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
88 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.
89 Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
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 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.
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 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
94 Note 1265 Data truncated for column 'f150' at row 1
95 Note 1265 Data truncated for column 'f151' at row 1
96 Note 1265 Data truncated for column 'f152' at row 1
97 Warnings:
98 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.
99
100 Testcase: 3.5:
101 --------------
102 Warnings:
103 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.
104 create User test_general@localhost;
105 alter user test_general@localhost identified by 'PWD';
106 revoke ALL PRIVILEGES, GRANT OPTION FROM test_general@localhost;
107 create User test_super@localhost;
108 alter user test_super@localhost identified by 'PWD';
109 grant ALL on *.* to test_super@localhost with grant OPTION;
110 Warnings:
111 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.
112
113 Testcase 3.5.4:
114 ---------------
115 Warnings:
116 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.
117 use test;
118 Warnings:
119 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.
120
121 Testcase 3.5.4.1:
122 -----------------
123 Warnings:
124 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.
125 create database db_drop;
126 Use db_drop;
127 create table t1 (f1 char(30)) engine = <engine_to_be_used>;
128 create user test_general;
129 grant INSERT, SELECT on db_drop.t1 to test_general;
130 Use db_drop;
131 Create trigger trg1 BEFORE INSERT on t1
132 for each row set new.f1='Trigger 3.5.4.1';
133 Use db_drop;
134 Insert into t1 values ('Insert error 3.5.4.1');
135 Select * from t1 order by f1;
136 f1
137 Trigger 3.5.4.1
138 drop trigger trg1;
139 select trigger_schema, trigger_name, event_object_table
140 from information_schema.triggers
141 where trigger_schema = 'db_drop'
142 order by trigger_name;
143 TRIGGER_SCHEMA TRIGGER_NAME EVENT_OBJECT_TABLE
144 Insert into t1 values ('Insert no trigger 3.5.4.1');
145 Select * from t1 order by f1;
146 f1
147 Insert no trigger 3.5.4.1
148 Trigger 3.5.4.1
149 drop trigger trg1;
150 drop database if exists db_drop;
151 revoke ALL PRIVILEGES, GRANT OPTION FROM 'test_general'@'localhost';
152 Warnings:
153 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.
154
155 Testcase 3.5.4.2:
156 -----------------
157 Warnings:
158 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.
159 create database db_drop2;
160 Use db_drop2;
161 drop table if exists t1_432 ;
162 create table t1_432 (f1 char (30)) engine = <engine_to_be_used>;
163 Drop trigger tr_does_not_exit;
164 ERROR HY000: Trigger does not exist
165 drop table if exists t1_432 ;
166 drop database if exists db_drop2;
167 Warnings:
168 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.
169
170 Testcase 3.5.4.3:
171 -----------------
172 Warnings:
173 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.
174 create database db_drop3;
175 Use db_drop3;
176 drop table if exists t1_433 ;
177 drop table if exists t1_433a ;
178 create table t1_433 (f1 char (30)) engine = <engine_to_be_used>;
179 create table t1_433a (f1a char (5)) engine = <engine_to_be_used>;
180 CREATE TRIGGER trg3 BEFORE INSERT on t1_433 for each row
181 set new.f1 = 'Trigger 3.5.4.3';
182 Drop trigger t1.433.trg3;
183 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.trg3' at line 1
184 Drop trigger db_drop3.t1.433.trg3;
185 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.433.trg3' at line 1
186 Drop trigger mysql.trg3;
187 ERROR HY000: Trigger does not exist
188 Drop trigger tbx.trg3;
189 ERROR 42000: Unknown database 'tbx'
190 Drop trigger db_drop3.trg3;
191 drop table if exists t1_433;
192 drop table if exists t1_433a;
193 drop database if exists db_drop3;
194 Warnings:
195 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.
196
197 Testcase 3.5.4.4:
198 -----------------
199 Warnings:
200 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.
201 create database db_drop4;
202 Use db_drop4;
203 create table t1 (f1 char(30)) engine = <engine_to_be_used>;
204 grant INSERT, SELECT on db_drop4.t1 to test_general;
205 Create trigger trg4 BEFORE INSERT on t1
206 for each row set new.f1='Trigger 3.5.4.4';
207 Use db_drop4;
208 Insert into t1 values ('Insert 3.5.4.4');
209 Select * from t1;
210 f1
211 Trigger 3.5.4.4
212 Drop database db_drop4;
213 Show databases like 'db_drop4';
214 Database (db_drop4)
215 select trigger_schema, trigger_name, event_object_table
216 from information_schema.triggers
217 where information_schema.triggers.trigger_name='trg4';
218 TRIGGER_SCHEMA TRIGGER_NAME EVENT_OBJECT_TABLE
219 create database db_drop4;
220 Use db_drop4;
221 create table t1 (f1 char(30)) engine = <engine_to_be_used>;
222 grant INSERT, SELECT on db_drop4.t1 to test_general;
223 Insert into t1 values ('2nd Insert 3.5.4.4');
224 Select * from t1;
225 f1
226 2nd Insert 3.5.4.4
227 drop trigger trg4;
228 ERROR HY000: Trigger does not exist
229 drop database if exists db_drop4;
230 revoke ALL PRIVILEGES, GRANT OPTION FROM 'test_general'@'localhost';
231 Warnings:
232 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.
233
234 Testcase 3.5.4.5:
235 -----------------
236 Warnings:
237 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.
238 create database db_drop5;
239 Use db_drop5;
240 create table t1 (f1 char(50)) engine = <engine_to_be_used>;
241 grant INSERT, SELECT on t1 to test_general;
242 Create trigger trg5 BEFORE INSERT on t1
243 for each row set new.f1='Trigger 3.5.4.5';
244 Use db_drop5;
245 Insert into t1 values ('Insert 3.5.4.5');
246 Select * from t1;
247 f1
248 Trigger 3.5.4.5
249 Drop table t1;
250 Show tables;
251 Tables_in_db_drop5
252 select trigger_schema, trigger_name, event_object_table
253 from information_schema.triggers
254 where information_schema.triggers.trigger_name='trg5';
255 TRIGGER_SCHEMA TRIGGER_NAME EVENT_OBJECT_TABLE
256 create table t1 (f1 char(50)) engine = <engine_to_be_used>;
257 grant INSERT, SELECT on t1 to test_general;
258 Insert into t1 values ('2nd Insert 3.5.4.5');
259 Select * from t1;
260 f1
261 2nd Insert 3.5.4.5
262 drop trigger trg5;
263 ERROR HY000: Trigger does not exist
264 drop database if exists db_drop5;
265 revoke ALL PRIVILEGES, GRANT OPTION FROM 'test_general'@'localhost';
266 Warnings:
267 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.
268
269 Testcase 3.5.5:
270 ---------------
271 Warnings:
272 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.
273 use test;
274 Warnings:
275 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.
276
277 Testcase 3.5.5.1:
278 -----------------
279 Warnings:
280 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.
281 Create trigger trg1 before INSERT on t100 for each row set new.f2=1000;
282 ERROR 42S02: Table 'test.t100' doesn't exist
283 Warnings:
284 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.
285
286 Testcase 3.5.5.2:
287 -----------------
288 Warnings:
289 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.
290 Create temporary table t1_temp (f1 bigint signed, f2 bigint unsigned);
291 Create trigger trg2 before INSERT
292 on t1_temp for each row set new.f2=9999;
293 ERROR HY000: Trigger's 't1_temp' is view or temporary table
294 drop table t1_temp;
295 Warnings:
296 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.
297
298 Testcase 3.5.5.3:
299 -----------------
300 Warnings:
301 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.
302 Create view vw3 as select f118 from tb3;
303 Create trigger trg3 before INSERT
304 on vw3 for each row set new.f118='s';
305 ERROR HY000: 'test.vw3' is not BASE TABLE
306 drop view vw3;
307 Warnings:
308 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.
309
310 Testcase 3.5.5.4:
311 -----------------
312 Warnings:
313 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.
314 create database dbtest_one;
315 create database dbtest_two;
316 use dbtest_two;
317 create table t2 (f1 char(15)) engine = <engine_to_be_used>;
318 use dbtest_one;
319 create trigger trg4 before INSERT
320 on dbtest_two.t2 for each row set new.f1='trig 3.5.5.4';
321 ERROR HY000: Trigger in wrong schema
322 grant INSERT, SELECT on dbtest_two.t2 to test_general;
323 grant SELECT on dbtest_one.* to test_general;
324 use dbtest_two;
325 Insert ignore into t2 values ('1st Insert 3.5.5.4');
326 Warnings:
327 Warning 1265 Data truncated for column 'f1' at row 1
328 Select * from t2;
329 f1
330 1st Insert 3.5.
331 use dbtest_one;
332 Insert ignore into dbtest_two.t2 values ('2nd Insert 3.5.5.4');
333 Warnings:
334 Warning 1265 Data truncated for column 'f1' at row 1
335 Select * from dbtest_two.t2 order by f1;
336 f1
337 1st Insert 3.5.
338 2nd Insert 3.5.
339 revoke ALL PRIVILEGES, GRANT OPTION FROM 'test_general'@'localhost';
340 DROP DATABASE if exists dbtest_one;
341 drop database if EXISTS dbtest_two;
342 Warnings:
343 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.
344
345 Testcase 3.5.6:
346 ---------------
347 Warnings:
348 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.
349 use test;
350 Warnings:
351 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.
352
353 Testcase 3.5.6.1 (see Testcase 3.5.1.1)
354 ---------------------------------------
355 Warnings:
356 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.
357 Warnings:
358 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.
359
360 Testcase 3.5.6.2 (see Testcase 3.5.1.1)
361 ---------------------------------------
362 Warnings:
363 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.
364 Warnings:
365 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.
366
367 Testcase 3.5.6.3:
368 -----------------
369 Warnings:
370 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.
371 Create trigger trg3_1 DURING UPDATE on tb3 for each row set new.f132=25;
372 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DURING UPDATE on tb3 for each row set new.f132=25' at line 1
373 Create trigger trg3_2 TIME INSERT on tb3 for each row set new.f132=15;
374 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TIME INSERT on tb3 for each row set new.f132=15' at line 1
375 drop trigger tb3.trg3_1;
376 drop trigger tb3.trg3_2;
377 Warnings:
378 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.
379
380 Testcase 3.5.6.4 (see Testcase 3.5.1.1)
381 ---------------------------------------
382 Warnings:
383 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.
384 Warnings:
385 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.
386
387 Testcase 3.5.6.5 (see Testcase 3.5.1.1)
388 ---------------------------------------
389 Warnings:
390 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.
391 Warnings:
392 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.
393
394 Testcase 3.5.7.1 (see Testcase 3.5.1.1)
395 ---------------------------------------
396 Warnings:
397 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.
398 Warnings:
399 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.
400
401 Testcase 3.5.7.2 (see Testcase 3.5.1.1)
402 ---------------------------------------
403 Warnings:
404 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.
405 Warnings:
406 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.
407
408 Testcase 3.5.7.3 (see Testcase 3.5.1.1)
409 ---------------------------------------
410 Warnings:
411 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.
412 Warnings:
413 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.
414
415 Testcase 3.5.7.4:
416 -----------------
417 Warnings:
418 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.
419 Create trigger trg4_1 BEFORE SELECT on tb3 for each row set new.f132=5;
420 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT on tb3 for each row set new.f132=5' at line 1
421 Create trigger trg4_2 AFTER VALUE on tb3 for each row set new.f132=1;
422 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VALUE on tb3 for each row set new.f132=1' at line 1
423 drop trigger tb3.trg4_1;
424 drop trigger tb3.trg4_2;
425 Warnings:
426 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.
427
428 Testcase 3.5.7.17 (see Testcase 3.5.1.1)
429 ----------------------------------------
430 Warnings:
431 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.
432 drop user test_general@localhost;
433 drop user test_general;
434 drop user test_super@localhost;
435 DROP TABLE test.tb3;