← Back to branch summary

~posulliv/drizzle/optimizer-style-cleanup

« back to all changes in this revision

Viewing changes to tests/t/variables.test

  • Committer: Padraig O'Sullivan
  • Date: 2010-03-15 14:05:26 UTC
  • mfrom: (1237.9.99 staging)
  • Revision ID: osullivan.padraig@gmail.com-20100315140526-opbgwdwn6tfecdkq
Merge from trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/variables.test
6
6
drop schema if exists data_dictionary;
7
7
--enable_warnings
8
8
 
9
 
create schema data_dictionary;
10
 
 
11
9
#
12
10
# Bug #19263: variables.test doesn't clean up after itself (I/II -- save)
13
11
#
15
13
set @my_max_connect_errors        =@@global.max_connect_errors;
16
14
set @my_max_heap_table_size       =@@global.max_heap_table_size;
17
15
set @my_max_join_size             =@@global.max_join_size;
18
 
set @my_drizzle_protocol_buffer_length =@@global.drizzle_protocol_buffer_length;
 
16
set @my_mysql_protocol_buffer_length =@@global.mysql_protocol_buffer_length;
19
17
set @my_server_id                 =@@global.server_id;
20
18
set @my_storage_engine            =@@global.storage_engine;
21
19
set @my_myisam_sort_buffer_size   =@@global.myisam_sort_buffer_size;
116
114
--replace_result 9223372036853727232 FILE_SIZE 2146435072 FILE_SIZE
117
115
select * from data_dictionary.global_variables where variable_name like 'myisam_max_sort_file_size';
118
116
 
119
 
set global drizzle_protocol_buffer_length=1024;
120
 
show global variables like 'drizzle_protocol_buffer_%';
121
 
select * from data_dictionary.global_variables where variable_name like 'drizzle_protocol_buffer_%';
122
 
show global variables like 'drizzle_protocol_buffer_%';
123
 
select * from data_dictionary.global_variables where variable_name like 'drizzle_protocol_buffer_%';
124
 
set global drizzle_protocol_buffer_length=1;
125
 
show variables like 'drizzle_protocol_buffer_length';
 
117
set global mysql_protocol_buffer_length=1024;
 
118
show global variables like 'mysql_protocol_buffer_%';
 
119
select * from data_dictionary.global_variables where variable_name like 'mysql_protocol_buffer_%';
 
120
show global variables like 'mysql_protocol_buffer_%';
 
121
select * from data_dictionary.global_variables where variable_name like 'mysql_protocol_buffer_%';
 
122
set global mysql_protocol_buffer_length=1;
 
123
show variables like 'mysql_protocol_buffer_length';
126
124
#warning 1292
127
 
set global drizzle_protocol_buffer_length=2000000000;
128
 
show variables like 'drizzle_protocol_buffer_length';
 
125
set global mysql_protocol_buffer_length=2000000000;
 
126
show variables like 'mysql_protocol_buffer_length';
129
127
 
130
128
show variables like '%alloc%';
131
129
select * from data_dictionary.session_variables where variable_name like '%alloc%';
182
180
set max_sort_length=100;
183
181
set global max_write_lock_count=100;
184
182
set global myisam_sort_buffer_size=100;
185
 
set global drizzle_protocol_buffer_length=100;
 
183
set global mysql_protocol_buffer_length=100;
186
184
set read_buffer_size=100;
187
185
set read_rnd_buffer_size=100;
188
186
set global server_id=100;
524
522
set global max_write_lock_count      =default;
525
523
--error 1232
526
524
set global myisam_data_pointer_size  =@my_myisam_data_pointer_size;
527
 
set global drizzle_protocol_buffer_length= @my_drizzle_protocol_buffer_length;
 
525
set global mysql_protocol_buffer_length= @my_mysql_protocol_buffer_length;
528
526
set global server_id                 =@my_server_id;
529
527
set global storage_engine            =@my_storage_engine;
530
528
--error 1193
536
534
#
537
535
--replace_column 2 #
538
536
show global variables where variable_name='table_definition_cache' or Variable_name='table_lock_wait_timeout';
539
 
 
540
 
drop schema data_dictionary;