← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/variables.test

Merged Eric from lp:~eday/drizzle/eday-merge

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/variables.test
8
8
#
9
9
# Bug #19263: variables.test doesn't clean up after itself (I/II -- save)
10
10
#
11
 
set @my_connect_timeout           =@@global.connect_timeout;
12
11
set @my_flush                     =@@global.flush;
13
12
set @my_key_buffer_size           =@@global.key_buffer_size;
14
13
set @my_max_connect_errors        =@@global.max_connect_errors;
15
14
set @my_max_heap_table_size       =@@global.max_heap_table_size;
16
15
set @my_max_join_size             =@@global.max_join_size;
17
16
set @my_net_buffer_length         =@@global.net_buffer_length;
18
 
set @my_net_write_timeout         =@@global.net_write_timeout;
19
 
set @my_net_read_timeout          =@@global.net_read_timeout;
20
17
set @my_server_id                 =@@global.server_id;
21
18
set @my_storage_engine            =@@global.storage_engine;
22
19
 
116
113
--replace_result 9223372036853727232 FILE_SIZE 2146435072 FILE_SIZE
117
114
select * from information_schema.global_variables where variable_name like 'myisam_max_sort_file_size';
118
115
 
119
 
set global net_retry_count=10, session net_retry_count=10;
120
 
set global net_buffer_length=1024, net_write_timeout=200, net_read_timeout=300;
121
 
set session net_buffer_length=2048, net_write_timeout=500, net_read_timeout=600;
 
116
set global net_buffer_length=1024;
 
117
set session net_buffer_length=2048;
122
118
show global variables like 'net_%';
123
119
select * from information_schema.global_variables where variable_name like 'net_%' order by 1;
124
120
show session variables like 'net_%';
125
121
select * from information_schema.session_variables where variable_name like 'net_%' order by 1;
126
 
set session net_buffer_length=8000, global net_read_timeout=900, net_write_timeout=1000;
 
122
set session net_buffer_length=8000;
127
123
show global variables like 'net_%';
128
124
select * from information_schema.global_variables where variable_name like 'net_%' order by 1;
129
125
show session variables like 'net_%';
185
181
set autocommit=1;
186
182
select @@autocommit;
187
183
set bulk_insert_buffer_size=100;
188
 
set global connect_timeout=100;
189
184
select @@delay_key_write;
190
185
set global delay_key_write="OFF";
191
186
select @@delay_key_write;
202
197
set global max_write_lock_count=100;
203
198
set global myisam_sort_buffer_size=100;
204
199
set net_buffer_length=100;
205
 
set net_read_timeout=100;
206
 
set net_write_timeout=100;
207
200
set read_buffer_size=100;
208
201
set read_rnd_buffer_size=100;
209
202
set global server_id=100;
220
213
set timestamp=1, timestamp=default;
221
214
set tmp_table_size=100;
222
215
set tx_isolation="READ-COMMITTED";
223
 
set wait_timeout=100;
224
216
 
225
217
#
226
218
# key buffer
559
551
# Bug #19263: variables.test doesn't clean up after itself (II/II --
560
552
# restore)
561
553
#
562
 
set global connect_timeout           =@my_connect_timeout;
563
554
set global flush                     =@my_flush;
564
555
--error 1193
565
556
set global flush_time                =@my_flush_time;
573
564
--error 1232
574
565
set global myisam_data_pointer_size  =@my_myisam_data_pointer_size;
575
566
set global net_buffer_length         =@my_net_buffer_length;
576
 
set global net_write_timeout         =@my_net_write_timeout;
577
 
set global net_read_timeout          =@my_net_read_timeout;
578
567
set global server_id                 =@my_server_id;
579
568
set global storage_engine            =@my_storage_engine;
580
569
--error 1193