summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb/r/innodb-index-online.result
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2022-08-31 15:58:52 +0300
committerMarko Mäkelä <marko.makela@mariadb.com>2022-08-31 15:58:52 +0300
commit4f2dc716ee95492f58c86e7ee615de55e7ae30f3 (patch)
treeca573cec74cfd51d3910610f3f688de6560caf23 /mysql-test/suite/innodb/r/innodb-index-online.result
parentc487eeed10d2a34d19141c5c3a98fbb38dd26f51 (diff)
downloadmariadb-git-4f2dc716ee95492f58c86e7ee615de55e7ae30f3.tar.gz
MDEV-13668 fixup: Remove test work-arounds
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb-index-online.result')
-rw-r--r--mysql-test/suite/innodb/r/innodb-index-online.result5
1 files changed, 2 insertions, 3 deletions
diff --git a/mysql-test/suite/innodb/r/innodb-index-online.result b/mysql-test/suite/innodb/r/innodb-index-online.result
index a0227d31393..4fd64b5c48a 100644
--- a/mysql-test/suite/innodb/r/innodb-index-online.result
+++ b/mysql-test/suite/innodb/r/innodb-index-online.result
@@ -231,7 +231,7 @@ WHERE variable_name = 'innodb_encryption_n_rowlog_blocks_encrypted');
connection con1;
SET DEBUG_SYNC = 'row_log_apply_before SIGNAL c2e_created WAIT_FOR dml2_done';
SET lock_wait_timeout = 10;
-ALTER TABLE t1 DROP INDEX c2d, ADD INDEX c2e(c2),
+ALTER TABLE t1 CHANGE c2 c22 INT, DROP INDEX c2d, ADD INDEX c2e(c22),
ALGORITHM = INPLACE;
connection default;
INSERT INTO t1 SELECT 80 + c1, c2, c3 FROM t1;
@@ -353,7 +353,7 @@ SET @rowlog_decrypt_1=
WHERE variable_name = 'innodb_encryption_n_rowlog_blocks_decrypted');
connection con1;
SET DEBUG_SYNC = 'row_log_apply_before SIGNAL c2f_created WAIT_FOR dml3_done';
-ALTER TABLE t1 ADD INDEX c2f(c2);
+ALTER TABLE t1 ADD INDEX c2f(c22f), CHANGE c2 c22f INT;
connection default;
SET DEBUG_SYNC = 'now WAIT_FOR c2f_created';
SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
@@ -392,7 +392,6 @@ SET DEBUG_SYNC = 'now SIGNAL dml3_done';
connection con1;
Warnings:
Note 1831 Duplicate index `c2f`. This is deprecated and will be disallowed in a future release
-ALTER TABLE t1 CHANGE c2 c22f INT;
SELECT name, count FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE subsystem = 'ddl';
name count
ddl_background_drop_indexes 0