Description:
main.ps_2myisam fails if MTR run with --mysqld=--query-cache-size=1000000
How to repeat:
$./mtr --mysqld=--query-cache-size=1000000 ps_2myisam
Logging: ./mtr --mysqld=--query-cache-size=1000000 ps_2myisam
100901 18:48:29 [Note] Plugin 'FEDERATED' is disabled.
100901 18:48:29 [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 45261
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
==============================================================================
TEST RESULT TIME (ms)
------------------------------------------------------------
main.ps_2myisam [ fail ]
Test ended at 2010-09-01 18:48:30
CURRENT_TEST: main.ps_2myisam
--- /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/r/ps_2myisam.result 2010-05-31 10:32:27.000000000 +0300
+++ /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/r/ps_2myisam.reject 2010-09-01 19:48:26.000000000 +0300
@@ -1007,7 +1007,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