diff options
| author | Rich Prohaska <prohaska@tokutek.com> | 2014-04-25 11:58:56 -0400 |
|---|---|---|
| committer | Rich Prohaska <prohaska@tokutek.com> | 2014-04-25 11:58:56 -0400 |
| commit | ac41e1c2b06574dec312cb56dc9022aed779681e (patch) | |
| tree | 94093315e1b03785ba47356842c51f63bb8dfafe /mysql-test | |
| parent | a35427dcf8125befaacd2b7adbc061e045fe4584 (diff) | |
| download | mariadb-git-ac41e1c2b06574dec312cb56dc9022aed779681e.tar.gz | |
#110 test cases for replace into with replication
Diffstat (limited to 'mysql-test')
6 files changed, 138 insertions, 0 deletions
diff --git a/mysql-test/suite/tokudb.bugs/r/rpl_mixed_replace_into.result b/mysql-test/suite/tokudb.bugs/r/rpl_mixed_replace_into.result new file mode 100644 index 00000000000..b1482aa0144 --- /dev/null +++ b/mysql-test/suite/tokudb.bugs/r/rpl_mixed_replace_into.result @@ -0,0 +1,21 @@ +include/master-slave.inc +[connection master] +set default_storage_engine='tokudb'; +drop table if exists testr; +CREATE TABLE testr (pk int(11) NOT NULL AUTO_INCREMENT, num int(11) DEFAULT NULL, txt varchar(32) DEFAULT NULL, PRIMARY KEY (pk) ); +INSERT INTO testr VALUES (1,1,'one'),(2,2,'two'),(3,3,'three'),(4,4,'four'); +replace into testr values (2,2,'twotwo'); +select * from testr; +pk num txt +1 1 one +2 2 twotwo +3 3 three +4 4 four +select * from testr; +pk num txt +1 1 one +2 2 twotwo +3 3 three +4 4 four +drop table testr; +include/rpl_end.inc diff --git a/mysql-test/suite/tokudb.bugs/r/rpl_row_replace_into.result b/mysql-test/suite/tokudb.bugs/r/rpl_row_replace_into.result new file mode 100644 index 00000000000..b1482aa0144 --- /dev/null +++ b/mysql-test/suite/tokudb.bugs/r/rpl_row_replace_into.result @@ -0,0 +1,21 @@ +include/master-slave.inc +[connection master] +set default_storage_engine='tokudb'; +drop table if exists testr; +CREATE TABLE testr (pk int(11) NOT NULL AUTO_INCREMENT, num int(11) DEFAULT NULL, txt varchar(32) DEFAULT NULL, PRIMARY KEY (pk) ); +INSERT INTO testr VALUES (1,1,'one'),(2,2,'two'),(3,3,'three'),(4,4,'four'); +replace into testr values (2,2,'twotwo'); +select * from testr; +pk num txt +1 1 one +2 2 twotwo +3 3 three +4 4 four +select * from testr; +pk num txt +1 1 one +2 2 twotwo +3 3 three +4 4 four +drop table testr; +include/rpl_end.inc diff --git a/mysql-test/suite/tokudb.bugs/r/rpl_stmt_replace_into.result b/mysql-test/suite/tokudb.bugs/r/rpl_stmt_replace_into.result new file mode 100644 index 00000000000..b1482aa0144 --- /dev/null +++ b/mysql-test/suite/tokudb.bugs/r/rpl_stmt_replace_into.result @@ -0,0 +1,21 @@ +include/master-slave.inc +[connection master] +set default_storage_engine='tokudb'; +drop table if exists testr; +CREATE TABLE testr (pk int(11) NOT NULL AUTO_INCREMENT, num int(11) DEFAULT NULL, txt varchar(32) DEFAULT NULL, PRIMARY KEY (pk) ); +INSERT INTO testr VALUES (1,1,'one'),(2,2,'two'),(3,3,'three'),(4,4,'four'); +replace into testr values (2,2,'twotwo'); +select * from testr; +pk num txt +1 1 one +2 2 twotwo +3 3 three +4 4 four +select * from testr; +pk num txt +1 1 one +2 2 twotwo +3 3 three +4 4 four +drop table testr; +include/rpl_end.inc diff --git a/mysql-test/suite/tokudb.bugs/t/rpl_mixed_replace_into.test b/mysql-test/suite/tokudb.bugs/t/rpl_mixed_replace_into.test new file mode 100644 index 00000000000..05e6e2fb228 --- /dev/null +++ b/mysql-test/suite/tokudb.bugs/t/rpl_mixed_replace_into.test @@ -0,0 +1,25 @@ +source include/have_tokudb.inc; +source include/master-slave.inc; +source include/have_binlog_format_mixed.inc; + +set default_storage_engine='tokudb'; + +disable_warnings; +drop table if exists testr; +enable_warnings; + +CREATE TABLE testr (pk int(11) NOT NULL AUTO_INCREMENT, num int(11) DEFAULT NULL, txt varchar(32) DEFAULT NULL, PRIMARY KEY (pk) ); +INSERT INTO testr VALUES (1,1,'one'),(2,2,'two'),(3,3,'three'),(4,4,'four'); +replace into testr values (2,2,'twotwo'); +select * from testr; + +save_master_pos; +connection slave; +sync_with_master; +select * from testr; + +connection master; + +drop table testr; + +source include/rpl_end.inc; diff --git a/mysql-test/suite/tokudb.bugs/t/rpl_row_replace_into.test b/mysql-test/suite/tokudb.bugs/t/rpl_row_replace_into.test new file mode 100644 index 00000000000..062f11e0ed9 --- /dev/null +++ b/mysql-test/suite/tokudb.bugs/t/rpl_row_replace_into.test @@ -0,0 +1,25 @@ +source include/have_tokudb.inc; +source include/master-slave.inc; +source include/have_binlog_format_row.inc; + +set default_storage_engine='tokudb'; + +disable_warnings; +drop table if exists testr; +enable_warnings; + +CREATE TABLE testr (pk int(11) NOT NULL AUTO_INCREMENT, num int(11) DEFAULT NULL, txt varchar(32) DEFAULT NULL, PRIMARY KEY (pk) ); +INSERT INTO testr VALUES (1,1,'one'),(2,2,'two'),(3,3,'three'),(4,4,'four'); +replace into testr values (2,2,'twotwo'); +select * from testr; + +save_master_pos; +connection slave; +sync_with_master; +select * from testr; + +connection master; + +drop table testr; + +source include/rpl_end.inc; diff --git a/mysql-test/suite/tokudb.bugs/t/rpl_stmt_replace_into.test b/mysql-test/suite/tokudb.bugs/t/rpl_stmt_replace_into.test new file mode 100644 index 00000000000..f7e4c7a09e0 --- /dev/null +++ b/mysql-test/suite/tokudb.bugs/t/rpl_stmt_replace_into.test @@ -0,0 +1,25 @@ +source include/have_tokudb.inc; +source include/master-slave.inc; +source include/have_binlog_format_statement.inc; + +set default_storage_engine='tokudb'; + +disable_warnings; +drop table if exists testr; +enable_warnings; + +CREATE TABLE testr (pk int(11) NOT NULL AUTO_INCREMENT, num int(11) DEFAULT NULL, txt varchar(32) DEFAULT NULL, PRIMARY KEY (pk) ); +INSERT INTO testr VALUES (1,1,'one'),(2,2,'two'),(3,3,'three'),(4,4,'four'); +replace into testr values (2,2,'twotwo'); +select * from testr; + +save_master_pos; +connection slave; +sync_with_master; +select * from testr; + +connection master; + +drop table testr; + +source include/rpl_end.inc; |