Debian Codegraph @

mysql-test/suite/rpl/r/rpl_tablespace_without_datafile_option.result

raw
1 #
2 # WL#12236 CREATE TABLESPACE without DATAFILE clause
3 #
4 include/master-slave.inc
5 Warnings:
6 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
7 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
8 [connection master]
9 #
10 # Create a tablespace without DATAFILE on master
11 # and make sure the tablespace is replicated on slave
12 #
13 CREATE TABLESPACE ts ENGINE=InnoDB;
14 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b INT) ENGINE=InnoDB TABLESPACE=ts;
15 INSERT INTO t1 VALUES(1, 1), (2, 2), (3, 3), (4, 4), (5, 5);
16 include/sync_slave_sql_with_master.inc
17 SHOW CREATE TABLE t1;
18 Table Create Table
19 t1 CREATE TABLE `t1` (
20 `a` int NOT NULL AUTO_INCREMENT,
21 `b` int DEFAULT NULL,
22 PRIMARY KEY (`a`)
23 ) /*!50100 TABLESPACE `ts` */ ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
24 SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME LIKE 'ts%';
25 NAME
26 ts
27 include/diff_tables.inc [master:test.t1,slave:test.t1]
28 [connection master]
29 DROP TABLE t1;
30 DROP TABLESPACE ts;
31 include/sync_slave_sql_with_master.inc
32 include/rpl_end.inc