Debian Codegraph @

mysql-test/suite/clone/include/remote_basic_replace_across_lts_setup.inc

raw
1 --let $HOST = 127.0.0.1
2 --let $PORT =`select @@port`
3 --let $USER = root
4
5 --let clone_remote_replace = 1
6 --let clone_inst_number = 2
7
8 # Windows does not have mysqld_safe. Skip instance monitoring if windows
9 let $have_windows = `SELECT CONVERT(@@version_compile_os using latin1) IN ("Win32", "Win64", "Windows")`;
10
11 if (!$have_windows) {
12 # After cloning is complete, the server is shutdown. At this point, the
13 # monitoring instance (mysqld_safe in most cases) will automatically restart
14 # the server. See clone_connection_begin.inc where the server is started under
15 # mysqld_safe and state is reset in clone_connection_end.inc
16 --source include/have_mysqld_safe.inc
17 --let inst_monitor = 1
18 }
19
20 --source ../include/clone_connection_begin.inc
21 --source include/count_sessions.inc
22 --let $CLONE_DATADIR = $MYSQL_TMP_DIR/data_new
23
24 --disable_query_log
25 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Non innodb table: .* is not cloned and is empty.");
26 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* Clone removing all user data for provisioning: .*");
27 --enable_query_log
28
29 --echo # Setup the tables
30 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 char(64), FULLTEXT KEY fts_index(col2));
31
32 INSERT INTO t1 VALUES(10, 'clone row 1');
33 INSERT INTO t1 VALUES(20, 'clone row 2');
34 INSERT INTO t1 VALUES(30, 'clone row 3');
35
36 SELECT * from t1 ORDER BY col1;
37
38 # Create MyIsam and CSV tables in common schema
39 CREATE TABLE t_myisam(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=MyISAM;
40 INSERT INTO t_myisam VALUES(10, 'myisam not cloned row 1');
41 SELECT * from t_myisam ORDER BY col1;
42
43 CREATE TABLE t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL) ENGINE=CSV;
44 INSERT INTO t_csv VALUES(10, 'csv not cloned row 1');
45 SELECT * from t_csv ORDER BY col1;
46
47 # Create MyIsam and CSV tables in separate schema
48 CREATE SCHEMA non_innodb;
49 CREATE TABLE non_innodb.t_myisam(col1 INT PRIMARY KEY, col2 char(64)) ENGINE=MyISAM;
50 INSERT INTO non_innodb.t_myisam VALUES(10, 'myisam not cloned row 1');
51 INSERT INTO non_innodb.t_myisam VALUES(20, 'myisam not cloned row 2');
52 INSERT INTO non_innodb.t_myisam VALUES(30, 'myisam not cloned row 3');
53 SELECT * from non_innodb.t_myisam ORDER BY col1;
54
55 CREATE TABLE non_innodb.t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL) ENGINE=CSV;
56 INSERT INTO non_innodb.t_csv VALUES(10, 'csv not cloned row 1');
57 INSERT INTO non_innodb.t_csv VALUES(20, 'csv not cloned row 2');
58 INSERT INTO non_innodb.t_csv VALUES(30, 'csv not cloned row 3');
59 SELECT * from non_innodb.t_csv ORDER BY col1;
60
61 # Create MyIsam, CSV and InnoDB tables in separate schema, set it to read only
62 CREATE SCHEMA schema_read_only;
63 CREATE TABLE schema_read_only.t_myisam(col1 INT PRIMARY KEY, col2 char(64))
64 ENGINE=MyISAM;
65 INSERT INTO schema_read_only.t_myisam VALUES(10, 'myisam not cloned row 1');
66 INSERT INTO schema_read_only.t_myisam VALUES(20, 'myisam not cloned row 2');
67 INSERT INTO schema_read_only.t_myisam VALUES(30, 'myisam not cloned row 3');
68 SELECT * from schema_read_only.t_myisam ORDER BY col1;
69
70 CREATE TABLE schema_read_only.t_csv(col1 INT NOT NULL, col2 char(64) NOT NULL)
71 ENGINE=CSV;
72 INSERT INTO schema_read_only.t_csv VALUES(10, 'csv not cloned row 1');
73 INSERT INTO schema_read_only.t_csv VALUES(20, 'csv not cloned row 2');
74 INSERT INTO schema_read_only.t_csv VALUES(30, 'csv not cloned row 3');
75 SELECT * from schema_read_only.t_csv ORDER BY col1;
76
77 CREATE TABLE schema_read_only.t_innodb(col1 INT PRIMARY KEY, col2 char(64))
78 ENGINE=InnoDB;
79 INSERT INTO schema_read_only.t_innodb VALUES(10, 'innodb cloned row 1');
80 INSERT INTO schema_read_only.t_innodb VALUES(20, 'innodb cloned row 2');
81 INSERT INTO schema_read_only.t_innodb VALUES(30, 'innodb cloned row 3');
82 SELECT * from schema_read_only.t_innodb ORDER BY col1;
83
84 ALTER SCHEMA schema_read_only READ ONLY=1;