mirror of
https://github.com/MariaDB/server.git
synced 2025-02-12 00:15:35 +01:00
17 lines
621 B
Text
17 lines
621 B
Text
--- instant_alter_limit.result
|
|
+++ instant_alter_limit,64k.reject
|
|
@@ -44,6 +44,13 @@
|
|
FROM information_schema.global_status
|
|
WHERE variable_name = 'innodb_instant_alter_column';
|
|
instants
|
|
-502
|
|
+506
|
|
DROP TABLE t;
|
|
+#
|
|
+# MDEV-21787 Alter table failure tries to access uninitialized column
|
|
+#
|
|
+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;
|
|
+ALTER TABLE t1 ADD UNIQUE KEY (f2(9));
|
|
+ALTER TABLE t1 ADD COLUMN f5 TEXT, ALGORITHM=INPLACE;
|
|
+DROP TABLE t1;
|
|
ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;
|