diff options
| author | unknown <tomas@poseidon.ndb.mysql.com> | 2006-03-13 09:55:41 +0100 |
|---|---|---|
| committer | unknown <tomas@poseidon.ndb.mysql.com> | 2006-03-13 09:55:41 +0100 |
| commit | 9db5b7d4f5355328bf1c77d7031af20baba924c4 (patch) | |
| tree | 326a967e25fcfd2c85c3f5a3c57ae03bfb3db6a8 /mysql-test/r/ndb_binlog_multi.result | |
| parent | 3364f871d48fe852f6914f4938b8331d81c78a3b (diff) | |
| download | mariadb-git-9db5b7d4f5355328bf1c77d7031af20baba924c4.tar.gz | |
changed test to make it predictable
sql/ha_ndbcluster_binlog.cc:
removing non critical assert
Diffstat (limited to 'mysql-test/r/ndb_binlog_multi.result')
| -rw-r--r-- | mysql-test/r/ndb_binlog_multi.result | 57 |
1 files changed, 47 insertions, 10 deletions
diff --git a/mysql-test/r/ndb_binlog_multi.result b/mysql-test/r/ndb_binlog_multi.result index 81f42a4f5b8..be5dc695d24 100644 --- a/mysql-test/r/ndb_binlog_multi.result +++ b/mysql-test/r/ndb_binlog_multi.result @@ -1,12 +1,18 @@ drop table if exists t1,t2; drop table if exists t1,t2; -SHOW TABLES; -Tables_in_test +reset master; +reset master; CREATE TABLE t2 (a INT PRIMARY KEY, b int) ENGINE = NDB; -show tables; -Tables_in_test -t2 INSERT INTO t2 VALUES (1,1),(2,2); +show binlog events from <binlog_start>; +Log_name Pos Event_type Server_id End_log_pos Info +master-bin1.000001 # Query # # use `test`; CREATE TABLE t2 (a INT PRIMARY KEY, b int) ENGINE = NDB +master-bin1.000001 # Query # # BEGIN +master-bin1.000001 # Table_map # # table_id: # (test.t2) +master-bin1.000001 # Table_map # # table_id: # (cluster.apply_status) +master-bin1.000001 # Write_rows # # table_id: # +master-bin1.000001 # Write_rows # # table_id: # flags: STMT_END_F +master-bin1.000001 # Query # # COMMIT select * from t2 order by a; a b 1 1 @@ -19,23 +25,54 @@ SELECT * FROM t2 ORDER BY a; a b 1 1 2 2 +DROP TABLE t2; +show binlog events from <binlog_start>; +Log_name Pos Event_type Server_id End_log_pos Info +master-bin.000001 # Query # # use `test`; CREATE TABLE t2 (a INT PRIMARY KEY, b int) ENGINE = NDB +master-bin.000001 # Query # # BEGIN +master-bin.000001 # Table_map # # table_id: # (test.t2) +master-bin.000001 # Table_map # # table_id: # (cluster.apply_status) +master-bin.000001 # Write_rows # # table_id: # +master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F +master-bin.000001 # Query # # COMMIT +master-bin.000001 # Query # # use `test`; DROP TABLE t2 SELECT inserts,updates,deletes,schemaops FROM cluster.binlog_index WHERE epoch=<the_epoch>; inserts updates deletes schemaops 2 0 0 0 -DROP TABLE t2; +reset master; +reset master; CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE = NDB; INSERT INTO t1 VALUES (1),(2); +show binlog events from <binlog_start>; +Log_name Pos Event_type Server_id End_log_pos Info +master-bin1.000001 # Query # # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE = NDB +master-bin1.000001 # Query # # BEGIN +master-bin1.000001 # Table_map # # table_id: # (test.t1) +master-bin1.000001 # Table_map # # table_id: # (cluster.apply_status) +master-bin1.000001 # Write_rows # # table_id: # +master-bin1.000001 # Write_rows # # table_id: # flags: STMT_END_F +master-bin1.000001 # Query # # COMMIT SELECT @the_epoch2:=epoch,inserts,updates,deletes,schemaops FROM cluster.binlog_index ORDER BY epoch DESC LIMIT 1; @the_epoch2:=epoch inserts updates deletes schemaops <the_epoch2> 2 0 0 0 SELECT inserts,updates,deletes,schemaops FROM -cluster.binlog_index WHERE epoch > <the_epoch> AND epoch < <the_epoch2>; +cluster.binlog_index WHERE epoch > <the_epoch> AND epoch <= <the_epoch2>; inserts updates deletes schemaops +2 0 0 0 drop table t1; -SHOW TABLES; -Tables_in_test +show binlog events from <binlog_start>; +Log_name Pos Event_type Server_id End_log_pos Info +master-bin1.000001 # Query # # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE = NDB +master-bin1.000001 # Query # # BEGIN +master-bin1.000001 # Table_map # # table_id: # (test.t1) +master-bin1.000001 # Table_map # # table_id: # (cluster.apply_status) +master-bin1.000001 # Write_rows # # table_id: # +master-bin1.000001 # Write_rows # # table_id: # flags: STMT_END_F +master-bin1.000001 # Query # # COMMIT +master-bin1.000001 # Query # # use `test`; drop table t1 SELECT inserts,updates,deletes,schemaops FROM -cluster.binlog_index WHERE epoch > <the_epoch> AND epoch < <the_epoch2>; +cluster.binlog_index WHERE epoch > <the_epoch> AND epoch <= <the_epoch2>; inserts updates deletes schemaops +2 0 0 0 |