mirror of
https://github.com/MariaDB/server.git
synced 2025-04-06 07:15:33 +02: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.
18 lines
327 B
Text
18 lines
327 B
Text
connection node_2;
|
|
connection node_1;
|
|
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;
|
|
a
|
|
1
|
|
connection node_2;
|
|
SET SESSION wsrep_sync_wait=15;
|
|
SELECT * FROM t1;
|
|
a
|
|
1
|
|
connection node_1;
|
|
DROP TABLE t1;
|