set_var.cc 99.4 KB
Newer Older
1
/* Copyright (C) 2000-2003 MySQL AB
unknown's avatar
unknown committed
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; either version 2 of the License, or
   (at your option) any later version.

   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.

   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */

/*
  Handling of MySQL SQL variables

  To add a new variable, one has to do the following:

  - Use one of the 'sys_var... classes from set_var.h or write a specific
    one for the variable type.
  - Define it in the 'variable definition list' in this file.
25 26
  - If the variable should be changeable or one should be able to access it
    with @@variable_name, it should be added to the 'list of all variables'
27 28 29
    list (sys_variables) in this file.
  - If the variable is thread specific, add it to 'system_variables' struct.
    If not, add it to mysqld.cc and an declaration in 'mysql_priv.h'
unknown's avatar
unknown committed
30 31
  - If the variable should be changed from the command line, add a definition
    of it in the my_option structure list in mysqld.dcc
32 33
  - Don't forget to initialize new fields in global_system_variables and
    max_system_variables!
unknown's avatar
unknown committed
34 35 36
  - If the variable should show up in 'show variables' add it to the
    init_vars[] struct in this file

37 38 39 40 41 42
  NOTES:
    - Be careful with var->save_result: sys_var::check() only updates
    ulonglong_value; so other members of the union are garbage then; to use
    them you must first assign a value to them (in specific ::check() for
    example).

unknown's avatar
unknown committed
43 44 45 46 47 48 49 50 51 52 53 54 55
  TODO:
    - Add full support for the variable character_set (for 4.1)

    - When updating myisam_delay_key_write, we should do a 'flush tables'
      of all MyISAM tables to ensure that they are reopen with the
      new attribute.
*/

#ifdef __GNUC__
#pragma implementation				// gcc: Class implementation
#endif

#include "mysql_priv.h"
56
#include <mysql.h>
unknown's avatar
unknown committed
57 58 59
#include "slave.h"
#include "sql_acl.h"
#include <my_getopt.h>
60
#include <thr_alarm.h>
unknown's avatar
unknown committed
61 62 63 64 65 66 67
#include <myisam.h>
#ifdef HAVE_BERKELEY_DB
#include "ha_berkeley.h"
#endif
#ifdef HAVE_INNOBASE_DB
#include "ha_innodb.h"
#endif
unknown's avatar
unknown committed
68 69 70
#ifdef HAVE_NDBCLUSTER_DB
#include "ha_ndbcluster.h"
#endif
unknown's avatar
unknown committed
71 72 73 74 75

static HASH system_variable_hash;
const char *bool_type_names[]= { "OFF", "ON", NullS };
TYPELIB bool_typelib=
{
76
  array_elements(bool_type_names)-1, "", bool_type_names, NULL
unknown's avatar
unknown committed
77 78
};

79 80 81
const char *delay_key_write_type_names[]= { "OFF", "ON", "ALL", NullS };
TYPELIB delay_key_write_typelib=
{
82 83
  array_elements(delay_key_write_type_names)-1, "",
  delay_key_write_type_names, NULL
84 85
};

86
static int sys_check_charset(THD *thd, set_var *var);
unknown's avatar
unknown committed
87 88
static bool sys_update_charset(THD *thd, set_var *var);
static void sys_set_default_charset(THD *thd, enum_var_type type);
89 90 91
static int  sys_check_ftb_syntax(THD *thd,  set_var *var);
static bool sys_update_ftb_syntax(THD *thd, set_var * var);
static void sys_default_ftb_syntax(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
92 93 94 95
static bool sys_update_init_connect(THD*, set_var*);
static void sys_default_init_connect(THD*, enum_var_type type);
static bool sys_update_init_slave(THD*, set_var*);
static void sys_default_init_slave(THD*, enum_var_type type);
unknown's avatar
unknown committed
96 97
static bool set_option_bit(THD *thd, set_var *var);
static bool set_option_autocommit(THD *thd, set_var *var);
98
static int  check_log_update(THD *thd, set_var *var);
unknown's avatar
unknown committed
99
static bool set_log_update(THD *thd, set_var *var);
100
static int  check_pseudo_thread_id(THD *thd, set_var *var);
101
static bool set_log_bin(THD *thd, set_var *var);
unknown's avatar
unknown committed
102 103 104 105
static void fix_low_priority_updates(THD *thd, enum_var_type type);
static void fix_tx_isolation(THD *thd, enum_var_type type);
static void fix_net_read_timeout(THD *thd, enum_var_type type);
static void fix_net_write_timeout(THD *thd, enum_var_type type);
106
static void fix_net_retry_count(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
107 108
static void fix_max_join_size(THD *thd, enum_var_type type);
static void fix_query_cache_size(THD *thd, enum_var_type type);
109
static void fix_query_cache_min_res_unit(THD *thd, enum_var_type type);
110 111
static void fix_myisam_max_extra_sort_file_size(THD *thd, enum_var_type type);
static void fix_myisam_max_sort_file_size(THD *thd, enum_var_type type);
112 113
static void fix_max_binlog_size(THD *thd, enum_var_type type);
static void fix_max_relay_log_size(THD *thd, enum_var_type type);
114
static void fix_max_connections(THD *thd, enum_var_type type);
115
static int check_max_delayed_threads(THD *thd, set_var *var);
116 117
static void fix_thd_mem_root(THD *thd, enum_var_type type);
static void fix_trans_mem_root(THD *thd, enum_var_type type);
118
static void fix_server_id(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
119
static KEY_CACHE *create_key_cache(const char *name, uint length);
120
void fix_sql_mode_var(THD *thd, enum_var_type type);
121 122
static byte *get_error_count(THD *thd);
static byte *get_warning_count(THD *thd);
unknown's avatar
unknown committed
123 124 125 126 127 128 129 130

/*
  Variable definition list

  These are variables that can be set from the command line, in
  alphabetic order
*/

131 132 133 134 135
sys_var_thd_ulong	sys_auto_increment_increment("auto_increment_increment",
                                                     &SV::auto_increment_increment);
sys_var_thd_ulong	sys_auto_increment_offset("auto_increment_offset",
                                                  &SV::auto_increment_offset);

unknown's avatar
unknown committed
136 137 138 139
sys_var_long_ptr	sys_binlog_cache_size("binlog_cache_size",
					      &binlog_cache_size);
sys_var_thd_ulong	sys_bulk_insert_buff_size("bulk_insert_buffer_size",
						  &SV::bulk_insert_buff_size);
140 141
sys_var_character_set_server	sys_character_set_server("character_set_server");
sys_var_str			sys_charset_system("character_set_system",
142 143
				    sys_check_charset,
				    sys_update_charset,
144 145
				    sys_set_default_charset,
                                    (char *)my_charset_utf8_general_ci.name);
146
sys_var_character_set_database	sys_character_set_database("character_set_database");
147
sys_var_character_set_client  sys_character_set_client("character_set_client");
unknown's avatar
unknown committed
148
sys_var_character_set_connection  sys_character_set_connection("character_set_connection");
149
sys_var_character_set_results sys_character_set_results("character_set_results");
unknown's avatar
unknown committed
150
sys_var_collation_connection sys_collation_connection("collation_connection");
151 152
sys_var_collation_database sys_collation_database("collation_database");
sys_var_collation_server sys_collation_server("collation_server");
unknown's avatar
unknown committed
153 154 155 156
sys_var_bool_ptr	sys_concurrent_insert("concurrent_insert",
					      &myisam_concurrent_insert);
sys_var_long_ptr	sys_connect_timeout("connect_timeout",
					    &connect_timeout);
157 158 159 160
sys_var_enum		sys_delay_key_write("delay_key_write",
					    &delay_key_write_options,
					    &delay_key_write_typelib,
					    fix_delay_key_write);
unknown's avatar
unknown committed
161 162 163 164 165 166
sys_var_long_ptr	sys_delayed_insert_limit("delayed_insert_limit",
						 &delayed_insert_limit);
sys_var_long_ptr	sys_delayed_insert_timeout("delayed_insert_timeout",
						   &delayed_insert_timeout);
sys_var_long_ptr	sys_delayed_queue_size("delayed_queue_size",
					       &delayed_queue_size);
unknown's avatar
unknown committed
167 168
sys_var_long_ptr	sys_expire_logs_days("expire_logs_days",
					     &expire_logs_days);
unknown's avatar
unknown committed
169 170
sys_var_bool_ptr	sys_flush("flush", &myisam_flush);
sys_var_long_ptr	sys_flush_time("flush_time", &flush_time);
171 172 173 174 175 176 177 178 179 180 181
sys_var_str             sys_ft_boolean_syntax("ft_boolean_syntax",
                                         sys_check_ftb_syntax,
                                         sys_update_ftb_syntax,
                                         sys_default_ftb_syntax,
                                         ft_boolean_syntax);
sys_var_str             sys_init_connect("init_connect", 0,
                                         sys_update_init_connect,
                                         sys_default_init_connect,0);
sys_var_str             sys_init_slave("init_slave", 0,
                                       sys_update_init_slave,
                                       sys_default_init_slave,0);
unknown's avatar
unknown committed
182 183 184 185
sys_var_thd_ulong	sys_interactive_timeout("interactive_timeout",
						&SV::net_interactive_timeout);
sys_var_thd_ulong	sys_join_buffer_size("join_buffer_size",
					     &SV::join_buff_size);
186
sys_var_key_buffer_size	sys_key_buffer_size("key_buffer_size");
187
sys_var_key_cache_long  sys_key_cache_block_size("key_cache_block_size",
unknown's avatar
unknown committed
188 189
						 offsetof(KEY_CACHE,
							  param_block_size));
190
sys_var_key_cache_long	sys_key_cache_division_limit("key_cache_division_limit",
unknown's avatar
unknown committed
191 192
						     offsetof(KEY_CACHE,
							      param_division_limit));
193
sys_var_key_cache_long  sys_key_cache_age_threshold("key_cache_age_threshold",
unknown's avatar
unknown committed
194 195
						     offsetof(KEY_CACHE,
							      param_age_threshold));
unknown's avatar
unknown committed
196 197
sys_var_bool_ptr	sys_local_infile("local_infile",
					 &opt_local_infile);
198
sys_var_thd_ulong	sys_log_warnings("log_warnings", &SV::log_warnings);
unknown's avatar
unknown committed
199 200 201 202 203 204 205 206 207 208 209 210 211 212 213
sys_var_thd_ulong	sys_long_query_time("long_query_time",
					     &SV::long_query_time);
sys_var_thd_bool	sys_low_priority_updates("low_priority_updates",
						 &SV::low_priority_updates,
						 fix_low_priority_updates);
#ifndef TO_BE_DELETED	/* Alias for the low_priority_updates */
sys_var_thd_bool	sys_sql_low_priority_updates("sql_low_priority_updates",
						     &SV::low_priority_updates,
						     fix_low_priority_updates);
#endif
sys_var_thd_ulong	sys_max_allowed_packet("max_allowed_packet",
					       &SV::max_allowed_packet);
sys_var_long_ptr	sys_max_binlog_cache_size("max_binlog_cache_size",
						  &max_binlog_cache_size);
sys_var_long_ptr	sys_max_binlog_size("max_binlog_size",
214 215
					    &max_binlog_size,
                                            fix_max_binlog_size);
unknown's avatar
unknown committed
216
sys_var_long_ptr	sys_max_connections("max_connections",
217 218
					    &max_connections,
                                            fix_max_connections);
unknown's avatar
unknown committed
219 220
sys_var_long_ptr	sys_max_connect_errors("max_connect_errors",
					       &max_connect_errors);
221
sys_var_thd_ulong       sys_max_insert_delayed_threads("max_insert_delayed_threads",
222 223 224
						       &SV::max_insert_delayed_threads,
                                                       check_max_delayed_threads,
                                                       fix_max_connections);
225 226
sys_var_thd_ulong	sys_max_delayed_threads("max_delayed_threads",
						&SV::max_insert_delayed_threads,
227 228
                                                check_max_delayed_threads,
                                                fix_max_connections);
229 230
sys_var_thd_ulong	sys_max_error_count("max_error_count",
					    &SV::max_error_count);
unknown's avatar
unknown committed
231 232
sys_var_thd_ulong	sys_max_heap_table_size("max_heap_table_size",
						&SV::max_heap_table_size);
233 234 235
sys_var_thd_ulong       sys_pseudo_thread_id("pseudo_thread_id",
					     &SV::pseudo_thread_id,
                                             check_pseudo_thread_id, 0);
236
sys_var_thd_ha_rows	sys_max_join_size("max_join_size",
unknown's avatar
unknown committed
237 238
					  &SV::max_join_size,
					  fix_max_join_size);
239 240
sys_var_thd_ulong	sys_max_seeks_for_key("max_seeks_for_key",
					      &SV::max_seeks_for_key);
unknown's avatar
unknown committed
241
sys_var_thd_ulong   sys_max_length_for_sort_data("max_length_for_sort_data",
242
                                                 &SV::max_length_for_sort_data);
unknown's avatar
unknown committed
243
#ifndef TO_BE_DELETED	/* Alias for max_join_size */
244
sys_var_thd_ha_rows	sys_sql_max_join_size("sql_max_join_size",
unknown's avatar
unknown committed
245 246 247
					      &SV::max_join_size,
					      fix_max_join_size);
#endif
248 249 250
sys_var_long_ptr	sys_max_relay_log_size("max_relay_log_size",
                                               &max_relay_log_size,
                                               fix_max_relay_log_size);
unknown's avatar
unknown committed
251 252 253 254 255 256 257 258
sys_var_thd_ulong	sys_max_sort_length("max_sort_length",
					    &SV::max_sort_length);
sys_var_long_ptr	sys_max_user_connections("max_user_connections",
						 &max_user_connections);
sys_var_thd_ulong	sys_max_tmp_tables("max_tmp_tables",
					   &SV::max_tmp_tables);
sys_var_long_ptr	sys_max_write_lock_count("max_write_lock_count",
						 &max_write_lock_count);
unknown's avatar
unknown committed
259 260
sys_var_long_ptr	sys_myisam_data_pointer_size("myisam_data_pointer_size",
                                                    &myisam_data_pointer_size);
261 262
sys_var_thd_ulonglong	sys_myisam_max_extra_sort_file_size("myisam_max_extra_sort_file_size", &SV::myisam_max_extra_sort_file_size, fix_myisam_max_extra_sort_file_size, 1);
sys_var_thd_ulonglong	sys_myisam_max_sort_file_size("myisam_max_sort_file_size", &SV::myisam_max_sort_file_size, fix_myisam_max_sort_file_size, 1);
263
sys_var_thd_ulong       sys_myisam_repair_threads("myisam_repair_threads", &SV::myisam_repair_threads);
unknown's avatar
unknown committed
264 265 266 267 268
sys_var_thd_ulong	sys_myisam_sort_buffer_size("myisam_sort_buffer_size", &SV::myisam_sort_buff_size);
sys_var_thd_ulong	sys_net_buffer_length("net_buffer_length",
					      &SV::net_buffer_length);
sys_var_thd_ulong	sys_net_read_timeout("net_read_timeout",
					     &SV::net_read_timeout,
269
					     0, fix_net_read_timeout);
unknown's avatar
unknown committed
270 271
sys_var_thd_ulong	sys_net_write_timeout("net_write_timeout",
					      &SV::net_write_timeout,
272
					      0, fix_net_write_timeout);
273 274
sys_var_thd_ulong	sys_net_retry_count("net_retry_count",
					    &SV::net_retry_count,
275
					    0, fix_net_retry_count);
276
sys_var_thd_bool	sys_new_mode("new", &SV::new_mode);
277
sys_var_thd_bool	sys_old_passwords("old_passwords", &SV::old_passwords);
278 279 280 281
sys_var_thd_ulong       sys_optimizer_prune_level("optimizer_prune_level",
                                                  &SV::optimizer_prune_level);
sys_var_thd_ulong       sys_optimizer_search_depth("optimizer_search_depth",
                                                   &SV::optimizer_search_depth);
unknown's avatar
unknown committed
282 283
sys_var_thd_ulong       sys_preload_buff_size("preload_buffer_size",
                                              &SV::preload_buff_size);
unknown's avatar
unknown committed
284 285
sys_var_thd_ulong	sys_read_buff_size("read_buffer_size",
					   &SV::read_buff_size);
286
sys_var_bool_ptr	sys_readonly("read_only", &opt_readonly);
unknown's avatar
unknown committed
287 288
sys_var_thd_ulong	sys_read_rnd_buff_size("read_rnd_buffer_size",
					       &SV::read_rnd_buff_size);
289 290 291 292
#ifdef HAVE_REPLICATION
sys_var_bool_ptr	sys_relay_log_purge("relay_log_purge",
                                            &relay_log_purge);
#endif
unknown's avatar
unknown committed
293 294 295 296 297
sys_var_long_ptr	sys_rpl_recovery_rank("rpl_recovery_rank",
					      &rpl_recovery_rank);
sys_var_long_ptr	sys_query_cache_size("query_cache_size",
					     &query_cache_size,
					     fix_query_cache_size);
298 299 300 301

sys_var_thd_ulong	sys_range_alloc_block_size("range_alloc_block_size",
						   &SV::range_alloc_block_size);
sys_var_thd_ulong	sys_query_alloc_block_size("query_alloc_block_size",
302 303
						   &SV::query_alloc_block_size,
						   0, fix_thd_mem_root);
304
sys_var_thd_ulong	sys_query_prealloc_size("query_prealloc_size",
305 306
						&SV::query_prealloc_size,
						0, fix_thd_mem_root);
307
sys_var_thd_ulong	sys_trans_alloc_block_size("transaction_alloc_block_size",
308 309
						   &SV::trans_alloc_block_size,
						   0, fix_trans_mem_root);
310
sys_var_thd_ulong	sys_trans_prealloc_size("transaction_prealloc_size",
311 312
						&SV::trans_prealloc_size,
						0, fix_trans_mem_root);
313

unknown's avatar
unknown committed
314 315 316
#ifdef HAVE_QUERY_CACHE
sys_var_long_ptr	sys_query_cache_limit("query_cache_limit",
					      &query_cache.query_cache_limit);
317 318 319
sys_var_long_ptr        sys_query_cache_min_res_unit("query_cache_min_res_unit",
						     &query_cache_min_res_unit,
						     fix_query_cache_min_res_unit);
unknown's avatar
unknown committed
320 321 322
sys_var_thd_enum	sys_query_cache_type("query_cache_type",
					     &SV::query_cache_type,
					     &query_cache_type_typelib);
323 324 325
sys_var_thd_bool
sys_query_cache_wlock_invalidate("query_cache_wlock_invalidate",
				 &SV::query_cache_wlock_invalidate);
unknown's avatar
unknown committed
326
#endif /* HAVE_QUERY_CACHE */
327
sys_var_bool_ptr	sys_secure_auth("secure_auth", &opt_secure_auth);
328
sys_var_long_ptr	sys_server_id("server_id", &server_id, fix_server_id);
329 330
sys_var_bool_ptr	sys_slave_compressed_protocol("slave_compressed_protocol",
						      &opt_slave_compressed_protocol);
unknown's avatar
SCRUM  
unknown committed
331
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
332 333
sys_var_long_ptr	sys_slave_net_timeout("slave_net_timeout",
					      &slave_net_timeout);
334
#endif
unknown's avatar
unknown committed
335 336 337 338
sys_var_long_ptr	sys_slow_launch_time("slow_launch_time",
					     &slow_launch_time);
sys_var_thd_ulong	sys_sort_buffer("sort_buffer_size",
					&SV::sortbuff_size);
339 340
sys_var_thd_sql_mode    sys_sql_mode("sql_mode",
                                     &SV::sql_mode);
341 342 343 344
sys_var_thd_enum
sys_updatable_views_with_limit("updatable_views_with_limit",
                               &SV::updatable_views_with_limit,
                               &updatable_views_with_limit_typelib);
unknown's avatar
VIEW  
unknown committed
345

346 347
sys_var_thd_table_type  sys_table_type("table_type",
				       &SV::table_type);
unknown's avatar
unknown committed
348 349
sys_var_thd_storage_engine sys_storage_engine("storage_engine",
				       &SV::table_type);
350 351 352 353
#ifdef HAVE_REPLICATION
sys_var_sync_binlog_period sys_sync_binlog_period("sync_binlog", &sync_binlog_period);
#endif
sys_var_bool_ptr	sys_sync_frm("sync_frm", &opt_sync_frm);
unknown's avatar
unknown committed
354 355 356 357 358 359 360 361 362 363 364 365
sys_var_long_ptr	sys_table_cache_size("table_cache",
					     &table_cache_size);
sys_var_long_ptr	sys_thread_cache_size("thread_cache_size",
					      &thread_cache_size);
sys_var_thd_enum	sys_tx_isolation("tx_isolation",
					 &SV::tx_isolation,
					 &tx_isolation_typelib,
					 fix_tx_isolation);
sys_var_thd_ulong	sys_tmp_table_size("tmp_table_size",
					   &SV::tmp_table_size);
sys_var_thd_ulong	sys_net_wait_timeout("wait_timeout",
					     &SV::net_wait_timeout);
366

367 368 369
#ifdef HAVE_INNOBASE_DB
sys_var_long_ptr        sys_innodb_max_dirty_pages_pct("innodb_max_dirty_pages_pct",
                                                        &srv_max_buf_pool_modified_pct);
370 371
sys_var_long_ptr	sys_innodb_max_purge_lag("innodb_max_purge_lag",
							&srv_max_purge_lag);
372 373
sys_var_thd_bool	sys_innodb_table_locks("innodb_table_locks",
                                               &SV::innodb_table_locks);
374 375
sys_var_long_ptr	sys_innodb_autoextend_increment("innodb_autoextend_increment",
							&srv_auto_extend_increment);
376
#endif
377 378 379 380 381

/* Time/date/datetime formats */

sys_var_thd_date_time_format sys_time_format("time_format",
					     &SV::time_format,
382
					     MYSQL_TIMESTAMP_TIME);
383 384
sys_var_thd_date_time_format sys_date_format("date_format",
					     &SV::date_format,
385
					     MYSQL_TIMESTAMP_DATE);
386 387
sys_var_thd_date_time_format sys_datetime_format("datetime_format",
						 &SV::datetime_format,
388
						 MYSQL_TIMESTAMP_DATETIME);
389 390

/* Variables that are bits in THD */
unknown's avatar
unknown committed
391

392
static sys_var_thd_bit	sys_autocommit("autocommit", 0,
unknown's avatar
unknown committed
393 394 395
				       set_option_autocommit,
				       OPTION_NOT_AUTOCOMMIT,
				       1);
396
static sys_var_thd_bit	sys_big_tables("big_tables", 0,
unknown's avatar
unknown committed
397 398 399
				       set_option_bit,
				       OPTION_BIG_TABLES);
#ifndef TO_BE_DELETED	/* Alias for big_tables */
400
static sys_var_thd_bit	sys_sql_big_tables("sql_big_tables", 0,
unknown's avatar
unknown committed
401 402 403
					   set_option_bit,
					   OPTION_BIG_TABLES);
#endif
404
static sys_var_thd_bit	sys_big_selects("sql_big_selects", 0,
unknown's avatar
unknown committed
405
					set_option_bit,
406
					OPTION_BIG_SELECTS);
407
static sys_var_thd_bit	sys_log_off("sql_log_off", 0,
unknown's avatar
unknown committed
408 409 410
				    set_option_bit,
				    OPTION_LOG_OFF);
static sys_var_thd_bit	sys_log_update("sql_log_update",
411
                                       check_log_update,
unknown's avatar
unknown committed
412 413 414
				       set_log_update,
				       OPTION_UPDATE_LOG);
static sys_var_thd_bit	sys_log_binlog("sql_log_bin",
415 416 417 418
                                       check_log_update,
				       set_log_bin,
				       OPTION_BIN_LOG);
static sys_var_thd_bit	sys_sql_warnings("sql_warnings", 0,
unknown's avatar
unknown committed
419 420
					 set_option_bit,
					 OPTION_WARNINGS);
421
static sys_var_thd_bit	sys_auto_is_null("sql_auto_is_null", 0,
unknown's avatar
unknown committed
422 423
					 set_option_bit,
					 OPTION_AUTO_IS_NULL);
424
static sys_var_thd_bit	sys_safe_updates("sql_safe_updates", 0,
unknown's avatar
unknown committed
425 426
					 set_option_bit,
					 OPTION_SAFE_UPDATES);
427
static sys_var_thd_bit	sys_buffer_results("sql_buffer_result", 0,
unknown's avatar
unknown committed
428 429
					   set_option_bit,
					   OPTION_BUFFER_RESULT);
430
static sys_var_thd_bit	sys_quote_show_create("sql_quote_show_create", 0,
unknown's avatar
unknown committed
431 432
					      set_option_bit,
					      OPTION_QUOTE_SHOW_CREATE);
433
static sys_var_thd_bit	sys_foreign_key_checks("foreign_key_checks", 0,
434 435 436
					       set_option_bit,
					       OPTION_NO_FOREIGN_KEY_CHECKS,
					       1);
437
static sys_var_thd_bit	sys_unique_checks("unique_checks", 0,
438 439 440 441
					  set_option_bit,
					  OPTION_RELAXED_UNIQUE_CHECKS,
					  1);

unknown's avatar
unknown committed
442 443
/* Local state variables */

444
static sys_var_thd_ha_rows	sys_select_limit("sql_select_limit",
unknown's avatar
unknown committed
445 446 447 448 449
						 &SV::select_limit);
static sys_var_timestamp	sys_timestamp("timestamp");
static sys_var_last_insert_id	sys_last_insert_id("last_insert_id");
static sys_var_last_insert_id	sys_identity("identity");
static sys_var_insert_id	sys_insert_id("insert_id");
450 451 452 453 454 455 456 457 458
static sys_var_readonly		sys_error_count("error_count",
						OPT_SESSION,
						SHOW_LONG,
						get_error_count);
static sys_var_readonly		sys_warning_count("warning_count",
						  OPT_SESSION,
						  SHOW_LONG,
						  get_warning_count);

unknown's avatar
unknown committed
459
/* alias for last_insert_id() to be compatible with Sybase */
unknown's avatar
SCRUM  
unknown committed
460
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
461
static sys_var_slave_skip_counter sys_slave_skip_counter("sql_slave_skip_counter");
462
#endif
463 464
static sys_var_rand_seed1	sys_rand_seed1("rand_seed1");
static sys_var_rand_seed2	sys_rand_seed2("rand_seed2");
unknown's avatar
unknown committed
465

466 467
static sys_var_thd_ulong        sys_default_week_format("default_week_format",
					                &SV::default_week_format);
unknown's avatar
unknown committed
468

unknown's avatar
unknown committed
469 470 471
sys_var_thd_ulong               sys_group_concat_max_len("group_concat_max_len",
                                                         &SV::group_concat_max_len);

472
sys_var_thd_time_zone            sys_time_zone("time_zone");
473 474 475 476 477

/* Read only variables */

sys_var_const_str		sys_os("version_compile_os", SYSTEM_TYPE);
/* Global read-only variable describing server license */
478
sys_var_const_str		sys_license("license", STRINGIFY_ARG(LICENSE));
479 480


unknown's avatar
unknown committed
481 482 483 484 485 486 487 488 489 490 491
/*
  List of all variables for initialisation and storage in hash
  This is sorted in alphabetical order to make it easy to add new variables

  If the variable is not in this list, it can't be changed with
  SET variable_name=
*/

sys_var *sys_variables[]=
{
  &sys_auto_is_null,
492 493
  &sys_auto_increment_increment,
  &sys_auto_increment_offset,
unknown's avatar
unknown committed
494 495 496 497 498 499
  &sys_autocommit,
  &sys_big_tables,
  &sys_big_selects,
  &sys_binlog_cache_size,
  &sys_buffer_results,
  &sys_bulk_insert_buff_size,
500 501
  &sys_character_set_server,
  &sys_character_set_database,
502
  &sys_character_set_client,
unknown's avatar
unknown committed
503
  &sys_character_set_connection,
504
  &sys_character_set_results,
unknown's avatar
unknown committed
505
  &sys_collation_connection,
506 507
  &sys_collation_database,
  &sys_collation_server,
unknown's avatar
unknown committed
508 509
  &sys_concurrent_insert,
  &sys_connect_timeout,
510 511
  &sys_date_format,
  &sys_datetime_format,
512
  &sys_default_week_format,
unknown's avatar
unknown committed
513 514 515 516
  &sys_delay_key_write,
  &sys_delayed_insert_limit,
  &sys_delayed_insert_timeout,
  &sys_delayed_queue_size,
517
  &sys_error_count,
unknown's avatar
unknown committed
518
  &sys_expire_logs_days,
unknown's avatar
unknown committed
519 520
  &sys_flush,
  &sys_flush_time,
521
  &sys_ft_boolean_syntax,
522
  &sys_foreign_key_checks,
unknown's avatar
unknown committed
523
  &sys_group_concat_max_len,
unknown's avatar
unknown committed
524
  &sys_identity,
unknown's avatar
unknown committed
525 526
  &sys_init_connect,
  &sys_init_slave,
unknown's avatar
unknown committed
527 528 529 530
  &sys_insert_id,
  &sys_interactive_timeout,
  &sys_join_buffer_size,
  &sys_key_buffer_size,
unknown's avatar
unknown committed
531
  &sys_key_cache_block_size,
532 533
  &sys_key_cache_division_limit,
  &sys_key_cache_age_threshold,
unknown's avatar
unknown committed
534
  &sys_last_insert_id,
535
  &sys_license,
unknown's avatar
unknown committed
536 537 538 539 540 541 542 543 544 545 546 547 548
  &sys_local_infile,
  &sys_log_binlog,
  &sys_log_off,
  &sys_log_update,
  &sys_log_warnings,
  &sys_long_query_time,
  &sys_low_priority_updates,
  &sys_max_allowed_packet,
  &sys_max_binlog_cache_size,
  &sys_max_binlog_size,
  &sys_max_connect_errors,
  &sys_max_connections,
  &sys_max_delayed_threads,
549
  &sys_max_error_count,
550
  &sys_max_insert_delayed_threads,
unknown's avatar
unknown committed
551 552
  &sys_max_heap_table_size,
  &sys_max_join_size,
unknown's avatar
unknown committed
553
  &sys_max_length_for_sort_data,
554
  &sys_max_relay_log_size,
555
  &sys_max_seeks_for_key,
unknown's avatar
unknown committed
556 557 558 559
  &sys_max_sort_length,
  &sys_max_tmp_tables,
  &sys_max_user_connections,
  &sys_max_write_lock_count,
unknown's avatar
unknown committed
560
  &sys_myisam_data_pointer_size,
unknown's avatar
unknown committed
561 562
  &sys_myisam_max_extra_sort_file_size,
  &sys_myisam_max_sort_file_size,
563
  &sys_myisam_repair_threads,
unknown's avatar
unknown committed
564 565 566
  &sys_myisam_sort_buffer_size,
  &sys_net_buffer_length,
  &sys_net_read_timeout,
567
  &sys_net_retry_count,
unknown's avatar
unknown committed
568 569
  &sys_net_wait_timeout,
  &sys_net_write_timeout,
570
  &sys_new_mode,
571
  &sys_old_passwords,
572 573
  &sys_optimizer_prune_level,
  &sys_optimizer_search_depth,
unknown's avatar
unknown committed
574
  &sys_preload_buff_size,
unknown's avatar
unknown committed
575
  &sys_pseudo_thread_id,
576
  &sys_query_alloc_block_size,
unknown's avatar
unknown committed
577
  &sys_query_cache_size,
578
  &sys_query_prealloc_size,
unknown's avatar
unknown committed
579 580
#ifdef HAVE_QUERY_CACHE
  &sys_query_cache_limit,
581
  &sys_query_cache_min_res_unit,
unknown's avatar
unknown committed
582
  &sys_query_cache_type,
583
  &sys_query_cache_wlock_invalidate,
584
#endif /* HAVE_QUERY_CACHE */
unknown's avatar
unknown committed
585
  &sys_quote_show_create,
586 587
  &sys_rand_seed1,
  &sys_rand_seed2,
588
  &sys_range_alloc_block_size,
589
  &sys_readonly,
unknown's avatar
unknown committed
590 591
  &sys_read_buff_size,
  &sys_read_rnd_buff_size,
592 593 594
#ifdef HAVE_REPLICATION
  &sys_relay_log_purge,
#endif
unknown's avatar
unknown committed
595 596
  &sys_rpl_recovery_rank,
  &sys_safe_updates,
597
  &sys_secure_auth,
unknown's avatar
unknown committed
598 599
  &sys_select_limit,
  &sys_server_id,
unknown's avatar
SCRUM  
unknown committed
600
#ifdef HAVE_REPLICATION
601
  &sys_slave_compressed_protocol,
unknown's avatar
unknown committed
602 603
  &sys_slave_net_timeout,
  &sys_slave_skip_counter,
604
#endif
unknown's avatar
unknown committed
605 606 607 608 609
  &sys_slow_launch_time,
  &sys_sort_buffer,
  &sys_sql_big_tables,
  &sys_sql_low_priority_updates,
  &sys_sql_max_join_size,
610
  &sys_sql_mode,
unknown's avatar
unknown committed
611
  &sys_sql_warnings,
unknown's avatar
unknown committed
612
  &sys_storage_engine,
613 614 615 616
#ifdef HAVE_REPLICATION
  &sys_sync_binlog_period,
#endif
  &sys_sync_frm,
unknown's avatar
unknown committed
617 618 619
  &sys_table_cache_size,
  &sys_table_type,
  &sys_thread_cache_size,
620
  &sys_time_format,
unknown's avatar
unknown committed
621
  &sys_timestamp,
622
  &sys_time_zone,
unknown's avatar
unknown committed
623
  &sys_tmp_table_size,
624 625
  &sys_trans_alloc_block_size,
  &sys_trans_prealloc_size,
unknown's avatar
unknown committed
626
  &sys_tx_isolation,
627
  &sys_os,
628 629
#ifdef HAVE_INNOBASE_DB
  &sys_innodb_max_dirty_pages_pct,
630
  &sys_innodb_max_purge_lag,
631
  &sys_innodb_table_locks,
632
  &sys_innodb_max_purge_lag,
633
  &sys_innodb_autoextend_increment,
634
#endif
635
  &sys_unique_checks,
636
  &sys_updatable_views_with_limit,
637
  &sys_warning_count
unknown's avatar
unknown committed
638 639 640 641 642 643 644 645
};


/*
  Variables shown by SHOW variables in alphabetical order
*/

struct show_var_st init_vars[]= {
646
  {"auto_increment_increment", (char*) &sys_auto_increment_increment, SHOW_SYS},
647
  {"auto_increment_offset",   (char*) &sys_auto_increment_offset, SHOW_SYS},
unknown's avatar
unknown committed
648 649 650 651 652
  {"back_log",                (char*) &back_log,                    SHOW_LONG},
  {"basedir",                 mysql_home,                           SHOW_CHAR},
#ifdef HAVE_BERKELEY_DB
  {"bdb_cache_size",          (char*) &berkeley_cache_size,         SHOW_LONG},
  {"bdb_home",                (char*) &berkeley_home,               SHOW_CHAR_PTR},
653
  {"bdb_log_buffer_size",     (char*) &berkeley_log_buffer_size,    SHOW_LONG},
unknown's avatar
unknown committed
654
  {"bdb_logdir",              (char*) &berkeley_logdir,             SHOW_CHAR_PTR},
655
  {"bdb_max_lock",            (char*) &berkeley_max_lock,	    SHOW_LONG},
unknown's avatar
unknown committed
656 657 658 659 660
  {"bdb_shared_data",	      (char*) &berkeley_shared_data,	    SHOW_BOOL},
  {"bdb_tmpdir",              (char*) &berkeley_tmpdir,             SHOW_CHAR_PTR},
#endif
  {sys_binlog_cache_size.name,(char*) &sys_binlog_cache_size,	    SHOW_SYS},
  {sys_bulk_insert_buff_size.name,(char*) &sys_bulk_insert_buff_size,SHOW_SYS},
661
  {sys_character_set_client.name,(char*) &sys_character_set_client, SHOW_SYS},
unknown's avatar
unknown committed
662
  {sys_character_set_connection.name,(char*) &sys_character_set_connection,SHOW_SYS},
663
  {sys_character_set_database.name, (char*) &sys_character_set_database,SHOW_SYS},
664
  {sys_character_set_results.name,(char*) &sys_character_set_results, SHOW_SYS},
665 666 667
  {sys_character_set_server.name, (char*) &sys_character_set_server,SHOW_SYS},
  {sys_charset_system.name,   (char*) &sys_charset_system,          SHOW_SYS},
  {"character_sets_dir",      mysql_charsets_dir,                   SHOW_CHAR},
unknown's avatar
unknown committed
668
  {sys_collation_connection.name,(char*) &sys_collation_connection, SHOW_SYS},
669 670
  {sys_collation_database.name,(char*) &sys_collation_database,     SHOW_SYS},
  {sys_collation_server.name,(char*) &sys_collation_server,         SHOW_SYS},
unknown's avatar
unknown committed
671 672 673
  {sys_concurrent_insert.name,(char*) &sys_concurrent_insert,       SHOW_SYS},
  {sys_connect_timeout.name,  (char*) &sys_connect_timeout,         SHOW_SYS},
  {"datadir",                 mysql_real_data_home,                 SHOW_CHAR},
674 675 676
  {sys_date_format.name,      (char*) &sys_date_format,		    SHOW_SYS},
  {sys_datetime_format.name,  (char*) &sys_datetime_format,	    SHOW_SYS},
  {sys_default_week_format.name, (char*) &sys_default_week_format,  SHOW_SYS},
unknown's avatar
unknown committed
677 678 679 680
  {sys_delay_key_write.name,  (char*) &sys_delay_key_write,         SHOW_SYS},
  {sys_delayed_insert_limit.name, (char*) &sys_delayed_insert_limit,SHOW_SYS},
  {sys_delayed_insert_timeout.name, (char*) &sys_delayed_insert_timeout, SHOW_SYS},
  {sys_delayed_queue_size.name,(char*) &sys_delayed_queue_size,     SHOW_SYS},
unknown's avatar
unknown committed
681
  {sys_expire_logs_days.name, (char*) &sys_expire_logs_days,        SHOW_SYS},
unknown's avatar
unknown committed
682 683
  {sys_flush.name,             (char*) &sys_flush,                  SHOW_SYS},
  {sys_flush_time.name,        (char*) &sys_flush_time,             SHOW_SYS},
684
  {sys_ft_boolean_syntax.name,(char*) &ft_boolean_syntax,	    SHOW_CHAR},
unknown's avatar
unknown committed
685
  {"ft_max_word_len",         (char*) &ft_max_word_len,             SHOW_LONG},
686
  {"ft_min_word_len",         (char*) &ft_min_word_len,             SHOW_LONG},
687
  {"ft_query_expansion_limit",(char*) &ft_query_expansion_limit,    SHOW_LONG},
688
  {"ft_stopword_file",        (char*) &ft_stopword_file,            SHOW_CHAR_PTR},
689
  {sys_group_concat_max_len.name, (char*) &sys_group_concat_max_len,  SHOW_SYS},
690
  {"have_archive",	      (char*) &have_archive_db,	            SHOW_HAVE},
unknown's avatar
unknown committed
691
  {"have_bdb",		      (char*) &have_berkeley_db,	    SHOW_HAVE},
unknown's avatar
unknown committed
692
  {"have_compress",	      (char*) &have_compress,		    SHOW_HAVE},
693
  {"have_crypt",	      (char*) &have_crypt,		    SHOW_HAVE},
694
  {"have_csv",	              (char*) &have_csv_db,	            SHOW_HAVE},
695
  {"have_example_engine",      (char*) &have_example_db,	            SHOW_HAVE},
unknown's avatar
unknown committed
696
  {"have_geometry",           (char*) &have_geometry,               SHOW_HAVE},
unknown's avatar
unknown committed
697
  {"have_innodb",	      (char*) &have_innodb,		    SHOW_HAVE},
698
  {"have_isam",		      (char*) &have_isam,		    SHOW_HAVE},
unknown's avatar
unknown committed
699
  {"have_ndbcluster",         (char*) &have_ndbcluster,             SHOW_HAVE},
unknown's avatar
unknown committed
700 701
  {"have_openssl",	      (char*) &have_openssl,		    SHOW_HAVE},
  {"have_query_cache",        (char*) &have_query_cache,            SHOW_HAVE},
702
  {"have_raid",		      (char*) &have_raid,		    SHOW_HAVE},
703
  {"have_rtree_keys",         (char*) &have_rtree_keys,             SHOW_HAVE},
704
  {"have_symlink",            (char*) &have_symlink,                SHOW_HAVE},
unknown's avatar
unknown committed
705
  {"init_connect",            (char*) &sys_init_connect,            SHOW_SYS},
706
  {"init_file",               (char*) &opt_init_file,               SHOW_CHAR_PTR},
unknown's avatar
unknown committed
707
  {"init_slave",              (char*) &sys_init_slave,              SHOW_SYS},
unknown's avatar
unknown committed
708 709
#ifdef HAVE_INNOBASE_DB
  {"innodb_additional_mem_pool_size", (char*) &innobase_additional_mem_pool_size, SHOW_LONG },
710
  {sys_innodb_autoextend_increment.name, (char*) &sys_innodb_autoextend_increment, SHOW_SYS},
unknown's avatar
unknown committed
711
  {"innodb_buffer_pool_awe_mem_mb", (char*) &innobase_buffer_pool_awe_mem_mb, SHOW_LONG },
712
  {"innodb_buffer_pool_size", (char*) &innobase_buffer_pool_size, SHOW_LONG },
unknown's avatar
unknown committed
713 714 715
  {"innodb_data_file_path", (char*) &innobase_data_file_path,	    SHOW_CHAR_PTR},
  {"innodb_data_home_dir",  (char*) &innobase_data_home_dir,	    SHOW_CHAR_PTR},
  {"innodb_fast_shutdown", (char*) &innobase_fast_shutdown, SHOW_MY_BOOL},
716
  {"innodb_file_io_threads", (char*) &innobase_file_io_threads, SHOW_LONG },
unknown's avatar
unknown committed
717
  {"innodb_file_per_table", (char*) &innobase_file_per_table, SHOW_MY_BOOL},
718
  {"innodb_locks_unsafe_for_binlog", (char*) &innobase_locks_unsafe_for_binlog, SHOW_MY_BOOL},
719
  {"innodb_flush_log_at_trx_commit", (char*) &innobase_flush_log_at_trx_commit, SHOW_INT},
unknown's avatar
unknown committed
720
  {"innodb_flush_method",    (char*) &innobase_unix_file_flush_method, SHOW_CHAR_PTR},
721
  {"innodb_force_recovery", (char*) &innobase_force_recovery, SHOW_LONG },
unknown's avatar
unknown committed
722 723 724 725 726 727 728
  {"innodb_lock_wait_timeout", (char*) &innobase_lock_wait_timeout, SHOW_LONG },
  {"innodb_log_arch_dir",   (char*) &innobase_log_arch_dir, 	    SHOW_CHAR_PTR},
  {"innodb_log_archive",    (char*) &innobase_log_archive, 	    SHOW_MY_BOOL},
  {"innodb_log_buffer_size", (char*) &innobase_log_buffer_size, SHOW_LONG },
  {"innodb_log_file_size", (char*) &innobase_log_file_size, SHOW_LONG},
  {"innodb_log_files_in_group", (char*) &innobase_log_files_in_group,	SHOW_LONG},
  {"innodb_log_group_home_dir", (char*) &innobase_log_group_home_dir, SHOW_CHAR_PTR},
729
  {sys_innodb_max_dirty_pages_pct.name, (char*) &sys_innodb_max_dirty_pages_pct, SHOW_SYS},
730
  {sys_innodb_max_purge_lag.name, (char*) &sys_innodb_max_purge_lag, SHOW_SYS},
731
  {sys_innodb_table_locks.name, (char*) &sys_innodb_table_locks, SHOW_SYS},
732
  {sys_innodb_max_purge_lag.name, (char*) &sys_innodb_max_purge_lag, SHOW_SYS},
733 734 735
  {"innodb_mirrored_log_groups", (char*) &innobase_mirrored_log_groups, SHOW_LONG},
  {"innodb_open_files", (char*) &innobase_open_files, SHOW_LONG },
  {"innodb_thread_concurrency", (char*) &innobase_thread_concurrency, SHOW_LONG },
unknown's avatar
unknown committed
736 737 738 739
#endif
  {sys_interactive_timeout.name,(char*) &sys_interactive_timeout,   SHOW_SYS},
  {sys_join_buffer_size.name,   (char*) &sys_join_buffer_size,	    SHOW_SYS},
  {sys_key_buffer_size.name,	(char*) &sys_key_buffer_size,	    SHOW_SYS},
740 741
  {sys_key_cache_age_threshold.name,   (char*) &sys_key_cache_age_threshold,
                                                                    SHOW_SYS},
unknown's avatar
unknown committed
742
  {sys_key_cache_block_size.name,   (char*) &sys_key_cache_block_size,
743
                                                                    SHOW_SYS},
744
  {sys_key_cache_division_limit.name,   (char*) &sys_key_cache_division_limit,
745
                                                                    SHOW_SYS},
unknown's avatar
unknown committed
746
  {"language",                language,                             SHOW_CHAR},
747 748
  {"large_files_support",     (char*) &opt_large_files,             SHOW_BOOL},
  {sys_license.name,	      (char*) &sys_license,                 SHOW_SYS},
unknown's avatar
unknown committed
749 750 751 752 753 754
  {sys_local_infile.name,     (char*) &sys_local_infile,	    SHOW_SYS},
#ifdef HAVE_MLOCKALL
  {"locked_in_memory",	      (char*) &locked_in_memory,	    SHOW_BOOL},
#endif
  {"log",                     (char*) &opt_log,                     SHOW_BOOL},
  {"log_bin",                 (char*) &opt_bin_log,                 SHOW_BOOL},
755
  {"log_error",               (char*) log_error_file,               SHOW_CHAR},
unknown's avatar
SCRUM  
unknown committed
756
#ifdef HAVE_REPLICATION
757
  {"log_slave_updates",       (char*) &opt_log_slave_updates,       SHOW_MY_BOOL},
758
#endif
unknown's avatar
unknown committed
759
  {"log_slow_queries",        (char*) &opt_slow_log,                SHOW_BOOL},
760
  {"log_update",              (char*) &opt_update_log,              SHOW_BOOL},
unknown's avatar
unknown committed
761 762 763
  {sys_log_warnings.name,     (char*) &sys_log_warnings,	    SHOW_SYS},
  {sys_long_query_time.name,  (char*) &sys_long_query_time, 	    SHOW_SYS},
  {sys_low_priority_updates.name, (char*) &sys_low_priority_updates, SHOW_SYS},
764
  {"lower_case_file_system",  (char*) &lower_case_file_system,      SHOW_MY_BOOL},
765
  {"lower_case_table_names",  (char*) &lower_case_table_names,      SHOW_INT},
unknown's avatar
unknown committed
766 767 768 769
  {sys_max_allowed_packet.name,(char*) &sys_max_allowed_packet,	    SHOW_SYS},
  {sys_max_binlog_cache_size.name,(char*) &sys_max_binlog_cache_size, SHOW_SYS},
  {sys_max_binlog_size.name,    (char*) &sys_max_binlog_size,	    SHOW_SYS},
  {sys_max_connect_errors.name, (char*) &sys_max_connect_errors,    SHOW_SYS},
770
  {sys_max_connections.name,    (char*) &sys_max_connections,	    SHOW_SYS},
unknown's avatar
unknown committed
771
  {sys_max_delayed_threads.name,(char*) &sys_max_delayed_threads,   SHOW_SYS},
772
  {sys_max_error_count.name,	(char*) &sys_max_error_count,	    SHOW_SYS},
unknown's avatar
unknown committed
773
  {sys_max_heap_table_size.name,(char*) &sys_max_heap_table_size,   SHOW_SYS},
774 775
  {sys_max_insert_delayed_threads.name,
   (char*) &sys_max_insert_delayed_threads,   SHOW_SYS},
unknown's avatar
unknown committed
776
  {sys_max_join_size.name,	(char*) &sys_max_join_size,	    SHOW_SYS},
unknown's avatar
unknown committed
777
  {sys_max_length_for_sort_data.name, (char*) &sys_max_length_for_sort_data,
unknown's avatar
unknown committed
778
   SHOW_SYS},
779 780
  {sys_max_relay_log_size.name, (char*) &sys_max_relay_log_size,    SHOW_SYS},
  {sys_max_seeks_for_key.name,  (char*) &sys_max_seeks_for_key,	    SHOW_SYS},
unknown's avatar
unknown committed
781
  {sys_max_sort_length.name,	(char*) &sys_max_sort_length,	    SHOW_SYS},
782
  {sys_max_tmp_tables.name,	(char*) &sys_max_tmp_tables,	    SHOW_SYS},
783
  {sys_max_user_connections.name,(char*) &sys_max_user_connections, SHOW_SYS},
unknown's avatar
unknown committed
784
  {sys_max_write_lock_count.name, (char*) &sys_max_write_lock_count,SHOW_SYS},
unknown's avatar
unknown committed
785
  {sys_myisam_data_pointer_size.name, (char*) &sys_myisam_data_pointer_size, SHOW_SYS},
unknown's avatar
unknown committed
786 787 788
  {sys_myisam_max_extra_sort_file_size.name,
   (char*) &sys_myisam_max_extra_sort_file_size,
   SHOW_SYS},
789 790
  {sys_myisam_max_sort_file_size.name, (char*) &sys_myisam_max_sort_file_size,
   SHOW_SYS},
791
  {"myisam_recover_options",  (char*) &myisam_recover_options_str,  SHOW_CHAR_PTR},
792
  {sys_myisam_repair_threads.name, (char*) &sys_myisam_repair_threads,
unknown's avatar
unknown committed
793 794 795
   SHOW_SYS},
  {sys_myisam_sort_buffer_size.name, (char*) &sys_myisam_sort_buffer_size, SHOW_SYS},
#ifdef __NT__
796
  {"named_pipe",	      (char*) &opt_enable_named_pipe,       SHOW_MY_BOOL},
unknown's avatar
unknown committed
797 798 799
#endif
  {sys_net_buffer_length.name,(char*) &sys_net_buffer_length,       SHOW_SYS},
  {sys_net_read_timeout.name, (char*) &sys_net_read_timeout,        SHOW_SYS},
800
  {sys_net_retry_count.name,  (char*) &sys_net_retry_count,	    SHOW_SYS},
unknown's avatar
unknown committed
801
  {sys_net_write_timeout.name,(char*) &sys_net_write_timeout,       SHOW_SYS},
802
  {sys_new_mode.name,         (char*) &sys_new_mode,                SHOW_SYS},
803
  {sys_old_passwords.name,    (char*) &sys_old_passwords,           SHOW_SYS},
unknown's avatar
unknown committed
804
  {"open_files_limit",	      (char*) &open_files_limit,	    SHOW_LONG},
805 806 807 808
  {sys_optimizer_prune_level.name, (char*) &sys_optimizer_prune_level,
   SHOW_SYS},
  {sys_optimizer_search_depth.name,(char*) &sys_optimizer_search_depth,
   SHOW_SYS},
unknown's avatar
unknown committed
809
  {"pid_file",                (char*) pidfile_name,                 SHOW_CHAR},
810
  {"port",                    (char*) &mysqld_port,                  SHOW_INT},
unknown's avatar
unknown committed
811
  {sys_preload_buff_size.name, (char*) &sys_preload_buff_size,      SHOW_SYS},
812
  {"protocol_version",        (char*) &protocol_version,            SHOW_INT},
813 814
  {sys_query_alloc_block_size.name, (char*) &sys_query_alloc_block_size,
   SHOW_SYS},
unknown's avatar
unknown committed
815
#ifdef HAVE_QUERY_CACHE
unknown's avatar
unknown committed
816
  {sys_query_cache_limit.name,(char*) &sys_query_cache_limit,	    SHOW_SYS},
817 818
  {sys_query_cache_min_res_unit.name, (char*) &sys_query_cache_min_res_unit,
   SHOW_SYS},
unknown's avatar
unknown committed
819 820
  {sys_query_cache_size.name, (char*) &sys_query_cache_size,	    SHOW_SYS},
  {sys_query_cache_type.name, (char*) &sys_query_cache_type,        SHOW_SYS},
unknown's avatar
unknown committed
821 822
  {sys_query_cache_wlock_invalidate.name,
   (char *) &sys_query_cache_wlock_invalidate, SHOW_SYS},
unknown's avatar
unknown committed
823
#endif /* HAVE_QUERY_CACHE */
824
  {sys_query_prealloc_size.name, (char*) &sys_query_prealloc_size,  SHOW_SYS},
825 826
  {sys_range_alloc_block_size.name, (char*) &sys_range_alloc_block_size,
   SHOW_SYS},
unknown's avatar
unknown committed
827 828 829
  {sys_read_buff_size.name,   (char*) &sys_read_buff_size,	    SHOW_SYS},
  {sys_readonly.name,         (char*) &sys_readonly,                SHOW_SYS},
  {sys_read_rnd_buff_size.name,(char*) &sys_read_rnd_buff_size,	    SHOW_SYS},
unknown's avatar
unknown committed
830 831 832
#ifdef HAVE_REPLICATION
  {sys_relay_log_purge.name,  (char*) &sys_relay_log_purge,         SHOW_SYS},
#endif
unknown's avatar
unknown committed
833
  {sys_rpl_recovery_rank.name,(char*) &sys_rpl_recovery_rank,       SHOW_SYS},
834
  {"secure_auth",             (char*) &sys_secure_auth,             SHOW_SYS},
835 836 837 838
#ifdef HAVE_SMEM
  {"shared_memory",           (char*) &opt_enable_shared_memory,    SHOW_MY_BOOL},
  {"shared_memory_base_name", (char*) &shared_memory_base_name,     SHOW_CHAR_PTR},
#endif
unknown's avatar
unknown committed
839
  {sys_server_id.name,	      (char*) &sys_server_id,		    SHOW_SYS},
840
  {"skip_external_locking",   (char*) &my_disable_locking,          SHOW_MY_BOOL},
unknown's avatar
unknown committed
841 842
  {"skip_networking",         (char*) &opt_disable_networking,      SHOW_BOOL},
  {"skip_show_database",      (char*) &opt_skip_show_db,            SHOW_BOOL},
843 844 845
#ifdef HAVE_REPLICATION
  {sys_slave_net_timeout.name,(char*) &sys_slave_net_timeout,	    SHOW_SYS},
#endif
unknown's avatar
unknown committed
846
  {sys_slow_launch_time.name, (char*) &sys_slow_launch_time,        SHOW_SYS},
847
#ifdef HAVE_SYS_UN_H
848
  {"socket",                  (char*) &mysqld_unix_port,             SHOW_CHAR_PTR},
849
#endif
unknown's avatar
unknown committed
850
  {sys_sort_buffer.name,      (char*) &sys_sort_buffer, 	    SHOW_SYS},
851
  {sys_sql_mode.name,         (char*) &sys_sql_mode,                SHOW_SYS},
unknown's avatar
unknown committed
852
  {sys_storage_engine.name,   (char*) &sys_storage_engine,          SHOW_SYS},
853 854 855 856
#ifdef HAVE_REPLICATION
  {sys_sync_binlog_period.name,(char*) &sys_sync_binlog_period,     SHOW_SYS},
#endif
  {sys_sync_frm.name,         (char*) &sys_sync_frm,               SHOW_SYS},
857 858 859
#ifdef HAVE_TZNAME
  {"system_time_zone",        system_time_zone,                     SHOW_CHAR},
#endif
unknown's avatar
unknown committed
860 861 862 863 864 865 866
  {"table_cache",             (char*) &table_cache_size,            SHOW_LONG},
  {sys_table_type.name,	      (char*) &sys_table_type,	            SHOW_SYS},
  {sys_thread_cache_size.name,(char*) &sys_thread_cache_size,       SHOW_SYS},
#ifdef HAVE_THR_SETCONCURRENCY
  {"thread_concurrency",      (char*) &concurrency,                 SHOW_LONG},
#endif
  {"thread_stack",            (char*) &thread_stack,                SHOW_LONG},
867
  {sys_time_format.name,      (char*) &sys_time_format,		    SHOW_SYS},
868
  {"time_zone",               (char*) &sys_time_zone,               SHOW_SYS},
unknown's avatar
unknown committed
869
  {sys_tmp_table_size.name,   (char*) &sys_tmp_table_size,	    SHOW_SYS},
unknown's avatar
unknown committed
870
  {"tmpdir",                  (char*) &opt_mysql_tmpdir,            SHOW_CHAR_PTR},
871 872 873
  {sys_trans_alloc_block_size.name, (char*) &sys_trans_alloc_block_size,
   SHOW_SYS},
  {sys_trans_prealloc_size.name, (char*) &sys_trans_prealloc_size,  SHOW_SYS},
874
  {sys_tx_isolation.name,     (char*) &sys_tx_isolation,	    SHOW_SYS},
875 876
  {sys_updatable_views_with_limit.name,
                              (char*) &sys_updatable_views_with_limit,SHOW_SYS},
unknown's avatar
unknown committed
877
  {"version",                 server_version,                       SHOW_CHAR},
878 879 880
#ifdef HAVE_BERKELEY_DB
  {"version_bdb",             (char*) DB_VERSION_STRING,            SHOW_CHAR},
#endif
881
  {"version_comment",         (char*) MYSQL_COMPILATION_COMMENT,    SHOW_CHAR},
882
  {"version_compile_machine", (char*) MACHINE_TYPE,		    SHOW_CHAR},
883
  {sys_os.name,		      (char*) &sys_os,			    SHOW_SYS},
unknown's avatar
unknown committed
884 885 886 887
  {sys_net_wait_timeout.name, (char*) &sys_net_wait_timeout,	    SHOW_SYS},
  {NullS, NullS, SHOW_LONG}
};

888

889 890 891 892 893 894
bool sys_var::check(THD *thd, set_var *var)
{
  var->save_result.ulonglong_value= var->value->val_int();
  return 0;
}

895 896 897 898 899 900 901
bool sys_var_str::check(THD *thd, set_var *var)
{
  int res;
  if (!check_func)
    return 0;

  if ((res=(*check_func)(thd, var)) < 0)
902 903
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0),
             name, var->value->str_value.ptr());
904 905 906
  return res;
}

unknown's avatar
unknown committed
907 908 909 910
/*
  Functions to check and update variables
*/

unknown's avatar
unknown committed
911

912 913 914 915 916 917 918 919 920 921
/*
  Update variables 'init_connect, init_slave'.

  In case of 'DEFAULT' value
  (for example: 'set GLOBAL init_connect=DEFAULT')
  'var' parameter is NULL pointer.
*/

bool update_sys_var_str(sys_var_str *var_str, rw_lock_t *var_mutex,
			set_var *var)
unknown's avatar
unknown committed
922
{
923 924 925 926
  char *res= 0, *old_value=(char *)(var ? var->value->str_value.ptr() : 0);
  uint new_length= (var ? var->value->str_value.length() : 0);
  if (!old_value)
    old_value= (char*) "";
927
  if (!(res= my_strdup_with_length((byte*)old_value, new_length, MYF(0))))
928
    return 1;
unknown's avatar
unknown committed
929 930 931 932
  /*
    Replace the old value in such a way that the any thread using
    the value will work.
  */
933 934 935 936 937
  rw_wrlock(var_mutex);
  old_value= var_str->value;
  var_str->value= res;
  var_str->value_length= new_length;
  rw_unlock(var_mutex);
unknown's avatar
unknown committed
938 939 940 941 942
  my_free(old_value, MYF(MY_ALLOW_ZERO_PTR));
  return 0;
}


943 944 945 946 947 948
static bool sys_update_init_connect(THD *thd, set_var *var)
{
  return update_sys_var_str(&sys_init_connect, &LOCK_sys_init_connect, var);
}


unknown's avatar
unknown committed
949 950
static void sys_default_init_connect(THD* thd, enum_var_type type)
{
951
  update_sys_var_str(&sys_init_connect, &LOCK_sys_init_connect, 0);
unknown's avatar
unknown committed
952 953 954 955 956
}


static bool sys_update_init_slave(THD *thd, set_var *var)
{
957
  return update_sys_var_str(&sys_init_slave, &LOCK_sys_init_slave, var);
unknown's avatar
unknown committed
958 959 960 961 962
}


static void sys_default_init_slave(THD* thd, enum_var_type type)
{
963
  update_sys_var_str(&sys_init_slave, &LOCK_sys_init_slave, 0);
unknown's avatar
unknown committed
964 965
}

966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986
static int sys_check_ftb_syntax(THD *thd,  set_var *var)
{
  if (thd->master_access & SUPER_ACL)
    return ft_boolean_check_syntax_string((byte*) var->value->str_value.c_ptr()) ?
      -1 : 0;
  else
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
}

static bool sys_update_ftb_syntax(THD *thd, set_var * var)
{
  strmake(ft_boolean_syntax, var->value->str_value.c_ptr(),
	  sizeof(ft_boolean_syntax)-1);
  return 0;
}

static void sys_default_ftb_syntax(THD *thd, enum_var_type type)
{
987
  strmake(ft_boolean_syntax, def_ft_boolean_syntax,
988 989
	  sizeof(ft_boolean_syntax)-1);
}
unknown's avatar
unknown committed
990

unknown's avatar
unknown committed
991 992 993 994 995
/*
  The following 3 functions need to be changed in 4.1 when we allow
  one to change character sets
*/

996
static int sys_check_charset(THD *thd, set_var *var)
unknown's avatar
unknown committed
997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025
{
  return 0;
}


static bool sys_update_charset(THD *thd, set_var *var)
{
  return 0;
}


static void sys_set_default_charset(THD *thd, enum_var_type type)
{
}


/*
  If one sets the LOW_PRIORIY UPDATES flag, we also must change the
  used lock type
*/

static void fix_low_priority_updates(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
    thd->update_lock_default= (thd->variables.low_priority_updates ?
			       TL_WRITE_LOW_PRIORITY : TL_WRITE);
}


1026 1027 1028 1029
static void
fix_myisam_max_extra_sort_file_size(THD *thd, enum_var_type type)
{
  myisam_max_extra_temp_length=
1030
    (my_off_t) global_system_variables.myisam_max_extra_sort_file_size;
1031 1032 1033 1034 1035 1036 1037 1038 1039 1040
}


static void
fix_myisam_max_sort_file_size(THD *thd, enum_var_type type)
{
  myisam_max_temp_length=
    (my_off_t) global_system_variables.myisam_max_sort_file_size;
}

unknown's avatar
unknown committed
1041 1042 1043 1044 1045 1046 1047 1048
/*
  Set the OPTION_BIG_SELECTS flag if max_join_size == HA_POS_ERROR
*/

static void fix_max_join_size(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
  {
1049
    if (thd->variables.max_join_size == HA_POS_ERROR)
unknown's avatar
unknown committed
1050 1051 1052 1053 1054
      thd->options|= OPTION_BIG_SELECTS;
    else
      thd->options&= ~OPTION_BIG_SELECTS;
  }
}
1055

unknown's avatar
unknown committed
1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073

/*
  If one doesn't use the SESSION modifier, the isolation level
  is only active for the next command
*/

static void fix_tx_isolation(THD *thd, enum_var_type type)
{
  if (type == OPT_SESSION)
    thd->session_tx_isolation= ((enum_tx_isolation)
				thd->variables.tx_isolation);
}


/*
  If we are changing the thread variable, we have to copy it to NET too
*/

unknown's avatar
SCRUM  
unknown committed
1074
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085 1086 1087
static void fix_net_read_timeout(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
    thd->net.read_timeout=thd->variables.net_read_timeout;
}


static void fix_net_write_timeout(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
    thd->net.write_timeout=thd->variables.net_write_timeout;
}

1088 1089 1090 1091 1092
static void fix_net_retry_count(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
    thd->net.retry_count=thd->variables.net_retry_count;
}
unknown's avatar
SCRUM  
unknown committed
1093 1094 1095
#else /* HAVE_REPLICATION */
static void fix_net_read_timeout(THD *thd __attribute__(unused),
				 enum_var_type type __attribute__(unused))
1096
{}
unknown's avatar
SCRUM  
unknown committed
1097 1098
static void fix_net_write_timeout(THD *thd __attribute__(unused),
				  enum_var_type type __attribute__(unused))
1099
{}
unknown's avatar
SCRUM  
unknown committed
1100 1101
static void fix_net_retry_count(THD *thd __attribute__(unused),
				enum_var_type type __attribute__(unused))
1102
{}
unknown's avatar
SCRUM  
unknown committed
1103
#endif /* HAVE_REPLICATION */
1104

unknown's avatar
unknown committed
1105 1106 1107 1108

static void fix_query_cache_size(THD *thd, enum_var_type type)
{
#ifdef HAVE_QUERY_CACHE
1109
  ulong requested= query_cache_size;
unknown's avatar
unknown committed
1110
  query_cache.resize(query_cache_size);
1111 1112 1113 1114
  if (requested != query_cache_size)
    push_warning_printf(current_thd, MYSQL_ERROR::WARN_LEVEL_WARN,
			ER_WARN_QC_RESIZE, ER(ER_WARN_QC_RESIZE),
			requested, query_cache_size);
unknown's avatar
unknown committed
1115 1116 1117 1118
#endif
}


1119 1120 1121 1122 1123 1124 1125 1126 1127
#ifdef HAVE_QUERY_CACHE
static void fix_query_cache_min_res_unit(THD *thd, enum_var_type type)
{
  query_cache_min_res_unit= 
    query_cache.set_min_res_unit(query_cache_min_res_unit);
}
#endif


1128
extern void fix_delay_key_write(THD *thd, enum_var_type type)
1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143
{
  switch ((enum_delay_key_write) delay_key_write_options) {
  case DELAY_KEY_WRITE_NONE:
    myisam_delay_key_write=0;
    break;
  case DELAY_KEY_WRITE_ON:
    myisam_delay_key_write=1;
    break;
  case DELAY_KEY_WRITE_ALL:
    myisam_delay_key_write=1;
    ha_open_options|= HA_OPEN_DELAY_KEY_WRITE;
    break;
  }
}

1144
static void fix_max_binlog_size(THD *thd, enum_var_type type)
1145 1146 1147 1148 1149
{
  DBUG_ENTER("fix_max_binlog_size");
  DBUG_PRINT("info",("max_binlog_size=%lu max_relay_log_size=%lu",
                     max_binlog_size, max_relay_log_size));
  mysql_bin_log.set_max_size(max_binlog_size);
1150
#ifdef HAVE_REPLICATION
1151 1152
  if (!max_relay_log_size)
    active_mi->rli.relay_log.set_max_size(max_binlog_size);
unknown's avatar
unknown committed
1153
#endif
1154 1155 1156
  DBUG_VOID_RETURN;
}

1157
static void fix_max_relay_log_size(THD *thd, enum_var_type type)
1158 1159 1160 1161
{
  DBUG_ENTER("fix_max_relay_log_size");
  DBUG_PRINT("info",("max_binlog_size=%lu max_relay_log_size=%lu",
                     max_binlog_size, max_relay_log_size));
1162
#ifdef HAVE_REPLICATION
1163 1164
  active_mi->rli.relay_log.set_max_size(max_relay_log_size ?
                                        max_relay_log_size: max_binlog_size);
1165
#endif
1166 1167
  DBUG_VOID_RETURN;
}
1168

1169

1170 1171
static int check_max_delayed_threads(THD *thd, set_var *var)
{
unknown's avatar
unknown committed
1172
  longlong val= var->value->val_int();
1173
  if (var->type != OPT_GLOBAL && val != 0 &&
unknown's avatar
unknown committed
1174
      val != (longlong) global_system_variables.max_insert_delayed_threads)
1175 1176
  {
    char buf[64];
1177
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), var->var->name, llstr(val, buf));
1178 1179 1180 1181 1182
    return 1;
  }
  return 0;
}

unknown's avatar
unknown committed
1183

1184
static void fix_max_connections(THD *thd, enum_var_type type)
1185
{
1186
#ifndef EMBEDDED_LIBRARY
1187 1188
  resize_thr_alarm(max_connections + 
		   global_system_variables.max_insert_delayed_threads + 10);
1189
#endif
1190 1191 1192 1193 1194 1195
}


static void fix_thd_mem_root(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
unknown's avatar
unknown committed
1196
    reset_root_defaults(thd->mem_root,
1197 1198 1199 1200 1201 1202 1203 1204 1205 1206 1207
                        thd->variables.query_alloc_block_size,
                        thd->variables.query_prealloc_size);
}


static void fix_trans_mem_root(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
    reset_root_defaults(&thd->transaction.mem_root,
                        thd->variables.trans_alloc_block_size,
                        thd->variables.trans_prealloc_size);
1208 1209
}

1210

1211 1212 1213 1214
static void fix_server_id(THD *thd, enum_var_type type)
{
  server_id_supplied = 1;
}
1215

1216

unknown's avatar
unknown committed
1217 1218
bool sys_var_long_ptr::update(THD *thd, set_var *var)
{
1219
  ulonglong tmp= var->save_result.ulonglong_value;
1220
  pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1221 1222 1223 1224
  if (option_limits)
    *value= (ulong) getopt_ull_limit_value(tmp, option_limits);
  else
    *value= (ulong) tmp;
1225
  pthread_mutex_unlock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1226 1227 1228 1229 1230 1231 1232 1233 1234 1235
  return 0;
}


void sys_var_long_ptr::set_default(THD *thd, enum_var_type type)
{
  *value= (ulong) option_limits->def_value;
}


1236 1237
bool sys_var_ulonglong_ptr::update(THD *thd, set_var *var)
{
1238
  ulonglong tmp= var->save_result.ulonglong_value;
1239
  pthread_mutex_lock(&LOCK_global_system_variables);
1240 1241 1242 1243
  if (option_limits)
    *value= (ulonglong) getopt_ull_limit_value(tmp, option_limits);
  else
    *value= (ulonglong) tmp;
1244
  pthread_mutex_unlock(&LOCK_global_system_variables);
1245 1246 1247 1248 1249 1250
  return 0;
}


void sys_var_ulonglong_ptr::set_default(THD *thd, enum_var_type type)
{
1251
  pthread_mutex_lock(&LOCK_global_system_variables);
1252
  *value= (ulonglong) option_limits->def_value;
1253
  pthread_mutex_unlock(&LOCK_global_system_variables);
1254 1255 1256
}


unknown's avatar
unknown committed
1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269
bool sys_var_bool_ptr::update(THD *thd, set_var *var)
{
  *value= (my_bool) var->save_result.ulong_value;
  return 0;
}


void sys_var_bool_ptr::set_default(THD *thd, enum_var_type type)
{
  *value= (my_bool) option_limits->def_value;
}


1270 1271 1272 1273 1274 1275 1276
bool sys_var_enum::update(THD *thd, set_var *var)
{
  *value= (uint) var->save_result.ulong_value;
  return 0;
}


1277
byte *sys_var_enum::value_ptr(THD *thd, enum_var_type type, LEX_STRING *base)
1278 1279 1280 1281
{
  return (byte*) enum_names->type_names[*value];
}

1282 1283 1284 1285 1286
bool sys_var_thd_ulong::check(THD *thd, set_var *var)
{
  return (sys_var_thd::check(thd, var) ||
          (check_func && (*check_func)(thd, var)));
}
1287

unknown's avatar
unknown committed
1288 1289
bool sys_var_thd_ulong::update(THD *thd, set_var *var)
{
1290
  ulonglong tmp= var->save_result.ulonglong_value;
unknown's avatar
unknown committed
1291 1292 1293 1294 1295 1296 1297 1298

  /* Don't use bigger value than given with --maximum-variable-name=.. */
  if ((ulong) tmp > max_system_variables.*offset)
    tmp= max_system_variables.*offset;

  if (option_limits)
    tmp= (ulong) getopt_ull_limit_value(tmp, option_limits);
  if (var->type == OPT_GLOBAL)
1299
    global_system_variables.*offset= (ulong) tmp;
unknown's avatar
unknown committed
1300 1301 1302 1303 1304 1305 1306 1307 1308 1309 1310 1311 1312 1313 1314 1315 1316 1317
  else
    thd->variables.*offset= (ulong) tmp;
  return 0;
}


void sys_var_thd_ulong::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
  {
    /* We will not come here if option_limits is not set */
    global_system_variables.*offset= (ulong) option_limits->def_value;
  }
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1318 1319
byte *sys_var_thd_ulong::value_ptr(THD *thd, enum_var_type type,
				   LEX_STRING *base)
unknown's avatar
unknown committed
1320 1321 1322 1323 1324 1325 1326
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}


1327 1328
bool sys_var_thd_ha_rows::update(THD *thd, set_var *var)
{
1329
  ulonglong tmp= var->save_result.ulonglong_value;
1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363

  /* Don't use bigger value than given with --maximum-variable-name=.. */
  if ((ha_rows) tmp > max_system_variables.*offset)
    tmp= max_system_variables.*offset;

  if (option_limits)
    tmp= (ha_rows) getopt_ull_limit_value(tmp, option_limits);
  if (var->type == OPT_GLOBAL)
  {
    /* Lock is needed to make things safe on 32 bit systems */
    pthread_mutex_lock(&LOCK_global_system_variables);    
    global_system_variables.*offset= (ha_rows) tmp;
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
  else
    thd->variables.*offset= (ha_rows) tmp;
  return 0;
}


void sys_var_thd_ha_rows::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
  {
    /* We will not come here if option_limits is not set */
    pthread_mutex_lock(&LOCK_global_system_variables);
    global_system_variables.*offset= (ha_rows) option_limits->def_value;
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1364 1365
byte *sys_var_thd_ha_rows::value_ptr(THD *thd, enum_var_type type,
				     LEX_STRING *base)
1366 1367 1368 1369 1370 1371
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}

unknown's avatar
unknown committed
1372 1373
bool sys_var_thd_ulonglong::update(THD *thd,  set_var *var)
{
1374
  ulonglong tmp= var->save_result.ulonglong_value;
1375

1376
  if (tmp > max_system_variables.*offset)
1377 1378 1379
    tmp= max_system_variables.*offset;

  if (option_limits)
1380
    tmp= getopt_ull_limit_value(tmp, option_limits);
unknown's avatar
unknown committed
1381
  if (var->type == OPT_GLOBAL)
1382 1383 1384
  {
    /* Lock is needed to make things safe on 32 bit systems */
    pthread_mutex_lock(&LOCK_global_system_variables);
1385
    global_system_variables.*offset= (ulonglong) tmp;
1386 1387
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
unknown's avatar
unknown committed
1388
  else
1389
    thd->variables.*offset= (ulonglong) tmp;
unknown's avatar
unknown committed
1390 1391 1392 1393 1394 1395 1396
  return 0;
}


void sys_var_thd_ulonglong::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
1397 1398
  {
    pthread_mutex_lock(&LOCK_global_system_variables);
1399
    global_system_variables.*offset= (ulonglong) option_limits->def_value;
1400 1401
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
unknown's avatar
unknown committed
1402 1403 1404 1405 1406
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1407 1408
byte *sys_var_thd_ulonglong::value_ptr(THD *thd, enum_var_type type,
				       LEX_STRING *base)
unknown's avatar
unknown committed
1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}


bool sys_var_thd_bool::update(THD *thd,  set_var *var)
{
  if (var->type == OPT_GLOBAL)
    global_system_variables.*offset= (my_bool) var->save_result.ulong_value;
  else
    thd->variables.*offset= (my_bool) var->save_result.ulong_value;
  return 0;
}


void sys_var_thd_bool::set_default(THD *thd,  enum_var_type type)
{
  if (type == OPT_GLOBAL)
    global_system_variables.*offset= (my_bool) option_limits->def_value;
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1435 1436
byte *sys_var_thd_bool::value_ptr(THD *thd, enum_var_type type,
				  LEX_STRING *base)
unknown's avatar
unknown committed
1437 1438 1439 1440 1441 1442 1443 1444 1445
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}


bool sys_var::check_enum(THD *thd, set_var *var, TYPELIB *enum_names)
{
1446 1447
  char buff[80];
  const char *value;
1448
  String str(buff, sizeof(buff), system_charset_info), *res;
unknown's avatar
unknown committed
1449 1450 1451 1452 1453

  if (var->value->result_type() == STRING_RESULT)
  {
    if (!(res=var->value->val_str(&str)) ||
	((long) (var->save_result.ulong_value=
1454 1455
		 (ulong) find_type(enum_names, res->ptr(),
				   res->length(),1)-1)) < 0)
unknown's avatar
unknown committed
1456
    {
1457
      value= res ? res->c_ptr() : "NULL";
unknown's avatar
unknown committed
1458 1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474
      goto err;
    }
  }
  else
  {
    ulonglong tmp=var->value->val_int();
    if (tmp >= enum_names->count)
    {
      llstr(tmp,buff);
      value=buff;				// Wrong value is here
      goto err;
    }
    var->save_result.ulong_value= (ulong) tmp;	// Save for update
  }
  return 0;

err:
1475
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, value);
unknown's avatar
unknown committed
1476 1477 1478
  return 1;
}

1479 1480 1481

bool sys_var::check_set(THD *thd, set_var *var, TYPELIB *enum_names)
{
1482
  bool not_used;
unknown's avatar
unknown committed
1483
  char buff[80], *error= 0;
1484 1485 1486 1487 1488 1489 1490
  uint error_len= 0;
  String str(buff, sizeof(buff), system_charset_info), *res;

  if (var->value->result_type() == STRING_RESULT)
  {
    if (!(res= var->value->val_str(&str)))
      goto err;
unknown's avatar
unknown committed
1491 1492
    var->save_result.ulong_value= ((ulong)
				   find_set(enum_names, res->c_ptr(),
1493 1494 1495
					    res->length(),
                                            NULL,
                                            &error, &error_len,
unknown's avatar
unknown committed
1496
					    &not_used));
1497 1498 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515
    if (error_len)
    {
      strmake(buff, error, min(sizeof(buff), error_len));
      goto err;
    }
  }
  else
  {
    ulonglong tmp= var->value->val_int();
    if (tmp >= enum_names->count)
    {
      llstr(tmp, buff);
      goto err;
    }
    var->save_result.ulong_value= (ulong) tmp;  // Save for update
  }
  return 0;

err:
1516
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, buff);
1517 1518 1519 1520
  return 1;
}


unknown's avatar
unknown committed
1521 1522 1523 1524 1525 1526 1527
/*
  Return an Item for a variable.  Used with @@[global.]variable_name

  If type is not given, return local value if exists, else global

  We have to use netprintf() instead of my_error() here as this is
  called on the parsing stage.
1528 1529 1530 1531

  TODO:
    With prepared statements/stored procedures this has to be fixed
    to create an item that gets the current value at fix_fields() stage.
unknown's avatar
unknown committed
1532 1533
*/

1534
Item *sys_var::item(THD *thd, enum_var_type var_type, LEX_STRING *base)
unknown's avatar
unknown committed
1535 1536 1537 1538 1539
{
  if (check_type(var_type))
  {
    if (var_type != OPT_DEFAULT)
    {
1540 1541
      my_error(ER_INCORRECT_GLOBAL_LOCAL_VAR, MYF(0),
               name, var_type == OPT_GLOBAL ? "SESSION" : "GLOBAL");
unknown's avatar
unknown committed
1542 1543 1544 1545 1546 1547 1548
      return 0;
    }
    /* As there was no local variable, return the global value */
    var_type= OPT_GLOBAL;
  }
  switch (type()) {
  case SHOW_LONG:
1549 1550 1551 1552 1553 1554 1555
  {
    ulong value;
    pthread_mutex_lock(&LOCK_global_system_variables);
    value= *(ulong*) value_ptr(thd, var_type, base);
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return new Item_uint((int32) value);
  }
unknown's avatar
unknown committed
1556
  case SHOW_LONGLONG:
1557 1558 1559
  {
    longlong value;
    pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1560
    value= *(longlong*) value_ptr(thd, var_type, base);
1561 1562 1563
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return new Item_int(value);
  }
1564
  case SHOW_HA_ROWS:
1565 1566 1567
  {
    ha_rows value;
    pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1568
    value= *(ha_rows*) value_ptr(thd, var_type, base);
1569 1570 1571
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return new Item_int((longlong) value);
  }
unknown's avatar
unknown committed
1572
  case SHOW_MY_BOOL:
1573
    return new Item_int((int32) *(my_bool*) value_ptr(thd, var_type, base),1);
unknown's avatar
unknown committed
1574 1575
  case SHOW_CHAR:
  {
1576 1577
    Item_string *tmp;
    pthread_mutex_lock(&LOCK_global_system_variables);
1578
    char *str= (char*) value_ptr(thd, var_type, base);
1579 1580 1581
    tmp= new Item_string(str, strlen(str), system_charset_info);
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return tmp;
unknown's avatar
unknown committed
1582 1583
  }
  default:
1584
    my_error(ER_VAR_CANT_BE_READ, MYF(0), name);
unknown's avatar
unknown committed
1585 1586 1587 1588 1589 1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608
  }
  return 0;
}


bool sys_var_thd_enum::update(THD *thd, set_var *var)
{
  if (var->type == OPT_GLOBAL)
    global_system_variables.*offset= var->save_result.ulong_value;
  else
    thd->variables.*offset= var->save_result.ulong_value;
  return 0;
}


void sys_var_thd_enum::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
    global_system_variables.*offset= (ulong) option_limits->def_value;
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1609 1610
byte *sys_var_thd_enum::value_ptr(THD *thd, enum_var_type type,
				  LEX_STRING *base)
unknown's avatar
unknown committed
1611 1612 1613 1614 1615 1616 1617
{
  ulong tmp= ((type == OPT_GLOBAL) ?
	      global_system_variables.*offset :
	      thd->variables.*offset);
  return (byte*) enum_names->type_names[tmp];
}

1618 1619 1620 1621 1622
bool sys_var_thd_bit::check(THD *thd, set_var *var)
{
  return (check_enum(thd, var, &bool_typelib) ||
          (check_func && (*check_func)(thd, var)));
}
unknown's avatar
unknown committed
1623 1624 1625

bool sys_var_thd_bit::update(THD *thd, set_var *var)
{
1626
  int res= (*update_func)(thd, var);
unknown's avatar
unknown committed
1627 1628 1629 1630
  return res;
}


1631 1632
byte *sys_var_thd_bit::value_ptr(THD *thd, enum_var_type type,
				 LEX_STRING *base)
unknown's avatar
unknown committed
1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643
{
  /*
    If reverse is 0 (default) return 1 if bit is set.
    If reverse is 1, return 0 if bit is set
  */
  thd->sys_var_tmp.my_bool_value= ((thd->options & bit_flag) ?
				   !reverse : reverse);
  return (byte*) &thd->sys_var_tmp.my_bool_value;
}


1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695
/* Update a date_time format variable based on given value */

void sys_var_thd_date_time_format::update2(THD *thd, enum_var_type type,
					   DATE_TIME_FORMAT *new_value)
{
  DATE_TIME_FORMAT *old;
  DBUG_ENTER("sys_var_date_time_format::update2");
  DBUG_DUMP("positions",(char*) new_value->positions,
	    sizeof(new_value->positions));

  if (type == OPT_GLOBAL)
  {
    pthread_mutex_lock(&LOCK_global_system_variables);
    old= (global_system_variables.*offset);
    (global_system_variables.*offset)= new_value;
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
  else
  {
    old= (thd->variables.*offset);
    (thd->variables.*offset)= new_value;
  }
  my_free((char*) old, MYF(MY_ALLOW_ZERO_PTR));
  DBUG_VOID_RETURN;
}


bool sys_var_thd_date_time_format::update(THD *thd, set_var *var)
{
  DATE_TIME_FORMAT *new_value;
  /* We must make a copy of the last value to get it into normal memory */
  new_value= date_time_format_copy((THD*) 0,
				   var->save_result.date_time_format);
  if (!new_value)
    return 1;					// Out of memory
  update2(thd, var->type, new_value);		// Can't fail
  return 0;
}


bool sys_var_thd_date_time_format::check(THD *thd, set_var *var)
{
  char buff[80];
  String str(buff,sizeof(buff), system_charset_info), *res;
  DATE_TIME_FORMAT *format;

  if (!(res=var->value->val_str(&str)))
    res= &my_empty_string;

  if (!(format= date_time_format_make(date_time_type,
				      res->ptr(), res->length())))
  {
1696
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, res->c_ptr());
1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723 1724 1725 1726 1727 1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 1747 1748 1749
    return 1;
  }
  
  /*
    We must copy result to thread space to not get a memory leak if
    update is aborted
  */
  var->save_result.date_time_format= date_time_format_copy(thd, format);
  my_free((char*) format, MYF(0));
  return var->save_result.date_time_format == 0;
}


void sys_var_thd_date_time_format::set_default(THD *thd, enum_var_type type)
{
  DATE_TIME_FORMAT *res= 0;

  if (type == OPT_GLOBAL)
  {
    const char *format;
    if ((format= opt_date_time_formats[date_time_type]))
      res= date_time_format_make(date_time_type, format, strlen(format));
  }
  else
  {
    /* Make copy with malloc */
    res= date_time_format_copy((THD *) 0, global_system_variables.*offset);
  }

  if (res)					// Should always be true
    update2(thd, type, res);
}


byte *sys_var_thd_date_time_format::value_ptr(THD *thd, enum_var_type type,
					      LEX_STRING *base)
{
  if (type == OPT_GLOBAL)
  {
    char *res;
    /*
      We do a copy here just to be sure things will work even if someone
      is modifying the original string while the copy is accessed
      (Can't happen now in SQL SHOW, but this is a good safety for the future)
    */
    res= thd->strmake((global_system_variables.*offset)->format.str,
		      (global_system_variables.*offset)->format.length);
    return (byte*) res;
  }
  return (byte*) (thd->variables.*offset)->format.str;
}


1750 1751
typedef struct old_names_map_st
{
unknown's avatar
unknown committed
1752 1753 1754
  const char *old_name;
  const char *new_name;
} my_old_conv;
unknown's avatar
unknown committed
1755

unknown's avatar
unknown committed
1756 1757
static my_old_conv old_conv[]= 
{
1758 1759 1760 1761 1762 1763 1764 1765 1766 1767 1768
  {	"cp1251_koi8"		,	"cp1251"	},
  {	"cp1250_latin2"		,	"cp1250"	},
  {	"kam_latin2"		,	"keybcs2"	},
  {	"mac_latin2"		,	"MacRoman"	},
  {	"macce_latin2"		,	"MacCE"		},
  {	"pc2_latin2"		,	"pclatin2"	},
  {	"vga_latin2"		,	"pclatin1"	},
  {	"koi8_cp1251"		,	"koi8r"		},
  {	"win1251ukr_koi8_ukr"	,	"win1251ukr"	},
  {	"koi8_ukr_win1251ukr"	,	"koi8u"		},
  {	NULL			,	NULL		}
unknown's avatar
unknown committed
1769
};
unknown's avatar
unknown committed
1770

unknown's avatar
unknown committed
1771
CHARSET_INFO *get_old_charset_by_name(const char *name)
unknown's avatar
unknown committed
1772
{
unknown's avatar
unknown committed
1773
  my_old_conv *conv;
unknown's avatar
unknown committed
1774
 
unknown's avatar
unknown committed
1775
  for (conv= old_conv; conv->old_name; conv++)
1776
  {
unknown's avatar
unknown committed
1777 1778
    if (!my_strcasecmp(&my_charset_latin1, name, conv->old_name))
      return get_charset_by_csname(conv->new_name, MY_CS_PRIMARY, MYF(0));
1779
  }
unknown's avatar
unknown committed
1780
  return NULL;
unknown's avatar
unknown committed
1781 1782
}

unknown's avatar
unknown committed
1783

1784
bool sys_var_collation::check(THD *thd, set_var *var)
unknown's avatar
unknown committed
1785 1786 1787
{
  CHARSET_INFO *tmp;

1788
  if (var->value->result_type() == STRING_RESULT)
1789
  {
1790 1791 1792 1793
    char buff[80];
    String str(buff,sizeof(buff), system_charset_info), *res;
    if (!(res=var->value->val_str(&str)))
    {
1794
      my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, "NULL");
1795 1796 1797 1798
      return 1;
    }
    if (!(tmp=get_charset_by_name(res->c_ptr(),MYF(0))))
    {
1799
      my_error(ER_UNKNOWN_COLLATION, MYF(0), res->c_ptr());
1800 1801
      return 1;
    }
1802
  }
1803
  else // INT_RESULT
1804
  {
1805
    if (!(tmp=get_charset((int) var->value->val_int(),MYF(0))))
1806 1807
    {
      char buf[20];
1808
      int10_to_str((int) var->value->val_int(), buf, -10);
1809
      my_error(ER_UNKNOWN_COLLATION, MYF(0), buf);
1810 1811
      return 1;
    }
1812 1813 1814 1815 1816
  }
  var->save_result.charset= tmp;	// Save for update
  return 0;
}

1817

1818 1819 1820 1821
bool sys_var_character_set::check(THD *thd, set_var *var)
{
  CHARSET_INFO *tmp;

1822 1823 1824 1825 1826
  if (var->value->result_type() == STRING_RESULT)
  {
    char buff[80];
    String str(buff,sizeof(buff), system_charset_info), *res;
    if (!(res=var->value->val_str(&str)))
1827
    {
1828 1829
      if (!nullable)
      {
1830
        my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, "NULL");
1831 1832 1833 1834 1835 1836 1837
        return 1;
      }
      tmp= NULL;
    }
    else if (!(tmp=get_charset_by_csname(res->c_ptr(),MY_CS_PRIMARY,MYF(0))) &&
             !(tmp=get_old_charset_by_name(res->c_ptr())))
    {
1838
      my_error(ER_UNKNOWN_CHARACTER_SET, MYF(0), res->c_ptr());
1839 1840 1841
      return 1;
    }
  }
1842
  else // INT_RESULT
unknown's avatar
unknown committed
1843
  {
1844
    if (!(tmp=get_charset((int) var->value->val_int(),MYF(0))))
1845 1846
    {
      char buf[20];
1847
      int10_to_str((int) var->value->val_int(), buf, -10);
1848 1849 1850
      my_error(ER_UNKNOWN_CHARACTER_SET, MYF(0), buf);
      return 1;
    }
unknown's avatar
unknown committed
1851 1852 1853 1854 1855
  }
  var->save_result.charset= tmp;	// Save for update
  return 0;
}

1856

1857
bool sys_var_character_set::update(THD *thd, set_var *var)
unknown's avatar
unknown committed
1858
{
1859
  ci_ptr(thd,var->type)[0]= var->save_result.charset;
unknown's avatar
unknown committed
1860
  thd->update_charset();
unknown's avatar
unknown committed
1861 1862 1863
  return 0;
}

1864 1865 1866

byte *sys_var_character_set::value_ptr(THD *thd, enum_var_type type,
				       LEX_STRING *base)
unknown's avatar
unknown committed
1867
{
1868
  CHARSET_INFO *cs= ci_ptr(thd,type)[0];
1869
  return cs ? (byte*) cs->csname : (byte*) "NULL";
unknown's avatar
unknown committed
1870 1871
}

1872

1873 1874
CHARSET_INFO ** sys_var_character_set_connection::ci_ptr(THD *thd,
							 enum_var_type type)
unknown's avatar
unknown committed
1875 1876 1877 1878 1879 1880 1881
{
  if (type == OPT_GLOBAL)
    return &global_system_variables.collation_connection;
  else
    return &thd->variables.collation_connection;
}

1882 1883 1884

void sys_var_character_set_connection::set_default(THD *thd,
						   enum_var_type type)
unknown's avatar
unknown committed
1885 1886 1887 1888
{
 if (type == OPT_GLOBAL)
   global_system_variables.collation_connection= default_charset_info;
 else
unknown's avatar
unknown committed
1889
 {
unknown's avatar
unknown committed
1890
   thd->variables.collation_connection= global_system_variables.collation_connection;
unknown's avatar
unknown committed
1891 1892
   thd->update_charset();
 }
unknown's avatar
unknown committed
1893 1894
}

1895

1896 1897
CHARSET_INFO ** sys_var_character_set_client::ci_ptr(THD *thd,
						     enum_var_type type)
1898 1899 1900 1901 1902 1903 1904
{
  if (type == OPT_GLOBAL)
    return &global_system_variables.character_set_client;
  else
    return &thd->variables.character_set_client;
}

1905

1906
void sys_var_character_set_client::set_default(THD *thd, enum_var_type type)
1907 1908
{
 if (type == OPT_GLOBAL)
1909
   global_system_variables.character_set_client= default_charset_info;
1910
 else
unknown's avatar
unknown committed
1911 1912 1913 1914 1915
 {
   thd->variables.character_set_client= (global_system_variables.
					 character_set_client);
   thd->update_charset();
 }
1916
}
unknown's avatar
unknown committed
1917

1918

unknown's avatar
unknown committed
1919 1920
CHARSET_INFO **
sys_var_character_set_results::ci_ptr(THD *thd, enum_var_type type)
1921
{
1922 1923
  if (type == OPT_GLOBAL)
    return &global_system_variables.character_set_results;
1924
  else
1925
    return &thd->variables.character_set_results;
1926 1927
}

1928

1929
void sys_var_character_set_results::set_default(THD *thd, enum_var_type type)
1930
{
1931
 if (type == OPT_GLOBAL)
1932
   global_system_variables.character_set_results= default_charset_info;
1933
 else
unknown's avatar
unknown committed
1934 1935 1936 1937 1938
 {
   thd->variables.character_set_results= (global_system_variables.
					  character_set_results);
   thd->update_charset();
 }
1939 1940
}

1941

unknown's avatar
unknown committed
1942 1943
CHARSET_INFO **
sys_var_character_set_server::ci_ptr(THD *thd, enum_var_type type)
1944 1945
{
  if (type == OPT_GLOBAL)
1946
    return &global_system_variables.collation_server;
1947
  else
1948
    return &thd->variables.collation_server;
1949 1950
}

1951

1952
void sys_var_character_set_server::set_default(THD *thd, enum_var_type type)
1953 1954
{
 if (type == OPT_GLOBAL)
1955
   global_system_variables.collation_server= default_charset_info;
1956
 else
unknown's avatar
unknown committed
1957
 {
1958
   thd->variables.collation_server= global_system_variables.collation_server;
unknown's avatar
unknown committed
1959 1960
   thd->update_charset();
 }
1961 1962
}

1963
#if defined(HAVE_REPLICATION)
1964 1965 1966 1967 1968 1969
bool sys_var_character_set_server::check(THD *thd, set_var *var)
{
  if ((var->type == OPT_GLOBAL) &&
      (mysql_bin_log.is_open() ||
       active_mi->slave_running || active_mi->rli.slave_running))
  {
unknown's avatar
unknown committed
1970 1971
    my_error(ER_LOGING_PROHIBIT_CHANGING_OF, MYF(0),
	     "character set, collation");
1972 1973 1974 1975 1976
    return 1;
  }
  return sys_var_character_set::check(thd,var);
}
#endif
1977 1978 1979

CHARSET_INFO ** sys_var_character_set_database::ci_ptr(THD *thd,
						       enum_var_type type)
1980 1981
{
  if (type == OPT_GLOBAL)
1982
    return &global_system_variables.collation_database;
1983
  else
1984
    return &thd->variables.collation_database;
1985 1986
}

1987

1988 1989 1990
void sys_var_character_set_database::set_default(THD *thd, enum_var_type type)
{
 if (type == OPT_GLOBAL)
1991
    global_system_variables.collation_database= default_charset_info;
1992
  else
unknown's avatar
unknown committed
1993
  {
1994
    thd->variables.collation_database= thd->db_charset;
unknown's avatar
unknown committed
1995 1996
    thd->update_charset();
  }
1997 1998
}

1999

2000
bool sys_var_collation_connection::update(THD *thd, set_var *var)
2001 2002
{
  if (var->type == OPT_GLOBAL)
2003
    global_system_variables.collation_connection= var->save_result.charset;
2004
  else
unknown's avatar
unknown committed
2005
  {
2006
    thd->variables.collation_connection= var->save_result.charset;
unknown's avatar
unknown committed
2007 2008
    thd->update_charset();
  }
2009 2010 2011
  return 0;
}

2012 2013 2014

byte *sys_var_collation_connection::value_ptr(THD *thd, enum_var_type type,
					      LEX_STRING *base)
2015 2016
{
  CHARSET_INFO *cs= ((type == OPT_GLOBAL) ?
2017 2018 2019
		  global_system_variables.collation_connection :
		  thd->variables.collation_connection);
  return cs ? (byte*) cs->name : (byte*) "NULL";
2020 2021
}

2022

2023
void sys_var_collation_connection::set_default(THD *thd, enum_var_type type)
2024 2025
{
 if (type == OPT_GLOBAL)
2026
   global_system_variables.collation_connection= default_charset_info;
2027
 else
unknown's avatar
unknown committed
2028 2029 2030 2031 2032
 {
   thd->variables.collation_connection= (global_system_variables.
					 collation_connection);
   thd->update_charset();
 }
2033 2034
}

2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069
bool sys_var_collation_database::update(THD *thd, set_var *var)
{
  if (var->type == OPT_GLOBAL)
    global_system_variables.collation_database= var->save_result.charset;
  else
  {
    thd->variables.collation_database= var->save_result.charset;
    thd->update_charset();
  }
  return 0;
}


byte *sys_var_collation_database::value_ptr(THD *thd, enum_var_type type,
					      LEX_STRING *base)
{
  CHARSET_INFO *cs= ((type == OPT_GLOBAL) ?
		  global_system_variables.collation_database :
		  thd->variables.collation_database);
  return cs ? (byte*) cs->name : (byte*) "NULL";
}


void sys_var_collation_database::set_default(THD *thd, enum_var_type type)
{
 if (type == OPT_GLOBAL)
   global_system_variables.collation_database= default_charset_info;
 else
 {
   thd->variables.collation_database= (global_system_variables.
					 collation_database);
   thd->update_charset();
 }
}

2070
#if defined(HAVE_REPLICATION)
2071 2072 2073 2074 2075 2076
bool sys_var_collation_server::check(THD *thd, set_var *var)
{
  if ((var->type == OPT_GLOBAL) &&
      (mysql_bin_log.is_open() ||
       active_mi->slave_running || active_mi->rli.slave_running))
  {
unknown's avatar
unknown committed
2077 2078
    my_error(ER_LOGING_PROHIBIT_CHANGING_OF, MYF(0),
	     "character set, collation");
2079 2080 2081 2082 2083
    return 1;
  }
  return sys_var_collation::check(thd,var);
}
#endif
2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119

bool sys_var_collation_server::update(THD *thd, set_var *var)
{
  if (var->type == OPT_GLOBAL)
    global_system_variables.collation_server= var->save_result.charset;
  else
  {
    thd->variables.collation_server= var->save_result.charset;
    thd->update_charset();
  }
  return 0;
}


byte *sys_var_collation_server::value_ptr(THD *thd, enum_var_type type,
					      LEX_STRING *base)
{
  CHARSET_INFO *cs= ((type == OPT_GLOBAL) ?
		  global_system_variables.collation_server :
		  thd->variables.collation_server);
  return cs ? (byte*) cs->name : (byte*) "NULL";
}


void sys_var_collation_server::set_default(THD *thd, enum_var_type type)
{
 if (type == OPT_GLOBAL)
   global_system_variables.collation_server= default_charset_info;
 else
 {
   thd->variables.collation_server= (global_system_variables.
					 collation_server);
   thd->update_charset();
 }
}

2120

2121
LEX_STRING default_key_cache_base= {(char *) "default", 7 };
unknown's avatar
unknown committed
2122

unknown's avatar
unknown committed
2123
static KEY_CACHE zero_key_cache;
unknown's avatar
unknown committed
2124

unknown's avatar
unknown committed
2125
KEY_CACHE *get_key_cache(LEX_STRING *cache_name)
unknown's avatar
unknown committed
2126
{
2127 2128
  safe_mutex_assert_owner(&LOCK_global_system_variables);
  if (!cache_name || ! cache_name->length)
unknown's avatar
unknown committed
2129
    cache_name= &default_key_cache_base;
unknown's avatar
unknown committed
2130
  return ((KEY_CACHE*) find_named(&key_caches,
2131
                                      cache_name->str, cache_name->length, 0));
unknown's avatar
unknown committed
2132 2133
}

2134

unknown's avatar
unknown committed
2135 2136
byte *sys_var_key_cache_param::value_ptr(THD *thd, enum_var_type type,
					 LEX_STRING *base)
2137
{
unknown's avatar
unknown committed
2138
  KEY_CACHE *key_cache= get_key_cache(base);
unknown's avatar
unknown committed
2139 2140 2141 2142
  if (!key_cache)
    key_cache= &zero_key_cache;
  return (byte*) key_cache + offset ;
}
2143

2144

2145 2146
bool sys_var_key_buffer_size::update(THD *thd, set_var *var)
{
2147
  ulonglong tmp= var->save_result.ulonglong_value;
unknown's avatar
unknown committed
2148
  LEX_STRING *base_name= &var->base;
unknown's avatar
unknown committed
2149
  KEY_CACHE *key_cache;
2150 2151 2152
  bool error= 0;

  /* If no basename, assume it's for the key cache named 'default' */
unknown's avatar
unknown committed
2153
  if (!base_name->length)
2154
    base_name= &default_key_cache_base;
2155 2156 2157

  pthread_mutex_lock(&LOCK_global_system_variables);
  key_cache= get_key_cache(base_name);
unknown's avatar
unknown committed
2158
                            
2159 2160
  if (!key_cache)
  {
2161
    /* Key cache didn't exists */
2162
    if (!tmp)					// Tried to delete cache
2163 2164 2165 2166 2167 2168
      goto end;					// Ok, nothing to do
    if (!(key_cache= create_key_cache(base_name->str, base_name->length)))
    {
      error= 1;
      goto end;
    }
2169
  }
2170 2171 2172 2173 2174 2175 2176 2177 2178

  /*
    Abort if some other thread is changing the key cache
    TODO: This should be changed so that we wait until the previous
    assignment is done and then do the new assign
  */
  if (key_cache->in_init)
    goto end;

unknown's avatar
unknown committed
2179
  if (!tmp)					// Zero size means delete
2180
  {
2181 2182 2183
    if (key_cache == sql_key_cache)
      goto end;					// Ignore default key cache

unknown's avatar
unknown committed
2184
    if (key_cache->key_cache_inited)		// If initied
2185 2186
    {
      /*
2187 2188
	Move tables using this key cache to the default key cache
	and clear the old key cache.
2189
      */
2190
      NAMED_LIST *list; 
unknown's avatar
unknown committed
2191
      key_cache= (KEY_CACHE *) find_named(&key_caches, base_name->str,
2192
					      base_name->length, &list);
2193 2194 2195 2196 2197
      key_cache->in_init= 1;
      pthread_mutex_unlock(&LOCK_global_system_variables);
      error= reassign_keycache_tables(thd, key_cache, sql_key_cache);
      pthread_mutex_lock(&LOCK_global_system_variables);
      key_cache->in_init= 0;
2198
    }
2199 2200 2201 2202 2203
    /*
      We don't delete the key cache as some running threads my still be
      in the key cache code with a pointer to the deleted (empty) key cache
    */
    goto end;
2204 2205
  }

unknown's avatar
unknown committed
2206 2207
  key_cache->param_buff_size=
    (ulonglong) getopt_ull_limit_value(tmp, option_limits);
2208

2209 2210 2211 2212
  /* If key cache didn't existed initialize it, else resize it */
  key_cache->in_init= 1;
  pthread_mutex_unlock(&LOCK_global_system_variables);

unknown's avatar
unknown committed
2213
  if (!key_cache->key_cache_inited)
2214
    error= (bool) (ha_init_key_cache("", key_cache));
unknown's avatar
unknown committed
2215
  else
2216
    error= (bool)(ha_resize_key_cache(key_cache));
2217

2218 2219
  pthread_mutex_lock(&LOCK_global_system_variables);
  key_cache->in_init= 0;  
2220

2221 2222 2223
end:
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return error;
2224 2225
}

2226 2227

bool sys_var_key_cache_long::update(THD *thd, set_var *var)
2228
{
unknown's avatar
unknown committed
2229
  ulong tmp= (ulong) var->value->val_int();
2230
  LEX_STRING *base_name= &var->base;
2231 2232
  bool error= 0;

2233
  if (!base_name->length)
unknown's avatar
unknown committed
2234
    base_name= &default_key_cache_base;
2235 2236

  pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
2237
  KEY_CACHE *key_cache= get_key_cache(base_name);
2238

unknown's avatar
unknown committed
2239 2240
  if (!key_cache && !(key_cache= create_key_cache(base_name->str,
				                  base_name->length)))
2241 2242 2243 2244
  {
    error= 1;
    goto end;
  }
2245

2246 2247 2248 2249 2250 2251 2252 2253 2254
  /*
    Abort if some other thread is changing the key cache
    TODO: This should be changed so that we wait until the previous
    assignment is done and then do the new assign
  */
  if (key_cache->in_init)
    goto end;

  *((ulong*) (((char*) key_cache) + offset))=
2255
    (ulong) getopt_ull_limit_value(tmp, option_limits);
unknown's avatar
unknown committed
2256

2257 2258 2259 2260 2261
  /*
    Don't create a new key cache if it didn't exist
    (key_caches are created only when the user sets block_size)
  */
  key_cache->in_init= 1;
2262

2263
  pthread_mutex_unlock(&LOCK_global_system_variables);
2264

2265 2266 2267 2268 2269 2270 2271 2272
  error= (bool) (ha_resize_key_cache(key_cache));

  pthread_mutex_lock(&LOCK_global_system_variables);
  key_cache->in_init= 0;  

end:
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return error;
2273 2274
}

2275

2276 2277 2278 2279
/*****************************************************************************
  Functions to handle SET NAMES and SET CHARACTER SET
*****************************************************************************/

unknown's avatar
unknown committed
2280
int set_var_collation_client::check(THD *thd)
2281 2282 2283 2284
{
  return 0;
}

unknown's avatar
unknown committed
2285
int set_var_collation_client::update(THD *thd)
2286
{
2287 2288
  thd->variables.character_set_client= character_set_client;
  thd->variables.character_set_results= character_set_results;
unknown's avatar
unknown committed
2289
  thd->variables.collation_connection= collation_connection;
unknown's avatar
unknown committed
2290
  thd->update_charset();
2291 2292 2293 2294 2295 2296 2297
  thd->protocol_simple.init(thd);
  thd->protocol_prep.init(thd);
  return 0;
}

/****************************************************************************/

unknown's avatar
unknown committed
2298 2299
bool sys_var_timestamp::update(THD *thd,  set_var *var)
{
2300
  thd->set_time((time_t) var->save_result.ulonglong_value);
unknown's avatar
unknown committed
2301 2302 2303 2304 2305 2306 2307 2308 2309 2310
  return 0;
}


void sys_var_timestamp::set_default(THD *thd, enum_var_type type)
{
  thd->user_time=0;
}


2311 2312
byte *sys_var_timestamp::value_ptr(THD *thd, enum_var_type type,
				   LEX_STRING *base)
unknown's avatar
unknown committed
2313 2314 2315 2316 2317 2318 2319 2320
{
  thd->sys_var_tmp.long_value= (long) thd->start_time;
  return (byte*) &thd->sys_var_tmp.long_value;
}


bool sys_var_last_insert_id::update(THD *thd, set_var *var)
{
2321
  thd->insert_id(var->save_result.ulonglong_value);
unknown's avatar
unknown committed
2322 2323 2324 2325
  return 0;
}


2326 2327
byte *sys_var_last_insert_id::value_ptr(THD *thd, enum_var_type type,
					LEX_STRING *base)
unknown's avatar
unknown committed
2328 2329 2330 2331 2332 2333 2334 2335
{
  thd->sys_var_tmp.long_value= (long) thd->insert_id();
  return (byte*) &thd->last_insert_id;
}


bool sys_var_insert_id::update(THD *thd, set_var *var)
{
2336
  thd->next_insert_id= var->save_result.ulonglong_value;
unknown's avatar
unknown committed
2337 2338 2339 2340
  return 0;
}


2341 2342
byte *sys_var_insert_id::value_ptr(THD *thd, enum_var_type type,
				   LEX_STRING *base)
unknown's avatar
unknown committed
2343 2344 2345 2346 2347
{
  return (byte*) &thd->current_insert_id;
}


unknown's avatar
SCRUM  
unknown committed
2348
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
2349 2350
bool sys_var_slave_skip_counter::check(THD *thd, set_var *var)
{
2351
  int result= 0;
2352
  pthread_mutex_lock(&LOCK_active_mi);
unknown's avatar
unknown committed
2353 2354 2355
  pthread_mutex_lock(&active_mi->rli.run_lock);
  if (active_mi->rli.slave_running)
  {
unknown's avatar
unknown committed
2356
    my_message(ER_SLAVE_MUST_STOP, ER(ER_SLAVE_MUST_STOP), MYF(0));
unknown's avatar
unknown committed
2357 2358 2359
    result=1;
  }
  pthread_mutex_unlock(&active_mi->rli.run_lock);
2360
  pthread_mutex_unlock(&LOCK_active_mi);
2361
  var->save_result.ulong_value= (ulong) var->value->val_int();
unknown's avatar
unknown committed
2362 2363 2364 2365 2366 2367
  return result;
}


bool sys_var_slave_skip_counter::update(THD *thd, set_var *var)
{
2368
  pthread_mutex_lock(&LOCK_active_mi);
unknown's avatar
unknown committed
2369 2370 2371 2372 2373 2374 2375 2376 2377
  pthread_mutex_lock(&active_mi->rli.run_lock);
  /*
    The following test should normally never be true as we test this
    in the check function;  To be safe against multiple
    SQL_SLAVE_SKIP_COUNTER request, we do the check anyway
  */
  if (!active_mi->rli.slave_running)
  {
    pthread_mutex_lock(&active_mi->rli.data_lock);
2378
    active_mi->rli.slave_skip_counter= var->save_result.ulong_value;
unknown's avatar
unknown committed
2379 2380 2381
    pthread_mutex_unlock(&active_mi->rli.data_lock);
  }
  pthread_mutex_unlock(&active_mi->rli.run_lock);
2382
  pthread_mutex_unlock(&LOCK_active_mi);
unknown's avatar
unknown committed
2383 2384
  return 0;
}
2385 2386 2387 2388 2389


bool sys_var_sync_binlog_period::update(THD *thd, set_var *var)
{
  pthread_mutex_t *lock_log= mysql_bin_log.get_log_lock();
2390
  sync_binlog_period= (ulong) var->save_result.ulonglong_value;
2391 2392 2393 2394 2395 2396 2397 2398 2399
  /*
    Must reset the counter otherwise it may already be beyond the new period
    and so the new period will not be taken into account. Need mutex otherwise
    might be cancelled by a simultanate ++ in MYSQL_LOG::write().
  */
  pthread_mutex_lock(lock_log);
  sync_binlog_counter= 0;
  pthread_mutex_unlock(lock_log);
  return 0;
unknown's avatar
unknown committed
2400
}
unknown's avatar
SCRUM  
unknown committed
2401
#endif /* HAVE_REPLICATION */
unknown's avatar
unknown committed
2402

2403 2404
bool sys_var_rand_seed1::update(THD *thd, set_var *var)
{
2405
  thd->rand.seed1= (ulong) var->save_result.ulonglong_value;
2406 2407 2408 2409 2410
  return 0;
}

bool sys_var_rand_seed2::update(THD *thd, set_var *var)
{
2411
  thd->rand.seed2= (ulong) var->save_result.ulonglong_value;
2412 2413 2414 2415
  return 0;
}


2416 2417 2418 2419 2420 2421
bool sys_var_thd_time_zone::check(THD *thd, set_var *var)
{
  char buff[MAX_TIME_ZONE_NAME_LENGTH]; 
  String str(buff, sizeof(buff), &my_charset_latin1);
  String *res= var->value->val_str(&str);

2422
#if defined(HAVE_REPLICATION)
2423 2424 2425 2426
  if ((var->type == OPT_GLOBAL) &&
      (mysql_bin_log.is_open() ||
       active_mi->slave_running || active_mi->rli.slave_running))
  {
unknown's avatar
unknown committed
2427
    my_error(ER_LOGING_PROHIBIT_CHANGING_OF, MYF(0), "time zone");
2428 2429 2430
    return 1;
  }
#endif
2431 2432

  if (!(var->save_result.time_zone=
2433
        my_tz_find(res, thd->lex->time_zone_tables_used)))
2434
  {
2435
    my_error(ER_UNKNOWN_TIME_ZONE, MYF(0), res ? res->c_ptr() : "NULL");
2436 2437 2438 2439 2440 2441 2442 2443 2444 2445 2446 2447 2448 2449 2450 2451 2452 2453 2454 2455 2456 2457 2458 2459 2460 2461 2462 2463 2464 2465 2466 2467 2468 2469 2470 2471 2472 2473 2474 2475 2476 2477
    return 1;
  }
  return 0;
}


bool sys_var_thd_time_zone::update(THD *thd, set_var *var)
{
  /* We are using Time_zone object found during check() phase */ 
  *get_tz_ptr(thd,var->type)= var->save_result.time_zone;
  return 0;
}


byte *sys_var_thd_time_zone::value_ptr(THD *thd, enum_var_type type,
				       LEX_STRING *base)
{
  /* 
    We can use ptr() instead of c_ptr() here because String contaning
    time zone name is guaranteed to be zero ended.
  */
  return (byte *)((*get_tz_ptr(thd,type))->get_name()->ptr());
}


Time_zone** sys_var_thd_time_zone::get_tz_ptr(THD *thd, 
                                              enum_var_type type)
{
  if (type == OPT_GLOBAL)
    return &global_system_variables.time_zone;
  else
    return &thd->variables.time_zone;
}


void sys_var_thd_time_zone::set_default(THD *thd, enum_var_type type)
{
 if (type == OPT_GLOBAL)
 {
   if (default_tz_name)
   {
     String str(default_tz_name, &my_charset_latin1);
2478 2479
     global_system_variables.time_zone=
       my_tz_find(&str, thd->lex->time_zone_tables_used);
2480 2481 2482 2483 2484 2485 2486 2487
   }
   else
     global_system_variables.time_zone= my_tz_SYSTEM;
 }
 else
   thd->variables.time_zone= global_system_variables.time_zone;
}

unknown's avatar
unknown committed
2488 2489 2490 2491 2492 2493
/*
  Functions to update thd->options bits
*/

static bool set_option_bit(THD *thd, set_var *var)
{
2494 2495 2496
  sys_var_thd_bit *sys_var= ((sys_var_thd_bit*) var->var);
  if ((var->save_result.ulong_value != 0) == sys_var->reverse)
    thd->options&= ~sys_var->bit_flag;
unknown's avatar
unknown committed
2497
  else
2498
    thd->options|= sys_var->bit_flag;
unknown's avatar
unknown committed
2499 2500 2501 2502 2503 2504 2505 2506 2507 2508 2509 2510 2511 2512 2513 2514 2515 2516 2517 2518 2519 2520 2521 2522 2523 2524 2525 2526 2527 2528 2529 2530 2531 2532
  return 0;
}


static bool set_option_autocommit(THD *thd, set_var *var)
{
  /* The test is negative as the flag we use is NOT autocommit */

  ulong org_options=thd->options;

  if (var->save_result.ulong_value != 0)
    thd->options&= ~((sys_var_thd_bit*) var->var)->bit_flag;
  else
    thd->options|= ((sys_var_thd_bit*) var->var)->bit_flag;

  if ((org_options ^ thd->options) & OPTION_NOT_AUTOCOMMIT)
  {
    if ((org_options & OPTION_NOT_AUTOCOMMIT))
    {
      /* We changed to auto_commit mode */
      thd->options&= ~(ulong) (OPTION_BEGIN | OPTION_STATUS_NO_TRANS_UPDATE);
      thd->server_status|= SERVER_STATUS_AUTOCOMMIT;
      if (ha_commit(thd))
	return 1;
    }
    else
    {
      thd->options&= ~(ulong) (OPTION_STATUS_NO_TRANS_UPDATE);
      thd->server_status&= ~SERVER_STATUS_AUTOCOMMIT;
    }
  }
  return 0;
}

2533 2534 2535 2536 2537 2538 2539 2540 2541 2542 2543
static int check_log_update(THD *thd, set_var *var)
{
#ifndef NO_EMBEDDED_ACCESS_CHECKS
  if (!(thd->master_access & SUPER_ACL))
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
#endif
  return 0;
}
unknown's avatar
unknown committed
2544 2545 2546

static bool set_log_update(THD *thd, set_var *var)
{
2547 2548 2549 2550 2551 2552
  /*
    The update log is not supported anymore since 5.0.
    See sql/mysqld.cc/, comments in function init_server_components() for an
    explaination of the different warnings we send below
  */
    
unknown's avatar
unknown committed
2553
  if (opt_sql_bin_update)
2554
  {
unknown's avatar
unknown committed
2555 2556
    ((sys_var_thd_bit*) var->var)->bit_flag|= (OPTION_BIN_LOG |
					       OPTION_UPDATE_LOG);
2557 2558 2559 2560 2561 2562 2563 2564
    push_warning(thd, MYSQL_ERROR::WARN_LEVEL_NOTE,
                 ER_UPDATE_LOG_DEPRECATED_TRANSLATED,
                 ER(ER_UPDATE_LOG_DEPRECATED_TRANSLATED));
  }
  else
    push_warning(thd, MYSQL_ERROR::WARN_LEVEL_NOTE,
                 ER_UPDATE_LOG_DEPRECATED_IGNORED,
                 ER(ER_UPDATE_LOG_DEPRECATED_IGNORED));
unknown's avatar
unknown committed
2565 2566 2567 2568
  set_option_bit(thd, var);
  return 0;
}

2569
static bool set_log_bin(THD *thd, set_var *var)
unknown's avatar
unknown committed
2570 2571 2572 2573 2574 2575 2576 2577
{
  if (opt_sql_bin_update)
    ((sys_var_thd_bit*) var->var)->bit_flag|= (OPTION_BIN_LOG |
					       OPTION_UPDATE_LOG);
  set_option_bit(thd, var);
  return 0;
}

2578 2579 2580 2581 2582 2583 2584 2585 2586 2587 2588 2589 2590 2591 2592
static int check_pseudo_thread_id(THD *thd, set_var *var)
{
  var->save_result.ulonglong_value= var->value->val_int();
#ifndef NO_EMBEDDED_ACCESS_CHECKS
  if (thd->master_access & SUPER_ACL)
    return 0;
  else
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
#else
  return 0;
#endif
}
2593

2594 2595 2596 2597 2598 2599 2600 2601 2602 2603 2604 2605 2606 2607 2608
static byte *get_warning_count(THD *thd)
{
  thd->sys_var_tmp.long_value=
    (thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_NOTE] +
     thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_WARN]);
  return (byte*) &thd->sys_var_tmp.long_value;
}

static byte *get_error_count(THD *thd)
{
  thd->sys_var_tmp.long_value= 
    thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_ERROR];
  return (byte*) &thd->sys_var_tmp.long_value;
}

unknown's avatar
unknown committed
2609 2610 2611 2612 2613 2614 2615 2616 2617 2618 2619 2620 2621 2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639 2640 2641 2642 2643 2644 2645 2646 2647 2648 2649 2650 2651 2652 2653 2654 2655 2656 2657 2658 2659 2660 2661 2662 2663 2664 2665 2666 2667

/****************************************************************************
  Main handling of variables:
  - Initialisation
  - Searching during parsing
  - Update loop
****************************************************************************/

/*
  Find variable name in option my_getopt structure used for command line args

  SYNOPSIS
    find_option()
    opt		option structure array to search in
    name	variable name

  RETURN VALUES
    0		Error
    ptr		pointer to option structure
*/

static struct my_option *find_option(struct my_option *opt, const char *name) 
{
  uint length=strlen(name);
  for (; opt->name; opt++)
  {
    if (!getopt_compare_strings(opt->name, name, length) &&
	!opt->name[length])
    {
      /*
	Only accept the option if one can set values through it.
	If not, there is no default value or limits in the option.
      */
      return (opt->value) ? opt : 0;
    }
  }
  return 0;
}


/*
  Return variable name and length for hashing of variables
*/

static byte *get_sys_var_length(const sys_var *var, uint *length,
				my_bool first)
{
  *length= var->name_length;
  return (byte*) var->name;
}


/*
  Initialises sys variables and put them in system_variable_hash
*/


void set_var_init()
{
2668 2669
  hash_init(&system_variable_hash, system_charset_info,
	    array_elements(sys_variables),0,0,
unknown's avatar
unknown committed
2670
	    (hash_get_key) get_sys_var_length,0,0);
unknown's avatar
unknown committed
2671 2672 2673 2674 2675 2676 2677
  sys_var **var, **end;
  for (var= sys_variables, end= sys_variables+array_elements(sys_variables) ;
       var < end;
       var++)
  {
    (*var)->name_length= strlen((*var)->name);
    (*var)->option_limits= find_option(my_long_options, (*var)->name);
unknown's avatar
SCRUM  
unknown committed
2678
    my_hash_insert(&system_variable_hash, (byte*) *var);
unknown's avatar
unknown committed
2679 2680 2681 2682 2683 2684 2685 2686 2687 2688 2689 2690 2691 2692 2693 2694 2695 2696 2697 2698 2699 2700 2701 2702 2703 2704 2705 2706 2707 2708 2709
  }
  /*
    Special cases
    Needed because MySQL can't find the limits for a variable it it has
    a different name than the command line option.
    As these variables are deprecated, this code will disappear soon...
  */
  sys_sql_max_join_size.option_limits= sys_max_join_size.option_limits;
}


void set_var_free()
{
  hash_free(&system_variable_hash);
}


/*
  Find a user set-table variable

  SYNOPSIS
    find_sys_var()
    str		Name of system variable to find
    length	Length of variable.  zero means that we should use strlen()
		on the variable

  RETURN VALUES
    pointer	pointer to variable definitions
    0		Unknown variable (error message is given)
*/

2710
sys_var *find_sys_var(const char *str, uint length)
unknown's avatar
unknown committed
2711
{
unknown's avatar
unknown committed
2712 2713
  sys_var *var= (sys_var*) hash_search(&system_variable_hash,
				       (byte*) str,
unknown's avatar
unknown committed
2714 2715 2716
				       length ? length :
				       strlen(str));
  if (!var)
2717
    my_error(ER_UNKNOWN_SYSTEM_VARIABLE, MYF(0), (char*) str);
unknown's avatar
unknown committed
2718 2719 2720 2721 2722 2723 2724 2725 2726 2727 2728 2729 2730 2731 2732 2733 2734 2735 2736 2737 2738 2739
  return var;
}


/*
  Execute update of all variables

  SYNOPSIS

  sql_set
    THD		Thread id
    set_var	List of variables to update

  DESCRIPTION
    First run a check of all variables that all updates will go ok.
    If yes, then execute all updates, returning an error if any one failed.

    This should ensure that in all normal cases none all or variables are
    updated

    RETURN VALUE
    0	ok
2740 2741
    1	ERROR, message sent (normally no variables was updated)
    -1  ERROR, message not sent
unknown's avatar
unknown committed
2742 2743
*/

2744
int sql_set_variables(THD *thd, List<set_var_base> *var_list)
unknown's avatar
unknown committed
2745
{
2746
  int error= 0;
unknown's avatar
unknown committed
2747
  List_iterator_fast<set_var_base> it(*var_list);
unknown's avatar
unknown committed
2748
  DBUG_ENTER("sql_set_variables");
unknown's avatar
unknown committed
2749 2750 2751 2752

  set_var_base *var;
  while ((var=it++))
  {
2753
    if ((error=var->check(thd)))
unknown's avatar
unknown committed
2754
      DBUG_RETURN(error);
unknown's avatar
unknown committed
2755
  }
2756 2757
  if (thd->net.report_error)
    DBUG_RETURN(1);
unknown's avatar
unknown committed
2758 2759
  it.rewind();
  while ((var=it++))
2760
    error|= var->update(thd);			// Returns 0, -1 or 1
unknown's avatar
unknown committed
2761
  DBUG_RETURN(error);
unknown's avatar
unknown committed
2762 2763 2764
}


2765 2766 2767 2768 2769 2770 2771 2772 2773 2774 2775 2776 2777 2778 2779 2780 2781 2782 2783 2784 2785 2786 2787 2788 2789 2790 2791 2792 2793 2794
/*
  Say if all variables set by a SET support the ONE_SHOT keyword (currently,
  only character set and collation do; later timezones will).

  SYNOPSIS

  not_all_support_one_shot
    set_var	List of variables to update

  NOTES
    It has a "not_" because it makes faster tests (no need to "!")

    RETURN VALUE
    0	all variables of the list support ONE_SHOT
    1	at least one does not support ONE_SHOT
*/

bool not_all_support_one_shot(List<set_var_base> *var_list)
{
  List_iterator_fast<set_var_base> it(*var_list);
  set_var_base *var;
  while ((var= it++))
  {
    if (var->no_support_one_shot())
      return 1;
  }
  return 0;
}


unknown's avatar
unknown committed
2795 2796 2797 2798
/*****************************************************************************
  Functions to handle SET mysql_internal_variable=const_expr
*****************************************************************************/

2799
int set_var::check(THD *thd)
unknown's avatar
unknown committed
2800 2801 2802
{
  if (var->check_type(type))
  {
unknown's avatar
unknown committed
2803
    int err= type == OPT_GLOBAL ? ER_LOCAL_VARIABLE : ER_GLOBAL_VARIABLE;
2804
    my_error(err, MYF(0), var->name);
2805
    return -1;
unknown's avatar
unknown committed
2806 2807 2808 2809 2810 2811 2812 2813
  }
  if ((type == OPT_GLOBAL && check_global_access(thd, SUPER_ACL)))
    return 1;
  /* value is a NULL pointer if we are using SET ... = DEFAULT */
  if (!value)
  {
    if (var->check_default(type))
    {
2814
      my_error(ER_NO_DEFAULT, MYF(0), var->name);
2815
      return -1;
unknown's avatar
unknown committed
2816 2817 2818 2819
    }
    return 0;
  }

unknown's avatar
unknown committed
2820
  if (value->fix_fields(thd, 0, &value) || value->check_cols(1))
2821
    return -1;
unknown's avatar
unknown committed
2822 2823
  if (var->check_update_type(value->result_type()))
  {
2824
    my_error(ER_WRONG_TYPE_FOR_VAR, MYF(0), var->name);
2825
    return -1;
2826
  }
2827
  return var->check(thd, this) ? -1 : 0;
unknown's avatar
unknown committed
2828 2829 2830
}


unknown's avatar
unknown committed
2831 2832 2833 2834 2835 2836 2837 2838 2839 2840 2841 2842
/*
  Check variable, but without assigning value (used by PS)

  SYNOPSIS
    set_var::light_check()
    thd		thread handler

  RETURN VALUE
    0	ok
    1	ERROR, message sent (normally no variables was updated)
    -1  ERROR, message not sent
*/
2843 2844 2845 2846
int set_var::light_check(THD *thd)
{
  if (var->check_type(type))
  {
unknown's avatar
unknown committed
2847
    int err= type == OPT_GLOBAL ? ER_LOCAL_VARIABLE : ER_GLOBAL_VARIABLE;
2848
    my_error(err, MYF(0), var->name);
2849 2850
    return -1;
  }
unknown's avatar
unknown committed
2851
  if (type == OPT_GLOBAL && check_global_access(thd, SUPER_ACL))
2852 2853 2854 2855 2856 2857 2858 2859
    return 1;

  if (value && (value->fix_fields(thd, 0, &value) || value->check_cols(1)))
    return -1;
  return 0;
}


2860
int set_var::update(THD *thd)
unknown's avatar
unknown committed
2861 2862 2863 2864
{
  if (!value)
    var->set_default(thd, type);
  else if (var->update(thd, this))
2865
    return -1;				// should never happen
unknown's avatar
unknown committed
2866 2867 2868 2869 2870 2871 2872 2873 2874 2875
  if (var->after_update)
    (*var->after_update)(thd, type);
  return 0;
}


/*****************************************************************************
  Functions to handle SET @user_variable=const_expr
*****************************************************************************/

2876
int set_var_user::check(THD *thd)
unknown's avatar
unknown committed
2877
{
unknown's avatar
unknown committed
2878 2879
  /*
    Item_func_set_user_var can't substitute something else on its place =>
2880
    0 can be passed as last argument (reference on item)
unknown's avatar
unknown committed
2881 2882
  */
  return (user_var_item->fix_fields(thd, 0, (Item**) 0) ||
2883
	  user_var_item->check()) ? -1 : 0;
unknown's avatar
unknown committed
2884 2885 2886
}


unknown's avatar
unknown committed
2887 2888 2889 2890 2891 2892 2893 2894 2895 2896 2897 2898
/*
  Check variable, but without assigning value (used by PS)

  SYNOPSIS
    set_var_user::light_check()
    thd		thread handler

  RETURN VALUE
    0	ok
    1	ERROR, message sent (normally no variables was updated)
    -1  ERROR, message not sent
*/
2899 2900 2901 2902 2903 2904 2905 2906 2907 2908
int set_var_user::light_check(THD *thd)
{
  /*
    Item_func_set_user_var can't substitute something else on its place =>
    0 can be passed as last argument (reference on item)
  */
  return (user_var_item->fix_fields(thd, 0, (Item**) 0));
}


2909
int set_var_user::update(THD *thd)
unknown's avatar
unknown committed
2910 2911 2912 2913
{
  if (user_var_item->update())
  {
    /* Give an error if it's not given already */
unknown's avatar
unknown committed
2914
    my_message(ER_SET_CONSTANTS_ONLY, ER(ER_SET_CONSTANTS_ONLY), MYF(0));
2915
    return -1;
unknown's avatar
unknown committed
2916 2917 2918 2919 2920 2921 2922 2923 2924
  }
  return 0;
}


/*****************************************************************************
  Functions to handle SET PASSWORD
*****************************************************************************/

2925
int set_var_password::check(THD *thd)
unknown's avatar
unknown committed
2926
{
unknown's avatar
unknown committed
2927
#ifndef NO_EMBEDDED_ACCESS_CHECKS
unknown's avatar
unknown committed
2928 2929
  if (!user->host.str)
    user->host.str= (char*) thd->host_or_ip;
2930
  /* Returns 1 as the function sends error to client */
2931 2932 2933
  return check_change_password(thd, user->host.str, user->user.str, password) ?
         1 : 0;
#else
unknown's avatar
unknown committed
2934 2935
  return 0;
#endif
unknown's avatar
unknown committed
2936 2937
}

2938
int set_var_password::update(THD *thd)
unknown's avatar
unknown committed
2939
{
unknown's avatar
unknown committed
2940
#ifndef NO_EMBEDDED_ACCESS_CHECKS
2941
  /* Returns 1 as the function sends error to client */
2942 2943
  return change_password(thd, user->host.str, user->user.str, password) ?
	  1 : 0;
unknown's avatar
unknown committed
2944 2945 2946
#else
  return 0;
#endif
unknown's avatar
unknown committed
2947 2948
}

2949 2950 2951 2952
/****************************************************************************
 Functions to handle table_type
****************************************************************************/

unknown's avatar
unknown committed
2953 2954
/* Based upon sys_var::check_enum() */

unknown's avatar
unknown committed
2955
bool sys_var_thd_storage_engine::check(THD *thd, set_var *var)
2956 2957 2958 2959 2960 2961 2962 2963 2964 2965 2966 2967 2968 2969 2970 2971
{
  char buff[80];
  const char *value;
  String str(buff, sizeof(buff), &my_charset_latin1), *res;

  if (var->value->result_type() == STRING_RESULT)
  {
    if (!(res=var->value->val_str(&str)) ||
	!(var->save_result.ulong_value=
	 (ulong) ha_resolve_by_name(res->ptr(), res->length())))
    {
      value= res ? res->c_ptr() : "NULL";
      goto err;
    }
    return 0;
  }
unknown's avatar
unknown committed
2972
  value= "unknown";
2973 2974

err:
2975
  my_error(ER_UNKNOWN_STORAGE_ENGINE, MYF(0), value);
unknown's avatar
unknown committed
2976
  return 1;
2977 2978
}

unknown's avatar
unknown committed
2979

unknown's avatar
unknown committed
2980 2981
byte *sys_var_thd_storage_engine::value_ptr(THD *thd, enum_var_type type,
					    LEX_STRING *base)
2982 2983 2984 2985
{
  ulong val;
  val= ((type == OPT_GLOBAL) ? global_system_variables.*offset :
        thd->variables.*offset);
unknown's avatar
unknown committed
2986
  const char *table_type= ha_get_storage_engine((enum db_type)val);
unknown's avatar
unknown committed
2987
  return (byte *) table_type;
2988 2989
}

unknown's avatar
unknown committed
2990

unknown's avatar
unknown committed
2991
void sys_var_thd_storage_engine::set_default(THD *thd, enum_var_type type)
2992 2993 2994 2995 2996 2997 2998
{
  if (type == OPT_GLOBAL)
    global_system_variables.*offset= (ulong) DB_TYPE_MYISAM;
  else
    thd->variables.*offset= (ulong) (global_system_variables.*offset);
}

unknown's avatar
unknown committed
2999

unknown's avatar
unknown committed
3000
bool sys_var_thd_storage_engine::update(THD *thd, set_var *var)
3001 3002 3003 3004 3005 3006 3007 3008
{
  if (var->type == OPT_GLOBAL)
    global_system_variables.*offset= var->save_result.ulong_value;
  else
    thd->variables.*offset= var->save_result.ulong_value;
  return 0;
}

unknown's avatar
unknown committed
3009 3010 3011 3012
void sys_var_thd_table_type::warn_deprecated(THD *thd)
{
  push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_WARN,
		      ER_WARN_DEPRECATED_SYNTAX,
3013 3014
		      ER(ER_WARN_DEPRECATED_SYNTAX), "table_type",
                      "storage_engine"); 
unknown's avatar
unknown committed
3015 3016 3017 3018 3019 3020 3021 3022 3023 3024 3025 3026 3027 3028
}

void sys_var_thd_table_type::set_default(THD *thd, enum_var_type type)
{
  warn_deprecated(thd);
  sys_var_thd_storage_engine::set_default(thd, type);
}

bool sys_var_thd_table_type::update(THD *thd, set_var *var)
{
  warn_deprecated(thd);
  return sys_var_thd_storage_engine::update(thd, var);
}

unknown's avatar
unknown committed
3029

3030 3031 3032
/****************************************************************************
 Functions to handle sql_mode
****************************************************************************/
3033

3034 3035
byte *sys_var_thd_sql_mode::value_ptr(THD *thd, enum_var_type type,
				      LEX_STRING *base)
3036 3037 3038 3039 3040 3041 3042 3043 3044 3045 3046 3047 3048 3049 3050 3051 3052 3053 3054 3055 3056 3057 3058 3059 3060 3061 3062 3063 3064 3065 3066 3067 3068 3069 3070 3071 3072 3073 3074 3075
{
  ulong val;
  char buff[256];
  String tmp(buff, sizeof(buff), &my_charset_latin1);

  tmp.length(0);
  val= ((type == OPT_GLOBAL) ? global_system_variables.*offset :
        thd->variables.*offset);
  for (uint i= 0; val; val>>= 1, i++)
  {
    if (val & 1)
    {
      tmp.append(enum_names->type_names[i]);
      tmp.append(',');
    }
  }
  if (tmp.length())
    tmp.length(tmp.length() - 1);
  return (byte*) thd->strmake(tmp.ptr(), tmp.length());
}


void sys_var_thd_sql_mode::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
    global_system_variables.*offset= 0;
  else
    thd->variables.*offset= global_system_variables.*offset;
}

void fix_sql_mode_var(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
    global_system_variables.sql_mode=
      fix_sql_mode(global_system_variables.sql_mode);
  else
    thd->variables.sql_mode= fix_sql_mode(thd->variables.sql_mode);
}

/* Map database specific bits to function bits */
3076

3077 3078 3079 3080 3081 3082 3083 3084 3085 3086 3087 3088 3089 3090 3091
ulong fix_sql_mode(ulong sql_mode)
{
  /*
    Note that we dont set 
    MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS | MODE_NO_FIELD_OPTIONS
    to allow one to get full use of MySQL in this mode.
  */

  if (sql_mode & MODE_ANSI)
    sql_mode|= (MODE_REAL_AS_FLOAT | MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE | MODE_ONLY_FULL_GROUP_BY);
  if (sql_mode & MODE_ORACLE)
    sql_mode|= (MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE |
		MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS |
3092
		MODE_NO_FIELD_OPTIONS | MODE_NO_AUTO_CREATE_USER);
3093 3094 3095 3096 3097 3098 3099 3100 3101 3102 3103 3104 3105 3106 3107
  if (sql_mode & MODE_MSSQL)
    sql_mode|= (MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE |
		MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS |
		MODE_NO_FIELD_OPTIONS);
  if (sql_mode & MODE_POSTGRESQL)
    sql_mode|= (MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE |
		MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS |
		MODE_NO_FIELD_OPTIONS);
  if (sql_mode & MODE_DB2)
    sql_mode|= (MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE |
		MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS |
		MODE_NO_FIELD_OPTIONS);
3108
  if (sql_mode & MODE_MAXDB)
3109 3110 3111
    sql_mode|= (MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE |
		MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS |
3112
		MODE_NO_FIELD_OPTIONS | MODE_NO_AUTO_CREATE_USER);
3113
  if (sql_mode & MODE_MYSQL40)
3114
    sql_mode|= MODE_NO_FIELD_OPTIONS | MODE_BROKEN_NOT;
3115
  if (sql_mode & MODE_MYSQL323)
3116
    sql_mode|= MODE_NO_FIELD_OPTIONS | MODE_BROKEN_NOT;
unknown's avatar
unknown committed
3117 3118 3119
  if (sql_mode & MODE_TRADITIONAL)
    sql_mode|= (MODE_STRICT_TRANS_TABLES | MODE_STRICT_ALL_TABLES |
                MODE_NO_ZERO_IN_DATE | MODE_NO_ZERO_DATE |
3120
                MODE_ERROR_FOR_DIVISION_BY_ZERO | MODE_NO_AUTO_CREATE_USER);
3121 3122
  return sql_mode;
}
3123 3124


3125 3126 3127 3128
/****************************************************************************
  Named list handling
****************************************************************************/

unknown's avatar
unknown committed
3129 3130
gptr find_named(I_List<NAMED_LIST> *list, const char *name, uint length,
		NAMED_LIST **found)
3131 3132 3133 3134 3135 3136
{
  I_List_iterator<NAMED_LIST> it(*list);
  NAMED_LIST *element;
  while ((element= it++))
  {
    if (element->cmp(name, length))
unknown's avatar
unknown committed
3137
    {
3138 3139
      if (found)
        *found= element;
3140
      return element->data;
unknown's avatar
unknown committed
3141
    }
3142 3143 3144 3145 3146
  }
  return 0;
}


3147 3148
void delete_elements(I_List<NAMED_LIST> *list,
		     void (*free_element)(const char *name, gptr))
3149 3150
{
  NAMED_LIST *element;
unknown's avatar
unknown committed
3151
  DBUG_ENTER("delete_elements");
3152 3153
  while ((element= list->get()))
  {
3154
    (*free_element)(element->name, element->data);
3155 3156
    delete element;
  }
unknown's avatar
unknown committed
3157
  DBUG_VOID_RETURN;
3158 3159 3160 3161 3162
}


/* Key cache functions */

unknown's avatar
unknown committed
3163
static KEY_CACHE *create_key_cache(const char *name, uint length)
3164
{
unknown's avatar
unknown committed
3165
  KEY_CACHE *key_cache;
3166 3167 3168
  DBUG_ENTER("create_key_cache");
  DBUG_PRINT("enter",("name: %.*s", length, name));
  
unknown's avatar
unknown committed
3169
  if ((key_cache= (KEY_CACHE*) my_malloc(sizeof(KEY_CACHE),
3170
					     MYF(MY_ZEROFILL | MY_WME))))
unknown's avatar
unknown committed
3171 3172
  {
    if (!new NAMED_LIST(&key_caches, name, length, (gptr) key_cache))
3173 3174
    {
      my_free((char*) key_cache, MYF(0));
unknown's avatar
unknown committed
3175
      key_cache= 0;
3176 3177 3178 3179 3180 3181 3182 3183 3184
    }
    else
    {
      /*
	Set default values for a key cache
	The values in dflt_key_cache_var is set by my_getopt() at startup

	We don't set 'buff_size' as this is used to enable the key cache
      */
unknown's avatar
unknown committed
3185 3186 3187
      key_cache->param_block_size=     dflt_key_cache_var.param_block_size;
      key_cache->param_division_limit= dflt_key_cache_var.param_division_limit;
      key_cache->param_age_threshold=  dflt_key_cache_var.param_age_threshold;
3188
    }
unknown's avatar
unknown committed
3189
  }
3190
  DBUG_RETURN(key_cache);
3191 3192 3193
}


unknown's avatar
unknown committed
3194
KEY_CACHE *get_or_create_key_cache(const char *name, uint length)
3195
{
unknown's avatar
unknown committed
3196
  LEX_STRING key_cache_name;
unknown's avatar
unknown committed
3197
  KEY_CACHE *key_cache;
3198

unknown's avatar
unknown committed
3199 3200
  key_cache_name.str= (char *) name;
  key_cache_name.length= length;
3201 3202
  pthread_mutex_lock(&LOCK_global_system_variables);
  if (!(key_cache= get_key_cache(&key_cache_name)))
3203
    key_cache= create_key_cache(name, length);
3204
  pthread_mutex_unlock(&LOCK_global_system_variables);
3205 3206 3207 3208
  return key_cache;
}


unknown's avatar
unknown committed
3209
void free_key_cache(const char *name, KEY_CACHE *key_cache)
3210
{
3211 3212
  ha_end_key_cache(key_cache);
  my_free((char*) key_cache, MYF(0));
unknown's avatar
unknown committed
3213 3214 3215
}


unknown's avatar
unknown committed
3216
bool process_key_caches(int (* func) (const char *name, KEY_CACHE *))
3217
{
unknown's avatar
unknown committed
3218 3219
  I_List_iterator<NAMED_LIST> it(key_caches);
  NAMED_LIST *element;
3220

unknown's avatar
unknown committed
3221 3222
  while ((element= it++))
  {
unknown's avatar
unknown committed
3223
    KEY_CACHE *key_cache= (KEY_CACHE *) element->data;
3224
    func(element->name, key_cache);
unknown's avatar
unknown committed
3225 3226
  }
  return 0;
3227 3228
}

3229

unknown's avatar
unknown committed
3230 3231 3232 3233 3234 3235
/****************************************************************************
  Used templates
****************************************************************************/

#ifdef __GNUC__
template class List<set_var_base>;
unknown's avatar
unknown committed
3236
template class List_iterator_fast<set_var_base>;
3237
template class I_List_iterator<NAMED_LIST>;
unknown's avatar
unknown committed
3238
#endif