mirror of
https://github.com/MariaDB/server.git
synced 2026-03-04 23:49:02 +01:00
36b2696d6c
Test case changes only. If DDL is made using RSU in only one node, then all objects need also be dropped using RSU. Additionally, added wait_conditions in second test case to verify that DDL and DML has happened to second node before accessing them. Also run MDEV-30764 separately and force restart before test using --force-restart and different config because it does kill whole cluster and this could disturb next test case run by same worker.
50 lines
1.6 KiB
Text
50 lines
1.6 KiB
Text
connection node_2;
|
|
connection node_1;
|
|
connection node_2;
|
|
SET AUTOCOMMIT=0;
|
|
SET SESSION wsrep_OSU_method='RSU';
|
|
CREATE TABLE t (i int primary key, j int) ENGINE=InnoDB;
|
|
CREATE TEMPORARY SEQUENCE seq2 NOCACHE ENGINE=InnoDB;
|
|
COMMIT;
|
|
CREATE SEQUENCE seq1 NOCACHE ENGINE=InnoDB;
|
|
COMMIT;
|
|
DROP TABLE t;
|
|
DROP SEQUENCE seq2;
|
|
DROP SEQUENCE seq1;
|
|
SET SESSION wsrep_OSU_method='TOI';
|
|
connection node_1;
|
|
SET GLOBAL wsrep_OSU_method='TOI';
|
|
CREATE TABLE t (i int primary key, j int) ENGINE=InnoDB;
|
|
SET AUTOCOMMIT=0;
|
|
INSERT INTO t VALUES (3,0);
|
|
CREATE TEMPORARY SEQUENCE seq1 NOCACHE ENGINE=InnoDB;
|
|
COMMIT;
|
|
INSERT INTO t VALUES (4,0);
|
|
CREATE SEQUENCE seq2 NOCACHE ENGINE=InnoDB;
|
|
COMMIT;
|
|
connection node_2;
|
|
SET SESSION wsrep_sync_wait=0;
|
|
SELECT * FROM t;
|
|
i j
|
|
3 0
|
|
4 0
|
|
SHOW CREATE TABLE seq1;
|
|
ERROR 42S02: Table 'test.seq1' doesn't exist
|
|
SHOW CREATE TABLE seq2;
|
|
Table Create Table
|
|
seq2 CREATE TABLE `seq2` (
|
|
`next_not_cached_value` bigint(21) NOT NULL,
|
|
`minimum_value` bigint(21) NOT NULL,
|
|
`maximum_value` bigint(21) NOT NULL,
|
|
`start_value` bigint(21) NOT NULL COMMENT 'start value when sequences is created or value if RESTART is used',
|
|
`increment` bigint(21) NOT NULL COMMENT 'increment value',
|
|
`cache_size` bigint(21) unsigned NOT NULL,
|
|
`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',
|
|
`cycle_count` bigint(21) NOT NULL COMMENT 'How many cycles have been done'
|
|
) ENGINE=InnoDB SEQUENCE=1
|
|
connection node_1;
|
|
DROP TABLE t;
|
|
DROP SEQUENCE seq1;
|
|
DROP SEQUENCE seq2;
|
|
disconnect node_2;
|
|
disconnect node_1;
|