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
Triage: Triaged: D3 (Medium)

[8 Dec 2008 14:42] Hakan Küçükyılmaz
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.
[8 Dec 2008 14:44] Bugs System
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
[16 Mar 2009 20:19] Hakan Küçükyılmaz
Fix is in 6.0.10
[18 Mar 2009 2:44] Paul Dubois
Test case change. No changelog entry needed.