diff options
author | unknown <sasha@mysql.sashanet.com> | 2002-06-05 20:16:44 -0600 |
---|---|---|
committer | unknown <sasha@mysql.sashanet.com> | 2002-06-05 20:16:44 -0600 |
commit | 40a7f1d30aea947f2a2e370bcff49a5f5d729807 (patch) | |
tree | 1c529a35f853c9a0437024f3baeb2e7dc8ddefdc /mysql-test | |
parent | 32113efe2a7d32bfa5820cda37164436a53719cc (diff) | |
download | mariadb-git-40a7f1d30aea947f2a2e370bcff49a5f5d729807.tar.gz |
spurious binlog error code logging on temp table auto-drop fixed
added a new replication test
sql/sql_base.cc:
f
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/rpl_alter.result | 4 | ||||
-rw-r--r-- | mysql-test/t/rpl_alter.test | 21 |
2 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/r/rpl_alter.result b/mysql-test/r/rpl_alter.result new file mode 100644 index 00000000000..7883e725e3a --- /dev/null +++ b/mysql-test/r/rpl_alter.result @@ -0,0 +1,4 @@ +n m +1 2 +n +45 diff --git a/mysql-test/t/rpl_alter.test b/mysql-test/t/rpl_alter.test new file mode 100644 index 00000000000..a65605f703e --- /dev/null +++ b/mysql-test/t/rpl_alter.test @@ -0,0 +1,21 @@ +source include/master-slave.inc; +connection master; +use test; +drop database if exists d1; +create database d1; +create table d1.t1 ( n int); +alter table d1.t1 add m int; +insert into d1.t1 values (1,2); +create table d1.t2 (n int); +insert into d1.t2 values (45); +rename table d1.t2 to d1.t3, d1.t1 to d1.t2; +save_master_pos; +connection slave; +sync_with_master; +select * from d1.t2; +select * from d1.t3; +connection master; +drop database d1; +save_master_pos; +connection slave; +sync_with_master; |