mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 12:56:14 +01:00
64 lines
1.4 KiB
Text
64 lines
1.4 KiB
Text
--source include/galera_cluster.inc
|
|
--source include/have_innodb.inc
|
|
--source include/have_aria.inc
|
|
|
|
create table t1 (id serial, val int) engine=innodb;
|
|
create table t2 (id serial, val int) engine=aria;
|
|
|
|
insert into t1 values(1, 23);
|
|
insert into t2 values(2, 42);
|
|
|
|
call mtr.add_suppression("WSREP: Replication of non-transactional engines is experimental\\. Storage engine Aria for table 'test'\\.'t2' is not supported in Galera");
|
|
|
|
begin;
|
|
update t1 set val=24 where id=1;
|
|
update t2 set val=41 where id=2;
|
|
--error ER_ERROR_DURING_COMMIT
|
|
commit;
|
|
|
|
select * from t1;
|
|
select * from t2;
|
|
|
|
--connection node_2
|
|
select * from t1;
|
|
select * from t2;
|
|
|
|
--connection node_1
|
|
drop table t1, t2;
|
|
|
|
# case 2
|
|
SET GLOBAL wsrep_mode=REPLICATE_ARIA;
|
|
create table t1 (id serial, val int) engine=innodb;
|
|
create table t2 (id serial, val int) engine=aria;
|
|
|
|
insert into t1 values(1, 23);
|
|
insert into t2 values(2, 42);
|
|
|
|
begin;
|
|
update t1 set val=24 where id=1;
|
|
--error ER_ERROR_DURING_COMMIT
|
|
update t2 set val=41 where id=2;
|
|
commit;
|
|
|
|
select * from t1;
|
|
select * from t2;
|
|
|
|
--connection node_2
|
|
select * from t1;
|
|
select * from t2;
|
|
|
|
--connection node_1
|
|
drop table t1, t2;
|
|
|
|
# case 3
|
|
create table t2 (id serial, val int) engine=aria;
|
|
INSERT INTO t2 values(1,1);
|
|
UPDATE t2 set id=5,val=6 where id = 1;
|
|
SELECT * from t2;
|
|
|
|
--connection node_2
|
|
SELECT * from t2;
|
|
DROP TABLE t2;
|
|
|
|
--connection node_1
|
|
SET GLOBAL wsrep_mode=DEFAULT;
|