summaryrefslogtreecommitdiff
path: root/mysql-test/suite/rpl/r/rpl_gtid_errorhandling.result
diff options
context:
space:
mode:
authorunknown <knielsen@knielsen-hq.org>2013-03-11 12:07:09 +0100
committerunknown <knielsen@knielsen-hq.org>2013-03-11 12:07:09 +0100
commit320863530f2038fc8783d30d43a02452c21a186d (patch)
tree847c9ed934b25d5aa242bf17ba9cefe0fecd1adf /mysql-test/suite/rpl/r/rpl_gtid_errorhandling.result
parent1baa0a57dff2a1906f171b0181f028ea45035497 (diff)
downloadmariadb-git-320863530f2038fc8783d30d43a02452c21a186d.tar.gz
MDEV-26: Global Transaction ID.
Improvements to record_gtid(): - Check for correct table definition of mysql.rpl_slave_state - Use autocommit, to save one call to ha_commit_trans() - Slightly more efficient way to set table->write_set - Use ha_index_read_map() to locate rows to support any storage engine.
Diffstat (limited to 'mysql-test/suite/rpl/r/rpl_gtid_errorhandling.result')
-rw-r--r--mysql-test/suite/rpl/r/rpl_gtid_errorhandling.result33
1 files changed, 33 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_gtid_errorhandling.result b/mysql-test/suite/rpl/r/rpl_gtid_errorhandling.result
new file mode 100644
index 00000000000..ccacdc68b50
--- /dev/null
+++ b/mysql-test/suite/rpl/r/rpl_gtid_errorhandling.result
@@ -0,0 +1,33 @@
+include/master-slave.inc
+[connection master]
+*** Test that we check against incorrect table definition for mysql.rpl_slave_state ***
+CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB;
+include/stop_slave.inc
+ALTER TABLE mysql.rpl_slave_state CHANGE seq_no seq_no VARCHAR(20);
+START SLAVE;
+INSERT INTO t1 VALUES (1);
+CALL mtr.add_suppression("Slave: Failed to open mysql.rpl_slave_state");
+include/wait_for_slave_sql_error.inc [errno=1942]
+include/stop_slave.inc
+ALTER TABLE mysql.rpl_slave_state CHANGE seq_no seq_no BIGINT UNSIGNED NOT NULL;
+ALTER TABLE mysql.rpl_slave_state DROP PRIMARY KEY;
+ALTER TABLE mysql.rpl_slave_state ADD PRIMARY KEY (sub_id, domain_id);
+START SLAVE;
+include/wait_for_slave_sql_error.inc [errno=1942]
+include/stop_slave.inc
+ALTER TABLE mysql.rpl_slave_state DROP PRIMARY KEY;
+START SLAVE;
+include/wait_for_slave_sql_error.inc [errno=1942]
+include/stop_slave.inc
+ALTER TABLE mysql.rpl_slave_state ADD PRIMARY KEY (sub_id);
+START SLAVE;
+include/wait_for_slave_sql_error.inc [errno=1942]
+include/stop_slave.inc
+ALTER TABLE mysql.rpl_slave_state DROP PRIMARY KEY;
+ALTER TABLE mysql.rpl_slave_state ADD PRIMARY KEY (domain_id, sub_id);
+include/start_slave.inc
+SELECT * FROM t1;
+a
+1
+DROP TABLE t1;
+include/rpl_end.inc