diff options
Diffstat (limited to 'mysql-test/suite/versioning/r/rpl_row.result')
-rw-r--r-- | mysql-test/suite/versioning/r/rpl_row.result | 54 |
1 files changed, 23 insertions, 31 deletions
diff --git a/mysql-test/suite/versioning/r/rpl_row.result b/mysql-test/suite/versioning/r/rpl_row.result index 6d41ed6ff7b..b91c8fd33c8 100644 --- a/mysql-test/suite/versioning/r/rpl_row.result +++ b/mysql-test/suite/versioning/r/rpl_row.result @@ -2,7 +2,7 @@ include/master-slave.inc [connection master] connection slave; connection master; -CREATE TABLE t1 (x int) with system versioning ENGINE = innodb; +CREATE TABLE t1 (x int) with system versioning; insert into t1 values (1); SELECT * FROM t1; x @@ -37,11 +37,19 @@ x 3 2 connection master; -create or replace table t1 (x int primary key) engine = innodb; +create or replace table t1 (x int primary key); connection slave; alter table t1 with system versioning; connection master; insert into t1 values (1); +connection slave; +select * from t1; +x +1 +select * from t1 for system_time all; +x +1 +connection master; update t1 set x= 2 where x = 1; connection slave; select * from t1; @@ -61,7 +69,7 @@ x 1 2 connection master; -create or replace table t1 (x int) engine = innodb; +create or replace table t1 (x int); connection slave; alter table t1 with system versioning; connection master; @@ -85,42 +93,26 @@ x 2 1 connection master; -create or replace table t1 (x int primary key) with system versioning engine = innodb; -connection slave; -alter table t1 without system versioning; -connection master; +create or replace table t1 (x int) with system versioning; +create or replace table t2 (x int) with system versioning; insert into t1 values (1); -update t1 set x= 2 where x = 1; -select * from t1 for system_time all; -x -1 -2 +insert into t2 values (2); +update t1, t2 set t1.x=11, t2.x=22; connection slave; select * from t1; x -2 -connection master; -delete from t1; +11 +select * from t2; +x +22 select * from t1 for system_time all; x +11 1 -2 -connection slave; -select * from t1; +select * from t2 for system_time all; x -connection master; -create or replace table t1 (a int) with system versioning engine = innodb; -insert into t1 values (1); -update t1 set a=2; -select * from t1 for system_time all; -a +22 2 -1 -connection slave; -select * from t1 for system_time all; -a -2 -1 connection master; -drop table t1; +drop table t1, t2; include/rpl_end.inc |