28 lines
830 B
Plaintext
28 lines
830 B
Plaintext
--echo #
|
|
--echo # WL#12236 CREATE TABLESPACE without DATAFILE clause
|
|
--echo #
|
|
|
|
--source include/master-slave.inc
|
|
|
|
--echo #
|
|
--echo # Create a tablespace without DATAFILE on master
|
|
--echo # and make sure the tablespace is replicated on slave
|
|
--echo #
|
|
CREATE TABLESPACE ts ENGINE=InnoDB;
|
|
CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b INT) ENGINE=InnoDB TABLESPACE=ts;
|
|
INSERT INTO t1 VALUES(1, 1), (2, 2), (3, 3), (4, 4), (5, 5);
|
|
--source include/sync_slave_sql_with_master.inc
|
|
|
|
SHOW CREATE TABLE t1;
|
|
SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME LIKE 'ts%';
|
|
|
|
--let $diff_tables=master:test.t1,slave:test.t1
|
|
--source include/diff_tables.inc
|
|
|
|
--source include/rpl_connection_master.inc
|
|
DROP TABLE t1;
|
|
DROP TABLESPACE ts;
|
|
--source include/sync_slave_sql_with_master.inc
|
|
|
|
--source include/rpl_end.inc
|