Description:
main.ps_ddl fails if MTR run with --mysqld=--query-cache-size=1000000
How to repeat:
$./mtr --mysqld=--query-cache-size=1000000 ps_ddl
Logging: ./mtr --mysqld=--query-cache-size=1000000 ps_ddl
100901 18:56:07 [Note] Plugin 'FEDERATED' is disabled.
100901 18:56:07 [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 40965
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
==============================================================================
TEST RESULT TIME (ms)
------------------------------------------------------------
main.ps_ddl [ fail ]
Test ended at 2010-09-01 18:56:08
CURRENT_TEST: main.ps_ddl
--- /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/r/ps_ddl.result 2010-05-31 10:32:27.000000000 +0300
+++ /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/r/ps_ddl.reject 2010-09-01 19:56:04.000000000 +0300
@@ -763,9 +763,9 @@
# used in a statement is replaced, bad data
execute stmt;
a b c
-10 20 30
-20 40 60
-30 60 90
+10 20 50
+20 40 100
+30 60 150
call p_verify_reprepare_count(0);
SUCCESS
mysqltest: Result content mismatch
Warnings from just before the error:
Note 1051 Unknown table 'test.v1'
Description: main.ps_ddl fails if MTR run with --mysqld=--query-cache-size=1000000 How to repeat: $./mtr --mysqld=--query-cache-size=1000000 ps_ddl Logging: ./mtr --mysqld=--query-cache-size=1000000 ps_ddl 100901 18:56:07 [Note] Plugin 'FEDERATED' is disabled. 100901 18:56:07 [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 40965 worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ main.ps_ddl [ fail ] Test ended at 2010-09-01 18:56:08 CURRENT_TEST: main.ps_ddl --- /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/r/ps_ddl.result 2010-05-31 10:32:27.000000000 +0300 +++ /users/ssmirnova/blade12/src/mysql-5.1/mysql-test/r/ps_ddl.reject 2010-09-01 19:56:04.000000000 +0300 @@ -763,9 +763,9 @@ # used in a statement is replaced, bad data execute stmt; a b c -10 20 30 -20 40 60 -30 60 90 +10 20 50 +20 40 100 +30 60 150 call p_verify_reprepare_count(0); SUCCESS mysqltest: Result content mismatch Warnings from just before the error: Note 1051 Unknown table 'test.v1'