1# - Check SHOW CREATE statement; 2 3--echo 4--echo 5 6--replace_column 7 # 7SHOW CREATE TRIGGER trg1| 8--echo 9--replace_column 7 # 10SHOW CREATE TRIGGER trg2| 11--echo 12--replace_column 7 # 13SHOW CREATE TRIGGER mysqltest2.trg3| 14--echo 15--replace_column 7 # 16SHOW CREATE TRIGGER mysqltest2.trg4| 17 18# - Check SHOW statement; 19 20--echo 21--echo 22 23--replace_column 6 # 24SHOW TRIGGERS| 25 26--echo 27 28use mysqltest2| 29 30--echo 31 32--replace_column 6 # 33SHOW TRIGGERS| 34 35use mysqltest1| 36 37# - Check INFORMATION_SCHEMA; 38 39--echo 40--echo 41 42--replace_column 17 CREATED 43SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg1'| 44 45--echo 46--replace_column 17 CREATED 47SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg2'| 48 49--echo 50--replace_column 17 CREATED 51SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg3'| 52 53--echo 54--replace_column 17 CREATED 55SELECT * FROM INFORMATION_SCHEMA.TRIGGERS WHERE trigger_name = 'trg4'| 56 57# - Initialize the used variables (actual values don't matter); 58 59--echo 60--echo 61 62SET @a1 = '1'| 63SET @a2 = '1'| 64SET @a3 = '1'| 65 66SET @b1 = '2'| 67SET @b2 = '2'| 68SET @b3 = '2'| 69 70# - Execute the triggers; 71 72--echo 73--echo 74 75INSERT INTO t1 VALUES(1)| 76 77--echo 78--echo ---> Log: 79--sorted_result 80SELECT msg FROM log| 81 82--echo 83SELECT 84 COLLATION(@a1) AS ca1, 85 COLLATION(@a2) AS ca2, 86 COLLATION(@a3) AS ca3, 87 COLLATION(@b1) AS cb1, 88 COLLATION(@b2) AS cb2, 89 COLLATION(@b3) AS cb3| 90 91--echo 92DELETE FROM log| 93 94--echo 95--echo 96 97INSERT INTO mysqltest2.t1 VALUES(1)| 98 99--echo 100--echo ---> Log: 101--sorted_result 102SELECT msg FROM mysqltest2.log| 103 104--echo 105SELECT 106 COLLATION(@a1) AS ca1, 107 COLLATION(@a2) AS ca2, 108 COLLATION(@a3) AS ca3, 109 COLLATION(@b1) AS cb1, 110 COLLATION(@b2) AS cb2, 111 COLLATION(@b3) AS cb3| 112 113--echo 114DELETE FROM mysqltest2.log| 115