~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/variables.result

  • Committer: Eric Day
  • Date: 2010-03-04 17:10:35 UTC
  • mto: This revision was merged to the branch mainline in revision 1329.
  • Revision ID: eday@oddments.org-20100304171035-9afxk6bvc701iuoj
Switched to using the MySQL protocol by default.

Show diffs side-by-side

added added

removed removed

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