Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3
4 * auto_increment_increment, auto_increment_offset *
5 connection master;
6 SET @@global.auto_increment_increment=2;
7 SET @@session.auto_increment_increment=2;
8 SET @@global.auto_increment_offset=10;
9 SET @@session.auto_increment_offset=10;
10 connection slave;
11 SET @@global.auto_increment_increment=3;
12 SET @@session.auto_increment_increment=3;
13 SET @@global.auto_increment_offset=20;
14 SET @@session.auto_increment_offset=20;
15 connection master;
16 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(10)) ENGINE=MyISAM CHARSET=latin1;
17 INSERT INTO t1 (b) VALUES ('master');
18 INSERT INTO t1 (b) VALUES ('master');
19 SELECT * FROM t1 ORDER BY a;
20 a b
21 2 master
22 4 master
23 connection slave;
24 CREATE TABLE t2 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(10)) ENGINE=MyISAM CHARSET=latin1;
25 INSERT INTO t1 (b) VALUES ('slave');
26 INSERT INTO t1 (b) VALUES ('slave');
27 INSERT INTO t2 (b) VALUES ('slave');
28 INSERT INTO t2 (b) VALUES ('slave');
29 SELECT * FROM t1 ORDER BY a;
30 a b
31 2 master
32 4 master
33 7 slave
34 10 slave
35 SELECT * FROM t2 ORDER BY a;
36 a b
37 1 slave
38 4 slave
39 connection master;
40 DROP TABLE IF EXISTS t1,t2;
41 SET @@global.auto_increment_increment=1;
42 SET @@session.auto_increment_increment=1;
43 SET @@global.auto_increment_offset=1;
44 SET @@session.auto_increment_offset=1;
45 connection slave;
46 SET @@global.auto_increment_increment=1;
47 SET @@session.auto_increment_increment=1;
48 SET @@global.auto_increment_offset=1;
49 SET @@session.auto_increment_offset=1;
50 connection slave;
51 SET auto_increment_increment=1;
52 SET auto_increment_offset=1;
53
54 * character_set_database, collation_server *
55 connection master;
56 SET @restore_master_collation_database=@@global.collation_database;
57 SET @restore_master_collation_server=@@global.collation_server;
58 SET @@global.collation_database=latin1_swedish_ci;
59 SET @@session.collation_database=latin1_swedish_ci;
60 SET @@global.collation_server=latin1_german1_ci;
61 SET @@session.collation_server=latin1_german1_ci;
62 connection slave;
63 SET @restore_slave_collation_database=@@global.collation_database;
64 SET @restore_slave_collation_server=@@global.collation_server;
65 SET @@global.collation_database=utf8_general_ci;
66 SET @@session.collation_database=utf8_general_ci;
67 SET @@global.collation_server=utf8_bin;
68 SET @@session.collation_server=utf8_bin;
69 connection master;
70 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10)) ENGINE=MyISAM CHARSET=latin1;
71 SHOW CREATE TABLE t1;
72 Table Create Table
73 t1 CREATE TABLE `t1` (
74 `a` int(11) NOT NULL,
75 `b` varchar(10) DEFAULT NULL,
76 PRIMARY KEY (`a`)
77 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
78 connection slave;
79 CREATE TABLE t2 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10)) ENGINE=MyISAM CHARSET=latin1;
80 SHOW CREATE TABLE t1;
81 Table Create Table
82 t1 CREATE TABLE `t1` (
83 `a` int(11) NOT NULL,
84 `b` varchar(10) DEFAULT NULL,
85 PRIMARY KEY (`a`)
86 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
87 SHOW CREATE TABLE t2;
88 Table Create Table
89 t2 CREATE TABLE `t2` (
90 `a` int(11) NOT NULL,
91 `b` varchar(10) DEFAULT NULL,
92 PRIMARY KEY (`a`)
93 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
94 SET @@global.collation_server=latin1_swedish_ci;
95 SET @@session.collation_server=latin1_swedish_ci;
96 connection master;
97 SET @@global.collation_server=latin1_swedish_ci;
98 SET @@session.collation_server=latin1_swedish_ci;
99 DROP TABLE IF EXISTS t1,t2;
100
101 * default_week_format *
102 connection master;
103 SET @@global.default_week_format=0;
104 SET @@session.default_week_format=0;
105 connection slave;
106 SET @@global.default_week_format=1;
107 SET @@session.default_week_format=1;
108 connection master;
109 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10), c INT) ENGINE=MyISAM CHARSET=latin1;
110 INSERT INTO t1 VALUES (1, 'master ', WEEK('2008-01-07'));
111 SELECT * FROM t1 ORDER BY a;
112 a b c
113 1 master 1
114 connection slave;
115 INSERT INTO t1 VALUES (2, 'slave ', WEEK('2008-01-07'));
116 SELECT * FROM t1 ORDER BY a;
117 a b c
118 1 master 1
119 2 slave 2
120 connection master;
121 DROP TABLE t1;
122 connection slave;
123 SET @@global.default_week_format=0;
124 SET @@session.default_week_format=0;
125
126 * local_infile *
127 connection slave;
128 SET @@global.local_infile=0;
129 connection master;
130 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(20), c CHAR(254)) ENGINE=MyISAM CHARSET=latin1;
131 LOAD DATA LOCAL INFILE 'FILE' INTO TABLE t1 (b);
132 SELECT COUNT(*) FROM t1;
133 COUNT(*)
134 70
135 connection slave;
136 LOAD DATA LOCAL INFILE 'FILE2' INTO TABLE t1 (b);
137 ERROR HY000: The used command is not allowed because the MariaDB server or client has disabled the local infile capability
138 SELECT COUNT(*) FROM t1;
139 COUNT(*)
140 70
141 SET @@global.local_infile=1;
142 connection master;
143 DROP TABLE t1;
144
145 * max_heap_table_size *
146 connection slave;
147 SET @restore_slave_max_heap_table_size=@@global.max_heap_table_size;
148 SET @@global.max_heap_table_size=16384;
149 SET @@session.max_heap_table_size=16384;
150 connection master;
151 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(10), c CHAR(254)) ENGINE=MEMORY CHARSET=latin1;
152 SELECT COUNT(*)=2000 FROM t1;
153 COUNT(*)=2000
154 1
155 connection slave;
156 SELECT COUNT(*)=2000 FROM t1 WHERE b='master' GROUP BY b ORDER BY b;
157 COUNT(*)=2000
158 1
159 SELECT COUNT(*)<2000 AND COUNT(*)>0 FROM t1 WHERE b='slave' GROUP BY b ORDER BY b;
160 COUNT(*)<2000 AND COUNT(*)>0
161 1
162 SELECT COUNT(*)<2000 AND COUNT(*)>0 FROM t2 WHERE b='slave' GROUP BY b ORDER BY b;
163 COUNT(*)<2000 AND COUNT(*)>0
164 1
165 connection master;
166 DROP TABLE IF EXISTS t1,t2;
167
168 * storage_engine *
169 connection master;
170 SET @restore_master_storage_engine=@@global.default_storage_engine;
171 SET @@global.default_storage_engine=InnoDB;
172 SET @@session.default_storage_engine=InnoDB;
173 connection slave;
174 SET @restore_slave_storage_engine=@@global.default_storage_engine;
175 SET @@global.default_storage_engine=Memory;
176 SET @@session.default_storage_engine=Memory;
177 connection master;
178 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10)) CHARSET=latin1;
179 CREATE TABLE t2 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10)) ENGINE=InnoDB CHARSET=latin1;
180 connection slave;
181 CREATE TABLE t3 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10)) CHARSET=latin1;
182 connection master;
183 SHOW CREATE TABLE t1;
184 Table Create Table
185 t1 CREATE TABLE `t1` (
186 `a` int(11) NOT NULL,
187 `b` varchar(10) DEFAULT NULL,
188 PRIMARY KEY (`a`)
189 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
190 SHOW CREATE TABLE t2;
191 Table Create Table
192 t2 CREATE TABLE `t2` (
193 `a` int(11) NOT NULL,
194 `b` varchar(10) DEFAULT NULL,
195 PRIMARY KEY (`a`)
196 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
197 connection slave;
198 SHOW CREATE TABLE t1;
199 Table Create Table
200 t1 CREATE TABLE `t1` (
201 `a` int(11) NOT NULL,
202 `b` varchar(10) DEFAULT NULL,
203 PRIMARY KEY (`a`)
204 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
205 SHOW CREATE TABLE t2;
206 Table Create Table
207 t2 CREATE TABLE `t2` (
208 `a` int(11) NOT NULL,
209 `b` varchar(10) DEFAULT NULL,
210 PRIMARY KEY (`a`)
211 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
212 SHOW CREATE TABLE t3;
213 Table Create Table
214 t3 CREATE TABLE `t3` (
215 `a` int(11) NOT NULL,
216 `b` varchar(10) DEFAULT NULL,
217 PRIMARY KEY (`a`)
218 ) ENGINE=MEMORY DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci
219 SET @@global.default_storage_engine=InnoDB;
220 SET @@session.default_storage_engine=InnoDB;
221 connection master;
222 DROP TABLE IF EXISTS t1,t2,t3;
223
224 * sql_mode *
225 connection master;
226 SET @old_sql_mode_master= @@global.sql_mode;
227 SET @@global.sql_mode=ANSI;
228 SET @@session.sql_mode=ANSI;
229 connection slave;
230 SET @old_sql_mode_slave= @@global.sql_mode;
231 SET @@global.sql_mode=TRADITIONAL;
232 SET @@session.sql_mode=TRADITIONAL;
233 connection master;
234 CREATE TABLE t1 (a INT NOT NULL PRIMARY KEY, b VARCHAR(10), c DATE) CHARSET=latin1;
235 INSERT INTO t1 VALUES (1, 'master', '0000-00-00');
236 SELECT * FROM t1 ORDER BY a;
237 a b c
238 1 master 0000-00-00
239 connection slave;
240 INSERT INTO t1 VALUES (1, 'slave', '0000-00-00');
241 ERROR 22007: Incorrect date value: '0000-00-00' for column `test`.`t1`.`c` at row 1
242 SELECT * FROM t1 ORDER BY a;
243 a b c
244 1 master 0000-00-00
245 SET @@global.sql_mode='';
246 SET @@session.sql_mode='';
247 connection master;
248 SET @@global.sql_mode='';
249 SET @@session.sql_mode='';
250 DROP TABLE t1;
251
252 *** clean up ***
253 connection master;
254 SET @@global.collation_database=@restore_master_collation_database;
255 SET @@global.collation_server=@restore_master_collation_server;
256 SET @@global.default_storage_engine=@restore_master_storage_engine;
257 SET @@global.sql_mode=@old_sql_mode_master;
258 connection slave;
259 SET @@global.collation_database=@restore_slave_collation_database;
260 SET @@global.collation_server=@restore_slave_collation_server;
261 SET @@global.max_heap_table_size=@restore_slave_max_heap_table_size;
262 SET @@global.default_storage_engine=@restore_slave_storage_engine;
263 SET @@global.sql_mode=@old_sql_mode_slave;
264
265 call mtr.add_suppression("The table 't[12]' is full");
266 include/rpl_end.inc