diff options
author | unknown <knielsen@knielsen-hq.org> | 2013-03-11 12:07:09 +0100 |
---|---|---|
committer | unknown <knielsen@knielsen-hq.org> | 2013-03-11 12:07:09 +0100 |
commit | 320863530f2038fc8783d30d43a02452c21a186d (patch) | |
tree | 847c9ed934b25d5aa242bf17ba9cefe0fecd1adf /mysql-test/suite/rpl/r/rpl_gtid_errorhandling.result | |
parent | 1baa0a57dff2a1906f171b0181f028ea45035497 (diff) | |
download | mariadb-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.result | 33 |
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 |