Debian Codegraph @

mysql-test/suite/rpl/t/rpl_tablespace_without_datafile_option.test

raw
1 --echo #
2 --echo # WL#12236 CREATE TABLESPACE without DATAFILE clause
3 --echo #
4
5 --source include/master-slave.inc
6
7 --echo #
8 --echo # Create a tablespace without DATAFILE on master
9 --echo # and make sure the tablespace is replicated on slave
10 --echo #
11 CREATE TABLESPACE ts ENGINE=InnoDB;
12 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b INT) ENGINE=InnoDB TABLESPACE=ts;
13 INSERT INTO t1 VALUES(1, 1), (2, 2), (3, 3), (4, 4), (5, 5);
14 --source include/sync_slave_sql_with_master.inc
15
16 SHOW CREATE TABLE t1;
17 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME LIKE 'ts%';
18
19 --let $diff_tables=master:test.t1,slave:test.t1
20 --source include/diff_tables.inc
21
22 --source include/rpl_connection_master.inc
23 DROP TABLE t1;
24 DROP TABLESPACE ts;
25 --source include/sync_slave_sql_with_master.inc
26
27 --source include/rpl_end.inc