Debian Codegraph @

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

raw
1 #############################################################
2 # Author: Serge Kozlov <[email protected]>
3 # Date: 07/01/2008
4 # Purpose: Testing possible affects of some system dynamic
5 # variables to the replication.
6 # Scenario for each variable:
7 # 1) Set different values for master and slave
8 # 2) Create and replicate a data from master to slave
9 # 3) Check results on master and slave: changes on slave
10 # shouldn't be affected to replicated data.
11 #############################################################
12 --source include/not_group_replication_plugin.inc
13 --source include/force_myisam_default.inc
14 --source include/have_myisam.inc
15 --source include/master-slave.inc
16 --echo
17
18 #
19 # AUTO_INCREMENT
20 #
21 --echo * auto_increment_increment, auto_increment_offset *
22
23 --connection master
24 SET @@global.auto_increment_increment=2;
25 SET @@session.auto_increment_increment=2;
26 SET @@global.auto_increment_offset=10;
27 SET @@session.auto_increment_offset=10;
28
29 --connection slave
30 SET @@global.auto_increment_increment=3;
31 SET @@session.auto_increment_increment=3;
32 SET @@global.auto_increment_offset=20;
33 SET @@session.auto_increment_offset=20;
34
35 --connection master
36 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(10)) ENGINE=MyISAM;
37 INSERT INTO t1 (b) VALUES ('master');
38 INSERT INTO t1 (b) VALUES ('master');
39 SELECT * FROM t1 ORDER BY a;
40
41 --source include/sync_slave_sql_with_master.inc
42 CREATE TABLE t2 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(10)) ENGINE=MyISAM;
43 INSERT INTO t1 (b) VALUES ('slave');
44 INSERT INTO t1 (b) VALUES ('slave');
45 INSERT INTO t2 (b) VALUES ('slave');
46 INSERT INTO t2 (b) VALUES ('slave');
47 SELECT * FROM t1 ORDER BY a;SELECT * FROM t2 ORDER BY a;
48
49 --connection master
50 --disable_warnings
51 DROP TABLE IF EXISTS t1,t2;
52 --enable_warnings
53 SET @@global.auto_increment_increment=1;
54 SET @@session.auto_increment_increment=1;
55 SET @@global.auto_increment_offset=1;
56 SET @@session.auto_increment_offset=1;
57
58 --connection slave
59 SET @@global.auto_increment_increment=1;
60 SET @@session.auto_increment_increment=1;
61 SET @@global.auto_increment_offset=1;
62 SET @@session.auto_increment_offset=1;
63
64 --connection slave
65 SET auto_increment_increment=1;
66 SET auto_increment_offset=1;
67 --echo
68
69 #
70 # CHARACTER_SET_DATABASE, COLLATION_SERVER
71 #
72 --echo * character_set_database, collation_server *
73
74 --echo [On Master]
75 --connection master
76 SET @restore_master_character_set_database=@@global.character_set_database;
77 SET @restore_master_collation_server=@@global.collation_server;
78 SET @@global.character_set_database=latin1;
79 SET @@session.character_set_database=latin1;
80 SET @@global.collation_server=latin1_german1_ci;
81 SET @@session.collation_server=latin1_german1_ci;
82
83 --echo [On Slave]
84 --connection slave
85 SET @restore_slave_character_set_database=@@global.character_set_database;
86 SET @restore_slave_collation_server=@@global.collation_server;
87 SET @@global.character_set_database=utf8;
88 SET @@session.character_set_database=utf8;
89 SET @@global.collation_server=utf8_bin;
90 SET @@session.collation_server=utf8_bin;
91
92 --echo [On Master]
93 --connection master
94 CREATE SCHEMA s1;
95 SHOW CREATE SCHEMA s1;
96 CREATE TABLE s1.t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10)) ENGINE=MyISAM;
97 SHOW CREATE TABLE s1.t1;
98
99 --source include/sync_slave_sql_with_master.inc
100
101 --echo [On Slave]
102 CREATE SCHEMA s2;
103 SHOW CREATE SCHEMA s2;
104 CREATE TABLE s1.t2 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10)) ENGINE=MyISAM;
105 CREATE TABLE s2.t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10)) ENGINE=MyISAM;
106 SHOW CREATE TABLE s1.t1;
107 SHOW CREATE TABLE s1.t2;
108 SHOW CREATE TABLE s2.t1;
109 DROP TABLE s2.t1;
110 DROP SCHEMA s2;
111
112 SET @@global.collation_server=latin1_swedish_ci;
113 SET @@session.collation_server=latin1_swedish_ci;
114
115 --echo [On Master]
116 --connection master
117 SET @@global.collation_server=latin1_swedish_ci;
118 SET @@session.collation_server=latin1_swedish_ci;
119
120 --disable_warnings
121 DROP TABLE IF EXISTS s1.t1,s1.t2;
122 DROP SCHEMA s1;
123 --enable_warnings
124 --echo
125
126 #
127 # DEFAULT_WEEK_FORMAT
128 #
129 --echo * default_week_format *
130
131 --connection master
132 SET @@global.default_week_format=0;
133 SET @@session.default_week_format=0;
134
135 --connection slave
136 SET @@global.default_week_format=1;
137 SET @@session.default_week_format=1;
138
139 --connection master
140 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10), c INT) ENGINE=MyISAM;
141 INSERT INTO t1 VALUES (1, 'master ', WEEK('2008-01-07'));
142 SELECT * FROM t1 ORDER BY a;
143
144 --source include/sync_slave_sql_with_master.inc
145 INSERT INTO t1 VALUES (2, 'slave ', WEEK('2008-01-07'));
146 SELECT * FROM t1 ORDER BY a;
147
148 --connection master
149 DROP TABLE t1;
150
151 --connection slave
152 SET @@global.default_week_format=0;
153 SET @@session.default_week_format=0;
154 --echo
155
156 #
157 # LOCAL_INFILE
158 #
159 --echo * local_infile *
160
161 --connection slave
162 SET @old_local_infile= @@global.local_infile;
163 SET @@global.local_infile=0;
164
165 --connection master
166 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(20), c CHAR(254)) ENGINE=MyISAM;
167 --copy_files_wildcard ./std_data/ $MYSQLTEST_VARDIR/tmp/ words.dat
168 --copy_files_wildcard ./std_data/ $MYSQLTEST_VARDIR/tmp/ words2.dat
169 --replace_regex /\'.+\'/'FILE'/
170 --eval LOAD DATA LOCAL INFILE '$MYSQLTEST_VARDIR/tmp/words.dat' INTO TABLE t1 (b)
171 SELECT COUNT(*) FROM t1;
172 --source include/sync_slave_sql_with_master.inc
173 --replace_regex /\'.+\'/'FILE2'/
174 --error ER_CLIENT_LOCAL_FILES_DISABLED
175 --eval LOAD DATA LOCAL INFILE '$MYSQLTEST_VARDIR/tmp/words2.dat' INTO TABLE t1 (b)
176 SELECT COUNT(*) FROM t1;
177
178 SET @@global.local_infile=1;
179
180 --connection master
181 DROP TABLE t1;
182 --echo
183
184 # Clean up
185 --echo *** clean up ***
186 --connection master
187 SET @@global.character_set_database=@restore_master_character_set_database;
188 SET @@global.collation_server=@restore_master_collation_server;
189 --source include/sync_slave_sql_with_master.inc
190 SET @@global.character_set_database=@restore_slave_character_set_database;
191 SET @@global.collation_server=@restore_slave_collation_server;
192 SET @@global.local_infile= @old_local_infile;
193 --remove_file $MYSQLTEST_VARDIR/tmp/words.dat
194 --remove_file $MYSQLTEST_VARDIR/tmp/words2.dat
195
196 # Put at the end since the test otherwise emptied the table.
197
198 --echo
199 call mtr.add_suppression("The table 't[12]' is full");
200
201 # End of 5.1 test
202 --source include/rpl_end.inc