| 1 |
--- instant_alter_limit.result |
| 2 |
+++ instant_alter_limit,64k.reject |
| 3 |
@@ -44,6 +44,13 @@ |
| 4 |
FROM information_schema.global_status |
| 5 |
WHERE variable_name = 'innodb_instant_alter_column'; |
| 6 |
instants |
| 7 |
-502 |
| 8 |
+506 |
| 9 |
DROP TABLE t; |
| 10 |
+# |
| 11 |
+# MDEV-21787 Alter table failure tries to access uninitialized column |
| 12 |
+# |
| 13 |
+CREATE TABLE t1(f1 INT PRIMARY KEY, f2 TEXT GENERATED ALWAYS AS (SUBSTR(f4, 1, 400)), f3 VARCHAR(500), f4 TEXT)ENGINE=InnoDB ROW_FORMAT=Compact; |
| 14 |
+ALTER TABLE t1 ADD UNIQUE KEY (f2(9)); |
| 15 |
+ALTER TABLE t1 ADD COLUMN f5 TEXT, ALGORITHM=INPLACE; |
| 16 |
+DROP TABLE t1; |
| 17 |
ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci; |