diff options
Diffstat (limited to 'storage/rocksdb/mysql-test/rocksdb/r/rpl_row_rocksdb.result')
-rw-r--r-- | storage/rocksdb/mysql-test/rocksdb/r/rpl_row_rocksdb.result | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/rpl_row_rocksdb.result b/storage/rocksdb/mysql-test/rocksdb/r/rpl_row_rocksdb.result new file mode 100644 index 00000000000..de47f3b39b0 --- /dev/null +++ b/storage/rocksdb/mysql-test/rocksdb/r/rpl_row_rocksdb.result @@ -0,0 +1,45 @@ +include/master-slave.inc +[connection master] +connection master; +drop table if exists t1; +connection master; +select @@binlog_format; +@@binlog_format +ROW +create table t1 (pk int primary key) engine=rocksdb; +insert into t1 values (1),(2),(3); +include/sync_slave_sql_with_master.inc +connection slave; +select * from t1; +pk +1 +2 +3 +connection master; +drop table t1; +# +# Issue #18: slave crash on update with row based binary logging +# +create table t1 (id int primary key, value int, value2 int, index(value)) engine=rocksdb; +insert into t1 values (1,1,1); +insert into t1 values (2,1,1); +insert into t1 values (3,1,1); +insert into t1 values (4,1,1); +insert into t1 values (5,1,1); +update t1 set value2=100 where id=1; +update t1 set value2=200 where id=2; +update t1 set value2=300 where id=3; +include/sync_slave_sql_with_master.inc +connection slave; +select * from t1 where id=1; +id value value2 +1 1 100 +select * from t1 where id=2; +id value value2 +2 1 200 +select * from t1 where id=3; +id value value2 +3 1 300 +connection master; +drop table t1; +include/rpl_end.inc |