mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 04:46:15 +01:00
43 lines
804 B
Text
43 lines
804 B
Text
#
|
|
# Test that identical updates can be delivered to two separate
|
|
# databases without this causing a certification conflict
|
|
#
|
|
|
|
--source include/galera_cluster.inc
|
|
--source include/have_innodb.inc
|
|
|
|
CREATE DATABASE d1;
|
|
CREATE TABLE d1.t1(f1 INTEGER) ENGINE=InnoDB;
|
|
|
|
CREATE DATABASE d2;
|
|
CREATE TABLE d2.t1(f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
|
|
|
|
--connection node_1
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO d1.t1 VALUES (1);
|
|
|
|
--connection node_2
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO d2.t1 VALUES (1);
|
|
|
|
--connection node_1
|
|
COMMIT;
|
|
|
|
--connection node_2
|
|
COMMIT;
|
|
|
|
SELECT COUNT(*) = 1 FROM d1.t1;
|
|
SELECT COUNT(*) = 1 FROM d2.t1;
|
|
|
|
--connection node_1
|
|
|
|
SELECT COUNT(*) = 1 FROM d1.t1;
|
|
SELECT COUNT(*) = 1 FROM d2.t1;
|
|
|
|
DROP TABLE d1.t1;
|
|
DROP TABLE d2.t1;
|
|
|
|
DROP DATABASE d1;
|
|
DROP DATABASE d2;
|