[Commits] Rev 3010: MWL#234: Add MTR tests for SESSION/GLOBAL semantics of new system variables. in http://bazaar.launchpad.net/~maria-captains/maria/5.2

knielsen at knielsen-hq.org knielsen at knielsen-hq.org
Mon Aug 15 11:05:14 EEST 2011


At http://bazaar.launchpad.net/~maria-captains/maria/5.2

------------------------------------------------------------
revno: 3010
revision-id: knielsen at knielsen-hq.org-20110815080514-run6038m7iflmou8
parent: knielsen at knielsen-hq.org-20110812111834-dz2ccmozbwil4k41
committer: knielsen at knielsen-hq.org
branch nick: work-5.2-mwl234
timestamp: Mon 2011-08-15 10:05:14 +0200
message:
  MWL#234: Add MTR tests for SESSION/GLOBAL semantics of new system variables.
=== modified file 'mysql-test/suite/rpl/r/rpl_skip_replication.result'
--- a/mysql-test/suite/rpl/r/rpl_skip_replication.result	2011-08-12 11:18:34 +0000
+++ b/mysql-test/suite/rpl/r/rpl_skip_replication.result	2011-08-15 08:05:14 +0000
@@ -6,12 +6,33 @@ SELECT,UPDATE ON *.* TO 'nonsuperuser'@'
 SET GLOBAL replicate_events_marked_for_skip=0;
 ERROR 42000: Access denied; you need the SUPER privilege for this operation
 DROP USER'nonsuperuser'@'127.0.0.1';
+SELECT @@global.replicate_events_marked_for_skip;
+@@global.replicate_events_marked_for_skip
+1
 SET GLOBAL replicate_events_marked_for_skip=0;
 ERROR HY000: This operation cannot be performed with a running slave; run STOP SLAVE first
+SELECT @@global.replicate_events_marked_for_skip;
+@@global.replicate_events_marked_for_skip
+1
 STOP SLAVE;
+SET SESSION replicate_events_marked_for_skip=0;
+ERROR HY000: Variable 'replicate_events_marked_for_skip' is a GLOBAL variable and should be set with SET GLOBAL
+SELECT @@global.replicate_events_marked_for_skip;
+@@global.replicate_events_marked_for_skip
+1
 SET GLOBAL replicate_events_marked_for_skip=0;
+SELECT @@global.replicate_events_marked_for_skip;
+@@global.replicate_events_marked_for_skip
+0
 START SLAVE;
-SET skip_replication=0;
+SELECT @@skip_replication;
+@@skip_replication
+0
+SET GLOBAL skip_replication=1;
+ERROR HY000: Variable 'skip_replication' is a SESSION variable and can't be used with SET GLOBAL
+SELECT @@skip_replication;
+@@skip_replication
+0
 CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=myisam;
 CREATE TABLE t2 (a INT PRIMARY KEY, b INT) ENGINE=innodb;
 INSERT INTO t1(a) VALUES (1);

=== modified file 'mysql-test/suite/rpl/t/rpl_skip_replication.test'
--- a/mysql-test/suite/rpl/t/rpl_skip_replication.test	2011-08-12 11:18:34 +0000
+++ b/mysql-test/suite/rpl/t/rpl_skip_replication.test	2011-08-15 08:05:14 +0000
@@ -14,14 +14,23 @@ disconnect nonpriv;
 connection slave;
 DROP USER'nonsuperuser'@'127.0.0.1';
 
+SELECT @@global.replicate_events_marked_for_skip;
 --error ER_SLAVE_MUST_STOP
 SET GLOBAL replicate_events_marked_for_skip=0;
+SELECT @@global.replicate_events_marked_for_skip;
 STOP SLAVE;
+--error ER_GLOBAL_VARIABLE
+SET SESSION replicate_events_marked_for_skip=0;
+SELECT @@global.replicate_events_marked_for_skip;
 SET GLOBAL replicate_events_marked_for_skip=0;
+SELECT @@global.replicate_events_marked_for_skip;
 START SLAVE;
 
 connection master;
-SET skip_replication=0;
+SELECT @@skip_replication;
+--error ER_LOCAL_VARIABLE
+SET GLOBAL skip_replication=1;
+SELECT @@skip_replication;
 
 CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=myisam;
 CREATE TABLE t2 (a INT PRIMARY KEY, b INT) ENGINE=innodb;



More information about the commits mailing list