Debian Codegraph @

mysql-test/suite/galera/t/mdev-22063.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/log_bin.inc
4 --source include/have_sequence.inc
5 --source include/have_aria.inc
6
7 --echo # Case 1 CREATE SEQUENCE with no NOCACHE
8 --error ER_NOT_SUPPORTED_YET
9 CREATE SEQUENCE s ENGINE=InnoDB;
10 CREATE SEQUENCE s NOCACHE ENGINE=InnoDB;
11 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
12 START TRANSACTION;
13 REPLACE INTO s VALUES (1,1,9223372036854775806,1,1,1000,0,0);
14 OPTIMIZE TABLE t1;
15 SELECT * FROM t1;
16 SELECT * FROM s;
17
18 --connection node_2
19 SET GLOBAL WSREP_MODE='REPLICATE_ARIA,REPLICATE_MYISAM';
20 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't1'
21 --source include/wait_condition.inc
22 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 's'
23 --source include/wait_condition.inc
24 --let $wait_condition = SELECT COUNT(*) = 1 FROM test.s;
25 --source include/wait_condition.inc
26
27 SELECT * FROM t1;
28 SELECT * FROM s;
29
30 --connection node_1
31 SET GLOBAL WSREP_MODE='REPLICATE_ARIA,REPLICATE_MYISAM';
32 DROP TABLE t1;
33 DROP SEQUENCE s;
34
35 --echo # Case 2 REPLACE INTO ... SELECT with error
36 CREATE TABLE t (id INT KEY,a YEAR,INDEX (id,a)) engine=innodb;
37 --error ER_WRONG_VALUE_COUNT_ON_ROW
38 REPLACE INTO t (id,a)SELECT /*!99997 */ 1;
39 REPLACE INTO t (id,a)SELECT /*!99997 */ 1,2;
40 SELECT * FROM t;
41
42 CREATE TABLE t2 (id INT KEY,a YEAR,INDEX (id,a)) engine=myisam;
43 --error ER_WRONG_VALUE_COUNT_ON_ROW
44 REPLACE INTO t2 (id,a)SELECT /*!99997 */ 1;
45 REPLACE INTO t2 (id,a)SELECT /*!99997 */ 1,2;
46 SELECT * FROM t2;
47
48 CREATE TABLE t3 (id INT KEY,a YEAR,INDEX (id,a)) engine=aria;
49 --error ER_WRONG_VALUE_COUNT_ON_ROW
50 REPLACE INTO t3 (id,a)SELECT /*!99997 */ 1;
51 REPLACE INTO t3 (id,a)SELECT /*!99997 */ 1,2;
52 SELECT * FROM t3;
53
54 --connection node_2
55 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't3'
56 --source include/wait_condition.inc
57 --let $wait_condition = SELECT COUNT(*) = 1 FROM test.t3;
58 --source include/wait_condition.inc
59
60 SELECT * FROM t;
61 SELECT * FROM t2;
62 SELECT * FROM t3;
63
64 --connection node_1
65 DROP TABLE t,t2,t3;
66
67 --echo # Bigger REPLACE ... AS SELECT test
68
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
79 INSERT INTO t1(id) SELECT seq FROM seq_1_to_1000;
80 INSERT INTO t2(id) SELECT seq FROM seq_1_to_1000;
81 INSERT INTO t3(id) SELECT seq FROM seq_1_to_1000;
82
83 REPLACE INTO t4 SELECT * FROM t1;
84 REPLACE INTO t5 SELECT * FROM t2;
85 REPLACE INTO t6 SELECT * FROM t3;
86 REPLACE INTO t7 SELECT * FROM t2;
87 REPLACE INTO t8 SELECT * FROM t3;
88
89 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
90 SELECT COUNT(*) AS EXPECT_1000 FROM t2;
91 SELECT COUNT(*) AS EXPECT_1000 FROM t3;
92 SELECT COUNT(*) AS EXPECT_1000 FROM t4;
93 SELECT COUNT(*) AS EXPECT_1000 FROM t5;
94 SELECT COUNT(*) AS EXPECT_1000 FROM t6;
95 SELECT COUNT(*) AS EXPECT_1000 FROM t7;
96 SELECT COUNT(*) AS EXPECT_1000 FROM t8;
97
98 --connection node_2
99 --let $wait_condition = SELECT COUNT(*) = 8 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME LIKE 't_'
100 --source include/wait_condition.inc
101 --let $wait_condition = SELECT COUNT(*) = 1000 FROM test.t7;
102 --source include/wait_condition.inc
103
104 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
105 SELECT COUNT(*) AS EXPECT_1000 FROM t2;
106 SELECT COUNT(*) AS EXPECT_1000 FROM t3;
107 SELECT COUNT(*) AS EXPECT_1000 FROM t4;
108 SELECT COUNT(*) AS EXPECT_1000 FROM t5;
109 SELECT COUNT(*) AS EXPECT_1000 FROM t6;
110 SELECT COUNT(*) AS EXPECT_1000 FROM t7;
111 SELECT COUNT(*) AS EXPECT_0 FROM t8;
112
113 --connection node_1
114 DROP TABLE t1,t2,t3,t4,t5,t6,t7,t8;
115
116 --echo # Bigger INSERT INTO ... SELECT test
117
118 CREATE TABLE t1(id int not null primary key ,b int) ENGINE=InnoDB;
119 CREATE TABLE t2(id int not null primary key ,b int) ENGINE=MyISAM;
120 CREATE TABLE t3(id int not null primary key ,b int) ENGINE=Aria;
121 CREATE TABLE t4(id int not null primary key ,b int) ENGINE=InnoDB;
122 CREATE TABLE t5(id int not null primary key ,b int) ENGINE=InnoDB;
123 CREATE TABLE t6(id int not null primary key ,b int) ENGINE=InnoDB;
124 CREATE TABLE t7(id int not null primary key ,b int) ENGINE=MyISAM;
125 CREATE TABLE t8(id int not null primary key ,b int) ENGINE=Aria;
126
127 INSERT INTO t1(id) SELECT seq FROM seq_1_to_1000;
128 INSERT INTO t2(id) SELECT seq FROM seq_1_to_1000;
129 INSERT INTO t3(id) SELECT seq FROM seq_1_to_1000;
130
131 INSERT INTO t4 SELECT * FROM t1;
132 INSERT INTO t5 SELECT * FROM t2;
133 INSERT INTO t6 SELECT * FROM t3;
134 INSERT INTO t7 SELECT * FROM t2;
135 INSERT INTO t8 SELECT * FROM t3;
136
137 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
138 SELECT COUNT(*) AS EXPECT_1000 FROM t2;
139 SELECT COUNT(*) AS EXPECT_1000 FROM t3;
140 SELECT COUNT(*) AS EXPECT_1000 FROM t4;
141 SELECT COUNT(*) AS EXPECT_1000 FROM t5;
142 SELECT COUNT(*) AS EXPECT_1000 FROM t6;
143 SELECT COUNT(*) AS EXPECT_1000 FROM t7;
144 SELECT COUNT(*) AS EXPECT_1000 FROM t8;
145
146 --connection node_2
147 --let $wait_condition = SELECT COUNT(*) = 8 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME LIKE 't_'
148 --source include/wait_condition.inc
149 --let $wait_condition = SELECT COUNT(*) = 1000 FROM test.t7;
150 --source include/wait_condition.inc
151
152 SELECT COUNT(*) AS EXPECT_1000 FROM t1;
153 SELECT COUNT(*) AS EXPECT_1000 FROM t2;
154 SELECT COUNT(*) AS EXPECT_1000 FROM t3;
155 SELECT COUNT(*) AS EXPECT_1000 FROM t4;
156 SELECT COUNT(*) AS EXPECT_1000 FROM t5;
157 SELECT COUNT(*) AS EXPECT_1000 FROM t6;
158 SELECT COUNT(*) AS EXPECT_1000 FROM t7;
159 SELECT COUNT(*) AS EXPECT_0 FROM t8;
160
161 --connection node_1
162 DROP TABLE t1,t2,t3,t4,t5,t6,t7,t8;
163 #
164 # View
165 #
166 CREATE TABLE t1(pk int not null primary key) engine=innodb;
167 INSERT INTO t1 values (1),(2),(3),(4);
168 CREATE VIEW view_t1 AS SELECT * FROM t1;
169 INSERT INTO view_t1 VALUES (5);
170 SELECT * FROM t1;
171 DROP TABLE t1;
172 DROP VIEW view_t1;
173 CREATE TABLE t1(pk int not null primary key) engine=myisam;
174 INSERT INTO t1 values (1),(2),(3),(4);
175 CREATE VIEW view_t1 AS SELECT * FROM t1;
176 INSERT INTO view_t1 VALUES (5);
177 SELECT * FROM t1;
178 DROP TABLE t1;
179 DROP VIEW view_t1;
180 CREATE TABLE t1(pk int not null primary key) engine=aria;
181 INSERT INTO t1 values (1),(2),(3),(4);
182 CREATE VIEW view_t1 AS SELECT * FROM t1;
183 INSERT INTO view_t1 VALUES (5);
184 SELECT * FROM t1;
185 DROP TABLE t1;
186 DROP VIEW view_t1;
187 SET GLOBAL wsrep_mode=DEFAULT;
188
189 --connection node_2
190 SET GLOBAL wsrep_mode=DEFAULT;