Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_2;
4 SET AUTOCOMMIT=0;
5 SET SESSION wsrep_OSU_method='RSU';
6 CREATE TABLE t (i int primary key, j int) ENGINE=InnoDB;
7 CREATE TEMPORARY SEQUENCE seq2 NOCACHE ENGINE=InnoDB;
8 COMMIT;
9 CREATE SEQUENCE seq1 NOCACHE ENGINE=InnoDB;
10 COMMIT;
11 DROP TABLE t;
12 DROP SEQUENCE seq2;
13 DROP SEQUENCE seq1;
14 SET SESSION wsrep_OSU_method='TOI';
15 connection node_1;
16 SET GLOBAL wsrep_OSU_method='TOI';
17 CREATE TABLE t (i int primary key, j int) ENGINE=InnoDB;
18 SET AUTOCOMMIT=0;
19 INSERT INTO t VALUES (3,0);
20 CREATE TEMPORARY SEQUENCE seq1 NOCACHE ENGINE=InnoDB;
21 COMMIT;
22 INSERT INTO t VALUES (4,0);
23 CREATE SEQUENCE seq2 NOCACHE ENGINE=InnoDB;
24 COMMIT;
25 connection node_2;
26 SET SESSION wsrep_sync_wait=0;
27 SELECT * FROM t;
28 i j
29 3 0
30 4 0
31 SHOW CREATE TABLE seq1;
32 ERROR 42S02: Table 'test.seq1' doesn't exist
33 SHOW CREATE TABLE seq2;
34 Table Create Table
35 seq2 CREATE TABLE `seq2` (
36 `next_not_cached_value` bigint(21) NOT NULL,
37 `minimum_value` bigint(21) NOT NULL,
38 `maximum_value` bigint(21) NOT NULL,
39 `start_value` bigint(21) NOT NULL COMMENT 'start value when sequences is created or value if RESTART is used',
40 `increment` bigint(21) NOT NULL COMMENT 'increment value',
41 `cache_size` bigint(21) unsigned NOT NULL,
42 `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',
43 `cycle_count` bigint(21) NOT NULL COMMENT 'How many cycles have been done'
44 ) ENGINE=InnoDB SEQUENCE=1
45 connection node_1;
46 DROP TABLE t;
47 DROP SEQUENCE seq1;
48 DROP SEQUENCE seq2;
49 disconnect node_2;
50 disconnect node_1;