mirror of
https://github.com/MariaDB/server.git
synced 2025-07-08 04:18:14 +02:00

Problem: ======== - InnoDB does consecutive instant alter operation, first instant DDL fails, it fails to reset the old instant information in table during rollback. This lead to consecutive instant alter to have wrong assumption about the exisitng instant column information. Fix: ==== dict_table_t::instant_column(): Duplicate the instant information field of the table. By doing this, InnoDB alter retains the old instant information and reset it during rollback operation
9 lines
253 B
Text
9 lines
253 B
Text
@@ -576,7 +576,7 @@
|
|
FROM information_schema.global_status
|
|
WHERE variable_name = 'innodb_instant_alter_column';
|
|
instants
|
|
-37
|
|
+38
|
|
CREATE TABLE t1(f1 INT, f2 TEXT)ENGINE=InnoDB;
|
|
INSERT INTO t1 VALUES(1, 'a');
|
|
ALTER TABLE t1 ADD COLUMN f3 TEXT FIRST;
|