MySQL Bugs: #41303: Using global variable makes mysql-test-run test fail

Bug #41303	Using global variable makes mysql-test-run test fail
Submitted:	8 Dec 2008 14:42	Modified:	18 Mar 2009 2:44
Reporter:	Hakan Küçükyılmaz	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Falcon storage engine	Severity:	S3 (Non-critical)
Version:	6.0-falcon	OS:	Any
Assigned to:	Hakan Küçükyılmaz	CPU Architecture:	Any
Tags:	F_TEST

Description:
Running a test with mysql-test-run and providing a mysqld variable lets some tests fail.

How to repeat:
hakan@lu0011:~/work/mysql/mysql-6.0-falcon/mysql-test$ ./mysql-test-run.pl --force --mem --mysqld=--falcon_debug_mask=1 --skip-ndb --suite=falcon falcon_bug_28095

Logging: ./mysql-test-run.pl --force --mem --mysqld=--falcon_debug_mask=1 --skip-ndb --suite=falcon falcon_bug_28095
MySQL Version 6.0.9
Using dynamic switching of binlog format
Using tmpfs in /dev/shm
Skipping ndbcluster
Setting mysqld to support SSL connections
Using MTR_BUILD_THREAD      = 0
Using MASTER_MYPORT         = 9306
Using MASTER_MYPORT1        = 9307
Using SLAVE_MYPORT          = 9308
Using SLAVE_MYPORT1         = 9309
Using SLAVE_MYPORT2         = 9310
Killing Possible Leftover Processes
Removing Stale Files
Creating Directories
Symlinking 'var' to '/dev/shm/var'
Installing Master Database
Saving snapshot of installed databases
=======================================================

TEST                           RESULT         TIME (ms)
-------------------------------------------------------

falcon.falcon_bug_28095        [ fail ]

--- /home/hakan/work/mysql/mysql-6.0-falcon/mysql-test/suite/falcon/r/falcon_bug_28095.result   2008-12-01 00:42:21.000000000 +0300
+++ /home/hakan/work/mysql/mysql-6.0-falcon/mysql-test/suite/falcon/r/falcon_bug_28095.reject   2008-12-08 17:41:06.000000000 +0300
@@ -14,7 +14,7 @@
 CREATE TABLE t2 (b int);
 SELECT @@GLOBAL.falcon_debug_mask;
 @@GLOBAL.falcon_debug_mask
-0
+1
 SET GLOBAL falcon_debug_mask = 4096;
 SELECT @@GLOBAL.falcon_debug_mask;
 @@GLOBAL.falcon_debug_mask
@@ -30,6 +30,6 @@
 3
 SELECT @@GLOBAL.falcon_debug_mask;
 @@GLOBAL.falcon_debug_mask
-0
+1
 DROP TABLE t1;
 DROP TABLE t2;

mysqltest: Result content mismatch

Suggested fix:
Use --replace_result for global variables.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/60943

2928 Hakan Kuecuekyilmaz	2008-12-08
      Fix for Bug#41303 Using global variable makes mysql-test-run test fail

Fix is in 6.0.10

Test case change. No changelog entry needed.