Debian Codegraph @

mysql-test/suite/innodb/r/instant_max_column_crash.result

raw
1 #
2 # Bug: #34378513 : Assertion failure: dict0mem.h:2482:pos < n_def thread 140243300361984
3 #
4 # Create table with 1017 columns
5 call create_table("tb1", 1017);
6 # Generate row version
7 INSERT INTO tb1 (col_1017) VALUES (1);
8 # Keep a copy for other scenarios
9 CREATE TABLE t1 AS SELECT * FROM tb1;
10 CREATE TABLE t2 AS SELECT * FROM tb1;
11 CREATE TABLE t3 AS SELECT * FROM tb1;
12 CREATE TABLE t4 AS SELECT * FROM tb1;
13
14 # 1017 (user cols) + 3 (system cols) = 1020 (MAX_FIELDS_ALLOWED)
15
16 ########################################
17 # Scenario 1: ADD/DROP single column:
18 ########################################
19 # Current: n_def = (user columns + system columns + n_drop_cols)
20 # Current: n_def = 1020 (1017 + 3 + 0)
21 # -----------------------------------------------------------------------
22 # DROP - ADD columns till (n_def + n_col_added < MAX_FIELDS_ALLOWED)
23 # -----------------------------------------------------------------------
24 # DROP COLUMN should pass
25 ALTER TABLE tb1 DROP COLUMN col_1017, ALGORITHM=INSTANT;
26 # Current: n_def = 1020 (1016 + 3 + 1)
27 SELECT TOTAL_ROW_VERSIONS, N_COLS, CURRENT_COLUMN_COUNTS, INITIAL_COLUMN_COUNTS,
28 TOTAL_COLUMN_COUNTS FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME="test/tb1";
29 TOTAL_ROW_VERSIONS N_COLS CURRENT_COLUMN_COUNTS INITIAL_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
30 1 1019 1016 1017 1017
31 # ADD COLUMN should fail
32 ALTER TABLE tb1 ADD COLUMN col_1017 INT, ALGORITHM=INSTANT;
33 ERROR HY000: Column can't be added to 'test/tb1' with ALGORITHM=INSTANT anymore. Please try ALGORITHM=INPLACE/COPY.
34 # DROP COLUMN should still pass
35 ALTER TABLE tb1 DROP COLUMN col_1016, ALGORITHM=INSTANT;
36 # Current: n_def = 1020 (1015 + 3 + 2)
37 SELECT TOTAL_ROW_VERSIONS, N_COLS, CURRENT_COLUMN_COUNTS, INITIAL_COLUMN_COUNTS,
38 TOTAL_COLUMN_COUNTS FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME="test/tb1";
39 TOTAL_ROW_VERSIONS N_COLS CURRENT_COLUMN_COUNTS INITIAL_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
40 2 1018 1015 1017 1017
41 # ADD COLUMN should still fail
42 ALTER TABLE tb1 ADD COLUMN col_1017 INT, ALGORITHM=INSTANT;
43 ERROR HY000: Column can't be added to 'test/tb1' with ALGORITHM=INSTANT anymore. Please try ALGORITHM=INPLACE/COPY.
44 # -----------------------------------------------------------------------
45 # Verify that ADD is possible without specifying ALGORITHM
46 # (should fallback to INPLACE)
47 # -----------------------------------------------------------------------
48 # Table is rebuilt when ALGORITHM=INPLACE is used (internally)
49 ALTER TABLE tb1 ADD COLUMN col_1017 INT;
50 # Current: n_def = 1019 (1016 + 3)
51 SELECT TOTAL_ROW_VERSIONS, N_COLS, CURRENT_COLUMN_COUNTS, INITIAL_COLUMN_COUNTS,
52 TOTAL_COLUMN_COUNTS FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME="test/tb1";
53 TOTAL_ROW_VERSIONS N_COLS CURRENT_COLUMN_COUNTS INITIAL_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
54 0 1019 1016 1016 1016
55 # Cleanup
56 DROP TABLE tb1;
57 ########################################
58 # Scenario 2: ADD/DROP two columns:
59 ########################################
60 # Current: n_def = (user columns + system columns + n_drop_cols)
61 # Current: n_def = 1020 (1017 + 3 + 0)
62 # -----------------------------------------------------------------------
63 # DROP - ADD columns till (n_def + n_col_added < MAX_FIELDS_ALLOWED)
64 # -----------------------------------------------------------------------
65 # DROP COLUMN for 2 columns should pass
66 ALTER TABLE t1
67 DROP COLUMN col_1017,
68 DROP COLUMN col_1016,
69 ALGORITHM=INSTANT;
70 # Current: n_def = 1020 (1015 + 3 + 2)
71 SELECT TOTAL_ROW_VERSIONS, N_COLS, CURRENT_COLUMN_COUNTS, INITIAL_COLUMN_COUNTS,
72 TOTAL_COLUMN_COUNTS FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME="test/t1";
73 TOTAL_ROW_VERSIONS N_COLS CURRENT_COLUMN_COUNTS INITIAL_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
74 1 1018 1015 1017 1017
75 # ADD COLUMN should fail
76 ALTER TABLE t1
77 ADD COLUMN col_1017 INT,
78 ADD COLUMN col_1016 INT,
79 ALGORITHM=INSTANT;
80 ERROR HY000: Column can't be added to 'test/t1' with ALGORITHM=INSTANT anymore. Please try ALGORITHM=INPLACE/COPY.
81 # DROP COLUMN for 2 columns should still pass
82 ALTER TABLE t1
83 DROP COLUMN col_1015,
84 DROP COLUMN col_1014,
85 ALGORITHM=INSTANT;
86 # Current: n_def = 1020 (1013 + 3 + 4)
87 SELECT TOTAL_ROW_VERSIONS, N_COLS, CURRENT_COLUMN_COUNTS, INITIAL_COLUMN_COUNTS,
88 TOTAL_COLUMN_COUNTS FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME="test/t1";
89 TOTAL_ROW_VERSIONS N_COLS CURRENT_COLUMN_COUNTS INITIAL_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
90 2 1016 1013 1017 1017
91 # ADD COLUMN should still fail
92 ALTER TABLE t1
93 ADD COLUMN col_1017 INT,
94 ADD COLUMN col_1016 INT,
95 ALGORITHM=INSTANT;
96 ERROR HY000: Column can't be added to 'test/t1' with ALGORITHM=INSTANT anymore. Please try ALGORITHM=INPLACE/COPY.
97 # -----------------------------------------------------------------------
98 # Verify that ADD is possible without specifying ALGORITHM
99 # (should fallback to INPLACE)
100 # -----------------------------------------------------------------------
101 # Table is rebuilt when ALGORITHM=INPLACE is used (internally)
102 ALTER TABLE t1
103 ADD COLUMN col_1017 INT,
104 ADD COLUMN col_1016 INT;
105 # Current: n_def = 1018 (1015 + 3)
106 SELECT TOTAL_ROW_VERSIONS, N_COLS, CURRENT_COLUMN_COUNTS, INITIAL_COLUMN_COUNTS,
107 TOTAL_COLUMN_COUNTS FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME="test/t1";
108 TOTAL_ROW_VERSIONS N_COLS CURRENT_COLUMN_COUNTS INITIAL_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
109 0 1018 1015 1015 1015
110 # Cleanup
111 DROP TABLE t1;
112 ########################################
113 # Scenario 3: ADD/DROP multiple columns:
114 ########################################
115 # Current: n_def = (user columns + system columns + n_drop_cols)
116 # Current: n_def = 1020 (1017 + 3 + 0)
117 # -----------------------------------------------------------------------
118 # ADD/DROP multiple columns and look for failures
119 # -----------------------------------------------------------------------
120 # DROP multiple columns should pass
121 ALTER TABLE t2
122 DROP COLUMN col_1016,
123 DROP COLUMN col_1015,
124 DROP COLUMN col_1014,
125 DROP COLUMN col_1013,
126 DROP COLUMN col_1012,
127 DROP COLUMN col_1011,
128 ALGORITHM=INSTANT;
129 # Current: n_def = 1020 (1011 + 3 + 6)
130 SELECT TOTAL_ROW_VERSIONS, N_COLS, CURRENT_COLUMN_COUNTS, INITIAL_COLUMN_COUNTS,
131 TOTAL_COLUMN_COUNTS FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME="test/t2";
132 TOTAL_ROW_VERSIONS N_COLS CURRENT_COLUMN_COUNTS INITIAL_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
133 1 1014 1011 1017 1017
134 # ADD COLUMN should fail
135 ALTER TABLE t2
136 ADD COLUMN col_1011 INT,
137 DROP COLUMN col_1010,
138 ADD COLUMN col_1012 INT,
139 ADD COLUMN col_1013 INT,
140 DROP COLUMN col_1009,
141 DROP COLUMN col_1008,
142 ADD COLUMN col_1014 INT,
143 ALGORITHM=INSTANT;
144 ERROR HY000: Column can't be added to 'test/t2' with ALGORITHM=INSTANT anymore. Please try ALGORITHM=INPLACE/COPY.
145 # -----------------------------------------------------------------------
146 # Fallback to inplace for failed query
147 # -----------------------------------------------------------------------
148 ALTER TABLE t2
149 ADD COLUMN col_1011 INT,
150 DROP COLUMN col_1010,
151 ADD COLUMN col_1012 INT,
152 ADD COLUMN col_1013 INT,
153 DROP COLUMN col_1009,
154 DROP COLUMN col_1008,
155 ADD COLUMN col_1014 INT;
156 # Current: n_def = 1018 (1015 + 3 + 0)
157 SELECT TOTAL_ROW_VERSIONS, N_COLS, CURRENT_COLUMN_COUNTS, INITIAL_COLUMN_COUNTS,
158 TOTAL_COLUMN_COUNTS FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME="test/t2";
159 TOTAL_ROW_VERSIONS N_COLS CURRENT_COLUMN_COUNTS INITIAL_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
160 0 1015 1012 1012 1012
161 # Cleanup
162 DROP TABLE t2;
163 ########################################
164 # Scenario 4: With other ALTER operations:
165 ########################################
166 # Current: n_def = (user columns + system columns + n_drop_cols)
167 # Current: n_def = 1020 (1017 + 3 + 0)
168 # -----------------------------------------------------------------------
169 # ADD/DROP with other ALTER operations
170 # -----------------------------------------------------------------------
171 # DROP COLUMN should pass
172 ALTER TABLE t3
173 DROP COLUMN col_1016,
174 DROP COLUMN col_1015,
175 DROP COLUMN col_1014,
176 DROP COLUMN col_1013,
177 DROP COLUMN col_1012,
178 DROP COLUMN col_1011,
179 DROP COLUMN col_1010,
180 DROP COLUMN col_1009,
181 ALGORITHM=INSTANT;
182 Current: n_def = 1020 (1009 + 3 + 8)
183 SELECT TOTAL_ROW_VERSIONS, N_COLS, CURRENT_COLUMN_COUNTS, INITIAL_COLUMN_COUNTS,
184 TOTAL_COLUMN_COUNTS FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME="test/t3";
185 TOTAL_ROW_VERSIONS N_COLS CURRENT_COLUMN_COUNTS INITIAL_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
186 1 1012 1009 1017 1017
187 # ADD COLUMN with other operations should fail
188 ALTER TABLE t3
189 ADD COLUMN col_1009 INT,
190 RENAME COLUMN col_1017 TO col_10177,
191 RENAME COLUMN col_1007 TO col_1007_new,
192 DROP COLUMN col_1008,
193 ALGORITHM=INSTANT;
194 ERROR HY000: Column can't be added to 'test/t3' with ALGORITHM=INSTANT anymore. Please try ALGORITHM=INPLACE/COPY.
195 # ADD COLUMN should fail
196 ALTER TABLE t3 ADD COLUMN col_1010 INT, ALGORITHM=INSTANT;
197 ERROR HY000: Column can't be added to 'test/t3' with ALGORITHM=INSTANT anymore. Please try ALGORITHM=INPLACE/COPY.
198 # Similarly single column add/drop will fail
199 ALTER TABLE t3 ADD COLUMN col_1010 INT, DROP COLUMN col_1008, ALGORITHM=INSTANT;
200 ERROR HY000: Column can't be added to 'test/t3' with ALGORITHM=INSTANT anymore. Please try ALGORITHM=INPLACE/COPY.
201 # -----------------------------------------------------------------------
202 # Fallback to inplace for failed query
203 # -----------------------------------------------------------------------
204 # ADD COLUMN should fallback to INPLACE and should pass
205 ALTER TABLE t3 ADD COLUMN col_1010 INT;
206 Current: n_def = 1013 (1010 + 3 + 0)
207 SELECT TOTAL_ROW_VERSIONS, N_COLS, CURRENT_COLUMN_COUNTS, INITIAL_COLUMN_COUNTS,
208 TOTAL_COLUMN_COUNTS FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME="test/t3";
209 TOTAL_ROW_VERSIONS N_COLS CURRENT_COLUMN_COUNTS INITIAL_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
210 0 1013 1010 1010 1010
211 # Cleanup
212 DROP TABLE t3;
213 ########################################
214 # Scenario 5: ADD/DROP few columns:
215 ########################################
216 # Current: n_def = (user columns + system columns + n_drop_cols)
217 # Current: n_def = 1020 (1017 + 3 + 0)
218 # -----------------------------------------------------------------------
219 # ADD/DROP few columns together
220 # -----------------------------------------------------------------------
221 # DROP COLUMN should pass
222 ALTER TABLE t4
223 DROP COLUMN col_1016,
224 DROP COLUMN col_1015,
225 DROP COLUMN col_1014,
226 DROP COLUMN col_1013,
227 DROP COLUMN col_1012,
228 DROP COLUMN col_1011,
229 DROP COLUMN col_1010,
230 DROP COLUMN col_1009,
231 ALGORITHM=INSTANT;
232 Current: n_def = 1020 (1009 + 3 + 8)
233 SELECT TOTAL_ROW_VERSIONS, N_COLS, CURRENT_COLUMN_COUNTS, INITIAL_COLUMN_COUNTS,
234 TOTAL_COLUMN_COUNTS FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME="test/t4";
235 TOTAL_ROW_VERSIONS N_COLS CURRENT_COLUMN_COUNTS INITIAL_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
236 1 1012 1009 1017 1017
237 # ADD COLUMN should fail
238 ALTER TABLE t4
239 ADD COLUMN col_1016 INT,
240 DROP COLUMN col_1008,
241 ALGORITHM=INSTANT;
242 ERROR HY000: Column can't be added to 'test/t4' with ALGORITHM=INSTANT anymore. Please try ALGORITHM=INPLACE/COPY.
243 # ADD COLUMN should fail
244 ALTER TABLE t4
245 ADD COLUMN col_1015 INT,
246 DROP COLUMN col_1007,
247 DROP COLUMN col_1006,
248 ALGORITHM=INSTANT;
249 ERROR HY000: Column can't be added to 'test/t4' with ALGORITHM=INSTANT anymore. Please try ALGORITHM=INPLACE/COPY.
250 # ADD COLUMN should fail
251 ALTER TABLE t4
252 ADD COLUMN col_1014 INT,
253 ADD COLUMN col_1013 INT,
254 DROP COLUMN col_1005,
255 ALGORITHM=INSTANT;
256 ERROR HY000: Column can't be added to 'test/t4' with ALGORITHM=INSTANT anymore. Please try ALGORITHM=INPLACE/COPY.
257 # -----------------------------------------------------------------------
258 # Fallback to inplace for failed query
259 # -----------------------------------------------------------------------
260 ALTER TABLE t4
261 ADD COLUMN col_1014 INT,
262 ADD COLUMN col_1013 INT,
263 DROP COLUMN col_1005;
264 Current: n_def = 1013 (1010 + 3 + 0)
265 SELECT TOTAL_ROW_VERSIONS, N_COLS, CURRENT_COLUMN_COUNTS, INITIAL_COLUMN_COUNTS,
266 TOTAL_COLUMN_COUNTS FROM INFORMATION_SCHEMA.INNODB_TABLES WHERE NAME="test/t4";
267 TOTAL_ROW_VERSIONS N_COLS CURRENT_COLUMN_COUNTS INITIAL_COLUMN_COUNTS TOTAL_COLUMN_COUNTS
268 0 1013 1010 1010 1010
269 # Cleanup
270 DROP TABLE t4;
271 DROP PROCEDURE create_table;