Debian Codegraph @

mysql-test/suite/atomic/create_trigger2.result

raw
1 "position: 1"
2 "position: 2"
3 "position: 3"
4 t1.TRG
5 t1_trg.TRN
6 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
7 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` trigger t1_trg before insert on t1 for each row
8 begin
9 if isnull(new.a) then
10 set new.a:= 1000;
11 end if;
12 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
13 "position: 4"
14 t1.TRG
15 t1_trg.TRN
16 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
17 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` trigger t1_trg before insert on t1 for each row
18 begin
19 if isnull(new.a) then
20 set new.a:= 1000;
21 end if;
22 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
23 "position: 5"
24 t1.TRG
25 t1_trg.TRN
26 t2_trg.TRN
27 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
28 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` trigger t1_trg before insert on t1 for each row
29 begin
30 if isnull(new.a) then
31 set new.a:= 1000;
32 end if;
33 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
34 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
35 t2_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` trigger t2_trg before insert on t1 for each row
36 begin
37 if isnull(new.b) then
38 set new.b:= 2000;
39 end if;
40 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
41 "position: 6"
42 t1.TRG
43 t1_trg.TRN
44 t2_trg.TRN
45 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
46 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` trigger t1_trg before insert on t1 for each row
47 begin
48 if isnull(new.a) then
49 set new.a:= 1000;
50 end if;
51 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
52 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
53 t2_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` trigger t2_trg before insert on t1 for each row
54 begin
55 if isnull(new.b) then
56 set new.b:= 2000;
57 end if;
58 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
59 "position: 7"
60 t1.TRG
61 t1_trg.TRN
62 t2_trg.TRN
63 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
64 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` trigger t1_trg before insert on t1 for each row
65 begin
66 if isnull(new.a) then
67 set new.a:= 1000;
68 end if;
69 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
70 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
71 t2_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` trigger t2_trg before insert on t1 for each row
72 begin
73 if isnull(new.b) then
74 set new.b:= 2000;
75 end if;
76 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
77 "position: 8"
78 t1.TRG
79 t1_trg.TRN
80 t2_trg.TRN
81 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
82 t1_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` trigger t1_trg before insert on t1 for each row
83 begin
84 if isnull(new.a) then
85 set new.a:= 1000;
86 end if;
87 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
88 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
89 t2_trg STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` trigger t2_trg before insert on t1 for each row
90 begin
91 if isnull(new.b) then
92 set new.b:= 3000;
93 end if;
94 end latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #