summaryrefslogtreecommitdiff
path: root/mysql-test/r/rpl_log.result
diff options
context:
space:
mode:
authorunknown <bell@sanja.is.com.ua>2003-06-19 15:25:41 +0300
committerunknown <bell@sanja.is.com.ua>2003-06-19 15:25:41 +0300
commit23ebb07fbc33430bd84a32d10f86f99fa791e465 (patch)
treecc9f1f02e2484cc414e4281f672a544211566e1c /mysql-test/r/rpl_log.result
parent145aa40d59150159018676033e30ec227519f6ef (diff)
parent5123410bd5b69662aff22c17e3a46bb6aa1d045f (diff)
downloadmariadb-git-23ebb07fbc33430bd84a32d10f86f99fa791e465.tar.gz
Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1
into sanja.is.com.ua:/home/bell/mysql/bk/work-item-4.1 sql/item.cc: Auto merged sql/item_subselect.cc: Auto merged sql/item_sum.cc: Auto merged sql/sql_lex.h: Auto merged sql/sql_select.cc: Auto merged sql/sql_union.cc: Auto merged sql/sql_yacc.yy: Auto merged
Diffstat (limited to 'mysql-test/r/rpl_log.result')
-rw-r--r--mysql-test/r/rpl_log.result24
1 files changed, 15 insertions, 9 deletions
diff --git a/mysql-test/r/rpl_log.result b/mysql-test/r/rpl_log.result
index 6f438c6c34a..df2ef4e3d8a 100644
--- a/mysql-test/r/rpl_log.result
+++ b/mysql-test/r/rpl_log.result
@@ -36,6 +36,8 @@ show binlog events from 79 limit 2,1;
Log_name Pos Event_type Server_id Orig_log_pos Info
master-bin.000001 200 Query 1 200 use `test`; insert into t1 values (NULL)
flush logs;
+create table t5 (a int);
+drop table t5;
start slave;
flush logs;
stop slave;
@@ -56,9 +58,11 @@ master-bin.000001 1079 Query 1 1079 use `test`; drop table t1
master-bin.000001 1127 Rotate 1 1127 master-bin.000002;pos=4
show binlog events in 'master-bin.000002';
Log_name Pos Event_type Server_id Orig_log_pos Info
-master-bin.000002 4 Query 1 4 use `test`; create table t1 (n int)
-master-bin.000002 62 Query 1 62 use `test`; insert into t1 values (1)
-master-bin.000002 122 Query 1 122 use `test`; drop table t1
+master-bin.000002 4 Query 1 4 use `test`; create table t5 (a int)
+master-bin.000002 62 Query 1 62 use `test`; drop table t5
+master-bin.000002 110 Query 1 110 use `test`; create table t1 (n int)
+master-bin.000002 168 Query 1 168 use `test`; insert into t1 values (1)
+master-bin.000002 228 Query 1 228 use `test`; drop table t1
show binary logs;
Log_name
master-bin.000001
@@ -79,14 +83,16 @@ slave-bin.000001 311 Query 1 311 use `test`; create table t1 (word char(20) not
slave-bin.000001 386 Create_file 1 386 db=test;table=t1;file_id=1;block_len=581
slave-bin.000001 1065 Exec_load 1 1056 ;file_id=1
slave-bin.000001 1088 Query 1 1079 use `test`; drop table t1
-slave-bin.000001 1136 Rotate 2 1136 slave-bin.000002;pos=4
+slave-bin.000001 1136 Query 1 4 use `test`; create table t5 (a int)
+slave-bin.000001 1194 Query 1 62 use `test`; drop table t5
+slave-bin.000001 1242 Rotate 2 1242 slave-bin.000002;pos=4
show binlog events in 'slave-bin.000002' from 4;
Log_name Pos Event_type Server_id Orig_log_pos Info
-slave-bin.000002 4 Query 1 4 use `test`; create table t1 (n int)
-slave-bin.000002 62 Query 1 62 use `test`; insert into t1 values (1)
-slave-bin.000002 122 Query 1 122 use `test`; drop table t1
+slave-bin.000002 4 Query 1 110 use `test`; create table t1 (n int)
+slave-bin.000002 62 Query 1 168 use `test`; insert into t1 values (1)
+slave-bin.000002 122 Query 1 228 use `test`; drop table t1
show slave status;
Master_Host Master_User Master_Port Connect_retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_do_db Replicate_ignore_db Last_errno Last_error Skip_counter Exec_master_log_pos Relay_log_space
-127.0.0.1 root MASTER_PORT 1 master-bin.000002 170 slave-relay-bin.000002 1469 master-bin.000002 Yes Yes 0 0 170 1473
+127.0.0.1 root MASTER_PORT 1 master-bin.000002 276 slave-relay-bin.000002 1531 master-bin.000002 Yes Yes 0 0 276 1535
show binlog events in 'slave-bin.000005' from 4;
-Error when executing command SHOW BINLOG EVENTS: Could not find target log
+ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log