Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 CREATE TABLE t1 (a int, b varchar(100), fulltext(b)) engine=MyISAM;
5 INSERT INTO t1 VALUES (1,"a"), (2,"b");
6 UPDATE t1 SET b='A' WHERE a=1;
7 DELETE FROM t1 WHERE a=2;
8 connection slave;
9 connection slave;
10 SELECT * FROM t1 ORDER BY a;
11 a b
12 1 A
13 connection master;
14 DROP TABLE t1;
15 connection master;
16 CREATE TABLE t1 (d INT PRIMARY KEY) ENGINE=myisam;
17 INSERT INTO t1 VALUES (0);
18 INSERT INTO t1 SELECT d+1 FROM t1;
19 INSERT INTO t1 SELECT d+2 FROM t1;
20 INSERT INTO t1 SELECT d+4 FROM t1;
21 INSERT INTO t1 SELECT d+8 FROM t1;
22 INSERT INTO t1 SELECT d+16 FROM t1;
23 INSERT INTO t1 SELECT d+32 FROM t1;
24 INSERT INTO t1 SELECT d+64 FROM t1;
25 INSERT INTO t1 SELECT d+128 FROM t1;
26 INSERT INTO t1 SELECT d+256 FROM t1;
27 INSERT INTO t1 SELECT d+512 FROM t1;
28 CREATE TABLE t2 (a INT, b INT, c INT, d INT,
29 KEY wrong_key(a),
30 KEY expected_key(b,c),
31 KEY wrong_key2(c)) ENGINE=myisam;
32 INSERT INTO t2 SELECT d DIV 10, d MOD 41, d MOD 37, d FROM t1;
33 connection slave;
34 connection slave;
35 ANALYZE TABLE t2;
36 Table Op Msg_type Msg_text
37 test.t2 analyze status OK
38 # Slave will crash if using the wrong or no index
39 SET GLOBAL debug_dbug="+d,slave_crash_if_wrong_index,slave_crash_if_table_scan";
40 connection master;
41 UPDATE t2 SET d=10042 WHERE d=42;
42 DELETE FROM t2 WHERE d=53;
43 connection slave;
44 connection slave;
45 SET GLOBAL debug_dbug="";
46 SELECT * FROM t2 WHERE d IN (10042,53);
47 a b c d
48 4 1 5 10042
49 connection master;
50 DROP TABLE t2;
51 CREATE TABLE t2 (a INT, b INT, c INT, d INT NOT NULL, e INT,
52 UNIQUE wrong_key3(a,e),
53 KEY wrong_key4(b,c),
54 UNIQUE expected_key(d)) ENGINE=myisam;
55 INSERT INTO t2 SELECT d DIV 10, d MOD 41, d MOD 37, d, NULL FROM t1;
56 connection slave;
57 connection slave;
58 ANALYZE TABLE t2;
59 Table Op Msg_type Msg_text
60 test.t2 analyze status OK
61 # Slave will crash if using the wrong or no index
62 SET GLOBAL debug_dbug="+d,slave_crash_if_wrong_index,slave_crash_if_table_scan";
63 connection master;
64 UPDATE t2 SET d=10042 WHERE d=42;
65 DELETE FROM t2 WHERE d=53;
66 connection slave;
67 connection slave;
68 SET GLOBAL debug_dbug="";
69 SELECT * FROM t2 WHERE d IN (10042,53);
70 a b c d e
71 4 1 5 10042 NULL
72 connection master;
73 DROP TABLE t2;
74 CREATE TABLE t2 (a INT NOT NULL, b INT NOT NULL, c INT NOT NULL, d INT NOT NULL,
75 KEY wrong_key5(b),
76 UNIQUE expected_key(d),
77 KEY wrong_key6(c)) ENGINE=myisam;
78 INSERT INTO t2 SELECT d DIV 10, d MOD 41, d MOD 37, d FROM t1;
79 connection slave;
80 connection slave;
81 # Slave will crash if using the wrong or no index
82 SET GLOBAL debug_dbug="+d,slave_crash_if_wrong_index,slave_crash_if_table_scan";
83 connection master;
84 UPDATE t2 SET d=10042 WHERE d=42;
85 DELETE FROM t2 WHERE d=53;
86 connection slave;
87 connection slave;
88 SET GLOBAL debug_dbug="";
89 SELECT * FROM t2 WHERE d IN (10042,53);
90 a b c d
91 4 1 5 10042
92 connection master;
93 DROP TABLE t2;
94 CREATE TABLE t2 (a INT NOT NULL, b INT NOT NULL, c INT NOT NULL, d INT NOT NULL,
95 KEY expected_key(b),
96 KEY wrong_key7(d),
97 KEY wrong_key8(c)) ENGINE=myisam;
98 INSERT INTO t2 SELECT d DIV 10, d MOD 41, d MOD 37, d FROM t1;
99 connection slave;
100 connection slave;
101 # Slave will crash if using the wrong or no index
102 SET GLOBAL debug_dbug="+d,slave_crash_if_wrong_index,slave_crash_if_table_scan";
103 connection master;
104 UPDATE t2 SET d=10042 WHERE d=42;
105 DELETE FROM t2 WHERE d=53;
106 connection slave;
107 connection slave;
108 SET GLOBAL debug_dbug="";
109 SELECT * FROM t2 WHERE d IN (10042,53);
110 a b c d
111 4 1 5 10042
112 connection master;
113 DROP TABLE t2;
114 CREATE TABLE t2 (a INT NOT NULL, b INT NOT NULL, c INT NOT NULL, d INT,
115 UNIQUE wrong_key9(d),
116 KEY wrong_key10(a),
117 PRIMARY KEY expected_key(c,b)) ENGINE=innodb;
118 INSERT INTO t2 SELECT d DIV 10, d MOD 41, d MOD 37, d FROM t1;
119 connection slave;
120 connection slave;
121 # Slave will crash if using the wrong or no index
122 SET GLOBAL debug_dbug="+d,slave_crash_if_wrong_index,slave_crash_if_table_scan,slave_crash_if_index_scan";
123 connection master;
124 UPDATE t2 SET d=10042 WHERE d=42;
125 DELETE FROM t2 WHERE d=53;
126 connection slave;
127 connection slave;
128 SET GLOBAL debug_dbug="";
129 SELECT * FROM t2 WHERE d IN (10042,53);
130 a b c d
131 4 1 5 10042
132 connection master;
133 DROP TABLE t2;
134 CREATE TABLE t2 (a INT NOT NULL, b INT NOT NULL, c INT NOT NULL, d INT, e INT,
135 UNIQUE wrong_key11(e),
136 KEY wrong_key12(a),
137 KEY expected_key(c,b)) ENGINE=innodb;
138 INSERT INTO t2 SELECT d DIV 10, d MOD 41, d MOD 37, d, IF(d<10, d, NULL) FROM t1;
139 connection slave;
140 connection slave;
141 ANALYZE TABLE t2;
142 Table Op Msg_type Msg_text
143 test.t2 analyze status OK
144 # Slave will crash if using the wrong or no index
145 SET GLOBAL debug_dbug="+d,slave_crash_if_wrong_index,slave_crash_if_table_scan";
146 connection master;
147 UPDATE t2 SET d=10042 WHERE d=42;
148 DELETE FROM t2 WHERE d=53;
149 connection slave;
150 connection slave;
151 SET GLOBAL debug_dbug="";
152 SELECT * FROM t2 WHERE d IN (10042,53);
153 a b c d e
154 4 1 5 10042 NULL
155 connection master;
156 DROP TABLE t2;
157 CREATE TABLE t2 (a INT NOT NULL, b INT NOT NULL, c INT NOT NULL, d INT, e INT,
158 KEY wrong_key13(a),
159 UNIQUE expected_key(e),
160 KEY wrong_key14(c,b)) ENGINE=innodb;
161 INSERT INTO t2 SELECT d DIV 10, d MOD 41, d MOD 37, d, IF(d<10, d, NULL) FROM t1;
162 connection slave;
163 connection slave;
164 # Slave will crash if using the wrong or no index
165 SET GLOBAL debug_dbug="+d,slave_crash_if_wrong_index,slave_crash_if_table_scan";
166 connection master;
167 UPDATE t2 SET d=10042 WHERE d=42;
168 DELETE FROM t2 WHERE d=53;
169 connection slave;
170 connection slave;
171 SET GLOBAL debug_dbug="";
172 SELECT * FROM t2 WHERE d IN (10042,53);
173 a b c d e
174 4 1 5 10042 NULL
175 connection master;
176 DROP TABLE t2;
177 CREATE TABLE t2 (a INT NOT NULL, d INT) ENGINE=innodb;
178 INSERT INTO t2 SELECT d DIV 10, d FROM t1;
179 UPDATE t2 SET d=10042 WHERE d=42;
180 DELETE FROM t2 WHERE d=53;
181 connection slave;
182 connection slave;
183 SELECT * FROM t2 WHERE d IN (10042,53);
184 a d
185 4 10042
186 connection master;
187 DROP TABLE t2;
188 connection master;
189 DROP TABLE t1;
190 connection slave;
191 connection slave;
192 SET GLOBAL debug_dbug="";
193 include/rpl_end.inc