Bug #56468 main.ps_ddl fails if MTR run with --mysqld=--query-cache-size=1000000
Submitted: 1 Sep 2010 16:57
Reporter: Sveta Smirnova Email Updates:
Status: Verified Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Bernt Marius Johnsen CPU Architecture:Any
Triage: Triaged: D2 (Serious)

[1 Sep 2010 16:57] Sveta Smirnova
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'
[8 Sep 2010 13:15] Bernt Marius Johnsen
In this case, mysql behaves correctly when query cache is enabled. See also Bug#36002