Description:
variables.test changes several variables, but then doesn't change them back. this could result in strange behavior in later tests.
How to repeat:
./mysql-test-run.pl --check-testcases variables
@@ -12,7 +12,7 @@
bdb_max_lock 10000
bdb_shared_data OFF
bdb_tmpdir /home/jimw/my/mysql-5.0-12792/mysql-test/var/tmp/
-binlog_cache_size 32768
+binlog_cache_size 4096
bulk_insert_buffer_size 8388608
character_set_client latin1
character_set_connection latin1
@@ -27,20 +27,20 @@
collation_server latin1_swedish_ci
completion_type 0
concurrent_insert 1
-connect_timeout 5
+connect_timeout 100
datadir /home/jimw/my/mysql-5.0-12792/mysql-test/var/master-data/
date_format %Y-%m-%d
datetime_format %Y-%m-%d %H:%i:%s
default_week_format 0
delay_key_write ON
delayed_insert_limit 100
-delayed_insert_timeout 300
-delayed_queue_size 1000
+delayed_insert_timeout 100
+delayed_queue_size 100
div_precision_increment 4
engine_condition_pushdown OFF
expire_logs_days 0
-flush OFF
-flush_time 0
+flush ON
+flush_time 100
ft_boolean_syntax + -><()~*:""&|
ft_max_word_len 84
ft_min_word_len 4
@@ -102,7 +102,7 @@
innodb_thread_sleep_delay 10000
interactive_timeout 28800
join_buffer_size 131072
-key_buffer_size 1048576
+key_buffer_size 98304
key_cache_age_threshold 300
key_cache_block_size 1024
key_cache_division_limit 100
@@ -125,15 +125,15 @@
lower_case_file_system OFF
lower_case_table_names 0
max_allowed_packet 1048576
-max_binlog_cache_size 18446744073709551615
-max_binlog_size 1073741824
-max_connect_errors 10
+max_binlog_cache_size 4096
+max_binlog_size 4096
+max_connect_errors 100
max_connections 100
-max_delayed_threads 20
+max_delayed_threads 100
max_error_count 64
-max_heap_table_size 1047552
-max_insert_delayed_threads 20
-max_join_size 100
+max_heap_table_size 4294967296
+max_insert_delayed_threads 100
+max_join_size 2000
max_length_for_sort_data 1024
max_prepared_stmt_count 16382
max_relay_log_size 0
@@ -141,10 +141,10 @@
max_sort_length 1024
max_sp_recursion_depth 0
max_tmp_tables 32
-max_user_connections 0
-max_write_lock_count 18446744073709551615
+max_user_connections 100
+max_write_lock_count 100
multi_range_count 256
-myisam_data_pointer_size 6
+myisam_data_pointer_size 7
myisam_max_sort_file_size 9223372036854775807
myisam_recover_options OFF
myisam_repair_threads 1
@@ -155,10 +155,10 @@
ndb_use_exact_count ON
ndb_use_transactions OFF
ndb_cache_check_time 0
-net_buffer_length 16384
-net_read_timeout 30
+net_buffer_length 1024
+net_read_timeout 900
net_retry_count 10
-net_write_timeout 60
+net_write_timeout 1000
new OFF
old_passwords OFF
open_files_limit 1024
@@ -170,10 +170,10 @@
preload_buffer_size 32768
protocol_version 10
query_alloc_block_size 8192
-query_cache_limit 1048576
+query_cache_limit 100
query_cache_min_res_unit 4096
query_cache_size 0
-query_cache_type ON
+query_cache_type DEMAND
query_cache_wlock_invalidate OFF
query_prealloc_size 8192
range_alloc_block_size 2048
@@ -182,9 +182,9 @@
read_rnd_buffer_size 262144
relay_log_purge ON
relay_log_space_limit 0
-rpl_recovery_rank 1
+rpl_recovery_rank 100
secure_auth OFF
-server_id 1
+server_id 100
skip_external_locking ON
skip_networking OFF
skip_show_database OFF
@@ -193,19 +193,19 @@
slave_net_timeout 3600
slave_skip_errors OFF
slave_transaction_retries 10
-slow_launch_time 2
+slow_launch_time 100
socket /home/jimw/my/mysql-5.0-12792/mysql-test/var/tmp/master.sock
sort_buffer_size 262108
sql_mode
sql_notes ON
sql_warnings ON
-storage_engine MyISAM
+storage_engine MRG_MYISAM
sync_frm ON
system_time_zone GMT
table_cache 64
table_lock_wait_timeout 50
-table_type MyISAM
-thread_cache_size 0
+table_type MRG_MYISAM
+thread_cache_size 100
thread_stack 262144
time_format %H:%i:%s
time_zone SYSTEM
Suggested fix:
Fix those variables to get preserved and restored.
