436 lines
24 KiB
Plaintext
436 lines
24 KiB
Plaintext
SET @@session.sql_mode = 'NO_ENGINE_SUBSTITUTION';
|
|
USE test;
|
|
drop table if exists tb3;
|
|
create table tb3 (
|
|
f118 char not null DEFAULT 'a',
|
|
f119 char binary not null DEFAULT b'101',
|
|
f120 char ascii not null DEFAULT b'101',
|
|
f121 char(50),
|
|
f122 char(50),
|
|
f129 binary not null DEFAULT b'101',
|
|
f130 tinyint not null DEFAULT 99,
|
|
f131 tinyint unsigned not null DEFAULT 99,
|
|
f132 tinyint zerofill not null DEFAULT 99,
|
|
f133 tinyint unsigned zerofill not null DEFAULT 99,
|
|
f134 smallint not null DEFAULT 999,
|
|
f135 smallint unsigned not null DEFAULT 999,
|
|
f136 smallint zerofill not null DEFAULT 999,
|
|
f137 smallint unsigned zerofill not null DEFAULT 999,
|
|
f138 mediumint not null DEFAULT 9999,
|
|
f139 mediumint unsigned not null DEFAULT 9999,
|
|
f140 mediumint zerofill not null DEFAULT 9999,
|
|
f141 mediumint unsigned zerofill not null DEFAULT 9999,
|
|
f142 int not null DEFAULT 99999,
|
|
f143 int unsigned not null DEFAULT 99999,
|
|
f144 int zerofill not null DEFAULT 99999,
|
|
f145 int unsigned zerofill not null DEFAULT 99999,
|
|
f146 bigint not null DEFAULT 999999,
|
|
f147 bigint unsigned not null DEFAULT 999999,
|
|
f148 bigint zerofill not null DEFAULT 999999,
|
|
f149 bigint unsigned zerofill not null DEFAULT 999999,
|
|
f150 decimal not null DEFAULT 999.999,
|
|
f151 decimal unsigned not null DEFAULT 999.17,
|
|
f152 decimal zerofill not null DEFAULT 999.999,
|
|
f153 decimal unsigned zerofill,
|
|
f154 decimal (0),
|
|
f155 decimal (64),
|
|
f156 decimal (0) unsigned,
|
|
f157 decimal (64) unsigned,
|
|
f158 decimal (0) zerofill,
|
|
f159 decimal (64) zerofill,
|
|
f160 decimal (0) unsigned zerofill,
|
|
f161 decimal (64) unsigned zerofill,
|
|
f162 decimal (0,0),
|
|
f163 decimal (63,30),
|
|
f164 decimal (0,0) unsigned,
|
|
f165 decimal (63,30) unsigned,
|
|
f166 decimal (0,0) zerofill,
|
|
f167 decimal (63,30) zerofill,
|
|
f168 decimal (0,0) unsigned zerofill,
|
|
f169 decimal (63,30) unsigned zerofill,
|
|
f170 numeric,
|
|
f171 numeric unsigned,
|
|
f172 numeric zerofill,
|
|
f173 numeric unsigned zerofill,
|
|
f174 numeric (0),
|
|
f175 numeric (64)
|
|
) charset latin1 engine = <engine_to_be_used>;
|
|
Warnings:
|
|
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
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
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.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
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.
|
|
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.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
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.
|
|
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.
|
|
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.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
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.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
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.
|
|
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.
|
|
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.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
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.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
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.
|
|
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.
|
|
Warning 1681 UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release.
|
|
Note 1265 Data truncated for column 'f150' at row 1
|
|
Note 1265 Data truncated for column 'f151' at row 1
|
|
Note 1265 Data truncated for column 'f152' at row 1
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase: 3.5:
|
|
--------------
|
|
Warnings:
|
|
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.
|
|
create User test_general@localhost;
|
|
alter user test_general@localhost identified by 'PWD';
|
|
revoke ALL PRIVILEGES, GRANT OPTION FROM test_general@localhost;
|
|
create User test_super@localhost;
|
|
alter user test_super@localhost identified by 'PWD';
|
|
grant ALL on *.* to test_super@localhost with grant OPTION;
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.4:
|
|
---------------
|
|
Warnings:
|
|
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.
|
|
use test;
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.4.1:
|
|
-----------------
|
|
Warnings:
|
|
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.
|
|
create database db_drop;
|
|
Use db_drop;
|
|
create table t1 (f1 char(30)) engine = <engine_to_be_used>;
|
|
create user test_general;
|
|
grant INSERT, SELECT on db_drop.t1 to test_general;
|
|
Use db_drop;
|
|
Create trigger trg1 BEFORE INSERT on t1
|
|
for each row set new.f1='Trigger 3.5.4.1';
|
|
Use db_drop;
|
|
Insert into t1 values ('Insert error 3.5.4.1');
|
|
Select * from t1 order by f1;
|
|
f1
|
|
Trigger 3.5.4.1
|
|
drop trigger trg1;
|
|
select trigger_schema, trigger_name, event_object_table
|
|
from information_schema.triggers
|
|
where trigger_schema = 'db_drop'
|
|
order by trigger_name;
|
|
TRIGGER_SCHEMA TRIGGER_NAME EVENT_OBJECT_TABLE
|
|
Insert into t1 values ('Insert no trigger 3.5.4.1');
|
|
Select * from t1 order by f1;
|
|
f1
|
|
Insert no trigger 3.5.4.1
|
|
Trigger 3.5.4.1
|
|
drop trigger trg1;
|
|
drop database if exists db_drop;
|
|
revoke ALL PRIVILEGES, GRANT OPTION FROM 'test_general'@'localhost';
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.4.2:
|
|
-----------------
|
|
Warnings:
|
|
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.
|
|
create database db_drop2;
|
|
Use db_drop2;
|
|
drop table if exists t1_432 ;
|
|
create table t1_432 (f1 char (30)) engine = <engine_to_be_used>;
|
|
Drop trigger tr_does_not_exit;
|
|
ERROR HY000: Trigger does not exist
|
|
drop table if exists t1_432 ;
|
|
drop database if exists db_drop2;
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.4.3:
|
|
-----------------
|
|
Warnings:
|
|
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.
|
|
create database db_drop3;
|
|
Use db_drop3;
|
|
drop table if exists t1_433 ;
|
|
drop table if exists t1_433a ;
|
|
create table t1_433 (f1 char (30)) engine = <engine_to_be_used>;
|
|
create table t1_433a (f1a char (5)) engine = <engine_to_be_used>;
|
|
CREATE TRIGGER trg3 BEFORE INSERT on t1_433 for each row
|
|
set new.f1 = 'Trigger 3.5.4.3';
|
|
Drop trigger t1.433.trg3;
|
|
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
|
|
Drop trigger db_drop3.t1.433.trg3;
|
|
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
|
|
Drop trigger mysql.trg3;
|
|
ERROR HY000: Trigger does not exist
|
|
Drop trigger tbx.trg3;
|
|
ERROR 42000: Unknown database 'tbx'
|
|
Drop trigger db_drop3.trg3;
|
|
drop table if exists t1_433;
|
|
drop table if exists t1_433a;
|
|
drop database if exists db_drop3;
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.4.4:
|
|
-----------------
|
|
Warnings:
|
|
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.
|
|
create database db_drop4;
|
|
Use db_drop4;
|
|
create table t1 (f1 char(30)) engine = <engine_to_be_used>;
|
|
grant INSERT, SELECT on db_drop4.t1 to test_general;
|
|
Create trigger trg4 BEFORE INSERT on t1
|
|
for each row set new.f1='Trigger 3.5.4.4';
|
|
Use db_drop4;
|
|
Insert into t1 values ('Insert 3.5.4.4');
|
|
Select * from t1;
|
|
f1
|
|
Trigger 3.5.4.4
|
|
Drop database db_drop4;
|
|
Show databases like 'db_drop4';
|
|
Database (db_drop4)
|
|
select trigger_schema, trigger_name, event_object_table
|
|
from information_schema.triggers
|
|
where information_schema.triggers.trigger_name='trg4';
|
|
TRIGGER_SCHEMA TRIGGER_NAME EVENT_OBJECT_TABLE
|
|
create database db_drop4;
|
|
Use db_drop4;
|
|
create table t1 (f1 char(30)) engine = <engine_to_be_used>;
|
|
grant INSERT, SELECT on db_drop4.t1 to test_general;
|
|
Insert into t1 values ('2nd Insert 3.5.4.4');
|
|
Select * from t1;
|
|
f1
|
|
2nd Insert 3.5.4.4
|
|
drop trigger trg4;
|
|
ERROR HY000: Trigger does not exist
|
|
drop database if exists db_drop4;
|
|
revoke ALL PRIVILEGES, GRANT OPTION FROM 'test_general'@'localhost';
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.4.5:
|
|
-----------------
|
|
Warnings:
|
|
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.
|
|
create database db_drop5;
|
|
Use db_drop5;
|
|
create table t1 (f1 char(50)) engine = <engine_to_be_used>;
|
|
grant INSERT, SELECT on t1 to test_general;
|
|
Create trigger trg5 BEFORE INSERT on t1
|
|
for each row set new.f1='Trigger 3.5.4.5';
|
|
Use db_drop5;
|
|
Insert into t1 values ('Insert 3.5.4.5');
|
|
Select * from t1;
|
|
f1
|
|
Trigger 3.5.4.5
|
|
Drop table t1;
|
|
Show tables;
|
|
Tables_in_db_drop5
|
|
select trigger_schema, trigger_name, event_object_table
|
|
from information_schema.triggers
|
|
where information_schema.triggers.trigger_name='trg5';
|
|
TRIGGER_SCHEMA TRIGGER_NAME EVENT_OBJECT_TABLE
|
|
create table t1 (f1 char(50)) engine = <engine_to_be_used>;
|
|
grant INSERT, SELECT on t1 to test_general;
|
|
Insert into t1 values ('2nd Insert 3.5.4.5');
|
|
Select * from t1;
|
|
f1
|
|
2nd Insert 3.5.4.5
|
|
drop trigger trg5;
|
|
ERROR HY000: Trigger does not exist
|
|
drop database if exists db_drop5;
|
|
revoke ALL PRIVILEGES, GRANT OPTION FROM 'test_general'@'localhost';
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.5:
|
|
---------------
|
|
Warnings:
|
|
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.
|
|
use test;
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.5.1:
|
|
-----------------
|
|
Warnings:
|
|
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.
|
|
Create trigger trg1 before INSERT on t100 for each row set new.f2=1000;
|
|
ERROR 42S02: Table 'test.t100' doesn't exist
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.5.2:
|
|
-----------------
|
|
Warnings:
|
|
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.
|
|
Create temporary table t1_temp (f1 bigint signed, f2 bigint unsigned);
|
|
Create trigger trg2 before INSERT
|
|
on t1_temp for each row set new.f2=9999;
|
|
ERROR HY000: Trigger's 't1_temp' is view or temporary table
|
|
drop table t1_temp;
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.5.3:
|
|
-----------------
|
|
Warnings:
|
|
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.
|
|
Create view vw3 as select f118 from tb3;
|
|
Create trigger trg3 before INSERT
|
|
on vw3 for each row set new.f118='s';
|
|
ERROR HY000: 'test.vw3' is not BASE TABLE
|
|
drop view vw3;
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.5.4:
|
|
-----------------
|
|
Warnings:
|
|
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.
|
|
create database dbtest_one;
|
|
create database dbtest_two;
|
|
use dbtest_two;
|
|
create table t2 (f1 char(15)) engine = <engine_to_be_used>;
|
|
use dbtest_one;
|
|
create trigger trg4 before INSERT
|
|
on dbtest_two.t2 for each row set new.f1='trig 3.5.5.4';
|
|
ERROR HY000: Trigger in wrong schema
|
|
grant INSERT, SELECT on dbtest_two.t2 to test_general;
|
|
grant SELECT on dbtest_one.* to test_general;
|
|
use dbtest_two;
|
|
Insert ignore into t2 values ('1st Insert 3.5.5.4');
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'f1' at row 1
|
|
Select * from t2;
|
|
f1
|
|
1st Insert 3.5.
|
|
use dbtest_one;
|
|
Insert ignore into dbtest_two.t2 values ('2nd Insert 3.5.5.4');
|
|
Warnings:
|
|
Warning 1265 Data truncated for column 'f1' at row 1
|
|
Select * from dbtest_two.t2 order by f1;
|
|
f1
|
|
1st Insert 3.5.
|
|
2nd Insert 3.5.
|
|
revoke ALL PRIVILEGES, GRANT OPTION FROM 'test_general'@'localhost';
|
|
DROP DATABASE if exists dbtest_one;
|
|
drop database if EXISTS dbtest_two;
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.6:
|
|
---------------
|
|
Warnings:
|
|
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.
|
|
use test;
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.6.1 (see Testcase 3.5.1.1)
|
|
---------------------------------------
|
|
Warnings:
|
|
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.
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.6.2 (see Testcase 3.5.1.1)
|
|
---------------------------------------
|
|
Warnings:
|
|
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.
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.6.3:
|
|
-----------------
|
|
Warnings:
|
|
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.
|
|
Create trigger trg3_1 DURING UPDATE on tb3 for each row set new.f132=25;
|
|
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
|
|
Create trigger trg3_2 TIME INSERT on tb3 for each row set new.f132=15;
|
|
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
|
|
drop trigger tb3.trg3_1;
|
|
drop trigger tb3.trg3_2;
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.6.4 (see Testcase 3.5.1.1)
|
|
---------------------------------------
|
|
Warnings:
|
|
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.
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.6.5 (see Testcase 3.5.1.1)
|
|
---------------------------------------
|
|
Warnings:
|
|
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.
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.7.1 (see Testcase 3.5.1.1)
|
|
---------------------------------------
|
|
Warnings:
|
|
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.
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.7.2 (see Testcase 3.5.1.1)
|
|
---------------------------------------
|
|
Warnings:
|
|
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.
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.7.3 (see Testcase 3.5.1.1)
|
|
---------------------------------------
|
|
Warnings:
|
|
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.
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.7.4:
|
|
-----------------
|
|
Warnings:
|
|
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.
|
|
Create trigger trg4_1 BEFORE SELECT on tb3 for each row set new.f132=5;
|
|
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
|
|
Create trigger trg4_2 AFTER VALUE on tb3 for each row set new.f132=1;
|
|
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
|
|
drop trigger tb3.trg4_1;
|
|
drop trigger tb3.trg4_2;
|
|
Warnings:
|
|
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.
|
|
|
|
Testcase 3.5.7.17 (see Testcase 3.5.1.1)
|
|
----------------------------------------
|
|
Warnings:
|
|
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.
|
|
drop user test_general@localhost;
|
|
drop user test_general;
|
|
drop user test_super@localhost;
|
|
DROP TABLE test.tb3;
|