summaryrefslogtreecommitdiff
path: root/mysql-test/suite/mariabackup/innodb_log_optimize_ddl.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/mariabackup/innodb_log_optimize_ddl.test')
-rw-r--r--mysql-test/suite/mariabackup/innodb_log_optimize_ddl.test47
1 files changed, 0 insertions, 47 deletions
diff --git a/mysql-test/suite/mariabackup/innodb_log_optimize_ddl.test b/mysql-test/suite/mariabackup/innodb_log_optimize_ddl.test
deleted file mode 100644
index d6680bec077..00000000000
--- a/mysql-test/suite/mariabackup/innodb_log_optimize_ddl.test
+++ /dev/null
@@ -1,47 +0,0 @@
-# see unsupported_redo.test for the opposite (default) case
---source include/have_innodb.inc
---source include/have_sequence.inc
-
-SET GLOBAL innodb_log_optimize_ddl=OFF;
-
-CREATE TABLE tz(id BIGINT PRIMARY KEY, i INT)
-ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
-INSERT INTO tz(id) select * from seq_1_to_10000;
-CREATE TABLE tr(id BIGINT PRIMARY KEY, i INT)
-ENGINE=InnoDB ROW_FORMAT=REDUNDANT;
-INSERT INTO tr(id) select * from seq_1_to_10000;
-CREATE TABLE td(id BIGINT PRIMARY KEY, i INT)
-ENGINE=InnoDB;
-INSERT INTO td(id) select * from seq_1_to_10000;
-
-DELIMITER //;
-CREATE PROCEDURE a()
-BEGIN
- ALTER TABLE tz ADD INDEX(i);
- ALTER TABLE tr ADD INDEX(i);
- ALTER TABLE td ADD INDEX(i);
-END //
-DELIMITER ;//
-
-let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
-
-send call a();
-
---disable_result_log
-exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --target-dir=$targetdir;
---enable_result_log
-exec $XTRABACKUP --prepare --target-dir=$targetdir;
-
-reap;
-
--- source include/restart_and_restore.inc
---rmdir $targetdir
-
-DROP PROCEDURE a;
-
-CHECK TABLE tz,tr,td;
-SELECT COUNT(*) FROM tz;
-SELECT COUNT(*) FROM tr;
-SELECT COUNT(*) FROM td;
-
-DROP TABLE tz,tr,td;