Debian Codegraph @

mysql-test/suite/rpl/t/rpl_spec_variables.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/master-slave.inc
14 --echo
15
16 #
17 # MAX_HEAP_TABLE_SIZE
18 #
19 --echo * max_heap_table_size *
20
21 --let $heap_size= 16384
22 --let $record_size= 512
23 --replace_numeric_round 0
24 --let $row_count = `SELECT $heap_size / $record_size`
25 --inc $row_count
26
27 --connection slave
28 SET @restore_slave_max_heap_table_size=@@global.max_heap_table_size;
29 --replace_result $heap_size HEAP_SIZE
30 --eval SET @@global.max_heap_table_size=$heap_size
31 --replace_result $heap_size HEAP_SIZE
32 --eval SET @@session.max_heap_table_size=$heap_size
33
34 --connection master
35 --replace_result $record_size RECORD_SIZE
36 --eval CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(10), c VARCHAR($record_size)) ENGINE=MEMORY
37 --let $counter=$row_count
38 --disable_query_log
39 while ($counter) {
40 --eval INSERT INTO t1 (b,c) VALUES ('master', REPEAT('A', $record_size));
41 dec $counter;
42 }
43 --enable_query_log
44 --replace_result $row_count ROW_COUNT
45 --eval SELECT COUNT(*)=$row_count FROM t1
46
47 --source include/sync_slave_sql_with_master.inc
48 --replace_result $row_count ROW_COUNT
49 --eval SELECT COUNT(*)=$row_count FROM t1 WHERE b='master' GROUP BY b ORDER BY b
50 # Truncate the table so that the slaves max_heap_table_size value takes effect on
51 # the replicted table
52 TRUNCATE TABLE t1;
53 --let $counter=$row_count
54 --disable_query_log
55 while ($counter) {
56 --error 0,1114
57 --eval INSERT INTO t1 (b,c) VALUES ('slave', REPEAT('A', $record_size))
58 dec $counter;
59 }
60 CREATE TABLE t2 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(10), c CHAR(254)) ENGINE=MEMORY;
61 --let $counter=$row_count
62 --disable_query_log
63 while ($counter) {
64 --error 0,1114
65 INSERT INTO t2 (b,c) VALUES ('slave', REPEAT('A', 254));
66 dec $counter;
67 }
68 --enable_query_log
69 # We don't know how many memory used and can't check exact values so need to check following
70 # conditions
71 --replace_result $row_count ROW_COUNT
72 --eval SELECT COUNT(*)<$row_count AND COUNT(*)>0 FROM t1 WHERE b='slave' GROUP BY b ORDER BY b
73 --replace_result $row_count ROW_COUNT
74 --eval SELECT COUNT(*)<$row_count AND COUNT(*)>0 FROM t2 WHERE b='slave' GROUP BY b ORDER BY b
75
76 --connection master
77 --disable_warnings
78 DROP TABLE IF EXISTS t1,t2;
79 --enable_warnings
80 --echo
81
82 #
83 # STORAGE_ENGINE
84 #
85 --echo * storage_engine *
86
87 --connection master
88 SET @restore_master_storage_engine=@@global.default_storage_engine;
89 SET @@global.default_storage_engine=InnoDB;
90 SET @@session.default_storage_engine=InnoDB;
91
92 --connection slave
93 SET @restore_slave_storage_engine=@@global.default_storage_engine;
94 SET @@global.default_storage_engine=Memory;
95 SET @@session.default_storage_engine=Memory;
96
97 --connection master
98 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10));
99 CREATE TABLE t2 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10)) ENGINE=InnoDB;
100
101 --source include/sync_slave_sql_with_master.inc
102 CREATE TABLE t3 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10));
103
104 --connection master
105 SHOW CREATE TABLE t1;
106 SHOW CREATE TABLE t2;
107
108 --connection slave
109 SHOW CREATE TABLE t1;
110 SHOW CREATE TABLE t2;
111 SHOW CREATE TABLE t3;
112
113 SET @@global.default_storage_engine=InnoDB;
114 SET @@session.default_storage_engine=InnoDB;
115
116 --connection master
117 --disable_warnings
118 DROP TABLE IF EXISTS t1,t2,t3;
119 --enable_warnings
120 --echo
121
122 #
123 # SQL_MODE
124 #
125 --echo * sql_mode *
126
127 --connection master
128 SET @@global.sql_mode=ANSI;
129 SET @@session.sql_mode=ANSI;
130
131 --connection slave
132 SET @@global.sql_mode=TRADITIONAL;
133 SET @@session.sql_mode=TRADITIONAL;
134
135 --connection master
136 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10), c DATE);
137 INSERT INTO t1 VALUES (1, 'master', '0000-00-00');
138 SELECT * FROM t1 ORDER BY a;
139
140 --source include/sync_slave_sql_with_master.inc
141 --error 1292
142 INSERT INTO t1 VALUES (1, 'slave', '0000-00-00');
143 SELECT * FROM t1 ORDER BY a;
144 SET @@global.sql_mode=DEFAULT;
145 SET @@session.sql_mode=DEFAULT;
146
147 --connection master
148 SET @@global.sql_mode=DEFAULT;
149 SET @@session.sql_mode=DEFAULT;
150 DROP TABLE t1;
151 --echo
152
153
154 # Clean up
155 --echo *** clean up ***
156 SET @@global.default_storage_engine=@restore_master_storage_engine;
157 --source include/sync_slave_sql_with_master.inc
158 SET @@global.max_heap_table_size=@restore_slave_max_heap_table_size;
159 SET @@global.default_storage_engine=@restore_slave_storage_engine;
160
161 # Put at the end since the test otherwise emptied the table.
162
163 --echo
164 call mtr.add_suppression("The table 't[12]' is full");
165
166 # End of 5.1 test
167 --source include/rpl_end.inc