← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/variables.result

Merged trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/variables.result
4
4
set @my_max_connect_errors        =@@global.max_connect_errors;
5
5
set @my_max_heap_table_size       =@@global.max_heap_table_size;
6
6
set @my_max_join_size             =@@global.max_join_size;
7
 
set @my_drizzle_protocol_buffer_length =@@global.drizzle_protocol_buffer_length;
 
7
set @my_mysql_protocol_buffer_length =@@global.mysql_protocol_buffer_length;
8
8
set @my_server_id                 =@@global.server_id;
9
9
set @my_storage_engine            =@@global.storage_engine;
10
10
set @my_myisam_sort_buffer_size   =@@global.myisam_sort_buffer_size;
182
182
select * from data_dictionary.global_variables where variable_name like 'myisam_max_sort_file_size';
183
183
VARIABLE_NAME   VARIABLE_VALUE
184
184
myisam_max_sort_file_size       2147483647
185
 
set global drizzle_protocol_buffer_length=1024;
186
 
show global variables like 'drizzle_protocol_buffer_%';
187
 
Variable_name   Value
188
 
drizzle_protocol_buffer_length  1024
189
 
select * from data_dictionary.global_variables where variable_name like 'drizzle_protocol_buffer_%';
190
 
VARIABLE_NAME   VARIABLE_VALUE
191
 
drizzle_protocol_buffer_length  1024
192
 
show global variables like 'drizzle_protocol_buffer_%';
193
 
Variable_name   Value
194
 
drizzle_protocol_buffer_length  1024
195
 
select * from data_dictionary.global_variables where variable_name like 'drizzle_protocol_buffer_%';
196
 
VARIABLE_NAME   VARIABLE_VALUE
197
 
drizzle_protocol_buffer_length  1024
198
 
set global drizzle_protocol_buffer_length=1;
 
185
set global mysql_protocol_buffer_length=1024;
 
186
show global variables like 'mysql_protocol_buffer_%';
 
187
Variable_name   Value
 
188
mysql_protocol_buffer_length    1024
 
189
select * from data_dictionary.global_variables where variable_name like 'mysql_protocol_buffer_%';
 
190
VARIABLE_NAME   VARIABLE_VALUE
 
191
mysql_protocol_buffer_length    1024
 
192
show global variables like 'mysql_protocol_buffer_%';
 
193
Variable_name   Value
 
194
mysql_protocol_buffer_length    1024
 
195
select * from data_dictionary.global_variables where variable_name like 'mysql_protocol_buffer_%';
 
196
VARIABLE_NAME   VARIABLE_VALUE
 
197
mysql_protocol_buffer_length    1024
 
198
set global mysql_protocol_buffer_length=1;
199
199
Warnings:
200
200
Error   1292    Truncated incorrect buffer_length value: '1'
201
 
show variables like 'drizzle_protocol_buffer_length';
 
201
show variables like 'mysql_protocol_buffer_length';
202
202
Variable_name   Value
203
 
drizzle_protocol_buffer_length  1024
204
 
set global drizzle_protocol_buffer_length=2000000000;
 
203
mysql_protocol_buffer_length    1024
 
204
set global mysql_protocol_buffer_length=2000000000;
205
205
Warnings:
206
206
Error   1292    Truncated incorrect buffer_length value: '2000000000'
207
 
show variables like 'drizzle_protocol_buffer_length';
 
207
show variables like 'mysql_protocol_buffer_length';
208
208
Variable_name   Value
209
 
drizzle_protocol_buffer_length  1048576
 
209
mysql_protocol_buffer_length    1048576
210
210
show variables like '%alloc%';
211
211
Variable_name   Value
212
212
innodb_use_sys_malloc   ON
297
297
set global myisam_sort_buffer_size=100;
298
298
Warnings:
299
299
Error   1292    Truncated incorrect sort_buffer_size value: '100'
300
 
set global drizzle_protocol_buffer_length=100;
 
300
set global mysql_protocol_buffer_length=100;
301
301
Warnings:
302
302
Error   1292    Truncated incorrect buffer_length value: '100'
303
303
set read_buffer_size=100;
580
580
set global max_write_lock_count      =default;
581
581
set global myisam_data_pointer_size  =@my_myisam_data_pointer_size;
582
582
ERROR 42000: Incorrect argument type to variable 'myisam_data_pointer_size'
583
 
set global drizzle_protocol_buffer_length= @my_drizzle_protocol_buffer_length;
 
583
set global mysql_protocol_buffer_length= @my_mysql_protocol_buffer_length;
584
584
set global server_id                 =@my_server_id;
585
585
set global storage_engine            =@my_storage_engine;
586
586
set global thread_cache_size         =@my_thread_cache_size;