diff options
Diffstat (limited to 'mysql-test/suite/ndb/r/ndb_binlog_ddl_multi.result')
| -rw-r--r-- | mysql-test/suite/ndb/r/ndb_binlog_ddl_multi.result | 196 |
1 files changed, 0 insertions, 196 deletions
diff --git a/mysql-test/suite/ndb/r/ndb_binlog_ddl_multi.result b/mysql-test/suite/ndb/r/ndb_binlog_ddl_multi.result deleted file mode 100644 index e3792f8272d..00000000000 --- a/mysql-test/suite/ndb/r/ndb_binlog_ddl_multi.result +++ /dev/null @@ -1,196 +0,0 @@ -drop database if exists mysqltest; -drop table if exists t1,t2,t3; -drop database if exists mysqltest; -drop table if exists t1,t2,t3; -reset master; -reset master; -create database mysqltest; -use mysqltest; -create table t1 (a int primary key) engine=ndb; -create table t2 (a int primary key) engine=ndb; -show binlog events from <binlog_start>; -Log_name Pos Event_type Server_id End_log_pos Info -mysqld-bin.000001 # Query 1 # create database mysqltest -mysqld-bin.000001 # Query 1 # use `mysqltest`; create table t1 (a int primary key) engine=ndb -mysqld-bin.000001 # Query 2 # use `test`; create table t2 (a int primary key) engine=ndb -show binlog events from <binlog_start>; -Log_name Pos Event_type Server_id End_log_pos Info -mysqld-bin.000001 # Query 1 # create database mysqltest -mysqld-bin.000001 # Query 1 # use `mysqltest`; create table t1 (a int primary key) engine=ndb -mysqld-bin.000001 # Query 2 # use `test`; create table t2 (a int primary key) engine=ndb -reset master; -reset master; -alter table t2 add column (b int); -show binlog events from <binlog_start>; -Log_name Pos Event_type Server_id End_log_pos Info -mysqld-bin.000001 # Query 2 # use `test`; alter table t2 add column (b int) -reset master; -reset master; -ALTER DATABASE mysqltest CHARACTER SET latin1; -drop table mysqltest.t1; -show binlog events from <binlog_start>; -Log_name Pos Event_type Server_id End_log_pos Info -mysqld-bin.000001 # Query 2 # ALTER DATABASE mysqltest CHARACTER SET latin1 -mysqld-bin.000001 # Query 2 # use `mysqltest`; drop table `t1` -show binlog events from <binlog_start>; -Log_name Pos Event_type Server_id End_log_pos Info -mysqld-bin.000001 # Query 2 # ALTER DATABASE mysqltest CHARACTER SET latin1 -mysqld-bin.000001 # Query 2 # use `mysqltest`; drop table `t1` -reset master; -reset master; -use test; -insert into t2 values (1,2); -drop database mysqltest; -create table t1 (a int primary key) engine=ndb; -show binlog events from <binlog_start>; -Log_name Pos Event_type Server_id End_log_pos Info -mysqld-bin.000001 # Query 2 # BEGIN -mysqld-bin.000001 # Table_map 2 # table_id: # (test.t2) -mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status) -mysqld-bin.000001 # Write_rows 2 # table_id: # -mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F -mysqld-bin.000001 # Query 2 # COMMIT -mysqld-bin.000001 # Query 1 # drop database mysqltest -mysqld-bin.000001 # Query 1 # use `test`; create table t1 (a int primary key) engine=ndb -drop table t2; -reset master; -reset master; -CREATE LOGFILE GROUP lg1 -ADD UNDOFILE 'undofile.dat' -INITIAL_SIZE 16M -UNDO_BUFFER_SIZE = 1M -ENGINE=NDB; -ALTER LOGFILE GROUP lg1 -ADD UNDOFILE 'undofile02.dat' -INITIAL_SIZE = 4M -ENGINE=NDB; -CREATE TABLESPACE ts1 -ADD DATAFILE 'datafile.dat' -USE LOGFILE GROUP lg1 -INITIAL_SIZE 12M -ENGINE NDB; -ALTER TABLESPACE ts1 -ADD DATAFILE 'datafile02.dat' -INITIAL_SIZE = 4M -ENGINE=NDB; -ALTER TABLESPACE ts1 -DROP DATAFILE 'datafile.dat' -ENGINE = NDB; -ALTER TABLESPACE ts1 -DROP DATAFILE 'datafile02.dat' -ENGINE = NDB; -DROP TABLESPACE ts1 -ENGINE = NDB; -DROP LOGFILE GROUP lg1 -ENGINE =NDB; -show binlog events from <binlog_start>; -Log_name Pos Event_type Server_id End_log_pos Info -mysqld-bin.000001 # Query 1 # CREATE LOGFILE GROUP lg1 -ADD UNDOFILE 'undofile.dat' -INITIAL_SIZE 16M -UNDO_BUFFER_SIZE = 1M -ENGINE=NDB -mysqld-bin.000001 # Query 1 # ALTER LOGFILE GROUP lg1 -ADD UNDOFILE 'undofile02.dat' -INITIAL_SIZE = 4M -ENGINE=NDB -mysqld-bin.000001 # Query 1 # CREATE TABLESPACE ts1 -ADD DATAFILE 'datafile.dat' -USE LOGFILE GROUP lg1 -INITIAL_SIZE 12M -ENGINE NDB -mysqld-bin.000001 # Query 1 # ALTER TABLESPACE ts1 -ADD DATAFILE 'datafile02.dat' -INITIAL_SIZE = 4M -ENGINE=NDB -mysqld-bin.000001 # Query 1 # ALTER TABLESPACE ts1 -DROP DATAFILE 'datafile.dat' -ENGINE = NDB -mysqld-bin.000001 # Query 1 # ALTER TABLESPACE ts1 -DROP DATAFILE 'datafile02.dat' -ENGINE = NDB -mysqld-bin.000001 # Query 1 # DROP TABLESPACE ts1 -ENGINE = NDB -mysqld-bin.000001 # Query 1 # DROP LOGFILE GROUP lg1 -ENGINE =NDB -show binlog events from <binlog_start>; -Log_name Pos Event_type Server_id End_log_pos Info -mysqld-bin.000001 # Query 1 # CREATE LOGFILE GROUP lg1 -ADD UNDOFILE 'undofile.dat' -INITIAL_SIZE 16M -UNDO_BUFFER_SIZE = 1M -ENGINE=NDB -mysqld-bin.000001 # Query 1 # ALTER LOGFILE GROUP lg1 -ADD UNDOFILE 'undofile02.dat' -INITIAL_SIZE = 4M -ENGINE=NDB -mysqld-bin.000001 # Query 1 # CREATE TABLESPACE ts1 -ADD DATAFILE 'datafile.dat' -USE LOGFILE GROUP lg1 -INITIAL_SIZE 12M -ENGINE NDB -mysqld-bin.000001 # Query 1 # ALTER TABLESPACE ts1 -ADD DATAFILE 'datafile02.dat' -INITIAL_SIZE = 4M -ENGINE=NDB -mysqld-bin.000001 # Query 1 # ALTER TABLESPACE ts1 -DROP DATAFILE 'datafile.dat' -ENGINE = NDB -mysqld-bin.000001 # Query 1 # ALTER TABLESPACE ts1 -DROP DATAFILE 'datafile02.dat' -ENGINE = NDB -mysqld-bin.000001 # Query 1 # DROP TABLESPACE ts1 -ENGINE = NDB -mysqld-bin.000001 # Query 1 # DROP LOGFILE GROUP lg1 -ENGINE =NDB -drop table t1; -reset master; -show tables; -Tables_in_test -reset master; -show tables; -Tables_in_test -create table t1 (a int key) engine=ndb; -create table t2 (a int key) engine=ndb; -create table t3 (a int key) engine=ndb; -rename table t3 to t4, t2 to t3, t1 to t2, t4 to t1; -show binlog events from <binlog_start>; -Log_name Pos Event_type Server_id End_log_pos Info -mysqld-bin.000001 # Query 1 # use `test`; create table t1 (a int key) engine=ndb -mysqld-bin.000001 # Query 1 # use `test`; create table t2 (a int key) engine=ndb -mysqld-bin.000001 # Query 1 # use `test`; create table t3 (a int key) engine=ndb -mysqld-bin.000001 # Query 1 # use `test`; rename table `test.t3` to `test.t4` -mysqld-bin.000001 # Query 1 # use `test`; rename table `test.t2` to `test.t3` -mysqld-bin.000001 # Query 1 # use `test`; rename table `test.t1` to `test.t2` -mysqld-bin.000001 # Query 1 # use `test`; rename table `test.t4` to `test.t1` -drop table t1; -drop table t2; -drop table t3; -reset master; -show tables; -Tables_in_test -reset master; -show tables; -Tables_in_test -create table t1 (a int key) engine=ndb; -insert into t1 values(1); -rename table t1 to t2; -insert into t2 values(2); -drop table t2; -show binlog events from <binlog_start>; -Log_name Pos Event_type Server_id End_log_pos Info -mysqld-bin.000001 # Query 1 # use `test`; create table t1 (a int key) engine=ndb -mysqld-bin.000001 # Query 2 # BEGIN -mysqld-bin.000001 # Table_map 2 # table_id: # (test.t1) -mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status) -mysqld-bin.000001 # Write_rows 2 # table_id: # -mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F -mysqld-bin.000001 # Query 2 # COMMIT -mysqld-bin.000001 # Query 1 # use `test`; rename table `test.t1` to `test.t2` -mysqld-bin.000001 # Query 2 # BEGIN -mysqld-bin.000001 # Table_map 2 # table_id: # (test.t2) -mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status) -mysqld-bin.000001 # Write_rows 2 # table_id: # -mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F -mysqld-bin.000001 # Query 2 # COMMIT -mysqld-bin.000001 # Query 2 # use `test`; DROP TABLE `t2` /* generated by server */ |