Bug #19263 variables.test doesn't clean up after itself
Submitted: 21 Apr 2006 15:55 Modified: 15 May 2006 15:25
Reporter: Jim Winstead Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0 OS:Any (All)
Assigned to: Tatiana Azundris Nuernberg CPU Architecture:Any

[21 Apr 2006 15:55] Jim Winstead
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.
[8 May 2006 12:59] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/6095
[15 May 2006 12:43] Tatiana Azundris Nuernberg
fixed in 5.0.22
[15 May 2006 15:25] Paul DuBois
Fix to test case.
No changelog entry needed.