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