diff options
Diffstat (limited to 'mysql-test/suite/ndb/r/ndb_binlog_basic.result')
-rw-r--r-- | mysql-test/suite/ndb/r/ndb_binlog_basic.result | 48 |
1 files changed, 48 insertions, 0 deletions
diff --git a/mysql-test/suite/ndb/r/ndb_binlog_basic.result b/mysql-test/suite/ndb/r/ndb_binlog_basic.result new file mode 100644 index 00000000000..09edd78bdb3 --- /dev/null +++ b/mysql-test/suite/ndb/r/ndb_binlog_basic.result @@ -0,0 +1,48 @@ +drop table if exists t1, t2; +drop database if exists mysqltest; +create database mysqltest; +use mysqltest; +drop database mysqltest; +use test; +create table t1 (a int primary key) engine=ndb; +insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); +select @max_epoch:=max(epoch)-1 from mysql.ndb_binlog_index; +@max_epoch:=max(epoch)-1 +# +delete from t1; +alter table t1 add (b int); +insert into t1 values (3,3),(4,4); +alter table t1 rename t2; +begin; +insert into t2 values (1,1),(2,2); +update t2 set b=1 where a=3; +delete from t2 where a=4; +commit; +drop table t2; +select inserts from mysql.ndb_binlog_index where epoch > @max_epoch and inserts > 5; +inserts +10 +select deletes from mysql.ndb_binlog_index where epoch > @max_epoch and deletes > 5; +deletes +10 +select inserts,updates,deletes from +mysql.ndb_binlog_index where epoch > @max_epoch and updates > 0; +inserts updates deletes +2 1 1 +flush logs; +purge master logs before now(); +create table t1 (a int primary key, b int) engine=ndb; +create database mysqltest; +use mysqltest; +create table t1 (c int, d int primary key) engine=ndb; +use test; +insert into mysqltest.t1 values (2,1),(2,2); +select @max_epoch:=max(epoch)-1 from mysql.ndb_binlog_index; +@max_epoch:=max(epoch)-1 +# +drop table t1; +drop database mysqltest; +select inserts,updates,deletes from +mysql.ndb_binlog_index where epoch > @max_epoch and inserts > 0; +inserts updates deletes +2 0 0 |