Debian Codegraph @

mysql-test/suite/mariabackup/lock_ddl_per_table.test

raw
1 --source include/have_debug.inc
2 --source include/have_partition.inc
3
4 CREATE TABLE t(i INT) ENGINE INNODB;
5 INSERT INTO t VALUES(1);
6 echo # xtrabackup backup;
7 let $targetdir=$MYSQLTEST_VARDIR/tmp/backup;
8
9 CREATE TABLE `bobby``tables` (id INT, name VARCHAR(50), purchased DATE) ENGINE INNODB PARTITION BY RANGE( YEAR(purchased) ) (
10 PARTITION p0 VALUES LESS THAN (1990),
11 PARTITION p1 VALUES LESS THAN (1995),
12 PARTITION p2 VALUES LESS THAN (2000),
13 PARTITION p3 VALUES LESS THAN (2005)
14 ) ;
15
16 set global innodb_log_checkpoint_now = 1;
17
18 --disable_result_log
19 exec $XTRABACKUP --defaults-file=$MYSQLTEST_VARDIR/my.cnf --backup --parallel=10 --target-dir=$targetdir --lock-ddl-per-table=1 --dbug=+d,check_mdl_lock_works;
20 --enable_result_log
21 DROP TABLE t;
22 DROP TABLE `bobby``tables`;
23 rmdir $targetdir;