From: Andrei Elkin Date: October 28 2010 5:10pm Subject: bzr push into mysql-next-mr branch (andrei.elkin:3188 to 3189) Bug#57589 List-Archive: http://lists.mysql.com/commits/122232 X-Bug: 57589 Message-Id: <201010281710.o9SHAEFx002141@mysql1000.dsl.inet.fi> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1379146360==" --===============1379146360== MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline 3189 Andrei Elkin 2010-10-28 Bug #57589 sysvar suite tests are added. added: mysql-test/suite/sys_vars/r/binlog_checksum_basic.result mysql-test/suite/sys_vars/r/master_verify_checksum_basic.result mysql-test/suite/sys_vars/r/slave_sql_verify_checksum_basic.result mysql-test/suite/sys_vars/t/binlog_checksum_basic.test mysql-test/suite/sys_vars/t/master_verify_checksum_basic.test mysql-test/suite/sys_vars/t/slave_sql_verify_checksum_basic.test 3188 Andrei Elkin 2010-10-28 Bug #57589 error numbers shifted, rpl_checksum simulates OS and its error text is updated modified: mysql-test/r/explain.result mysql-test/suite/rpl/r/rpl_checksum.result mysql-test/suite/rpl/r/rpl_mixed_binlog_max_cache_size.result mysql-test/suite/rpl/r/rpl_row_binlog_max_cache_size.result mysql-test/suite/rpl/r/rpl_stm_binlog_max_cache_size.result mysql-test/suite/sys_vars/r/max_binlog_cache_size_basic.result === added file 'mysql-test/suite/sys_vars/r/binlog_checksum_basic.result' --- a/mysql-test/suite/sys_vars/r/binlog_checksum_basic.result 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/sys_vars/r/binlog_checksum_basic.result 2010-10-28 17:09:41 +0000 @@ -0,0 +1,14 @@ +set @save_binlog_checksum= @@global.binlog_checksum; +select @@global.binlog_checksum as 'must be NONE by default'; +must be NONE by default +NONE +select @@session.binlog_checksum as 'no session var'; +ERROR HY000: Variable 'binlog_checksum' is a GLOBAL variable +set @@global.binlog_checksum = default; +set @@global.binlog_checksum = CRC32; +set @@global.binlog_checksum = CRC32; +set @@global.master_verify_checksum = 0; +set @@global.master_verify_checksum = default; +set @@global.binlog_checksum = ADLER32; +ERROR 42000: Variable 'binlog_checksum' can't be set to the value of 'ADLER32' +set @@global.binlog_checksum = @save_binlog_checksum; === added file 'mysql-test/suite/sys_vars/r/master_verify_checksum_basic.result' --- a/mysql-test/suite/sys_vars/r/master_verify_checksum_basic.result 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/sys_vars/r/master_verify_checksum_basic.result 2010-10-28 17:09:41 +0000 @@ -0,0 +1,11 @@ +set @save_master_verify_checksum = @@global.master_verify_checksum; +select @@global.master_verify_checksum as 'must be zero because of default'; +must be zero because of default +0 +select @@session.master_verify_checksum as 'no session var'; +ERROR HY000: Variable 'master_verify_checksum' is a GLOBAL variable +set @@global.master_verify_checksum = 0; +set @@global.master_verify_checksum = default; +set @@global.master_verify_checksum = 2; +ERROR 42000: Variable 'master_verify_checksum' can't be set to the value of '2' +set @@global.master_verify_checksum = @save_master_verify_checksum; === added file 'mysql-test/suite/sys_vars/r/slave_sql_verify_checksum_basic.result' --- a/mysql-test/suite/sys_vars/r/slave_sql_verify_checksum_basic.result 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/sys_vars/r/slave_sql_verify_checksum_basic.result 2010-10-28 17:09:41 +0000 @@ -0,0 +1,11 @@ +set @save_slave_sql_verify_checksum = @@global.slave_sql_verify_checksum; +select @@global.slave_sql_verify_checksum as 'must be one because of default'; +must be one because of default +1 +select @@session.slave_sql_verify_checksum as 'no session var'; +ERROR HY000: Variable 'slave_sql_verify_checksum' is a GLOBAL variable +set @@global.slave_sql_verify_checksum = 0; +set @@global.slave_sql_verify_checksum = default; +set @@global.slave_sql_verify_checksum = 2; +ERROR 42000: Variable 'slave_sql_verify_checksum' can't be set to the value of '2' +set @@global.slave_sql_verify_checksum = @save_slave_sql_verify_checksum; === added file 'mysql-test/suite/sys_vars/t/binlog_checksum_basic.test' --- a/mysql-test/suite/sys_vars/t/binlog_checksum_basic.test 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/sys_vars/t/binlog_checksum_basic.test 2010-10-28 17:09:41 +0000 @@ -0,0 +1,25 @@ +--source include/not_embedded.inc + +# suite/rpl/t/rpl_checksum.test contains similar testing of +# all checksum related system variables. + +set @save_binlog_checksum= @@global.binlog_checksum; + +select @@global.binlog_checksum as 'must be NONE by default'; +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.binlog_checksum as 'no session var'; + +set @@global.binlog_checksum = default; + +# testing lack of side-effects in non-effective update of binlog_checksum: +set @@global.binlog_checksum = CRC32; +set @@global.binlog_checksum = CRC32; + +set @@global.master_verify_checksum = 0; +set @@global.master_verify_checksum = default; + +--error ER_WRONG_VALUE_FOR_VAR +set @@global.binlog_checksum = ADLER32; + +# cleanup +set @@global.binlog_checksum = @save_binlog_checksum; === added file 'mysql-test/suite/sys_vars/t/master_verify_checksum_basic.test' --- a/mysql-test/suite/sys_vars/t/master_verify_checksum_basic.test 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/sys_vars/t/master_verify_checksum_basic.test 2010-10-28 17:09:41 +0000 @@ -0,0 +1,19 @@ +--source include/not_embedded.inc + +# suite/rpl/t/rpl_checksum.test contains similar testing of +# all checksum related system variables. + +set @save_master_verify_checksum = @@global.master_verify_checksum; + +select @@global.master_verify_checksum as 'must be zero because of default'; +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.master_verify_checksum as 'no session var'; + +set @@global.master_verify_checksum = 0; +set @@global.master_verify_checksum = default; + +--error ER_WRONG_VALUE_FOR_VAR +set @@global.master_verify_checksum = 2; # the var is of bool type + +# cleanup +set @@global.master_verify_checksum = @save_master_verify_checksum; === added file 'mysql-test/suite/sys_vars/t/slave_sql_verify_checksum_basic.test' --- a/mysql-test/suite/sys_vars/t/slave_sql_verify_checksum_basic.test 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/sys_vars/t/slave_sql_verify_checksum_basic.test 2010-10-28 17:09:41 +0000 @@ -0,0 +1,18 @@ +--source include/not_embedded.inc + +# suite/rpl/t/rpl_checksum.test contains similar testing of +# all checksum related system variables. + +set @save_slave_sql_verify_checksum = @@global.slave_sql_verify_checksum; + +select @@global.slave_sql_verify_checksum as 'must be one because of default'; +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +select @@session.slave_sql_verify_checksum as 'no session var'; + +set @@global.slave_sql_verify_checksum = 0; +set @@global.slave_sql_verify_checksum = default; +--error ER_WRONG_VALUE_FOR_VAR +set @@global.slave_sql_verify_checksum = 2; # the var is of bool type + +# cleanup +set @@global.slave_sql_verify_checksum = @save_slave_sql_verify_checksum; --===============1379146360== MIME-Version: 1.0 Content-Type: text/bzr-bundle; charset="us-ascii"; name="bzr/andrei.elkin@stripped" Content-Transfer-Encoding: 7bit Content-Disposition: inline # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: andrei.elkin@stripped # target_branch: file:///home/andrei/MySQL/BZR/2a-23May/WL/mysql-next-\ # mr-wl2540/ # testament_sha1: 42272d1868935f8f8ecbc97d41ca37503da3a252 # timestamp: 2010-10-28 20:10:14 +0300 # source_branch: file:///home/andrei/MySQL/BZR/2a-23May/WL/5.6.99-\ # next-rm-wl2540-checksum/ # base_revision_id: andrei.elkin@stripped\ # cgt8narf0dkxtp5b # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWSARqGgABWJfgAAQWOP//3/l l6C////wYAl/ffVBihT1UrA42OFJEqpUikxzAJgJkYARiYmEwmCGmJpgJSTCaaMmKU8QEwAAAAAA HMAmAmRgBGJiYTCYIaYmmAk1RU9CaZAADQAA0AAaAAIpCZE1PTU1PEp7KZimampoAyNA02JNNAik EBAaaZBTTCKe1T9TKZDQGTEYJz/ofzZIdl+/oc89M9NCCKWSi8NsGbObuWjBGFOvzMVrthN143TA LxrfIy3XLnnLBnKUREfb3xWLvrqVtGBLmmlKONatVCyyllllSy83Fa902jEBU8MZxDzBgv4DwXx0 D8F69dpvXE4+rVKwV2MV4RvicTVW5ezyAXwl0STAJCgkRBEQPgl/+XS630jtZd7LExCIIgxB7qxB HW8HtfJ0Nm4+hBEGoDAfOnjpo6HWceI9Um4KkDhDWo+hhdQ0crNc3oYk3WBs0M3pLhyH3vQzefgR y48e3lxurkN04iI5eocMfHvkdol0AvrE5Ol1DI63SwwyUNjGuyG8KtWzzKHQSJEiYBI7GCGA0B2O yz5jQAnedfy9LHb0HF1wuBwIMQTx4AkMyhAujBIgTizcxpuuHQIHiyLnnzu3QFYN0cM/xiIiBsHc X3A0VbgA9SFWZOTKWRdU8JD23l+A9pv29oNiACpfYcwMqPAcKmBtCE95Oy7vcsuVCZjGVloNoBX0 mq5Qqze1TQ5TwJT3nEvvuy5+NsmhnKAZ46Af1+rboAV4nAtJAs+n0l5RMjd0LRodsjkWHU15Fxed bC6JV/icWjREM93ruMDsYjuOEzO7n375quuMGkkNheQEGszoaSRBrIqZF2g142MJhgX2zGQ8z6n7 QkcrB62khu8C+ymeeVTPhO3ODwP+g5mw5W7898ygbRwoBXpYAQS95sma2y3OJfPvja10OZPRFjy9 EiZJMAJwqJS9WLc2ZwBekjJffh/iSaSW7y45se2ypPdwzJ7C404BQsNvi6lTIqTkYEwc35XWLpgS UMIuYywUtdwsXkFQeTwMC51CBa8zl2cAfAehQ4QXkEcLst4LFhPEZzMyQXFpeCYyLcWXPlnKFFgO MxCRlBLiBiylVIyqhFOVJICgRHNJpMSAA1xInBisBZVsaUI0Giy4ZtP/id/HDGdUZ2g4GUoLjaZM myqBF2VS4nga7yZnKEiwmRKlgvApgRtZu2Ij62JdSoKowHtU7KS0JARWKLehW0S1uhDuGU2QzZk2 LBEEnXzWAbiBS7Q+gfAdrImyJEJBDv9w33gD+oiXgkgZDlI3Pkw+tkPdnkMQREJ8R9tPYE34ugLn +GYX1fa4DYfJj5MMNmTJvfg/EZs0PJyXCzoQwDFDpfFwG8c2gXPyYGjRCGGje9CGgYfNufk3tXNh kO4TWHQSTEIMiCiCImGUosRFEisduYLApEYwnl51CVJJbDvBGKpEVYiIoqqiKiOZMJhLYHOJOUqJ xnUcYstOUUNtAFH7yDTxBO2WIIdc6ROjAOwyvQNI7XQImWL/r7x6xr1OH4PuP0WBl89boOmNjA5b Vcmb7RhoDqE5AB772XYgah6gaAB+mQUNxvIDDj5CJ9onDMGhYkOlnY2AH9i/4LLyZB17RD8QeANh 3h6v2r6eY7TMyMDgWfDI76uhU7mJvYG8/hILzzf1wPveWXQUcWBA0J4KiSBKNXYD1BNaNgpv18dp T7i84m2jy2gbsAOpPqduF6Pwl8juYnYXZtbujwDmgVxXNzRLcqHch2vZVmP1PQ+G4bDLn7Em6dm2 gejERhueRbbbdPse07x8y8G1vIIPYfkPlWBobwuHBCQgb5ugB0NoHxO5YqJYDgabHMJ6jjoe06k7 tNIKVKl6By5czxB4onG3X2Rt+cirxB1Amx8Gi+lgDp4XKtrgFm5j3b3v5WBuGUJgzVC8ZIZURr4g FR36acy9jU52HcnqSPQoSOxbQ8D0PlMuPEvQPIuuQtoaLB8x9R9R6QcsQCLQF9ahqi7xP+CJiDvT 0i8ADsSYYwqJgPSAZo33hCJY3IzGK4epGkrvUtQF4O0QoVdnOIBO9kyQyqGQ6IsP69M7MES9PNDo G7Go+nuB6O4GaJtQmqJsZu88fQInN3h9OhtMKNRHVwaNgj7DuQoO0EgaDAyag0cf7zBJPPP6CJxR ZAmeDVCaA2YHUoQIRAn4fZEe8NCAfrJEiZ5tzePhknu2bQa1X0qDltIgiClzcNrCsgSNR9mbSAfu kCVDCikQi3jbUzclqwygCzJ55u0eT1CJPsAMQCaLgckS8boVq/Sj3LwPUExQ2PjJwceD2O65y64G AKUX3FugdF1cQDQo8wCw7Eexx6kAoi6tDXvRM2SvBy4UWiuHGAFwYeU+OQ9xqtnoAQ3A9m8g1fMP UIAua69gZ5jxByyGozBCTNPKDkO4SgXjugYAoOJzy6RGgFSA8iRImWDsfdUR4o8UIWbpFZBmhGYQ 61BJ3UdXFtYTgEAwQBAwPIeDAyasmB3un78nVqBh0bBsBhupqHgDWbR0gV1HigYQlcO+ZaGVjJDa 4sSpWYGVTdiPuvDlkyYFhQS9tLJoPShRKQDooKFXeAsh2q5AHpkLvZDxaNRJAImUlIIUEkiYpH+F 3JFOFCQIBGoaAA== --===============1379146360==--