Bug #56467 main.ps_5merge fails if MTR run with --mysqld=--query-cache-size=1000000

• Submitted: 1 Sep 2010 16:54
• Reporter: Sveta Smirnova
• Status: Verified
• Category: Tests: Server
• Severity: S3 (Non-critical)
• Version: 5.1
• OS: Any
• CPU Architecture: Any

[1 Sep 2010 16:54] Sveta Smirnova

Description:
main.ps_5merge fails if MTR run with --mysqld=--query-cache-size=1000000

How to repeat:
$./mtr --mysqld=--query-cache-size=1000000 ps_5merge
Logging: ./mtr  --mysqld=--query-cache-size=1000000 ps_5merge
100901 18:53:42 [Note] Plugin 'FEDERATED' is disabled.
100901 18:53:42 [Note] Plugin 'ndbcluster' is disabled.
MySQL Version 5.1.51
Checking supported features...
 - using ndbcluster when necessary, mysqld supports it
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
vardir: /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/var
Checking leftover processes...
Removing old var directory...
 - WARNING: Using the 'mysql-test/var' symlink
Creating var directory '/users/ssmirnova/blade12/src/mysql-5.1/mysql-test/var'...
Installing system database...
Using server port 47860

==============================================================================

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

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
main.ps_5merge                           [ fail ]
        Test ended at 2010-09-01 18:53:43

CURRENT_TEST: main.ps_5merge
--- /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/r/ps_5merge.result        2010-05-31 10:32:27.000000000 +0300
+++ /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/r/ps_5merge.reject        2010-09-01 19:53:39.000000000 +0300
@@ -1050,7 +1050,7 @@
                      union distinct
                      select ? FROM t1 where a=1 ' ;
 execute stmt1 using @arg00;
-1
+?
 1
 set @arg00='a' ;
 select @arg00 FROM t1 where a=1
@@ -4072,7 +4072,7 @@
                      union distinct
                      select ? FROM t1 where a=1 ' ;
 execute stmt1 using @arg00;
-1
+?
 1
 set @arg00='a' ;
 select @arg00 FROM t1 where a=1

mysqltest: Result content mismatch