← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/variables.result

  • Committer: Brian Aker
  • Date: 2009-10-07 15:52:54 UTC
  • mfrom: (971.7.4 eday-dev)
  • Revision ID: brian@gaz-20091007155254-wmnmmm1brm0oc0w7
Merge Eric

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/variables.result
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_net_buffer_length         =@@global.net_buffer_length;
 
6
set @my_oldlibdrizzle_buffer_length =@@global.oldlibdrizzle_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 net_buffer_length=1024;
185
 
set session net_buffer_length=2048;
186
 
show global variables like 'net_%';
187
 
Variable_name   Value
188
 
net_buffer_length       1024
189
 
select * from information_schema.global_variables where variable_name like 'net_%' order by 1;
190
 
VARIABLE_NAME   VARIABLE_VALUE
191
 
NET_BUFFER_LENGTH       1024
192
 
show session variables like 'net_%';
193
 
Variable_name   Value
194
 
net_buffer_length       2048
195
 
select * from information_schema.session_variables where variable_name like 'net_%' order by 1;
196
 
VARIABLE_NAME   VARIABLE_VALUE
197
 
NET_BUFFER_LENGTH       2048
198
 
set session net_buffer_length=8000;
199
 
show global variables like 'net_%';
200
 
Variable_name   Value
201
 
net_buffer_length       1024
202
 
select * from information_schema.global_variables where variable_name like 'net_%' order by 1;
203
 
VARIABLE_NAME   VARIABLE_VALUE
204
 
NET_BUFFER_LENGTH       1024
205
 
show session variables like 'net_%';
206
 
Variable_name   Value
207
 
net_buffer_length       7168
208
 
select * from information_schema.session_variables where variable_name like 'net_%' order by 1;
209
 
VARIABLE_NAME   VARIABLE_VALUE
210
 
NET_BUFFER_LENGTH       7168
211
 
set net_buffer_length=1;
212
 
Warnings:
213
 
Error   1292    Truncated incorrect net_buffer_length value: '1'
214
 
show variables like 'net_buffer_length';
215
 
Variable_name   Value
216
 
net_buffer_length       1024
217
 
select * from information_schema.session_variables where variable_name like 'net_buffer_length';
218
 
VARIABLE_NAME   VARIABLE_VALUE
219
 
NET_BUFFER_LENGTH       1024
220
 
set net_buffer_length=2000000000;
221
 
Warnings:
222
 
Error   1292    Truncated incorrect net_buffer_length value: '2000000000'
223
 
show variables like 'net_buffer_length';
224
 
Variable_name   Value
225
 
net_buffer_length       1048576
226
 
select * from information_schema.session_variables where variable_name like 'net_buffer_length';
227
 
VARIABLE_NAME   VARIABLE_VALUE
228
 
NET_BUFFER_LENGTH       1048576
 
184
set global oldlibdrizzle_buffer_length=1024;
 
185
show global variables like 'oldlibdrizzle_buffer_%';
 
186
Variable_name   Value
 
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_%';
 
192
Variable_name   Value
 
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;
 
198
Warnings:
 
199
Error   1292    Truncated incorrect buffer_length value: '1'
 
200
show variables like 'oldlibdrizzle_buffer_length';
 
201
Variable_name   Value
 
202
oldlibdrizzle_buffer_length     1024
 
203
set global oldlibdrizzle_buffer_length=2000000000;
 
204
Warnings:
 
205
Error   1292    Truncated incorrect buffer_length value: '2000000000'
 
206
show variables like 'oldlibdrizzle_buffer_length';
 
207
Variable_name   Value
 
208
oldlibdrizzle_buffer_length     1048576
229
209
show variables like '%alloc%';
230
210
Variable_name   Value
231
211
innodb_use_sys_malloc   ON
331
311
set global myisam_sort_buffer_size=100;
332
312
Warnings:
333
313
Error   1292    Truncated incorrect sort_buffer_size value: '100'
334
 
set net_buffer_length=100;
 
314
set global oldlibdrizzle_buffer_length=100;
335
315
Warnings:
336
 
Error   1292    Truncated incorrect net_buffer_length value: '100'
 
316
Error   1292    Truncated incorrect buffer_length value: '100'
337
317
set read_buffer_size=100;
338
318
Warnings:
339
319
Error   1292    Truncated incorrect read_buffer_size value: '100'
625
605
set global max_write_lock_count      =default;
626
606
set global myisam_data_pointer_size  =@my_myisam_data_pointer_size;
627
607
ERROR 42000: Incorrect argument type to variable 'myisam_data_pointer_size'
628
 
set global net_buffer_length         =@my_net_buffer_length;
 
608
set global oldlibdrizzle_buffer_length= @my_oldlibdrizzle_buffer_length;
629
609
set global server_id                 =@my_server_id;
630
610
set global storage_engine            =@my_storage_engine;
631
611
set global thread_cache_size         =@my_thread_cache_size;