Debian Codegraph @

mysql-test/suite/galera/r/mdev-22063.result

raw
1 connection node_2;
2 connection node_1;
3 # Case 1 CREATE SEQUENCE with no NOCACHE
4 CREATE SEQUENCE s ENGINE=InnoDB;
5 ERROR 42000: This version of MariaDB doesn't yet support 'CACHE without INCREMENT BY 0 in Galera cluster'
6 CREATE SEQUENCE s NOCACHE ENGINE=InnoDB;
7 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
8 START TRANSACTION;
9 REPLACE INTO s VALUES (1,1,9223372036854775806,1,1,1000,0,0);
10 OPTIMIZE TABLE t1;
11 Table Op Msg_type Msg_text
12 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
13 test.t1 optimize status OK
14 SELECT * FROM t1;
15 a
16 SELECT * FROM s;
17 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
18 1 1 9223372036854775806 1 1 1000 0 0
19 connection node_2;
20 SET GLOBAL WSREP_MODE='REPLICATE_ARIA,REPLICATE_MYISAM';
21 SELECT * FROM t1;
22 a
23 SELECT * FROM s;
24 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
25 1 1 9223372036854775806 1 1 0 0 0
26 connection node_1;
27 SET GLOBAL WSREP_MODE='REPLICATE_ARIA,REPLICATE_MYISAM';
28 DROP TABLE t1;
29 DROP SEQUENCE s;
30 # Case 2 REPLACE INTO ... SELECT with error
31 CREATE TABLE t (id INT KEY,a YEAR,INDEX (id,a)) engine=innodb;
32 REPLACE INTO t (id,a)SELECT /*!99997 */ 1;
33 ERROR 21S01: Column count doesn't match value count at row 1
34 REPLACE INTO t (id,a)SELECT /*!99997 */ 1,2;
35 SELECT * FROM t;
36 id a
37 1 2002
38 CREATE TABLE t2 (id INT KEY,a YEAR,INDEX (id,a)) engine=myisam;
39 REPLACE INTO t2 (id,a)SELECT /*!99997 */ 1;
40 ERROR 21S01: Column count doesn't match value count at row 1
41 REPLACE INTO t2 (id,a)SELECT /*!99997 */ 1,2;
42 Warnings:
43 Warning 138 Galera cluster does support consistency check only for InnoDB tables.
44 SELECT * FROM t2;
45 id a
46 1 2002
47 CREATE TABLE t3 (id INT KEY,a YEAR,INDEX (id,a)) engine=aria;
48 REPLACE INTO t3 (id,a)SELECT /*!99997 */ 1;
49 ERROR 21S01: Column count doesn't match value count at row 1
50 REPLACE INTO t3 (id,a)SELECT /*!99997 */ 1,2;
51 Warnings:
52 Warning 138 Galera cluster does support consistency check only for InnoDB tables.
53 SELECT * FROM t3;
54 id a
55 1 2002
56 connection node_2;
57 SELECT * FROM t;
58 id a
59 1 2002
60 SELECT * FROM t2;
61 id a
62 1 2002
63 SELECT * FROM t3;
64 id a
65 1 2002
66 connection node_1;
67 DROP TABLE t,t2,t3;
68 # Bigger REPLACE ... AS SELECT test
69 SET GLOBAL wsrep_mode=REPLICATE_MYISAM;
70 CREATE TABLE t1(id int not null primary key ,b int) ENGINE=InnoDB;
71 CREATE TABLE t2(id int not null primary key ,b int) ENGINE=MyISAM;
72 CREATE TABLE t3(id int not null primary key ,b int) ENGINE=Aria;
73 CREATE TABLE t4(id int not null primary key ,b int) ENGINE=InnoDB;
74 CREATE TABLE t5(id int not null primary key ,b int) ENGINE=InnoDB;
75 CREATE TABLE t6(id int not null primary key ,b int) ENGINE=InnoDB;
76 CREATE TABLE t7(id int not null primary key ,b int) ENGINE=MyISAM;
77 CREATE TABLE t8(id int not null primary key ,b int) ENGINE=Aria;
78 INSERT INTO t1(id) SELECT seq FROM seq_1_to_1000;
79 INSERT INTO t2(id) SELECT seq FROM seq_1_to_1000;
80 INSERT INTO t3(id) SELECT seq FROM seq_1_to_1000;
81 REPLACE INTO t4 SELECT * FROM t1;
82 REPLACE INTO t5 SELECT * FROM t2;
83 REPLACE INTO t6 SELECT * FROM t3;
84 REPLACE INTO t7 SELECT * FROM t2;
85 REPLACE INTO t8 SELECT * FROM t3;
86 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
87 EXPECT_1000
88 1000
89 SELECT COUNT(*) AS EXPECT_1000 FROM t2;
90 EXPECT_1000
91 1000
92 SELECT COUNT(*) AS EXPECT_1000 FROM t3;
93 EXPECT_1000
94 1000
95 SELECT COUNT(*) AS EXPECT_1000 FROM t4;
96 EXPECT_1000
97 1000
98 SELECT COUNT(*) AS EXPECT_1000 FROM t5;
99 EXPECT_1000
100 1000
101 SELECT COUNT(*) AS EXPECT_1000 FROM t6;
102 EXPECT_1000
103 1000
104 SELECT COUNT(*) AS EXPECT_1000 FROM t7;
105 EXPECT_1000
106 1000
107 SELECT COUNT(*) AS EXPECT_1000 FROM t8;
108 EXPECT_1000
109 1000
110 connection node_2;
111 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
112 EXPECT_1000
113 1000
114 SELECT COUNT(*) AS EXPECT_1000 FROM t2;
115 EXPECT_1000
116 1000
117 SELECT COUNT(*) AS EXPECT_1000 FROM t3;
118 EXPECT_1000
119 0
120 SELECT COUNT(*) AS EXPECT_1000 FROM t4;
121 EXPECT_1000
122 1000
123 SELECT COUNT(*) AS EXPECT_1000 FROM t5;
124 EXPECT_1000
125 1000
126 SELECT COUNT(*) AS EXPECT_1000 FROM t6;
127 EXPECT_1000
128 1000
129 SELECT COUNT(*) AS EXPECT_1000 FROM t7;
130 EXPECT_1000
131 1000
132 SELECT COUNT(*) AS EXPECT_0 FROM t8;
133 EXPECT_0
134 0
135 connection node_1;
136 DROP TABLE t1,t2,t3,t4,t5,t6,t7,t8;
137 # Bigger INSERT INTO ... SELECT test
138 CREATE TABLE t1(id int not null primary key ,b int) ENGINE=InnoDB;
139 CREATE TABLE t2(id int not null primary key ,b int) ENGINE=MyISAM;
140 CREATE TABLE t3(id int not null primary key ,b int) ENGINE=Aria;
141 CREATE TABLE t4(id int not null primary key ,b int) ENGINE=InnoDB;
142 CREATE TABLE t5(id int not null primary key ,b int) ENGINE=InnoDB;
143 CREATE TABLE t6(id int not null primary key ,b int) ENGINE=InnoDB;
144 CREATE TABLE t7(id int not null primary key ,b int) ENGINE=MyISAM;
145 CREATE TABLE t8(id int not null primary key ,b int) ENGINE=Aria;
146 INSERT INTO t1(id) SELECT seq FROM seq_1_to_1000;
147 INSERT INTO t2(id) SELECT seq FROM seq_1_to_1000;
148 INSERT INTO t3(id) SELECT seq FROM seq_1_to_1000;
149 INSERT INTO t4 SELECT * FROM t1;
150 INSERT INTO t5 SELECT * FROM t2;
151 INSERT INTO t6 SELECT * FROM t3;
152 INSERT INTO t7 SELECT * FROM t2;
153 INSERT INTO t8 SELECT * FROM t3;
154 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
155 EXPECT_1000
156 1000
157 SELECT COUNT(*) AS EXPECT_1000 FROM t2;
158 EXPECT_1000
159 1000
160 SELECT COUNT(*) AS EXPECT_1000 FROM t3;
161 EXPECT_1000
162 1000
163 SELECT COUNT(*) AS EXPECT_1000 FROM t4;
164 EXPECT_1000
165 1000
166 SELECT COUNT(*) AS EXPECT_1000 FROM t5;
167 EXPECT_1000
168 1000
169 SELECT COUNT(*) AS EXPECT_1000 FROM t6;
170 EXPECT_1000
171 1000
172 SELECT COUNT(*) AS EXPECT_1000 FROM t7;
173 EXPECT_1000
174 1000
175 SELECT COUNT(*) AS EXPECT_1000 FROM t8;
176 EXPECT_1000
177 1000
178 connection node_2;
179 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
180 EXPECT_1000
181 1000
182 SELECT COUNT(*) AS EXPECT_1000 FROM t2;
183 EXPECT_1000
184 1000
185 SELECT COUNT(*) AS EXPECT_1000 FROM t3;
186 EXPECT_1000
187 0
188 SELECT COUNT(*) AS EXPECT_1000 FROM t4;
189 EXPECT_1000
190 1000
191 SELECT COUNT(*) AS EXPECT_1000 FROM t5;
192 EXPECT_1000
193 1000
194 SELECT COUNT(*) AS EXPECT_1000 FROM t6;
195 EXPECT_1000
196 1000
197 SELECT COUNT(*) AS EXPECT_1000 FROM t7;
198 EXPECT_1000
199 1000
200 SELECT COUNT(*) AS EXPECT_0 FROM t8;
201 EXPECT_0
202 0
203 connection node_1;
204 DROP TABLE t1,t2,t3,t4,t5,t6,t7,t8;
205 CREATE TABLE t1(pk int not null primary key) engine=innodb;
206 INSERT INTO t1 values (1),(2),(3),(4);
207 CREATE VIEW view_t1 AS SELECT * FROM t1;
208 INSERT INTO view_t1 VALUES (5);
209 SELECT * FROM t1;
210 pk
211 1
212 2
213 3
214 4
215 5
216 DROP TABLE t1;
217 DROP VIEW view_t1;
218 CREATE TABLE t1(pk int not null primary key) engine=myisam;
219 INSERT INTO t1 values (1),(2),(3),(4);
220 CREATE VIEW view_t1 AS SELECT * FROM t1;
221 INSERT INTO view_t1 VALUES (5);
222 SELECT * FROM t1;
223 pk
224 1
225 2
226 3
227 4
228 5
229 DROP TABLE t1;
230 DROP VIEW view_t1;
231 CREATE TABLE t1(pk int not null primary key) engine=aria;
232 INSERT INTO t1 values (1),(2),(3),(4);
233 CREATE VIEW view_t1 AS SELECT * FROM t1;
234 INSERT INTO view_t1 VALUES (5);
235 SELECT * FROM t1;
236 pk
237 1
238 2
239 3
240 4
241 5
242 DROP TABLE t1;
243 DROP VIEW view_t1;
244 SET GLOBAL wsrep_mode=DEFAULT;
245 connection node_2;
246 SET GLOBAL wsrep_mode=DEFAULT;