Bug #56468 main.ps_ddl fails if MTR run with --mysqld=--query-cache-size=1000000
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'
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
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'