Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 1000000 increment by 0 cache 1000 nocycle ENGINE=InnoDB;
5 SHOW CREATE SEQUENCE seq;
6 Table Create Table
7 seq CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 1000000 increment by 0 cache 1000 nocycle ENGINE=InnoDB
8 connection node_2;
9 SHOW CREATE SEQUENCE seq;
10 Table Create Table
11 seq CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 1000000 increment by 0 cache 1000 nocycle ENGINE=InnoDB
12 connection node_1;
13 ALTER SEQUENCE seq MAXVALUE = 10000 NOCACHE;
14 SHOW CREATE SEQUENCE seq;
15 Table Create Table
16 seq CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 10000 increment by 0 nocache nocycle ENGINE=InnoDB
17 connection node_2;
18 SHOW CREATE SEQUENCE seq;
19 Table Create Table
20 seq CREATE SEQUENCE `seq` start with 1 minvalue 1 maxvalue 10000 increment by 0 nocache nocycle ENGINE=InnoDB
21 connection node_1;
22 DROP SEQUENCE seq;
23 SHOW CREATE SEQUENCE seq;
24 ERROR 42S02: Table 'test.seq' doesn't exist
25 connection node_2;
26 SHOW CREATE SEQUENCE seq;
27 ERROR 42S02: Table 'test.seq' doesn't exist
28 connection node_1;
29 CREATE SEQUENCE Seq1_1 START WITH 1 INCREMENT BY 1 NOCACHE;
30 select NEXT VALUE FOR Seq1_1;
31 NEXT VALUE FOR Seq1_1
32 1
33 alter table Seq1_1 engine=myisam;
34 ERROR 42000: This version of MariaDB doesn't yet support 'non-InnoDB sequences in Galera cluster'
35 select NEXT VALUE FOR Seq1_1;
36 NEXT VALUE FOR Seq1_1
37 2
38 alter table Seq1_1 engine=innodb;
39 select NEXT VALUE FOR Seq1_1;
40 NEXT VALUE FOR Seq1_1
41 3
42 connection node_2;
43 SHOW CREATE SEQUENCE Seq1_1;
44 Table Create Table
45 Seq1_1 CREATE SEQUENCE `Seq1_1` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 1 nocache nocycle ENGINE=InnoDB
46 select NEXT VALUE FOR Seq1_1;
47 NEXT VALUE FOR Seq1_1
48 4
49 connection node_1;
50 SHOW CREATE SEQUENCE Seq1_1;
51 Table Create Table
52 Seq1_1 CREATE SEQUENCE `Seq1_1` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 1 nocache nocycle ENGINE=InnoDB
53 DROP SEQUENCE Seq1_1;
54 connection node_1;
55 CREATE TABLE t2 (d CHAR(1)KEY);
56 SET SESSION autocommit=0;
57 INSERT INTO t2 VALUES(1);
58 CREATE TEMPORARY SEQUENCE seq1 NOCACHE ENGINE=INNODB;
59 CREATE SEQUENCE seq2 NOCACHE ENGINE=INNODB;
60 COMMIT;
61 SET SESSION AUTOCOMMIT=1;
62 SHOW CREATE TABLE seq1;
63 Table Create Table
64 seq1 CREATE TEMPORARY TABLE `seq1` (
65 `next_not_cached_value` bigint(21) NOT NULL,
66 `minimum_value` bigint(21) NOT NULL,
67 `maximum_value` bigint(21) NOT NULL,
68 `start_value` bigint(21) NOT NULL COMMENT 'start value when sequences is created or value if RESTART is used',
69 `increment` bigint(21) NOT NULL COMMENT 'increment value',
70 `cache_size` bigint(21) unsigned NOT NULL,
71 `cycle_option` tinyint(1) unsigned NOT NULL COMMENT '0 if no cycles are allowed, 1 if the sequence should begin a new cycle when maximum_value is passed',
72 `cycle_count` bigint(21) NOT NULL COMMENT 'How many cycles have been done'
73 ) ENGINE=InnoDB SEQUENCE=1
74 connection node_2;
75 SHOW CREATE SEQUENCE seq1;
76 ERROR 42S02: Table 'test.seq1' doesn't exist
77 SHOW CREATE SEQUENCE seq2;
78 Table Create Table
79 seq2 CREATE SEQUENCE `seq2` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 1 nocache nocycle ENGINE=InnoDB
80 connection node_1;
81 SET SESSION autocommit=1;
82 DROP SEQUENCE seq1;
83 DROP SEQUENCE seq2;
84 DROP TABLE t2;
85 connection node_2;
86 SET SESSION AUTOCOMMIT=0;
87 SET SESSION wsrep_OSU_method='RSU';
88 CREATE TABLE t1(c1 VARCHAR(10));
89 create temporary sequence sq1 NOCACHE engine=innodb;
90 create sequence sq2 NOCACHE engine=innodb;
91 COMMIT;
92 SET SESSION wsrep_OSU_method='TOI';
93 SHOW CREATE SEQUENCE sq1;
94 Table Create Table
95 sq1 CREATE SEQUENCE `sq1` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 1 nocache nocycle ENGINE=InnoDB
96 SHOW CREATE SEQUENCE sq2;
97 Table Create Table
98 sq2 CREATE SEQUENCE `sq2` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 1 nocache nocycle ENGINE=InnoDB
99 connection node_1;
100 SHOW CREATE SEQUENCE sq1;
101 ERROR 42S02: Table 'test.sq1' doesn't exist
102 SHOW CREATE SEQUENCE sq2;
103 ERROR 42S02: Table 'test.sq2' doesn't exist
104 connection node_2;
105 SET SESSION AUTOCOMMIT=1;
106 DROP TABLE t1;
107 DROP SEQUENCE sq1;
108 DROP SEQUENCE sq2;
109 connection node_1;
110 CREATE TABLE t (f INT) engine=innodb;
111 LOCK TABLE t WRITE;
112 CREATE OR REPLACE SEQUENCE t MAXVALUE=13 INCREMENT BY 1 NOCACHE engine=innodb;
113 Warnings:
114 Warning 138 Galera cluster does not support LOCK TABLE on SEQUENCES. Lock is released.
115 LOCK TABLE t WRITE;
116 ERROR 42000: This version of MariaDB doesn't yet support 'LOCK TABLE on SEQUENCES in Galera cluster'
117 INSERT INTO t VALUES (0,0,1,1,1,0,0,0);
118 SELECT * from t;
119 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
120 0 0 1 1 1 0 0 0
121 SELECT NEXTVAL(t);
122 NEXTVAL(t)
123 0
124 UNLOCK TABLES;
125 DROP TABLE t;
126 CREATE SEQUENCE t INCREMENT BY 0 NOCACHE ENGINE=INNODB;
127 CREATE TABLE t1(a int not null primary key default nextval(t),
128 b int) engine=innodb;
129 INSERT INTO t1(b) VALUES (1),(2),(3);
130 SELECT * FROM t1;
131 a b
132 1 1
133 3 2
134 5 3
135 connection node_2;
136 SELECT * FROM t1;
137 a b
138 1 1
139 3 2
140 5 3
141 INSERT INTO t1(b) VALUES (4),(5),(6);
142 SELECT * FROM t1;
143 a b
144 1 1
145 3 2
146 5 3
147 8 4
148 10 5
149 12 6
150 connection node_1;
151 SELECT * FROM t1;
152 a b
153 1 1
154 3 2
155 5 3
156 8 4
157 10 5
158 12 6
159 DROP TABLE t1;
160 DROP SEQUENCE t;
161 CREATE SEQUENCE t ENGINE=MYISAM;
162 ERROR 42000: This version of MariaDB doesn't yet support 'non-InnoDB sequences in Galera cluster'
163 SHOW CREATE SEQUENCE t;
164 ERROR 42S02: Table 'test.t' doesn't exist
165 SHOW CREATE TABLE t;
166 ERROR 42S02: Table 'test.t' doesn't exist
167 connection node_2;
168 SHOW CREATE SEQUENCE t;
169 ERROR 42S02: Table 'test.t' doesn't exist
170 SHOW CREATE TABLE t;
171 ERROR 42S02: Table 'test.t' doesn't exist
172 connection node_1;
173 CREATE SEQUENCE t NOCACHE ENGINE=InnoDB;
174 ALTER TABLE t ENGINE=MyISAM;
175 ERROR 42000: This version of MariaDB doesn't yet support 'non-InnoDB sequences in Galera cluster'
176 SHOW CREATE SEQUENCE t;
177 Table Create Table
178 t CREATE SEQUENCE `t` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 1 nocache nocycle ENGINE=InnoDB
179 SHOW CREATE TABLE t;
180 Table Create Table
181 t CREATE TABLE `t` (
182 `next_not_cached_value` bigint(21) NOT NULL,
183 `minimum_value` bigint(21) NOT NULL,
184 `maximum_value` bigint(21) NOT NULL,
185 `start_value` bigint(21) NOT NULL COMMENT 'start value when sequences is created or value if RESTART is used',
186 `increment` bigint(21) NOT NULL COMMENT 'increment value',
187 `cache_size` bigint(21) unsigned NOT NULL,
188 `cycle_option` tinyint(1) unsigned NOT NULL COMMENT '0 if no cycles are allowed, 1 if the sequence should begin a new cycle when maximum_value is passed',
189 `cycle_count` bigint(21) NOT NULL COMMENT 'How many cycles have been done'
190 ) ENGINE=InnoDB SEQUENCE=1
191 connection node_2;
192 SHOW CREATE SEQUENCE t;
193 Table Create Table
194 t CREATE SEQUENCE `t` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 1 nocache nocycle ENGINE=InnoDB
195 SHOW CREATE TABLE t;
196 Table Create Table
197 t CREATE TABLE `t` (
198 `next_not_cached_value` bigint(21) NOT NULL,
199 `minimum_value` bigint(21) NOT NULL,
200 `maximum_value` bigint(21) NOT NULL,
201 `start_value` bigint(21) NOT NULL COMMENT 'start value when sequences is created or value if RESTART is used',
202 `increment` bigint(21) NOT NULL COMMENT 'increment value',
203 `cache_size` bigint(21) unsigned NOT NULL,
204 `cycle_option` tinyint(1) unsigned NOT NULL COMMENT '0 if no cycles are allowed, 1 if the sequence should begin a new cycle when maximum_value is passed',
205 `cycle_count` bigint(21) NOT NULL COMMENT 'How many cycles have been done'
206 ) ENGINE=InnoDB SEQUENCE=1
207 connection node_1;
208 DROP SEQUENCE t;
209 CREATE SEQUENCE t INCREMENT BY 0 CACHE 1 ENGINE=INNODB;
210 CREATE TABLE t1(a int not null primary key default nextval(t), b int) engine=innodb;
211 connection node_2;
212 # Wait DDL to replicate
213 connection node_1;
214 SELECT @@auto_increment_increment;
215 @@auto_increment_increment
216 2
217 SELECT @@auto_increment_offset;
218 @@auto_increment_offset
219 1
220 SET SESSION wsrep_sync_wait=0;
221 connection node_2;
222 SELECT @@auto_increment_increment;
223 @@auto_increment_increment
224 2
225 SELECT @@auto_increment_offset;
226 @@auto_increment_offset
227 2
228 SET SESSION wsrep_sync_wait=0;
229 connection node_1;
230 connection node_2;
231 connection node_1;
232 DROP SEQUENCE t;
233 DROP TABLE t1;
234 CREATE SEQUENCE t INCREMENT BY 0 NOCACHE ENGINE=INNODB;
235 DROP SEQUENCE t;
236 CREATE SEQUENCE t INCREMENT BY 1 CACHE=20 ENGINE=INNODB;
237 ERROR 42000: This version of MariaDB doesn't yet support 'CACHE without INCREMENT BY 0 in Galera cluster'
238 CREATE SEQUENCE t INCREMENT BY 0 CACHE=20 ENGINE=INNODB;
239 CREATE TABLE t1(a int not null primary key default nextval(t), b int) engine=innodb;
240 connection node_2;
241 # Wait DDL to replicate
242 connection node_1;
243 SET SESSION wsrep_sync_wait=0;
244 connection node_2;
245 SET SESSION wsrep_sync_wait=0;
246 connection node_1;
247 connection node_2;
248 connection node_1;
249 DROP SEQUENCE t;
250 DROP TABLE t1;
251 CREATE SEQUENCE t INCREMENT BY 0 CACHE=20 ENGINE=INNODB;
252 ALTER TABLE t ENGINE=MYISAM;
253 ERROR 42000: This version of MariaDB doesn't yet support 'non-InnoDB sequences in Galera cluster'
254 ALTER SEQUENCE t INCREMENT BY 1 CACHE=10;
255 ERROR 42000: This version of MariaDB doesn't yet support 'CACHE without INCREMENT BY 0 in Galera cluster'
256 ALTER SEQUENCE t INCREMENT BY 1 NOCACHE;
257 ALTER SEQUENCE t INCREMENT BY 0 NOCACHE;
258 ALTER SEQUENCE t INCREMENT BY 0 CACHE=10;
259 DROP SEQUENCE t;
260 CREATE SEQUENCE t INCREMENT BY 0 CACHE=20 ENGINE=INNODB;
261 CREATE TABLE t1(a int not null primary key default nextval(t), b int) engine=innodb;
262 BEGIN;
263 INSERT INTO t1(b) VALUES (1);
264 INSERT INTO t1(b) VALUES (2);
265 INSERT INTO t1(b) VALUES (3);
266 INSERT INTO t1(b) VALUES (4);
267 INSERT INTO t1(a,b) VALUES (2,2);
268 INSERT INTO t1(a,b) VALUES (3,2);
269 ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
270 ROLLBACK;
271 SELECT * FROM t1;
272 a b
273 SELECT NEXTVAL(t);
274 NEXTVAL(t)
275 9
276 connection node_2;
277 SELECT * FROM t1;
278 a b
279 SELECT NEXTVAL(t);
280 NEXTVAL(t)
281 2
282 connection node_1;
283 DROP TABLE t1;
284 DROP SEQUENCE t;
285 connection node_2;
286 SET SESSION wsrep_sync_wait=15;
287 connection node_1;
288 CREATE SEQUENCE t INCREMENT BY 0 CACHE=20 ENGINE=INNODB;
289 CREATE TABLE t1(a int not null primary key default nextval(t), b int) engine=innodb;
290 BEGIN;
291 INSERT INTO t1(b) VALUES (1);
292 INSERT INTO t1(b) VALUES (2);
293 INSERT INTO t1(b) VALUES (3);
294 INSERT INTO t1(b) VALUES (4);
295 INSERT INTO t1(a,b) VALUES (2,2);
296 INSERT INTO t1(a,b) VALUES (3,2);
297 ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
298 COMMIT;
299 SELECT * FROM t1;
300 a b
301 1 1
302 2 2
303 3 2
304 5 3
305 7 4
306 SELECT NEXTVAL(t);
307 NEXTVAL(t)
308 9
309 connection node_2;
310 SELECT * FROM t1;
311 a b
312 1 1
313 2 2
314 3 2
315 5 3
316 7 4
317 SELECT NEXTVAL(t);
318 NEXTVAL(t)
319 42
320 connection node_1;
321 DROP TABLE t1;
322 DROP SEQUENCE t;
323
324 MDEV-33245 SIGSEGV in wsrep_check_sequence | Sql_cmd_alter_sequence::execute
325
326 CREATE TABLE t (a INT) ENGINE=InnoDB;
327 INSERT INTO t VALUES (0);
328 CREATE TABLE t1 (c VARCHAR) ENGINE=InnoDB;
329 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') ENGINE=InnoDB' at line 1
330 ALTER SEQUENCE IF EXISTS t MINVALUE=1;
331 ERROR 42000: This version of MariaDB doesn't yet support 'CACHE without INCREMENT BY 0 in Galera cluster'
332 DROP TABLE t;
333
334 MDEV-32631:
335
336 CREATE OR REPLACE TABLE t1(c INT ) ENGINE=ARIA;
337 SET SESSION WSREP_OSU_METHOD=RSU;
338 INSERT INTO t1 SELECT seq,concat(seq,1) FROM seq_1_to_100;
339 ERROR 42000: This version of MariaDB doesn't yet support 'RSU on this table engine'
340 SET SESSION WSREP_OSU_METHOD=TOI;
341 DROP TABLE t1;
342
343 End of 10.5 tests