5.5.10-20.1 test sys_vars.all_vars fails

[Valentine Gostev]

Percona Server
mysqld Ver 5.5.10-55-log for Linux on x86_64 (Percona Server (GPL), Release beta20.1, Revision 95)

Test sys_vars.all_vars fails with result content mismatch:

[root@gval-cent5-64-n403 mysql-test]# ./mysql-test-run sys_vars.all_vars
Logging: ./mysql-test-run sys_vars.all_vars
110329 17:04:10 [Note] Flashcache bypass: disabled
110329 17:04:10 [Note] Flashcache setup error is : open flash device failed

110329 17:04:10 [Note] Plugin 'FEDERATED' is disabled.
MySQL Version 5.5.10
Checking supported features...
 - skipping ndbcluster
 - SSL connections supported
Collecting tests...
vardir: /usr/share/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/usr/share/mysql-test/var'...
Installing system database...
Using server port 36118

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

TEST RESULT TIME (ms) or COMMENT
--------------------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped
sys_vars.all_vars [ fail ]
        Test ended at 2011-03-29 17:04:18

CURRENT_TEST: sys_vars.all_vars
--- /usr/share/mysql-test/suite/sys_vars/r/all_vars.result 2011-03-29 01:27:59.000000000 +0300
+++ /usr/share/mysql-test/suite/sys_vars/r/all_vars.reject 2011-03-29 16:04:18.697856418 +0300
@@ -11,99 +11,101 @@
 select variable_name as `There should be *no* variables listed below:` from t2
 left join t1 on variable_name=test_name where test_name is null;
 There should be *no* variables listed below:
-USE_GLOBAL_LOG_SLOW_CONTROL
 LOG_SLOW_SP_STATEMENTS
-INNODB_FAST_CHECKSUM
+SLOW_QUERY_LOG_TIMESTAMP_PRECISION
+THREAD_STATISTICS
+SLOW_QUERY_LOG_TIMESTAMP_ALWAYS
 INNODB_THREAD_CONCURRENCY_TIMER_BASED

-LOG_SLOW_TIMESTAMP_EVERY
+INNODB_LOG_BLOCK_SIZE
 INNODB_SHOW_VERBOSE_LOCKS
 INNODB_READ_AHEAD
 INNODB_USE_GLOBAL_FLUSH_LOG_AT_TRX_COMMIT
-INNODB_PASS_CORRUPT_TABLE
+LOG_WARNINGS_SUPPRESS
 FAST_INDEX_CREATION
+INNODB_CORRUPT_TABLE_ACTION
 INNODB_FLUSH_NEIGHBOR_PAGES
+INNODB_LAZY_DROP_TABLE
 INNODB_BUFFER_POOL_SHM_CHECKSUM
 LOG_SLOW_VERBOSITY
 QUERY_RESPONSE_TIME_STATS
 QUERY_CACHE_STRIP_COMMENTS
 INNODB_SHOW_LOCKS_HELD
 INNODB_IBUF_ACCEL_RATE
-INNODB_EXPAND_IMPORT
+INNODB_IBUF_MAX_SIZE
 INNODB_CHECKPOINT_AGE_TARGET
-LOG_SLOW_SLAVE_STATEMENTS
+INNODB_IMPORT_TABLE_FROM_XTRABACKUP
 INNODB_ADAPTIVE_FLUSHING_METHOD
 INNODB_STATS_METHOD
 HAVE_RESPONSE_TIME_DISTRIBUTION
-LOG_SLOW_RATE_LIMIT
+INNODB_RECOVERY_UPDATE_RELAY_LOG
 OPTIMIZER_FIX
-INNODB_STATS_AUTO_UPDATE
+INNODB_BUFFER_POOL_RESTORE_AT_STARTUP
 INNODB_PAGE_SIZE
-INNODB_LOG_BLOCK_SIZE
+INNODB_FAST_CHECKSUM
+SLOW_QUERY_LOG_USE_GLOBAL_CONTROL
 INNODB_ADAPTIVE_HASH_INDEX_PARTITIONS
-SLOW_QUERY_LOG_MICROSECONDS_TIMESTAMP
+USERSTAT
 INNODB_BUFFER_POOL_SHM_KEY
 INNODB_USE_SYS_STATS_TABLE
 INNODB_RECOVERY_STATS
 INNODB_DOUBLEWRITE_FILE
 INNODB_STATS_UPDATE_NEED_LOCK
-USERSTAT_RUNNING
 QUERY_RESPONSE_TIME_RANGE_BASE

+LOG_SLOW_RATE_LIMIT
 INNODB_IBUF_ACTIVE_CONTRACT
-INNODB_AUTO_LRU_DUMP
+INNODB_STATS_AUTO_UPDATE
+LOG_SLOW_SLAVE_STATEMENTS
 INNODB_FILE_FORMAT_MAX
 INNODB_DICT_SIZE_LIMIT
-LOG_WARNINGS_SILENCE
 LOG_SLOW_FILTER
-INNODB_IBUF_MAX_SIZE
-INNODB_OVERWRITE_RELAY_LOG_INFO
 INNODB_EXTRA_RSEGMENTS
-THREAD_STATISTICS
-USE_GLOBAL_LOG_SLOW_CONTROL
 LOG_SLOW_SP_STATEMENTS
-INNODB_FAST_CHECKSUM
+SLOW_QUERY_LOG_TIMESTAMP_PRECISION
+THREAD_STATISTICS
+SLOW_QUERY_LOG_TIMESTAMP_ALWAYS
 INNODB_THREAD_CONCURRENCY_TIMER_BASED
-LOG_SLOW_TIMESTAMP_EVERY
+INNODB_LOG_BLOCK_SIZE
 INNODB_SHOW_VERBOSE_LOCKS
 INNODB_READ_AHEAD
 INNODB_USE_GLOBAL_FLUSH_LOG_AT_TRX_COMMIT
-INNODB_PASS_CORRUPT_TABLE
+LOG_WARNINGS_SUPPRESS
 FAST_INDEX_CREATION
+INNODB_CORRUPT_TABLE_ACTION
 INNODB_FLUSH_NEIGHBOR_PAGES
+INNODB_LAZY_DROP_TABLE
 INNODB_BUFFER_POOL_SHM_CHECKSUM
 LOG_SLOW_VERBOSITY
 QUERY_RESPONSE_TIME_STATS
 QUERY_CACHE_STRIP_COMMENTS
 INNODB_SHOW_LOCKS_HELD
 INNODB_IBUF_ACCEL_RATE
-INNODB_EXPAND_IMPORT
+INNODB_IBUF_MAX_SIZE
 INNODB_CHECKPOINT_AGE_TARGET
-LOG_SLOW_SLAVE_STATEMENTS
+INNODB_IMPORT_TABLE_FROM_XTRABACKUP
 INNODB_ADAPTIVE_FLUSHING_METHOD
 INNODB_STATS_METHOD
 HAVE_RESPONSE_TIME_DISTRIBUTION

-LOG_SLOW_RATE_LIMIT
+INNODB_RECOVERY_UPDATE_RELAY_LOG
 OPTIMIZER_FIX
-INNODB_STATS_AUTO_UPDATE
+INNODB_BUFFER_POOL_RESTORE_AT_STARTUP
 INNODB_PAGE_SIZE
-INNODB_LOG_BLOCK_SIZE
+INNODB_FAST_CHECKSUM
+SLOW_QUERY_LOG_USE_GLOBAL_CONTROL
 INNODB_ADAPTIVE_HASH_INDEX_PARTITIONS
-SLOW_QUERY_LOG_MICROSECONDS_TIMESTAMP
+USERSTAT
 INNODB_BUFFER_POOL_SHM_KEY
 INNODB_USE_SYS_STATS_TABLE
 INNODB_RECOVERY_STATS
 INNODB_DOUBLEWRITE_FILE
 INNODB_STATS_UPDATE_NEED_LOCK
-USERSTAT_RUNNING
 QUERY_RESPONSE_TIME_RANGE_BASE
+LOG_SLOW_RATE_LIMIT
 INNODB_IBUF_ACTIVE_CONTRACT
-INNODB_AUTO_LRU_DUMP
+INNODB_STATS_AUTO_UPDATE
+LOG_SLOW_SLAVE_STATEMENTS
 INNODB_FILE_FORMAT_MAX
 INNODB_DICT_SIZE_LIMIT
-LOG_WARNINGS_SILENCE
 LOG_SLOW_FILTER
-INNODB_IBUF_MAX_SIZE
-INNODB_OVERWRITE_RELAY_LOG_INFO
 INNODB_EXTRA_RSEGMENTS
-THREAD_STATISTICS
 drop table t1;
 drop table t2;

mysqltest: Result content mismatch

 - saving '/usr/share/mysql-test/var/log/sys_vars.all_vars/' to '/usr/share/mysql-test/var/log/sys_vars.all_vars/'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 8 seconds executing testcases

Completed: Failed 1/1 tests, 0.00% were successful.

Failing test(s): sys_vars.all_vars

[Alexey Kopytov (akopytov)]

Fixed file porting the patches to 5.5.11.

[Alexey Kopytov (akopytov)]

s/file/while/ :)