Debian Codegraph @

mysql-test/suite/atomic/alter_table_trigger.result

raw
1
2 engine: myisam
3
4
5 query: ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
6
7 crash point: ddl_log_alter_before_rename_triggers
8 t1_trg.TRN
9 t2.MYD
10 t2.MYI
11 t2.TRG
12 t2.frm
13 Table Create Table
14 t2 CREATE TABLE `t2` (
15 `a` int(11) DEFAULT NULL,
16 `b` int(11) DEFAULT NULL,
17 `c` int(11) DEFAULT NULL
18 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='new'
19 count(*)
20 2
21 sum(a)
22 1003
23 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
24 crash point: ddl_log_alter_after_rename_triggers
25 t1_trg.TRN
26 t2.MYD
27 t2.MYI
28 t2.TRG
29 t2.frm
30 Table Create Table
31 t2 CREATE TABLE `t2` (
32 `a` int(11) DEFAULT NULL,
33 `b` int(11) DEFAULT NULL,
34 `c` int(11) DEFAULT NULL
35 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='new'
36 count(*)
37 2
38 sum(a)
39 1003
40 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
41 crash point: ddl_log_alter_after_drop_original_table
42 t1_trg.TRN
43 t2.MYD
44 t2.MYI
45 t2.TRG
46 t2.frm
47 Table Create Table
48 t2 CREATE TABLE `t2` (
49 `a` int(11) DEFAULT NULL,
50 `b` int(11) DEFAULT NULL,
51 `c` int(11) DEFAULT NULL
52 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='new'
53 count(*)
54 2
55 sum(a)
56 1003
57 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 ADD COLUMN c INT, COMMENT "new", rename t2
58
59 query: ALTER TABLE t1 COMMENT "new", rename t2
60
61 crash point: ddl_log_alter_before_rename_triggers
62 t1_trg.TRN
63 t2.MYD
64 t2.MYI
65 t2.TRG
66 t2.frm
67 Table Create Table
68 t2 CREATE TABLE `t2` (
69 `a` int(11) DEFAULT NULL,
70 `b` int(11) DEFAULT NULL
71 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='new'
72 count(*)
73 2
74 sum(a)
75 1003
76 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename t2
77 crash point: ddl_log_alter_after_rename_triggers
78 t1_trg.TRN
79 t2.MYD
80 t2.MYI
81 t2.TRG
82 t2.frm
83 Table Create Table
84 t2 CREATE TABLE `t2` (
85 `a` int(11) DEFAULT NULL,
86 `b` int(11) DEFAULT NULL
87 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='new'
88 count(*)
89 2
90 sum(a)
91 1003
92 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 COMMENT "new", rename t2
93 crash point: ddl_log_alter_after_drop_original_table
94 "No crash!"
95
96 query: ALTER TABLE t1 change column b c int, COMMENT "new", rename t2
97
98 crash point: ddl_log_alter_before_rename_triggers
99 t1_trg.TRN
100 t2.MYD
101 t2.MYI
102 t2.TRG
103 t2.frm
104 Table Create Table
105 t2 CREATE TABLE `t2` (
106 `a` int(11) DEFAULT NULL,
107 `c` int(11) DEFAULT NULL
108 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='new'
109 count(*)
110 2
111 sum(a)
112 1003
113 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column b c int, COMMENT "new", rename t2
114 crash point: ddl_log_alter_after_rename_triggers
115 t1_trg.TRN
116 t2.MYD
117 t2.MYI
118 t2.TRG
119 t2.frm
120 Table Create Table
121 t2 CREATE TABLE `t2` (
122 `a` int(11) DEFAULT NULL,
123 `c` int(11) DEFAULT NULL
124 ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='new'
125 count(*)
126 2
127 sum(a)
128 1003
129 master-bin.000002 # Query # # use `test`; ALTER TABLE t1 change column b c int, COMMENT "new", rename t2
130 crash point: ddl_log_alter_after_drop_original_table
131 "No crash!"