3
3
set @my_max_connect_errors =@@global.max_connect_errors;
4
4
set @my_max_heap_table_size =@@global.max_heap_table_size;
5
5
set @my_max_join_size =@@global.max_join_size;
6
set @my_oldlibdrizzle_buffer_length =@@global.oldlibdrizzle_buffer_length;
6
set @my_drizzle_protocol_buffer_length =@@global.drizzle_protocol_buffer_length;
7
7
set @my_server_id =@@global.server_id;
8
8
set @my_storage_engine =@@global.storage_engine;
9
9
set @my_myisam_sort_buffer_size =@@global.myisam_sort_buffer_size;
181
181
select * from information_schema.global_variables where variable_name like 'myisam_max_sort_file_size';
182
182
VARIABLE_NAME VARIABLE_VALUE
183
183
MYISAM_MAX_SORT_FILE_SIZE 2147483647
184
set global oldlibdrizzle_buffer_length=1024;
185
show global variables like 'oldlibdrizzle_buffer_%';
187
oldlibdrizzle_buffer_length 1024
188
select * from information_schema.global_variables where variable_name like 'oldlibdrizzle_buffer_%' order by 1;
189
VARIABLE_NAME VARIABLE_VALUE
190
OLDLIBDRIZZLE_BUFFER_LENGTH 1024
191
show global variables like 'oldlibdrizzle_buffer_%';
193
oldlibdrizzle_buffer_length 1024
194
select * from information_schema.global_variables where variable_name like 'oldlibdrizzle_buffer_%' order by 1;
195
VARIABLE_NAME VARIABLE_VALUE
196
OLDLIBDRIZZLE_BUFFER_LENGTH 1024
197
set global oldlibdrizzle_buffer_length=1;
184
set global drizzle_protocol_buffer_length=1024;
185
show global variables like 'drizzle_protocol_buffer_%';
187
drizzle_protocol_buffer_length 1024
188
select * from information_schema.global_variables where variable_name like 'drizzle_protocol_buffer_%' order by 1;
189
VARIABLE_NAME VARIABLE_VALUE
190
DRIZZLE_PROTOCOL_BUFFER_LENGTH 1024
191
show global variables like 'drizzle_protocol_buffer_%';
193
drizzle_protocol_buffer_length 1024
194
select * from information_schema.global_variables where variable_name like 'drizzle_protocol_buffer_%' order by 1;
195
VARIABLE_NAME VARIABLE_VALUE
196
DRIZZLE_PROTOCOL_BUFFER_LENGTH 1024
197
set global drizzle_protocol_buffer_length=1;
199
199
Error 1292 Truncated incorrect buffer_length value: '1'
200
show variables like 'oldlibdrizzle_buffer_length';
200
show variables like 'drizzle_protocol_buffer_length';
201
201
Variable_name Value
202
oldlibdrizzle_buffer_length 1024
203
set global oldlibdrizzle_buffer_length=2000000000;
202
drizzle_protocol_buffer_length 1024
203
set global drizzle_protocol_buffer_length=2000000000;
205
205
Error 1292 Truncated incorrect buffer_length value: '2000000000'
206
show variables like 'oldlibdrizzle_buffer_length';
206
show variables like 'drizzle_protocol_buffer_length';
207
207
Variable_name Value
208
oldlibdrizzle_buffer_length 1048576
208
drizzle_protocol_buffer_length 1048576
209
209
show variables like '%alloc%';
210
210
Variable_name Value
211
211
innodb_use_sys_malloc ON
311
311
set global myisam_sort_buffer_size=100;
313
313
Error 1292 Truncated incorrect sort_buffer_size value: '100'
314
set global oldlibdrizzle_buffer_length=100;
314
set global drizzle_protocol_buffer_length=100;
316
316
Error 1292 Truncated incorrect buffer_length value: '100'
317
317
set read_buffer_size=100;
593
593
set global max_write_lock_count =default;
594
594
set global myisam_data_pointer_size =@my_myisam_data_pointer_size;
595
595
ERROR 42000: Incorrect argument type to variable 'myisam_data_pointer_size'
596
set global oldlibdrizzle_buffer_length= @my_oldlibdrizzle_buffer_length;
596
set global drizzle_protocol_buffer_length= @my_drizzle_protocol_buffer_length;
597
597
set global server_id =@my_server_id;
598
598
set global storage_engine =@my_storage_engine;
599
599
set global thread_cache_size =@my_thread_cache_size;
added
removed
tests/r/variables.result
