Debian Codegraph @

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

raw
1 SET @save_stats_persistent = @@GLOBAL.innodb_stats_persistent;
2 SET GLOBAL innodb_stats_persistent = 0;
3 SET @old_instant=
4 (SELECT variable_value FROM information_schema.global_status
5 WHERE variable_name = 'innodb_instant_alter_column');
6 CREATE TABLE t1 (
7 pk INT AUTO_INCREMENT PRIMARY KEY,
8 c1 INT,
9 c2 VARCHAR(255),
10 c3 VARCHAR(255),
11 c4 INT,
12 c5 INT,
13 c6 INT,
14 c7 VARCHAR(255),
15 c8 TIMESTAMP NULL
16 ) ENGINE=InnoDB;
17 INSERT INTO t1 VALUES (NULL,1,NULL,'foo',NULL,1,NULL,NULL,'2011-11-11 00:00:00');
18 ALTER TABLE t1 ADD COLUMN f INT;
19 REPLACE INTO t1 (c7) VALUES ('bar');
20 CREATE TABLE t2 (i INT PRIMARY KEY) ENGINE=InnoDB;
21 INSERT INTO t2 VALUES (-1),(1);
22 ALTER TABLE t2 ADD COLUMN j INT;
23 BEGIN;
24 DELETE FROM t2;
25 ROLLBACK;
26 TRUNCATE TABLE t2;
27 INSERT INTO t2 VALUES (1,2);
28 CREATE TABLE t3 (pk INT AUTO_INCREMENT PRIMARY KEY) ENGINE=InnoDB;
29 INSERT INTO t3 () VALUES ();
30 ALTER TABLE t3 ADD COLUMN f INT;
31 UPDATE t3 SET pk = DEFAULT;
32 SELECT * FROM t3;
33 pk f
34 0 NULL
35 CREATE TABLE t4 (pk INT PRIMARY KEY) ENGINE=InnoDB;
36 INSERT INTO t4 VALUES (0);
37 ALTER TABLE t4 ADD COLUMN b INT;
38 SELECT COUNT(*)>0 FROM INFORMATION_SCHEMA.COLUMNS
39 LEFT JOIN t4 ON (NUMERIC_SCALE = pk);
40 COUNT(*)>0
41 1
42 ALTER TABLE t4 ADD COLUMN c INT;
43 CREATE TABLE t5 (i INT, KEY(i)) ENGINE=InnoDB;
44 INSERT INTO t5 VALUES (-42);
45 ALTER TABLE t5 ADD UNIQUE ui(i);
46 ALTER TABLE t5 ADD COLUMN i2 INT, DROP INDEX i;
47 CREATE TABLE t6 (i INT NOT NULL) ENGINE=InnoDB;
48 INSERT INTO t6 VALUES (0);
49 ALTER TABLE t6 ADD COLUMN j INT;
50 TRUNCATE TABLE t6;
51 INSERT INTO t6 VALUES (1,2);
52 CREATE TABLE t7 (i INT) ENGINE=InnoDB;
53 INSERT INTO t7 VALUES (1),(2),(3),(4),(5);
54 ALTER TABLE t7 ADD t TEXT DEFAULT '';
55 CREATE TABLE t8 (i INT) ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
56 INSERT INTO t8 VALUES (NULL);
57 ALTER TABLE t8 ADD c CHAR(3);
58 SET DEBUG_SYNC='row_log_table_apply1_before SIGNAL rebuilt WAIT_FOR dml';
59 ALTER TABLE t8 FORCE;
60 connect dml,localhost,root,,;
61 SET DEBUG_SYNC='now WAIT_FOR rebuilt';
62 BEGIN;
63 INSERT INTO t8 SET i=1;
64 UPDATE t8 SET i=ISNULL(i);
65 ROLLBACK;
66 SET DEBUG_SYNC='now SIGNAL dml';
67 connection default;
68 SET DEBUG_SYNC='RESET';
69 CREATE TABLE t9 (
70 pk INT AUTO_INCREMENT PRIMARY KEY,
71 c1 BIGINT UNSIGNED,
72 c2 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
73 c3 BIGINT,
74 c4 VARCHAR(257) CHARACTER SET utf8,
75 c5 TINYINT UNSIGNED,
76 c6 TINYINT,
77 c7 VARCHAR(257) CHARACTER SET latin1,
78 c8 VARCHAR(257) CHARACTER SET binary
79 ) ENGINE=InnoDB;
80 INSERT INTO t9 () VALUES ();
81 ALTER TABLE t9 ADD COLUMN IF NOT EXISTS t TIMESTAMP NULL;
82 SET DEBUG_SYNC='row_log_table_apply1_before SIGNAL rebuilt WAIT_FOR dml';
83 OPTIMIZE TABLE t9;
84 connection dml;
85 SET DEBUG_SYNC='now WAIT_FOR rebuilt';
86 BEGIN;
87 INSERT INTO t9 () VALUES (),();
88 UPDATE t9 SET t=current_timestamp();
89 ROLLBACK;
90 SET DEBUG_SYNC='now SIGNAL dml';
91 disconnect dml;
92 connection default;
93 Table Op Msg_type Msg_text
94 test.t9 optimize note Table does not support optimize, doing recreate + analyze instead
95 test.t9 optimize status OK
96 SET DEBUG_SYNC='RESET';
97 CREATE TABLE t10 (pk INT DEFAULT 0 KEY) ENGINE=InnoDB;
98 INSERT INTO t10 (pk) VALUES (1);
99 ALTER TABLE t10 ADD c INT;
100 TRUNCATE TABLE t10;
101 INSERT INTO t10 VALUES (1,1),(2,2);
102 ALTER TABLE t10 FORCE;
103 CREATE TABLE t11 (
104 c01 enum('a','b'),
105 c02 bit,
106 c03 blob,
107 c04 enum('c','d'),
108 c05 blob,
109 c06 decimal,
110 c07 char(1),
111 c08 int,
112 c09 char(1),
113 c10 set('e','f'),
114 c11 char(1),
115 c12 float,
116 c13 bit,
117 c14 char(1),
118 c15 int,
119 c16 float,
120 c17 decimal,
121 c18 char(1) CHARACTER SET utf8 not null default '',
122 c19 float,
123 c20 set('g','h'),
124 c21 char(1),
125 c22 int,
126 c23 int,
127 c24 int,
128 c25 set('i','j'),
129 c26 decimal,
130 c27 float,
131 c28 char(1),
132 c29 int,
133 c30 enum('k','l'),
134 c31 decimal,
135 c32 char(1),
136 c33 decimal,
137 c34 bit,
138 c35 enum('m','n'),
139 c36 set('o','p'),
140 c37 enum('q','r'),
141 c38 blob,
142 c39 decimal,
143 c40 blob not null default '',
144 c41 char(1),
145 c42 int,
146 c43 float,
147 c44 float,
148 c45 enum('s','t'),
149 c46 decimal,
150 c47 set('u','v'),
151 c48 enum('w','x'),
152 c49 set('y','z'),
153 c50 float
154 ) ENGINE=InnoDB;
155 INSERT INTO t11 () VALUES ();
156 ALTER TABLE t11 ADD COLUMN f INT;
157 INSERT INTO t11 () VALUES ();
158 UPDATE t11 SET c22 = 1;
159 InnoDB 0 transactions not purged
160 DROP TABLE t1,t2,t3,t4,t5,t6,t7,t8,t9,t10,t11;
161 #
162 # MDEV-15060 Assertion in row_log_table_apply_op after instant ADD
163 # when the table is emptied during subsequent ALTER TABLE
164 #
165 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
166 INSERT INTO t1 VALUES (NULL);
167 ALTER TABLE t1 ADD COLUMN b INT NOT NULL;
168 connect stop_purge,localhost,root;
169 START TRANSACTION WITH CONSISTENT SNAPSHOT;
170 connect ddl,localhost,root,,test;
171 DELETE FROM t1;
172 INSERT INTO t1 VALUES(1, 2);
173 SET DEBUG_SYNC='row_log_table_apply1_before SIGNAL copied WAIT_FOR logged';
174 ALTER TABLE t1 FORCE;
175 connection default;
176 SET DEBUG_SYNC='now WAIT_FOR copied';
177 BEGIN;
178 INSERT INTO t1 SET b=1;
179 ROLLBACK;
180 connection stop_purge;
181 COMMIT;
182 connection default;
183 InnoDB 1 transactions not purged
184 SET DEBUG_SYNC='now SIGNAL logged';
185 connection ddl;
186 connection default;
187 DROP TABLE t1;
188 SET DEBUG_SYNC='RESET';
189 #
190 # MDEV-16131 Assertion failed in dict_index_t::instant_field_value()
191 #
192 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
193 INSERT INTO t1 SET a=0;
194 ALTER TABLE t1 ADD COLUMN b INT NOT NULL DEFAULT 2, ADD COLUMN c INT;
195 BEGIN NOT ATOMIC
196 DECLARE c TEXT DEFAULT(SELECT CONCAT('ALTER TABLE t1 ADD (c',
197 GROUP_CONCAT(seq SEPARATOR ' INT, c'), ' INT), ALGORITHM=INSTANT;') FROM seq_1_to_130);
198 EXECUTE IMMEDIATE c;
199 END;
200 $$
201 connection stop_purge;
202 START TRANSACTION WITH CONSISTENT SNAPSHOT;
203 connection default;
204 DELETE FROM t1;
205 connection ddl;
206 SET DEBUG_SYNC='row_log_table_apply1_before SIGNAL copied WAIT_FOR logged';
207 ALTER TABLE t1 FORCE;
208 connection default;
209 SET DEBUG_SYNC = 'now WAIT_FOR copied';
210 connection stop_purge;
211 COMMIT;
212 connection default;
213 InnoDB 1 transactions not purged
214 INSERT INTO t1 SET a=1;
215 INSERT INTO t1 SET a=2,b=3,c=4;
216 SET DEBUG_SYNC = 'now SIGNAL logged';
217 connection ddl;
218 connection default;
219 SET DEBUG_SYNC = RESET;
220 SELECT a, b, c FROM t1;
221 a b c
222 1 2 NULL
223 2 3 4
224 ALTER TABLE t1 DROP b, ALGORITHM=INSTANT;
225 connection stop_purge;
226 START TRANSACTION WITH CONSISTENT SNAPSHOT;
227 connection default;
228 DELETE FROM t1;
229 connection ddl;
230 SET DEBUG_SYNC='row_log_table_apply1_before SIGNAL copied WAIT_FOR logged';
231 ALTER TABLE t1 ADD COLUMN b INT NOT NULL DEFAULT 2 AFTER a, FORCE;
232 connection default;
233 SET DEBUG_SYNC = 'now WAIT_FOR copied';
234 disconnect stop_purge;
235 InnoDB 1 transactions not purged
236 INSERT INTO t1 SET a=1;
237 INSERT INTO t1 SET a=2,c=4;
238 SET DEBUG_SYNC = 'now SIGNAL logged';
239 connection ddl;
240 UPDATE t1 SET b = b + 1 WHERE a = 2;
241 connection default;
242 SET DEBUG_SYNC = RESET;
243 SELECT a, b, c FROM t1;
244 a b c
245 1 2 NULL
246 2 3 4
247 #
248 # MDEV-15872 Crash in online ALTER TABLE...ADD PRIMARY KEY
249 # after instant ADD COLUMN ... NULL
250 #
251 ALTER TABLE t1 ADD COLUMN d INT, ALGORITHM=INSTANT;
252 UPDATE t1 SET d=1;
253 connection ddl;
254 SET DEBUG_SYNC='row_log_table_apply1_before SIGNAL copied WAIT_FOR logged';
255 ALTER TABLE t1 DROP PRIMARY KEY, ADD PRIMARY KEY (a,d);
256 connection default;
257 SET DEBUG_SYNC = 'now WAIT_FOR copied';
258 BEGIN;
259 INSERT INTO t1 SET a=3;
260 ROLLBACK;
261 SET DEBUG_SYNC = 'now SIGNAL logged';
262 connection ddl;
263 disconnect ddl;
264 connection default;
265 SET DEBUG_SYNC = RESET;
266 SELECT a, b, c, d FROM t1;
267 a b c d
268 1 2 NULL 1
269 2 3 4 1
270 DROP TABLE t1;
271 #
272 # MDEV-19916 Corruption after instant ADD/DROP and shrinking the tree
273 #
274 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
275 SET @old_limit = @@innodb_limit_optimistic_insert_debug;
276 SET GLOBAL innodb_limit_optimistic_insert_debug = 2;
277 INSERT INTO t1 VALUES (1),(5),(4),(3),(2);
278 SET GLOBAL innodb_limit_optimistic_insert_debug = @old_limit;
279 ALTER TABLE t1 ADD COLUMN b INT, ALGORITHM=INSTANT;
280 ALTER TABLE t1 ADD vb INT AS (b) VIRTUAL;
281 CHECK TABLE t1;
282 Table Op Msg_type Msg_text
283 test.t1 check status OK
284 SELECT * FROM t1;
285 a b vb
286 1 NULL NULL
287 2 NULL NULL
288 3 NULL NULL
289 4 NULL NULL
290 5 NULL NULL
291 DROP TABLE t1;
292 #
293 # MDEV-21045 AddressSanitizer: use-after-poison in mem_heap_dup / row_log_table_get_pk_col
294 #
295 CREATE TABLE t1 (a TEXT) ENGINE = InnoDB ROW_FORMAT=REDUNDANT;
296 INSERT INTO t1 (a) VALUES ('foo');
297 ALTER TABLE t1 ADD COLUMN b INT DEFAULT 0,algorithm=instant;
298 connect con2,localhost,root,,test;
299 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL onlinealter WAIT_FOR update';
300 ALTER TABLE t1 ADD PRIMARY KEY (b);
301 connection default;
302 SET DEBUG_SYNC='now WAIT_FOR onlinealter';
303 UPDATE t1 SET b = 1;
304 SET DEBUG_SYNC='now SIGNAL update';
305 connection con2;
306 connection default;
307 DROP TABLE t1;
308 #
309 # MDEV-21658 Error on online ADD PRIMARY KEY after instant DROP/reorder
310 #
311 CREATE TABLE t1 (a INT, b INT, c INT, col INT) ENGINE=InnoDB;
312 INSERT INTO t1 () VALUES ();
313 ALTER TABLE t1 DROP b, DROP c, DROP col;
314 ALTER TABLE t1 ADD COLUMN col INT;
315 ALTER TABLE t1 DROP a, DROP col, ADD COLUMN b INT;
316 connection con2;
317 SET SQL_MODE= '';
318 SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL scanned WAIT_FOR dml';
319 ALTER TABLE t1 ADD PRIMARY KEY(b);
320 connection default;
321 SET DEBUG_SYNC = 'now WAIT_FOR scanned';
322 UPDATE t1 SET b = 1;
323 SET DEBUG_SYNC = 'now SIGNAL dml';
324 connection con2;
325 Warnings:
326 Warning 1265 Data truncated for column 'b' at row 1
327 connection default;
328 SELECT * FROM t1;
329 b
330 1
331 SET DEBUG_SYNC='RESET';
332 disconnect con2;
333 DROP TABLE t1;
334 #
335 # MDEV-24653 Assertion block->page.id.page_no() == index->page failed
336 # in innobase_add_instant_try()
337 #
338 SET @saved_limit = @@GLOBAL.innodb_limit_optimistic_insert_debug;
339 SET GLOBAL innodb_limit_optimistic_insert_debug = 2;
340 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
341 INSERT INTO t1 VALUES (1),(2),(3),(4);
342 ALTER TABLE t1 ADD COLUMN b INT;
343 DELETE FROM t1;
344 InnoDB 0 transactions not purged
345 ALTER TABLE t1 ADD COLUMN c INT;
346 SELECT * FROM t1;
347 a b c
348 DROP TABLE t1;
349 SET GLOBAL innodb_limit_optimistic_insert_debug = @saved_limit;
350 #
351 # MDEV-24796 Assertion page_has_next... failed
352 # in btr_pcur_store_position()
353 #
354 CREATE TABLE t1 (c INT KEY) ENGINE=InnoDB;
355 INSERT INTO t1 VALUES(1),(2);
356 SET GLOBAL innodb_limit_optimistic_insert_debug=2;
357 ALTER TABLE t1 ADD COLUMN d INT;
358 DELETE FROM t1;
359 InnoDB 0 transactions not purged
360 SELECT * FROM t1 WHERE c<>1 ORDER BY c DESC;
361 c d
362 DROP TABLE t1;
363 SET GLOBAL innodb_limit_optimistic_insert_debug = @saved_limit;
364 #
365 # MDEV-24620 ASAN heap-buffer-overflow in btr_pcur_restore_position()
366 #
367 CREATE TABLE t1 (a VARCHAR(1) PRIMARY KEY) ENGINE=InnoDB;
368 INSERT INTO t1 VALUES (1);
369 connect stop_purge,localhost,root,,;
370 START TRANSACTION WITH CONSISTENT SNAPSHOT;
371 connection default;
372 ALTER TABLE t1 ADD c INT;
373 BEGIN;
374 DELETE FROM t1;
375 connect dml,localhost,root,,test;
376 SET DEBUG_SYNC='row_mysql_handle_errors SIGNAL s1 WAIT_FOR s2';
377 UPDATE t1 SET c=1;
378 connection default;
379 SET DEBUG_SYNC='now WAIT_FOR s1';
380 COMMIT;
381 connection stop_purge;
382 COMMIT;
383 disconnect stop_purge;
384 connection default;
385 InnoDB 1 transactions not purged
386 SET DEBUG_SYNC='now SIGNAL s2';
387 connection dml;
388 disconnect dml;
389 connection default;
390 InnoDB 0 transactions not purged
391 SET DEBUG_SYNC=RESET;
392 DROP TABLE t1;
393 # End of 10.3 tests
394 #
395 # MDEV-17899 Assertion failures on rollback of instant ADD/DROP
396 # MDEV-18098 Crash after rollback of instant DROP COLUMN
397 #
398 SET @save_dbug = @@SESSION.debug_dbug;
399 SET debug_dbug='+d,ib_commit_inplace_fail_1';
400 CREATE TABLE t1 (a int, b int) ENGINE=InnoDB;
401 INSERT INTO t1 VALUES (1,2);
402 ALTER TABLE t1 DROP COLUMN b;
403 ERROR HY000: Internal error: Injected error!
404 ALTER TABLE t1 DROP COLUMN b;
405 ERROR HY000: Internal error: Injected error!
406 ALTER TABLE t1 ADD COLUMN c INT;
407 ERROR HY000: Internal error: Injected error!
408 SELECT * FROM t1;
409 a b
410 1 2
411 DROP TABLE t1;
412 CREATE TABLE t1 (a int, b int) ENGINE=InnoDB;
413 ALTER TABLE t1 ADD COLUMN c INT;
414 ERROR HY000: Internal error: Injected error!
415 BEGIN;
416 INSERT INTO t1 VALUES(1, 1);
417 ROLLBACK;
418 ALTER TABLE t1 DROP COLUMN b;
419 ERROR HY000: Internal error: Injected error!
420 INSERT INTO t1 values (1,1);
421 SELECT * FROM t1;
422 a b
423 1 1
424 DROP TABLE t1;
425 SET debug_dbug = @save_dbug;
426 #
427 # MDEV-24512 Assertion failed in rec_is_metadata()
428 # in btr_discard_only_page_on_level()
429 #
430 SET @save_limit= @@GLOBAL.innodb_limit_optimistic_insert_debug;
431 SET GLOBAL innodb_limit_optimistic_insert_debug=2;
432 CREATE TABLE t1 (c CHAR(1) UNIQUE) ENGINE=InnoDB;
433 ALTER TABLE t1 ADD c2 INT NOT NULL DEFAULT 0 FIRST;
434 INSERT INTO t1 (c) VALUES ('x'),('d'),('r'),('f'),('y'),('u'),('m'),('d');
435 ERROR 23000: Duplicate entry 'd' for key 'c'
436 SET GLOBAL innodb_limit_optimistic_insert_debug=@save_limit;
437 SELECT * FROM t1;
438 c2 c
439 DROP TABLE t1;
440 #
441 # MDEV-25236 Online log apply fails for ROW_FORMAT=REDUNDANT tables
442 #
443 CREATE TABLE t1
444 (a INT NOT NULL, b INT, c INT, d INT, e INT, f INT, g INT, h INT, i TEXT)
445 ENGINE=InnoDB;
446 INSERT INTO t1 VALUES(1, 2, 3, 4, 5, 6, 7, 8, "test");
447 ALTER TABLE t1 MODIFY a INT NULL;
448 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL alter WAIT_FOR go';
449 ALTER TABLE t1 ADD PRIMARY KEY (a);
450 connect con1,localhost,root,,;
451 set DEBUG_SYNC='now WAIT_FOR alter';
452 BEGIN;
453 INSERT INTO t1 SET a=0, i=REPEAT('1', 10000);
454 ROLLBACK;
455 set DEBUG_SYNC='now SIGNAL go';
456 connection default;
457 SELECT * FROM t1;
458 a b c d e f g h i
459 1 2 3 4 5 6 7 8 test
460 DROP TABLE t1;
461 SET DEBUG_SYNC=RESET;
462 #
463 # MDEV-27962 Instant DDL downgrades the MDL when table is empty
464 #
465 CREATE TABLE t1(f1 INT NOT NULL, f2 INT NOT NULL)ENGINE=InnoDB;
466 SET DEBUG_SYNC="alter_table_inplace_after_lock_downgrade SIGNAL try_insert WAIT_FOR alter_progress";
467 ALTER TABLE t1 ADD INDEX(f1), ADD INDEX(f2);
468 connection con1;
469 SET SESSION lock_wait_timeout=1;
470 SET DEBUG_SYNC="now WAIT_FOR try_insert";
471 INSERT INTO t1 VALUES(1, 2);
472 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
473 SET DEBUG_SYNC="now SIGNAL alter_progress";
474 connection default;
475 DROP TABLE t1;
476 #
477 # MDEV-26198 Assertion `0' failed in row_log_table_apply_op during
478 # ADD PRIMARY KEY or OPTIMIZE TABLE
479 #
480 CREATE TABLE t1(f1 year default null, f2 year default null,
481 f3 text, f4 year default null, f5 year default null,
482 f6 year default null, f7 year default null,
483 f8 year default null)ENGINE=InnoDB;
484 INSERT INTO t1 VALUES(1, 1, 1, 1, 1, 1, 1, 1);
485 ALTER TABLE t1 ADD COLUMN f9 year default null, ALGORITHM=INPLACE;
486 set DEBUG_SYNC="row_log_table_apply1_before SIGNAL con1_insert WAIT_FOR con1_finish";
487 ALTER TABLE t1 ADD COLUMN f10 YEAR DEFAULT NULL, FORCE, ALGORITHM=INPLACE;
488 connection con1;
489 SET DEBUG_SYNC="now WAIT_FOR con1_insert";
490 INSERT IGNORE INTO t1 (f3) VALUES ( 'b' );
491 INSERT IGNORE INTO t1 (f3) VALUES ( 'l' );
492 SET DEBUG_SYNC="now SIGNAL con1_finish";
493 connection default;
494 CHECK TABLE t1;
495 Table Op Msg_type Msg_text
496 test.t1 check status OK
497 DROP TABLE t1;
498 #
499 # MDEV-19044 Alter table corrupts while applying the
500 # modification log
501 #
502 CREATE TABLE t1 (
503 f1 INT,
504 f2 INT,
505 f3 char(19) CHARACTER SET utf8mb3,
506 f4 VARCHAR(500),
507 f5 TEXT)ENGINE=InnoDB;
508 INSERT INTO t1 VALUES(3, 1, REPEAT('a', 2), REPEAT("b", 20),'a');
509 ALTER TABLE t1 ADD COLUMN f6 INT NOT NULL, ALGORITHM=INSTANT;
510 INSERT INTO t1 VALUES(1, 2, REPEAT('InnoDB', 2),
511 REPEAT("MariaDB", 20), REPEAT('a', 8000), 12);
512 INSERT INTO t1 VALUES(1, 2, REPEAT('MYSQL', 2),
513 REPEAT("MariaDB", 20), REPEAT('a', 8000), 12);
514 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL con1_begin WAIT_FOR con1_update';
515 ALTER TABLE t1 MODIFY COLUMN f2 INT NOT NULL, FORCE, ALGORITHM=INPLACE;
516 connection con1;
517 SET DEBUG_SYNC='now WAIT_FOR con1_begin';
518 UPDATE t1 SET f2=204 order by f1 limit 2;
519 SET DEBUG_SYNC='now SIGNAL con1_update';
520 connection default;
521 disconnect con1;
522 SET DEBUG_SYNC=reset;
523 CHECK TABLE t1;
524 Table Op Msg_type Msg_text
525 test.t1 check status OK
526 DROP TABLE t1;
527 # End of 10.4 tests
528 #
529 # MDEV-22867 Assertion instant.n_core_fields == n_core_fields
530 # in dict_index_t::instant_add_field
531 #
532 CREATE TABLE t1 (a INT PRIMARY KEY, b INT UNIQUE) ENGINE=InnoDB;
533 INSERT INTO t1 SET a=1;
534 connect prevent_purge,localhost,root,,;
535 START TRANSACTION WITH CONSISTENT SNAPSHOT;
536 connection default;
537 ALTER TABLE t1 ADD COLUMN c INT;
538 DELETE FROM t1;
539 connect con2,localhost,root,,test;
540 ALTER TABLE t1 DROP b, ADD INDEX(c), ALGORITHM=NOCOPY;
541 ERROR 0A000: ALGORITHM=NOCOPY is not supported for this operation. Try ALGORITHM=INPLACE
542 SET DEBUG_SYNC='innodb_inplace_alter_table_enter SIGNAL ddl WAIT_FOR emptied';
543 ALTER TABLE t1 DROP b;
544 connection default;
545 SET DEBUG_SYNC='now WAIT_FOR ddl';
546 BEGIN;
547 INSERT INTO t1 SET a=1;
548 connection prevent_purge;
549 COMMIT;
550 disconnect prevent_purge;
551 connection default;
552 ROLLBACK;
553 SELECT * FROM t1;
554 a b c
555 SET DEBUG_SYNC='now SIGNAL emptied';
556 connection con2;
557 disconnect con2;
558 connection default;
559 ALTER TABLE t1 DROP c;
560 INSERT INTO t1 VALUES (2),(3),(4);
561 CHECK TABLE t1;
562 Table Op Msg_type Msg_text
563 test.t1 check status OK
564 DROP TABLE t1;
565 SET DEBUG_SYNC=RESET;
566 # End of 10.5 tests
567 SELECT variable_value-@old_instant instants
568 FROM information_schema.global_status
569 WHERE variable_name = 'innodb_instant_alter_column';
570 instants
571 37
572 CREATE TABLE t1(f1 INT, f2 TEXT)ENGINE=InnoDB;
573 INSERT INTO t1 VALUES(1, 'a');
574 ALTER TABLE t1 ADD COLUMN f3 TEXT FIRST;
575 SET STATEMENT DEBUG_DBUG="+d,instant_insert_fail" FOR
576 ALTER TABLE t1 DROP COLUMN f1;
577 ERROR HY000: Internal error: InnoDB: Insert into SYS_COLUMNS failed
578 ALTER TABLE t1 DROP COLUMN f1;
579 CHECK TABLE t1;
580 Table Op Msg_type Msg_text
581 test.t1 check status OK
582 DROP TABLE t1;
583 SET GLOBAL innodb_stats_persistent = @save_stats_persistent;
584 # End of 10.6 tests