Debian Codegraph @

mysql-test/suite/galera/r/MDEV-37366.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 connection node_1;
6 SET SESSION binlog_row_image=minimal;
7 CREATE SEQUENCE `seq_test` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 0 cache 1000 nocycle ENGINE=InnoDB;
8 SHOW CREATE TABLE seq_test;
9 Table Create Table
10 seq_test CREATE TABLE `seq_test` (
11 `next_not_cached_value` bigint(21) NOT NULL,
12 `minimum_value` bigint(21) NOT NULL,
13 `maximum_value` bigint(21) NOT NULL,
14 `start_value` bigint(21) NOT NULL COMMENT 'start value when sequences is created or value if RESTART is used',
15 `increment` bigint(21) NOT NULL COMMENT 'increment value',
16 `cache_size` bigint(21) unsigned NOT NULL,
17 `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',
18 `cycle_count` bigint(21) NOT NULL COMMENT 'How many cycles have been done'
19 ) ENGINE=InnoDB SEQUENCE=1
20 SELECT NEXT VALUE FOR seq_test;
21 NEXT VALUE FOR seq_test
22 1
23 SELECT NEXT VALUE FOR seq_test;
24 NEXT VALUE FOR seq_test
25 3
26 connection node_2;
27 DROP SEQUENCE seq_test;