Debian Codegraph @

mysql-test/suite/funcs_1/r/myisam_trig_0407.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 Warnings:
99 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.
100
101 Testcase: 3.5:
102 --------------
103 Warnings:
104 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.
105 create User test_general@localhost;
106 alter user test_general@localhost identified by 'PWD';
107 revoke ALL PRIVILEGES, GRANT OPTION FROM test_general@localhost;
108 create User test_super@localhost;
109 alter user test_super@localhost identified by 'PWD';
110 grant ALL on *.* to test_super@localhost with grant OPTION;
111 Warnings:
112 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.
113
114 Testcase 3.5.4:
115 ---------------
116 Warnings:
117 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.
118 use test;
119 Warnings:
120 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.
121
122 Testcase 3.5.4.1:
123 -----------------
124 Warnings:
125 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.
126 create database db_drop;
127 Use db_drop;
128 create table t1 (f1 char(30)) engine = <engine_to_be_used>;
129 create user test_general;
130 grant INSERT, SELECT on db_drop.t1 to test_general;
131 Use db_drop;
132 Create trigger trg1 BEFORE INSERT on t1
133 for each row set new.f1='Trigger 3.5.4.1';
134 Use db_drop;
135 Insert into t1 values ('Insert error 3.5.4.1');
136 Select * from t1 order by f1;
137 f1
138 Trigger 3.5.4.1
139 drop trigger trg1;
140 select trigger_schema, trigger_name, event_object_table
141 from information_schema.triggers
142 where trigger_schema = 'db_drop'
143 order by trigger_name;
144 TRIGGER_SCHEMA TRIGGER_NAME EVENT_OBJECT_TABLE
145 Insert into t1 values ('Insert no trigger 3.5.4.1');
146 Select * from t1 order by f1;
147 f1
148 Insert no trigger 3.5.4.1
149 Trigger 3.5.4.1
150 drop trigger trg1;
151 drop database if exists db_drop;
152 revoke ALL PRIVILEGES, GRANT OPTION FROM 'test_general'@'localhost';
153 Warnings:
154 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.
155
156 Testcase 3.5.4.2:
157 -----------------
158 Warnings:
159 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.
160 create database db_drop2;
161 Use db_drop2;
162 drop table if exists t1_432 ;
163 create table t1_432 (f1 char (30)) engine = <engine_to_be_used>;
164 Drop trigger tr_does_not_exit;
165 ERROR HY000: Trigger does not exist
166 drop table if exists t1_432 ;
167 drop database if exists db_drop2;
168 Warnings:
169 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.
170
171 Testcase 3.5.4.3:
172 -----------------
173 Warnings:
174 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.
175 create database db_drop3;
176 Use db_drop3;
177 drop table if exists t1_433 ;
178 drop table if exists t1_433a ;
179 create table t1_433 (f1 char (30)) engine = <engine_to_be_used>;
180 create table t1_433a (f1a char (5)) engine = <engine_to_be_used>;
181 CREATE TRIGGER trg3 BEFORE INSERT on t1_433 for each row
182 set new.f1 = 'Trigger 3.5.4.3';
183 Drop trigger t1.433.trg3;
184 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
185 Drop trigger db_drop3.t1.433.trg3;
186 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
187 Drop trigger mysql.trg3;
188 ERROR HY000: Trigger does not exist
189 Drop trigger tbx.trg3;
190 ERROR 42000: Unknown database 'tbx'
191 Drop trigger db_drop3.trg3;
192 drop table if exists t1_433;
193 drop table if exists t1_433a;
194 drop database if exists db_drop3;
195 Warnings:
196 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.
197
198 Testcase 3.5.4.4:
199 -----------------
200 Warnings:
201 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.
202 create database db_drop4;
203 Use db_drop4;
204 create table t1 (f1 char(30)) engine = <engine_to_be_used>;
205 grant INSERT, SELECT on db_drop4.t1 to test_general;
206 Create trigger trg4 BEFORE INSERT on t1
207 for each row set new.f1='Trigger 3.5.4.4';
208 Use db_drop4;
209 Insert into t1 values ('Insert 3.5.4.4');
210 Select * from t1;
211 f1
212 Trigger 3.5.4.4
213 Drop database db_drop4;
214 Show databases like 'db_drop4';
215 Database (db_drop4)
216 select trigger_schema, trigger_name, event_object_table
217 from information_schema.triggers
218 where information_schema.triggers.trigger_name='trg4';
219 TRIGGER_SCHEMA TRIGGER_NAME EVENT_OBJECT_TABLE
220 create database db_drop4;
221 Use db_drop4;
222 create table t1 (f1 char(30)) engine = <engine_to_be_used>;
223 grant INSERT, SELECT on db_drop4.t1 to test_general;
224 Insert into t1 values ('2nd Insert 3.5.4.4');
225 Select * from t1;
226 f1
227 2nd Insert 3.5.4.4
228 drop trigger trg4;
229 ERROR HY000: Trigger does not exist
230 drop database if exists db_drop4;
231 revoke ALL PRIVILEGES, GRANT OPTION FROM 'test_general'@'localhost';
232 Warnings:
233 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.
234
235 Testcase 3.5.4.5:
236 -----------------
237 Warnings:
238 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.
239 create database db_drop5;
240 Use db_drop5;
241 create table t1 (f1 char(50)) engine = <engine_to_be_used>;
242 grant INSERT, SELECT on t1 to test_general;
243 Create trigger trg5 BEFORE INSERT on t1
244 for each row set new.f1='Trigger 3.5.4.5';
245 Use db_drop5;
246 Insert into t1 values ('Insert 3.5.4.5');
247 Select * from t1;
248 f1
249 Trigger 3.5.4.5
250 Drop table t1;
251 Show tables;
252 Tables_in_db_drop5
253 select trigger_schema, trigger_name, event_object_table
254 from information_schema.triggers
255 where information_schema.triggers.trigger_name='trg5';
256 TRIGGER_SCHEMA TRIGGER_NAME EVENT_OBJECT_TABLE
257 create table t1 (f1 char(50)) engine = <engine_to_be_used>;
258 grant INSERT, SELECT on t1 to test_general;
259 Insert into t1 values ('2nd Insert 3.5.4.5');
260 Select * from t1;
261 f1
262 2nd Insert 3.5.4.5
263 drop trigger trg5;
264 ERROR HY000: Trigger does not exist
265 drop database if exists db_drop5;
266 revoke ALL PRIVILEGES, GRANT OPTION FROM 'test_general'@'localhost';
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.5:
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 use test;
275 Warnings:
276 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.
277
278 Testcase 3.5.5.1:
279 -----------------
280 Warnings:
281 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.
282 Create trigger trg1 before INSERT on t100 for each row set new.f2=1000;
283 ERROR 42S02: Table 'test.t100' doesn't exist
284 Warnings:
285 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.
286
287 Testcase 3.5.5.2:
288 -----------------
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 Create temporary table t1_temp (f1 bigint signed, f2 bigint unsigned);
292 Create trigger trg2 before INSERT
293 on t1_temp for each row set new.f2=9999;
294 ERROR HY000: Trigger's 't1_temp' is view or temporary table
295 drop table t1_temp;
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.5.3:
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 view vw3 as select f118 from tb3;
304 Create trigger trg3 before INSERT
305 on vw3 for each row set new.f118='s';
306 ERROR HY000: 'test.vw3' is not BASE TABLE
307 drop view vw3;
308 Warnings:
309 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.
310
311 Testcase 3.5.5.4:
312 -----------------
313 Warnings:
314 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.
315 create database dbtest_one;
316 create database dbtest_two;
317 use dbtest_two;
318 create table t2 (f1 char(15)) engine = <engine_to_be_used>;
319 use dbtest_one;
320 create trigger trg4 before INSERT
321 on dbtest_two.t2 for each row set new.f1='trig 3.5.5.4';
322 ERROR HY000: Trigger in wrong schema
323 grant INSERT, SELECT on dbtest_two.t2 to test_general;
324 grant SELECT on dbtest_one.* to test_general;
325 use dbtest_two;
326 Insert ignore into t2 values ('1st Insert 3.5.5.4');
327 Warnings:
328 Warning 1265 Data truncated for column 'f1' at row 1
329 Select * from t2;
330 f1
331 1st Insert 3.5.
332 use dbtest_one;
333 Insert ignore into dbtest_two.t2 values ('2nd Insert 3.5.5.4');
334 Warnings:
335 Warning 1265 Data truncated for column 'f1' at row 1
336 Select * from dbtest_two.t2 order by f1;
337 f1
338 1st Insert 3.5.
339 2nd Insert 3.5.
340 revoke ALL PRIVILEGES, GRANT OPTION FROM 'test_general'@'localhost';
341 DROP DATABASE if exists dbtest_one;
342 drop database if EXISTS dbtest_two;
343 Warnings:
344 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.
345
346 Testcase 3.5.6:
347 ---------------
348 Warnings:
349 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.
350 use test;
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.6.1 (see Testcase 3.5.1.1)
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 Warnings:
359 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.
360
361 Testcase 3.5.6.2 (see Testcase 3.5.1.1)
362 ---------------------------------------
363 Warnings:
364 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.
365 Warnings:
366 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.
367
368 Testcase 3.5.6.3:
369 -----------------
370 Warnings:
371 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.
372 Create trigger trg3_1 DURING UPDATE on tb3 for each row set new.f132=25;
373 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
374 Create trigger trg3_2 TIME INSERT on tb3 for each row set new.f132=15;
375 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
376 drop trigger tb3.trg3_1;
377 drop trigger tb3.trg3_2;
378 Warnings:
379 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.
380
381 Testcase 3.5.6.4 (see Testcase 3.5.1.1)
382 ---------------------------------------
383 Warnings:
384 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.
385 Warnings:
386 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.
387
388 Testcase 3.5.6.5 (see Testcase 3.5.1.1)
389 ---------------------------------------
390 Warnings:
391 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.
392 Warnings:
393 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.
394
395 Testcase 3.5.7.1 (see Testcase 3.5.1.1)
396 ---------------------------------------
397 Warnings:
398 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.
399 Warnings:
400 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.
401
402 Testcase 3.5.7.2 (see Testcase 3.5.1.1)
403 ---------------------------------------
404 Warnings:
405 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.
406 Warnings:
407 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.
408
409 Testcase 3.5.7.3 (see Testcase 3.5.1.1)
410 ---------------------------------------
411 Warnings:
412 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.
413 Warnings:
414 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.
415
416 Testcase 3.5.7.4:
417 -----------------
418 Warnings:
419 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.
420 Create trigger trg4_1 BEFORE SELECT on tb3 for each row set new.f132=5;
421 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
422 Create trigger trg4_2 AFTER VALUE on tb3 for each row set new.f132=1;
423 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
424 drop trigger tb3.trg4_1;
425 drop trigger tb3.trg4_2;
426 Warnings:
427 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.
428
429 Testcase 3.5.7.17 (see Testcase 3.5.1.1)
430 ----------------------------------------
431 Warnings:
432 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.
433 drop user test_general@localhost;
434 drop user test_general;
435 drop user test_super@localhost;
436 DROP TABLE test.tb3;