mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 04:46:15 +01:00
a16f4927db
The optional AND CHAIN clause is a convenience for initiating a new transaction as soon as the old transaction terminates. Therefore, do not start new transaction if it is already started at wsrep_start_transaction.
19 lines
325 B
Text
19 lines
325 B
Text
--source include/galera_cluster.inc
|
|
|
|
ROLLBACK AND CHAIN;
|
|
|
|
CREATE TABLE t1(a int not null primary key) engine=innodb;
|
|
INSERT INTO t1 values (1);
|
|
|
|
BEGIN;
|
|
INSERT INTO t1 values (2);
|
|
ROLLBACK AND CHAIN;
|
|
|
|
SELECT * FROM t1;
|
|
|
|
--connection node_2
|
|
SET SESSION wsrep_sync_wait=15;
|
|
SELECT * FROM t1;
|
|
|
|
--connection node_1
|
|
DROP TABLE t1;
|