Debian Codegraph @

mysql-test/suite/galera/t/galera_temporary_sequences.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_sequence.inc
3
4 --connection node_2
5 SET AUTOCOMMIT=0;
6 SET SESSION wsrep_OSU_method='RSU';
7 CREATE TABLE t (i int primary key, j int) ENGINE=InnoDB;
8 CREATE TEMPORARY SEQUENCE seq2 NOCACHE ENGINE=InnoDB;
9 COMMIT;
10 CREATE SEQUENCE seq1 NOCACHE ENGINE=InnoDB;
11 COMMIT;
12 DROP TABLE t;
13 DROP SEQUENCE seq2;
14 DROP SEQUENCE seq1;
15 SET SESSION wsrep_OSU_method='TOI';
16
17 --connection node_1
18 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
19 --source include/wait_condition.inc
20 SET GLOBAL wsrep_OSU_method='TOI';
21 CREATE TABLE t (i int primary key, j int) ENGINE=InnoDB;
22 SET AUTOCOMMIT=0;
23 INSERT INTO t VALUES (3,0);
24 CREATE TEMPORARY SEQUENCE seq1 NOCACHE ENGINE=InnoDB;
25 COMMIT;
26 INSERT INTO t VALUES (4,0);
27 CREATE SEQUENCE seq2 NOCACHE ENGINE=InnoDB;
28 COMMIT;
29
30 --connection node_2
31 SET SESSION wsrep_sync_wait=0;
32 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
33 --source include/wait_condition.inc
34 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't'
35 --source include/wait_condition.inc
36 --let $wait_condition = SELECT COUNT(*) = 2 FROM t
37 --source include/wait_condition.inc
38
39 SELECT * FROM t;
40 --error ER_NO_SUCH_TABLE
41 SHOW CREATE TABLE seq1;
42 SHOW CREATE TABLE seq2;
43
44 --connection node_1
45 DROP TABLE t;
46 DROP SEQUENCE seq1;
47 DROP SEQUENCE seq2;
48
49 --source include/galera_end.inc