diff options
Diffstat (limited to 'mysql-test/suite/percona/percona_show_slave_status_nolock.result')
-rw-r--r-- | mysql-test/suite/percona/percona_show_slave_status_nolock.result | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/suite/percona/percona_show_slave_status_nolock.result b/mysql-test/suite/percona/percona_show_slave_status_nolock.result new file mode 100644 index 00000000000..1d6114a001e --- /dev/null +++ b/mysql-test/suite/percona/percona_show_slave_status_nolock.result @@ -0,0 +1,21 @@ +include/master-slave.inc +[connection master] +DROP TABLE IF EXISTS t; +CREATE TABLE t(id INT); +INSERT INTO t SELECT SLEEP(10); +STOP SLAVE; +Warnings: +Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave. +master count(*) +master 1 +slave count(*) +slave 0 +SHOW SLAVE STATUS NOLOCK; +include/wait_for_slave_to_stop.inc +START SLAVE; +include/wait_for_slave_to_start.inc +slave count(*) +slave 1 +DROP TABLE t; +STOP SLAVE; +include/wait_for_slave_to_stop.inc |