Debian Codegraph @

mysql-test/suite/galera/r/galera_strict_require_primary_key.result

raw
1 connection node_2;
2 connection node_1;
3 call mtr.add_suppression("WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled\\. Table ");
4 CREATE TABLE t1(a int, b varchar(50)) ENGINE=INNODB;
5 CREATE TABLE t2(a int, b varchar(50)) ENGINE=MYISAM;
6 CREATE TABLE t3(a int, b varchar(50)) ENGINE=MEMORY;
7 CREATE TABLE t4(a int, b varchar(50)) ENGINE=ARIA;
8 SET GLOBAL wsrep_mode = "REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM,REPLICATE_ARIA";
9 SET GLOBAL log_warnings=2;
10 INSERT INTO t1 values (1,'test1');
11 Warnings:
12 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
13 INSERT INTO t2 values (1,'myisam1');
14 Warnings:
15 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
16 INSERT INTO t3 values (1,'memory1');
17 INSERT INTO t4 values (1,'aria1');
18 Warnings:
19 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
20 SET GLOBAL wsrep_mode = "REQUIRED_PRIMARY_KEY,REPLICATE_ARIA";
21 INSERT INTO t2 values (2,'myisam2');
22 SET GLOBAL wsrep_mode = "REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM";
23 INSERT INTO t4 values (2,'ARIA2');
24 SET GLOBAL wsrep_mode = "REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM,REPLICATE_ARIA";
25 SET GLOBAL log_warnings=1;
26 INSERT INTO t1 values (21,'not1');
27 Warnings:
28 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
29 INSERT INTO t1 values (22,'not2');
30 Warnings:
31 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
32 INSERT INTO t2 values (21,'not1');
33 Warnings:
34 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
35 INSERT INTO t2 values (22,'not2');
36 Warnings:
37 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
38 INSERT INTO t4 values (21,'not1');
39 Warnings:
40 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
41 INSERT INTO t4 values (22,'not2');
42 Warnings:
43 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
44 include/assert_grep.inc [WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled.]
45 SET GLOBAL log_warnings=2;
46 INSERT INTO t1 values (6,'test6');
47 Warnings:
48 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
49 INSERT INTO t1 values (7,'test7');
50 Warnings:
51 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
52 INSERT INTO t1 values (8,'test8');
53 Warnings:
54 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
55 INSERT INTO t1 values (9,'test9');
56 Warnings:
57 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
58 INSERT INTO t1 values (10,'test10');
59 Warnings:
60 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
61 INSERT INTO t1 values (11,'test11');
62 Warnings:
63 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
64 INSERT INTO t1 values (12,'test12');
65 Warnings:
66 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
67 INSERT INTO t1 values (13,'test13');
68 Warnings:
69 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
70 INSERT INTO t1 values (33,'test13');
71 Warnings:
72 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
73 INSERT INTO t1 values (34,'test13');
74 Warnings:
75 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
76 INSERT INTO t1 values (35,'test13');
77 Warnings:
78 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
79 INSERT INTO t1 values (36,'test13');
80 Warnings:
81 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
82 INSERT INTO t1 values (37,'test13');
83 Warnings:
84 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
85 INSERT INTO t1 values (38,'test13');
86 Warnings:
87 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
88 INSERT INTO t1 values (39,'test13');
89 Warnings:
90 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t1' should have PRIMARY KEY defined.
91 INSERT INTO t2 values (6,'test6');
92 Warnings:
93 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
94 INSERT INTO t2 values (7,'test7');
95 Warnings:
96 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
97 INSERT INTO t2 values (8,'test8');
98 Warnings:
99 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
100 INSERT INTO t2 values (9,'test9');
101 Warnings:
102 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
103 INSERT INTO t2 values (10,'test10');
104 Warnings:
105 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
106 INSERT INTO t2 values (11,'test11');
107 Warnings:
108 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
109 INSERT INTO t2 values (12,'test12');
110 Warnings:
111 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
112 INSERT INTO t2 values (13,'test13');
113 Warnings:
114 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
115 INSERT INTO t2 values (33,'test13');
116 Warnings:
117 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
118 INSERT INTO t2 values (34,'test13');
119 Warnings:
120 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
121 INSERT INTO t2 values (35,'test13');
122 Warnings:
123 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
124 INSERT INTO t2 values (36,'test13');
125 Warnings:
126 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
127 INSERT INTO t2 values (37,'test13');
128 Warnings:
129 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
130 INSERT INTO t2 values (38,'test13');
131 Warnings:
132 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
133 INSERT INTO t2 values (39,'test13');
134 Warnings:
135 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t2' should have PRIMARY KEY defined.
136 INSERT INTO t4 values (6,'test6');
137 Warnings:
138 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
139 INSERT INTO t4 values (7,'test7');
140 Warnings:
141 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
142 INSERT INTO t4 values (8,'test8');
143 Warnings:
144 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
145 INSERT INTO t4 values (9,'test9');
146 Warnings:
147 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
148 INSERT INTO t4 values (10,'test10');
149 Warnings:
150 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
151 INSERT INTO t4 values (11,'test11');
152 Warnings:
153 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
154 INSERT INTO t4 values (12,'test12');
155 Warnings:
156 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
157 INSERT INTO t4 values (13,'test13');
158 Warnings:
159 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
160 INSERT INTO t4 values (33,'test13');
161 Warnings:
162 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
163 INSERT INTO t4 values (34,'test13');
164 Warnings:
165 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
166 INSERT INTO t4 values (35,'test13');
167 Warnings:
168 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
169 INSERT INTO t4 values (36,'test13');
170 Warnings:
171 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
172 INSERT INTO t4 values (37,'test13');
173 Warnings:
174 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
175 INSERT INTO t4 values (38,'test13');
176 Warnings:
177 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
178 INSERT INTO t4 values (39,'test13');
179 Warnings:
180 Warning 1290 WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled. Table 'test'.'t4' should have PRIMARY KEY defined.
181 SELECT COUNT(*) AS EXPECT_18 FROM t1;
182 EXPECT_18
183 18
184 SELECT COUNT(*) AS EXPECT_19 FROM t2;
185 EXPECT_19
186 19
187 SELECT COUNT(*) AS EXPECT_1 FROM t3;
188 EXPECT_1
189 1
190 SELECT COUNT(*) AS EXPECT_19 FROM t4;
191 EXPECT_19
192 19
193 connection node_2;
194 SELECT COUNT(*) AS EXPECT_18 FROM t1;
195 EXPECT_18
196 18
197 SELECT COUNT(*) AS EXPECT_18 FROM t2;
198 EXPECT_18
199 18
200 SELECT COUNT(*) AS EXPECT_0 FROM t3;
201 EXPECT_0
202 0
203 SELECT COUNT(*) AS EXPECT_18 FROM t4;
204 EXPECT_18
205 18
206 connection node_1;
207 DROP TABLE t1,t2,t3,t4;
208 include/assert_grep.inc [WSREP: wsrep_mode = REQUIRED_PRIMARY_KEY enabled.]
209 include/assert_grep.inc [WSREP: Suppressing warnings of type 'WSREP_REQUIRE_PRIMARY_KEY' for up to 300 seconds because of flooding]