set_var.cc 137 KB
Newer Older
Michael Widenius's avatar
Michael Widenius committed
1 2
/* Copyright (c) 2002, 2010, Oracle and/or its affiliates.
   2009-2010 Monty Program Ab
unknown's avatar
unknown committed
3 4 5

   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
unknown's avatar
unknown committed
6
   the Free Software Foundation; version 2 of the License.
unknown's avatar
unknown committed
7 8 9 10 11 12 13 14 15 16

   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 */

unknown's avatar
unknown committed
17 18 19 20
/**
  @file

  @brief
unknown's avatar
unknown committed
21 22
  Handling of MySQL SQL variables

unknown's avatar
unknown committed
23
  @details
unknown's avatar
unknown committed
24 25 26 27 28
  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.
29 30
  - 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
31
  - If the variable should be changed from the command line, add a definition
unknown's avatar
unknown committed
32
    of it in the my_option structure list in mysqld.cc
33 34
  - Don't forget to initialize new fields in global_system_variables and
    max_system_variables!
unknown's avatar
unknown committed
35

unknown's avatar
unknown committed
36 37 38 39 40 41 42 43 44 45
  @todo
    Add full support for the variable character_set (for 4.1)

  @todo
    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.

  @note
    Be careful with var->save_result: sys_var::check() only updates
46 47 48
    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
49 50
*/

51
#ifdef USE_PRAGMA_IMPLEMENTATION
unknown's avatar
unknown committed
52 53 54 55
#pragma implementation				// gcc: Class implementation
#endif

#include "mysql_priv.h"
56
#include <mysql.h>
unknown's avatar
unknown committed
57
#include "slave.h"
58
#include "rpl_mi.h"
unknown's avatar
unknown committed
59
#include <my_getopt.h>
60
#include <thr_alarm.h>
unknown's avatar
unknown committed
61
#include <myisam.h>
Sergei Golubchik's avatar
Sergei Golubchik committed
62
#ifdef WITH_ARIA_STORAGE_ENGINE
63 64
#include <maria.h>
#endif
65
#include <my_dir.h>
66
#include <waiting_threads.h>
67
#include "events.h"
68

69
/* WITH_NDBCLUSTER_STORAGE_ENGINE */
70
#ifdef WITH_NDBCLUSTER_STORAGE_ENGINE
71
extern ulong ndb_cache_check_time;
72
extern char opt_ndb_constrbuf[];
unknown's avatar
unknown committed
73
extern ulong ndb_extra_logging;
74 75
#endif

unknown's avatar
unknown committed
76 77 78 79
#ifdef HAVE_NDB_BINLOG
extern ulong ndb_report_thresh_binlog_epoch_slip;
extern ulong ndb_report_thresh_binlog_mem_usage;
#endif
80

unknown's avatar
unknown committed
81
extern CHARSET_INFO *character_set_filesystem;
82 83


unknown's avatar
unknown committed
84
static HASH system_variable_hash;
unknown's avatar
unknown committed
85

unknown's avatar
unknown committed
86 87 88
const char *bool_type_names[]= { "OFF", "ON", NullS };
TYPELIB bool_typelib=
{
89
  array_elements(bool_type_names)-1, "", bool_type_names, NULL
unknown's avatar
unknown committed
90 91
};

92 93 94
const char *delay_key_write_type_names[]= { "OFF", "ON", "ALL", NullS };
TYPELIB delay_key_write_typelib=
{
95 96
  array_elements(delay_key_write_type_names)-1, "",
  delay_key_write_type_names, NULL
97 98
};

99 100 101
static const char *slave_exec_mode_names[]= { "STRICT", "IDEMPOTENT", NullS };
static unsigned int slave_exec_mode_names_len[]= { sizeof("STRICT") - 1,
                                                   sizeof("IDEMPOTENT") - 1, 0 };
102 103 104
TYPELIB slave_exec_mode_typelib=
{
  array_elements(slave_exec_mode_names)-1, "",
105
  slave_exec_mode_names, slave_exec_mode_names_len
106 107
};

108 109 110
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
111 112 113 114
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
115
static bool set_option_bit(THD *thd, set_var *var);
116
static bool set_option_log_bin_bit(THD *thd, set_var *var);
unknown's avatar
unknown committed
117
static bool set_option_autocommit(THD *thd, set_var *var);
118
static int  check_log_update(THD *thd, set_var *var);
unknown's avatar
unknown committed
119
static bool set_log_update(THD *thd, set_var *var);
120
static int  check_pseudo_thread_id(THD *thd, set_var *var);
121
void fix_binlog_format_after_update(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
122
static void fix_low_priority_updates(THD *thd, enum_var_type type);
123
static int check_tx_isolation(THD *thd, set_var *var);
unknown's avatar
unknown committed
124
static void fix_tx_isolation(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
125 126
static int check_completion_type(THD *thd, set_var *var);
static void fix_completion_type(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
127 128
static void fix_net_read_timeout(THD *thd, enum_var_type type);
static void fix_net_write_timeout(THD *thd, enum_var_type type);
129
static void fix_net_retry_count(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
130 131
static void fix_max_join_size(THD *thd, enum_var_type type);
static void fix_query_cache_size(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
132
#ifdef HAVE_QUERY_CACHE
133
static void fix_query_cache_min_res_unit(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
134
#endif
135
static void fix_myisam_max_sort_file_size(THD *thd, enum_var_type type);
136 137
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);
138
static void fix_max_connections(THD *thd, enum_var_type type);
139
static int check_max_delayed_threads(THD *thd, set_var *var);
140 141
static void fix_thd_mem_root(THD *thd, enum_var_type type);
static void fix_trans_mem_root(THD *thd, enum_var_type type);
142
static void fix_server_id(THD *thd, enum_var_type type);
143 144
bool throw_bounds_warning(THD *thd, bool fixed, bool unsignd,
                          const char *name, longlong val);
unknown's avatar
unknown committed
145
static KEY_CACHE *create_key_cache(const char *name, uint length);
146
void fix_sql_mode_var(THD *thd, enum_var_type type);
147 148 149
static uchar *get_error_count(THD *thd);
static uchar *get_warning_count(THD *thd);
static uchar *get_tmpdir(THD *thd);
150 151 152 153 154
static int  sys_check_log_path(THD *thd,  set_var *var);
static bool sys_update_general_log_path(THD *thd, set_var * var);
static void sys_default_general_log_path(THD *thd, enum_var_type type);
static bool sys_update_slow_log_path(THD *thd, set_var * var);
static void sys_default_slow_log_path(THD *thd, enum_var_type type);
155
static void fix_sys_log_slow_filter(THD *thd, enum_var_type);
156
static uchar *get_myisam_mmap_size(THD *thd);
unknown's avatar
unknown committed
157 158 159 160 161

/*
  Variable definition list

  These are variables that can be set from the command line, in
162 163 164 165
  alphabetic order.

  The variables are linked into the list. A variable is added to
  it in the constructor (see sys_var class for details).
unknown's avatar
unknown committed
166 167
*/

unknown's avatar
unknown committed
168
static sys_var_chain vars = { NULL, NULL };
169

170 171 172 173 174 175 176 177
static sys_var_thd_ulong
sys_auto_increment_increment(&vars, "auto_increment_increment",
                             &SV::auto_increment_increment, NULL, NULL,
                             sys_var::SESSION_VARIABLE_IN_BINLOG);
static sys_var_thd_ulong
sys_auto_increment_offset(&vars, "auto_increment_offset",
                          &SV::auto_increment_offset, NULL, NULL,
                          sys_var::SESSION_VARIABLE_IN_BINLOG);
178

unknown's avatar
unknown committed
179
static sys_var_bool_ptr	sys_automatic_sp_privileges(&vars, "automatic_sp_privileges",
180 181
					      &sp_automatic_privileges);

182 183 184
static sys_var_const            sys_back_log(&vars, "back_log",
                                             OPT_GLOBAL, SHOW_LONG,
                                             (uchar*) &back_log);
185
static sys_var_const_os_str       sys_basedir(&vars, "basedir", mysql_home);
unknown's avatar
unknown committed
186
static sys_var_long_ptr	sys_binlog_cache_size(&vars, "binlog_cache_size",
unknown's avatar
unknown committed
187
					      &binlog_cache_size);
unknown's avatar
unknown committed
188
static sys_var_thd_binlog_format sys_binlog_format(&vars, "binlog_format",
189
                                            &SV::binlog_format);
190 191
static sys_var_thd_bool sys_binlog_direct_non_trans_update(&vars, "binlog_direct_non_transactional_updates",
                                                           &SV::binlog_direct_non_trans_update);
unknown's avatar
unknown committed
192
static sys_var_thd_ulong	sys_bulk_insert_buff_size(&vars, "bulk_insert_buffer_size",
unknown's avatar
unknown committed
193
						  &SV::bulk_insert_buff_size);
194
static sys_var_const_os         sys_character_sets_dir(&vars,
195 196 197 198
                                                       "character_sets_dir",
                                                       OPT_GLOBAL, SHOW_CHAR,
                                                       (uchar*)
                                                       mysql_charsets_dir);
199 200 201 202
static sys_var_character_set_sv
sys_character_set_server(&vars, "character_set_server",
                         &SV::collation_server, &default_charset_info, 0,
                         sys_var::SESSION_VARIABLE_IN_BINLOG);
unknown's avatar
unknown committed
203
sys_var_const_str       sys_charset_system(&vars, "character_set_system",
204
                                           (char *)my_charset_utf8_general_ci.name);
205 206 207 208 209 210 211 212 213 214 215 216 217
static sys_var_character_set_database
sys_character_set_database(&vars, "character_set_database",
                           sys_var::SESSION_VARIABLE_IN_BINLOG);
static sys_var_character_set_client
sys_character_set_client(&vars, "character_set_client",
                         &SV::character_set_client,
                         &default_charset_info,
                         sys_var::SESSION_VARIABLE_IN_BINLOG);
static sys_var_character_set_sv
sys_character_set_connection(&vars, "character_set_connection",
                             &SV::collation_connection,
                             &default_charset_info, 0,
                             sys_var::SESSION_VARIABLE_IN_BINLOG);
unknown's avatar
unknown committed
218 219 220 221 222 223 224
static sys_var_character_set_sv sys_character_set_results(&vars, "character_set_results",
                                        &SV::character_set_results,
                                        &default_charset_info, true);
static sys_var_character_set_sv sys_character_set_filesystem(&vars, "character_set_filesystem",
                                        &SV::character_set_filesystem,
                                        &character_set_filesystem);
static sys_var_thd_ulong	sys_completion_type(&vars, "completion_type",
unknown's avatar
unknown committed
225 226 227
					 &SV::completion_type,
					 check_completion_type,
					 fix_completion_type);
228 229 230 231 232 233 234 235 236 237 238 239
static sys_var_collation_sv
sys_collation_connection(&vars, "collation_connection",
                         &SV::collation_connection, &default_charset_info,
                         sys_var::SESSION_VARIABLE_IN_BINLOG);
static sys_var_collation_sv
sys_collation_database(&vars, "collation_database", &SV::collation_database,
                       &default_charset_info,
                       sys_var::SESSION_VARIABLE_IN_BINLOG);
static sys_var_collation_sv
sys_collation_server(&vars, "collation_server", &SV::collation_server,
                     &default_charset_info,
                     sys_var::SESSION_VARIABLE_IN_BINLOG);
unknown's avatar
unknown committed
240
static sys_var_long_ptr	sys_concurrent_insert(&vars, "concurrent_insert",
241
                                              &myisam_concurrent_insert);
unknown's avatar
unknown committed
242
static sys_var_long_ptr	sys_connect_timeout(&vars, "connect_timeout",
unknown's avatar
unknown committed
243
					    &connect_timeout);
244
static sys_var_const_os_str       sys_datadir(&vars, "datadir", mysql_real_data_home);
245 246 247 248 249 250 251 252 253 254 255 256 257

static sys_var_thd_ulong sys_deadlock_search_depth_short(&vars,
                                "deadlock_search_depth_short",
                                 &SV::wt_deadlock_search_depth_short);
static sys_var_thd_ulong sys_deadlock_search_depth_long(&vars,
                                "deadlock_search_depth_long",
                                 &SV::wt_deadlock_search_depth_long);
static sys_var_thd_ulong sys_deadlock_timeout_short(&vars,
                                "deadlock_timeout_short",
                                 &SV::wt_timeout_short);
static sys_var_thd_ulong sys_deadlock_timeout_long(&vars,
                                "deadlock_timeout_long",
                                 &SV::wt_timeout_long);
unknown's avatar
unknown committed
258
#ifndef DBUG_OFF
unknown's avatar
unknown committed
259
static sys_var_thd_dbug        sys_dbug(&vars, "debug");
unknown's avatar
unknown committed
260
#endif
unknown's avatar
unknown committed
261
static sys_var_enum		sys_delay_key_write(&vars, "delay_key_write",
262 263 264
					    &delay_key_write_options,
					    &delay_key_write_typelib,
					    fix_delay_key_write);
unknown's avatar
unknown committed
265
static sys_var_long_ptr	sys_delayed_insert_limit(&vars, "delayed_insert_limit",
unknown's avatar
unknown committed
266
						 &delayed_insert_limit);
unknown's avatar
unknown committed
267
static sys_var_long_ptr	sys_delayed_insert_timeout(&vars, "delayed_insert_timeout",
unknown's avatar
unknown committed
268
						   &delayed_insert_timeout);
unknown's avatar
unknown committed
269
static sys_var_long_ptr	sys_delayed_queue_size(&vars, "delayed_queue_size",
unknown's avatar
unknown committed
270
					       &delayed_queue_size);
271

272
#ifdef HAVE_EVENT_SCHEDULER
unknown's avatar
unknown committed
273
static sys_var_event_scheduler sys_event_scheduler(&vars, "event_scheduler");
274 275
#endif

276 277 278 279 280 281 282
static sys_var_const    sys_extra_port(&vars, "extra_port",
                                       OPT_GLOBAL, SHOW_INT,
                                       (uchar*) &mysqld_extra_port);
static sys_var_long_ptr	sys_extra_max_connections(&vars,
                                                  "extra_max_connections",
                                                  &extra_max_connections,
                                                  fix_max_connections);
unknown's avatar
unknown committed
283
static sys_var_long_ptr	sys_expire_logs_days(&vars, "expire_logs_days",
unknown's avatar
unknown committed
284
					     &expire_logs_days);
unknown's avatar
unknown committed
285 286
static sys_var_bool_ptr	sys_flush(&vars, "flush", &myisam_flush);
static sys_var_long_ptr	sys_flush_time(&vars, "flush_time", &flush_time);
287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305
static sys_var_str      sys_ft_boolean_syntax(&vars, "ft_boolean_syntax",
                                              sys_check_ftb_syntax,
                                              sys_update_ftb_syntax,
                                              sys_default_ftb_syntax,
                                              ft_boolean_syntax);
static sys_var_const    sys_ft_max_word_len(&vars, "ft_max_word_len",
                                            OPT_GLOBAL, SHOW_LONG,
                                            (uchar*) &ft_max_word_len);
static sys_var_const    sys_ft_min_word_len(&vars, "ft_min_word_len",
                                            OPT_GLOBAL, SHOW_LONG,
                                            (uchar*) &ft_min_word_len);
static sys_var_const    sys_ft_query_expansion_limit(&vars,
                                                     "ft_query_expansion_limit",
                                                     OPT_GLOBAL, SHOW_LONG,
                                                     (uchar*)
                                                     &ft_query_expansion_limit);
static sys_var_const    sys_ft_stopword_file(&vars, "ft_stopword_file",
                                             OPT_GLOBAL, SHOW_CHAR_PTR,
                                             (uchar*) &ft_stopword_file);
306 307 308 309 310

static sys_var_const    sys_ignore_builtin_innodb(&vars, "ignore_builtin_innodb",
                                                  OPT_GLOBAL, SHOW_BOOL,
                                                  (uchar*) &opt_ignore_builtin_innodb);

unknown's avatar
unknown committed
311
sys_var_str             sys_init_connect(&vars, "init_connect", 0,
312 313
                                         sys_update_init_connect,
                                         sys_default_init_connect,0);
314 315 316
static sys_var_const    sys_init_file(&vars, "init_file",
                                      OPT_GLOBAL, SHOW_CHAR_PTR,
                                      (uchar*) &opt_init_file);
unknown's avatar
unknown committed
317
sys_var_str             sys_init_slave(&vars, "init_slave", 0,
318 319
                                       sys_update_init_slave,
                                       sys_default_init_slave,0);
unknown's avatar
unknown committed
320
static sys_var_thd_ulong	sys_interactive_timeout(&vars, "interactive_timeout",
unknown's avatar
unknown committed
321
						&SV::net_interactive_timeout);
unknown's avatar
unknown committed
322
static sys_var_thd_ulong	sys_join_buffer_size(&vars, "join_buffer_size",
unknown's avatar
unknown committed
323
					     &SV::join_buff_size);
unknown's avatar
unknown committed
324
static sys_var_key_buffer_size	sys_key_buffer_size(&vars, "key_buffer_size");
325 326 327 328 329 330 331 332 333 334
static sys_var_key_cache_long  sys_key_cache_block_size(&vars,
                                   "key_cache_block_size",
                                   offsetof(KEY_CACHE,param_block_size));
static sys_var_key_cache_long  sys_key_cache_division_limit(&vars,
                                   "key_cache_division_limit",
                                   offsetof(KEY_CACHE, param_division_limit));
static sys_var_key_cache_long  sys_key_cache_age_threshold(&vars,
                                   "key_cache_age_threshold",
                                   offsetof(KEY_CACHE, param_age_threshold));
static sys_var_key_cache_long  sys_key_cache_partitions(&vars,
335
                                   "key_cache_segments",
336
                                   offsetof(KEY_CACHE, param_partitions));
337 338 339 340 341 342 343 344 345 346 347 348
static sys_var_const    sys_language(&vars, "language",
                                     OPT_GLOBAL, SHOW_CHAR,
                                     (uchar*) language);
static sys_var_const    sys_large_files_support(&vars, "large_files_support",
                                                OPT_GLOBAL, SHOW_BOOL,
                                                (uchar*) &opt_large_files);
static sys_var_const    sys_large_page_size(&vars, "large_page_size",
                                            OPT_GLOBAL, SHOW_INT,
                                            (uchar*) &opt_large_page_size);
static sys_var_const    sys_large_pages(&vars, "large_pages",
                                        OPT_GLOBAL, SHOW_MY_BOOL,
                                        (uchar*) &opt_large_pages);
unknown's avatar
unknown committed
349
static sys_var_bool_ptr	sys_local_infile(&vars, "local_infile",
unknown's avatar
unknown committed
350
					 &opt_local_infile);
351 352 353 354 355 356 357 358
#ifdef HAVE_MLOCKALL
static sys_var_const    sys_locked_in_memory(&vars, "locked_in_memory",
                                             OPT_GLOBAL, SHOW_MY_BOOL,
                                             (uchar*) &locked_in_memory);
#endif
static sys_var_const    sys_log_bin(&vars, "log_bin",
                                    OPT_GLOBAL, SHOW_BOOL,
                                    (uchar*) &opt_bin_log);
unknown's avatar
unknown committed
359 360
static sys_var_trust_routine_creators
sys_trust_routine_creators(&vars, "log_bin_trust_routine_creators",
361
                           &trust_function_creators);
362
static sys_var_bool_ptr
unknown's avatar
unknown committed
363
sys_trust_function_creators(&vars, "log_bin_trust_function_creators",
364
                            &trust_function_creators);
365 366 367
static sys_var_const    sys_log_error(&vars, "log_error",
                                      OPT_GLOBAL, SHOW_CHAR,
                                      (uchar*) log_error_file);
unknown's avatar
unknown committed
368 369
static sys_var_bool_ptr
  sys_log_queries_not_using_indexes(&vars, "log_queries_not_using_indexes",
370
                                    &opt_log_queries_not_using_indexes);
unknown's avatar
unknown committed
371
static sys_var_thd_ulong	sys_log_warnings(&vars, "log_warnings", &SV::log_warnings);
372 373
static sys_var_microseconds	sys_var_long_query_time(&vars, "long_query_time",
                                                        &SV::long_query_time);
374 375 376
static sys_var_microseconds	sys_var_long_query_time2(&vars,
                                                         "log_slow_time",
                                                         &SV::long_query_time);
unknown's avatar
unknown committed
377
static sys_var_thd_bool	sys_low_priority_updates(&vars, "low_priority_updates",
unknown's avatar
unknown committed
378 379 380
						 &SV::low_priority_updates,
						 fix_low_priority_updates);
#ifndef TO_BE_DELETED	/* Alias for the low_priority_updates */
unknown's avatar
unknown committed
381
static sys_var_thd_bool	sys_sql_low_priority_updates(&vars, "sql_low_priority_updates",
unknown's avatar
unknown committed
382 383 384
						     &SV::low_priority_updates,
						     fix_low_priority_updates);
#endif
385 386 387 388 389 390 391 392 393 394
static sys_var_const    sys_lower_case_file_system(&vars,
                                                   "lower_case_file_system",
                                                   OPT_GLOBAL, SHOW_MY_BOOL,
                                                   (uchar*)
                                                   &lower_case_file_system);
static sys_var_const    sys_lower_case_table_names(&vars,
                                                   "lower_case_table_names",
                                                   OPT_GLOBAL, SHOW_INT,
                                                   (uchar*)
                                                   &lower_case_table_names);
395
static sys_var_thd_ulong_session_readonly sys_max_allowed_packet(&vars, "max_allowed_packet",
unknown's avatar
unknown committed
396
					       &SV::max_allowed_packet);
397 398
static sys_var_ulonglong_ptr sys_max_binlog_cache_size(&vars, "max_binlog_cache_size",
                                                       &max_binlog_cache_size);
unknown's avatar
unknown committed
399
static sys_var_long_ptr	sys_max_binlog_size(&vars, "max_binlog_size",
400 401
					    &max_binlog_size,
                                            fix_max_binlog_size);
unknown's avatar
unknown committed
402
static sys_var_long_ptr	sys_max_connections(&vars, "max_connections",
403 404
					    &max_connections,
                                            fix_max_connections);
unknown's avatar
unknown committed
405
static sys_var_long_ptr	sys_max_connect_errors(&vars, "max_connect_errors",
unknown's avatar
unknown committed
406
					       &max_connect_errors);
unknown's avatar
unknown committed
407
static sys_var_thd_ulong       sys_max_insert_delayed_threads(&vars, "max_insert_delayed_threads",
408 409 410
						       &SV::max_insert_delayed_threads,
                                                       check_max_delayed_threads,
                                                       fix_max_connections);
unknown's avatar
unknown committed
411
static sys_var_thd_ulong	sys_max_delayed_threads(&vars, "max_delayed_threads",
412
						&SV::max_insert_delayed_threads,
413 414
                                                check_max_delayed_threads,
                                                fix_max_connections);
unknown's avatar
unknown committed
415
static sys_var_thd_ulong	sys_max_error_count(&vars, "max_error_count",
416
					    &SV::max_error_count);
unknown's avatar
unknown committed
417
static sys_var_thd_ulonglong	sys_max_heap_table_size(&vars, "max_heap_table_size",
unknown's avatar
unknown committed
418
						&SV::max_heap_table_size);
419 420 421 422
static sys_var_thd_ulong sys_pseudo_thread_id(&vars, "pseudo_thread_id",
                                              &SV::pseudo_thread_id,
                                              check_pseudo_thread_id, 0,
                                              sys_var::SESSION_VARIABLE_IN_BINLOG);
unknown's avatar
unknown committed
423
static sys_var_thd_ha_rows	sys_max_join_size(&vars, "max_join_size",
unknown's avatar
unknown committed
424 425
					  &SV::max_join_size,
					  fix_max_join_size);
unknown's avatar
unknown committed
426
static sys_var_thd_ulong	sys_max_seeks_for_key(&vars, "max_seeks_for_key",
427
					      &SV::max_seeks_for_key);
unknown's avatar
unknown committed
428
static sys_var_thd_ulong   sys_max_length_for_sort_data(&vars, "max_length_for_sort_data",
429
                                                 &SV::max_length_for_sort_data);
unknown's avatar
unknown committed
430
#ifndef TO_BE_DELETED	/* Alias for max_join_size */
unknown's avatar
unknown committed
431
static sys_var_thd_ha_rows	sys_sql_max_join_size(&vars, "sql_max_join_size",
unknown's avatar
unknown committed
432 433 434
					      &SV::max_join_size,
					      fix_max_join_size);
#endif
435
static sys_var_long_ptr_global
unknown's avatar
unknown committed
436
sys_max_prepared_stmt_count(&vars, "max_prepared_stmt_count",
437 438
                            &max_prepared_stmt_count,
                            &LOCK_prepared_stmt_count);
unknown's avatar
unknown committed
439
static sys_var_long_ptr	sys_max_relay_log_size(&vars, "max_relay_log_size",
440 441
                                               &max_relay_log_size,
                                               fix_max_relay_log_size);
unknown's avatar
unknown committed
442
static sys_var_thd_ulong	sys_max_sort_length(&vars, "max_sort_length",
unknown's avatar
unknown committed
443
					    &SV::max_sort_length);
unknown's avatar
unknown committed
444
static sys_var_thd_ulong	sys_max_sp_recursion_depth(&vars, "max_sp_recursion_depth",
445
                                                   &SV::max_sp_recursion_depth);
unknown's avatar
unknown committed
446 447
static sys_var_max_user_conn   sys_max_user_connections(&vars, "max_user_connections");
static sys_var_thd_ulong	sys_max_tmp_tables(&vars, "max_tmp_tables",
unknown's avatar
unknown committed
448
					   &SV::max_tmp_tables);
unknown's avatar
unknown committed
449
static sys_var_long_ptr	sys_max_write_lock_count(&vars, "max_write_lock_count",
unknown's avatar
unknown committed
450
						 &max_write_lock_count);
451 452
static sys_var_thd_ulong       sys_min_examined_row_limit(&vars, "min_examined_row_limit",
                                                          &SV::min_examined_row_limit);
unknown's avatar
unknown committed
453
static sys_var_thd_ulong       sys_multi_range_count(&vars, "multi_range_count",
unknown's avatar
unknown committed
454
                                              &SV::multi_range_count);
unknown's avatar
unknown committed
455
static sys_var_long_ptr	sys_myisam_data_pointer_size(&vars, "myisam_data_pointer_size",
unknown's avatar
unknown committed
456
                                                    &myisam_data_pointer_size);
unknown's avatar
unknown committed
457
static sys_var_thd_ulonglong	sys_myisam_max_sort_file_size(&vars, "myisam_max_sort_file_size", &SV::myisam_max_sort_file_size, fix_myisam_max_sort_file_size, 1);
458 459 460 461
static sys_var_const sys_myisam_recover_options(&vars, "myisam_recover_options",
                                                OPT_GLOBAL, SHOW_CHAR_PTR,
                                                (uchar*)
                                                &myisam_recover_options_str);
unknown's avatar
unknown committed
462 463
static sys_var_thd_ulong       sys_myisam_repair_threads(&vars, "myisam_repair_threads", &SV::myisam_repair_threads);
static sys_var_thd_ulong	sys_myisam_sort_buffer_size(&vars, "myisam_sort_buffer_size", &SV::myisam_sort_buff_size);
unknown's avatar
unknown committed
464
static sys_var_bool_ptr	sys_myisam_use_mmap(&vars, "myisam_use_mmap",
unknown's avatar
unknown committed
465
                                            &opt_myisam_use_mmap);
466

unknown's avatar
unknown committed
467
static sys_var_thd_enum         sys_myisam_stats_method(&vars, "myisam_stats_method",
468 469 470 471
                                                &SV::myisam_stats_method,
                                                &myisam_stats_method_typelib,
                                                NULL);

472 473 474 475
static sys_var_const            sys_myisam_block_size(&vars, "myisam_block_size",
                                             OPT_GLOBAL, SHOW_LONG,
                                             (uchar*) &myisam_block_size);

476 477 478 479 480 481 482
#ifdef __NT__
/* purecov: begin inspected */
static sys_var_const            sys_named_pipe(&vars, "named_pipe",
                                               OPT_GLOBAL, SHOW_MY_BOOL,
                                               (uchar*) &opt_enable_named_pipe);
/* purecov: end */
#endif
483
static sys_var_thd_ulong_session_readonly sys_net_buffer_length(&vars, "net_buffer_length",
unknown's avatar
unknown committed
484
					      &SV::net_buffer_length);
unknown's avatar
unknown committed
485
static sys_var_thd_ulong	sys_net_read_timeout(&vars, "net_read_timeout",
unknown's avatar
unknown committed
486
					     &SV::net_read_timeout,
487
					     0, fix_net_read_timeout);
unknown's avatar
unknown committed
488
static sys_var_thd_ulong	sys_net_write_timeout(&vars, "net_write_timeout",
unknown's avatar
unknown committed
489
					      &SV::net_write_timeout,
490
					      0, fix_net_write_timeout);
unknown's avatar
unknown committed
491
static sys_var_thd_ulong	sys_net_retry_count(&vars, "net_retry_count",
492
					    &SV::net_retry_count,
493
					    0, fix_net_retry_count);
unknown's avatar
unknown committed
494
static sys_var_thd_bool	sys_new_mode(&vars, "new", &SV::new_mode);
unknown's avatar
unknown committed
495
static sys_var_bool_ptr_readonly sys_old_mode(&vars, "old",
unknown's avatar
unknown committed
496
                                       &global_system_variables.old_mode);
unknown's avatar
unknown committed
497 498 499 500
/* these two cannot be static */
sys_var_thd_bool                sys_old_alter_table(&vars, "old_alter_table",
                                            &SV::old_alter_table);
sys_var_thd_bool                sys_old_passwords(&vars, "old_passwords", &SV::old_passwords);
501 502 503 504
static sys_var_const            sys_open_files_limit(&vars, "open_files_limit",
                                                     OPT_GLOBAL, SHOW_LONG,
                                                     (uchar*)
                                                     &open_files_limit);
unknown's avatar
unknown committed
505
static sys_var_thd_ulong        sys_optimizer_prune_level(&vars, "optimizer_prune_level",
506
                                                  &SV::optimizer_prune_level);
unknown's avatar
unknown committed
507
static sys_var_thd_ulong        sys_optimizer_search_depth(&vars, "optimizer_search_depth",
508
                                                   &SV::optimizer_search_depth);
509 510
static sys_var_thd_optimizer_switch   sys_optimizer_switch(&vars, "optimizer_switch",
                                     &SV::optimizer_switch);
511 512 513
static sys_var_const            sys_pid_file(&vars, "pid_file",
                                             OPT_GLOBAL, SHOW_CHAR,
                                             (uchar*) pidfile_name);
514
static sys_var_const_os         sys_plugin_dir(&vars, "plugin_dir",
515 516 517 518 519
                                               OPT_GLOBAL, SHOW_CHAR,
                                               (uchar*) opt_plugin_dir);
static sys_var_const            sys_port(&vars, "port",
                                         OPT_GLOBAL, SHOW_INT,
                                         (uchar*) &mysqld_port);
unknown's avatar
unknown committed
520
static sys_var_thd_ulong        sys_preload_buff_size(&vars, "preload_buffer_size",
unknown's avatar
unknown committed
521
                                              &SV::preload_buff_size);
522 523 524 525
static sys_var_const            sys_protocol_version(&vars, "protocol_version",
                                                     OPT_GLOBAL, SHOW_INT,
                                                     (uchar*)
                                                     &protocol_version);
unknown's avatar
unknown committed
526
static sys_var_thd_ulong	sys_read_buff_size(&vars, "read_buffer_size",
unknown's avatar
unknown committed
527
					   &SV::read_buff_size);
unknown's avatar
unknown committed
528
static sys_var_opt_readonly	sys_readonly(&vars, "read_only", &opt_readonly);
529 530 531
static sys_var_bool_ptr	        sys_userstat(&vars, "userstat",
                                             &opt_userstat_running);

unknown's avatar
unknown committed
532
static sys_var_thd_ulong	sys_read_rnd_buff_size(&vars, "read_rnd_buffer_size",
unknown's avatar
unknown committed
533
					       &SV::read_rnd_buff_size);
unknown's avatar
unknown committed
534
static sys_var_thd_ulong	sys_div_precincrement(&vars, "div_precision_increment",
unknown's avatar
unknown committed
535
                                              &SV::div_precincrement);
unknown's avatar
unknown committed
536
static sys_var_long_ptr	sys_rpl_recovery_rank(&vars, "rpl_recovery_rank",
unknown's avatar
unknown committed
537
					      &rpl_recovery_rank);
unknown's avatar
unknown committed
538
static sys_var_long_ptr	sys_query_cache_size(&vars, "query_cache_size",
unknown's avatar
unknown committed
539 540
					     &query_cache_size,
					     fix_query_cache_size);
541

unknown's avatar
unknown committed
542
static sys_var_thd_ulong	sys_range_alloc_block_size(&vars, "range_alloc_block_size",
543
						   &SV::range_alloc_block_size);
unknown's avatar
unknown committed
544
static sys_var_thd_ulong	sys_query_alloc_block_size(&vars, "query_alloc_block_size",
545 546
						   &SV::query_alloc_block_size,
						   0, fix_thd_mem_root);
unknown's avatar
unknown committed
547
static sys_var_thd_ulong	sys_query_prealloc_size(&vars, "query_prealloc_size",
548 549
						&SV::query_prealloc_size,
						0, fix_thd_mem_root);
550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573
#ifdef HAVE_SMEM
/* purecov: begin tested */
static sys_var_const    sys_shared_memory(&vars, "shared_memory",
                                          OPT_GLOBAL, SHOW_MY_BOOL,
                                          (uchar*)
                                          &opt_enable_shared_memory);
static sys_var_const    sys_shared_memory_base_name(&vars,
                                                    "shared_memory_base_name",
                                                    OPT_GLOBAL, SHOW_CHAR_PTR,
                                                    (uchar*)
                                                    &shared_memory_base_name);
/* purecov: end */
#endif
static sys_var_const    sys_skip_external_locking(&vars,
                                                  "skip_external_locking",
                                                  OPT_GLOBAL, SHOW_MY_BOOL,
                                                  (uchar*)
                                                  &my_disable_locking);
static sys_var_const    sys_skip_networking(&vars, "skip_networking",
                                            OPT_GLOBAL, SHOW_BOOL,
                                            (uchar*) &opt_disable_networking);
static sys_var_const    sys_skip_show_database(&vars, "skip_show_database",
                                            OPT_GLOBAL, SHOW_BOOL,
                                            (uchar*) &opt_skip_show_db);
574

575 576 577 578
static sys_var_const    sys_skip_name_resolve(&vars, "skip_name_resolve",
                                            OPT_GLOBAL, SHOW_BOOL,
                                            (uchar*) &opt_skip_name_resolve);

579 580 581
static sys_var_const    sys_socket(&vars, "socket",
                                   OPT_GLOBAL, SHOW_CHAR_PTR,
                                   (uchar*) &mysqld_unix_port);
582

583 584 585 586 587 588 589 590 591 592
#ifdef HAVE_THR_SETCONCURRENCY
/* purecov: begin tested */
static sys_var_const    sys_thread_concurrency(&vars, "thread_concurrency",
                                               OPT_GLOBAL, SHOW_LONG,
                                               (uchar*) &concurrency);
/* purecov: end */
#endif
static sys_var_const    sys_thread_stack(&vars, "thread_stack",
                                         OPT_GLOBAL, SHOW_LONG,
                                         (uchar*) &my_thread_stack_size);
593
static sys_var_readonly_os      sys_tmpdir(&vars, "tmpdir", OPT_GLOBAL, SHOW_CHAR, get_tmpdir);
unknown's avatar
unknown committed
594
static sys_var_thd_ulong	sys_trans_alloc_block_size(&vars, "transaction_alloc_block_size",
595 596
						   &SV::trans_alloc_block_size,
						   0, fix_trans_mem_root);
unknown's avatar
unknown committed
597
static sys_var_thd_ulong	sys_trans_prealloc_size(&vars, "transaction_prealloc_size",
598 599
						&SV::trans_prealloc_size,
						0, fix_trans_mem_root);
unknown's avatar
unknown committed
600
sys_var_enum_const        sys_thread_handling(&vars, "thread_handling",
601 602
                                              &thread_handling,
                                              &thread_handling_typelib);
603

unknown's avatar
unknown committed
604
#ifdef HAVE_QUERY_CACHE
unknown's avatar
unknown committed
605
static sys_var_long_ptr	sys_query_cache_limit(&vars, "query_cache_limit",
unknown's avatar
unknown committed
606
					      &query_cache.query_cache_limit);
unknown's avatar
unknown committed
607
static sys_var_long_ptr        sys_query_cache_min_res_unit(&vars, "query_cache_min_res_unit",
608 609
						     &query_cache_min_res_unit,
						     fix_query_cache_min_res_unit);
unknown's avatar
unknown committed
610
static sys_var_thd_enum	sys_query_cache_type(&vars, "query_cache_type",
unknown's avatar
unknown committed
611 612
					     &SV::query_cache_type,
					     &query_cache_type_typelib);
unknown's avatar
unknown committed
613 614
static sys_var_thd_bool
sys_query_cache_wlock_invalidate(&vars, "query_cache_wlock_invalidate",
615
				 &SV::query_cache_wlock_invalidate);
unknown's avatar
unknown committed
616
#endif /* HAVE_QUERY_CACHE */
unknown's avatar
unknown committed
617
static sys_var_bool_ptr	sys_secure_auth(&vars, "secure_auth", &opt_secure_auth);
618
static sys_var_const_str_ptr sys_secure_file_priv(&vars, "secure_file_priv",
619
                                             &opt_secure_file_priv);
unknown's avatar
unknown committed
620 621
static sys_var_long_ptr	sys_server_id(&vars, "server_id", &server_id, fix_server_id);
static sys_var_bool_ptr	sys_slave_compressed_protocol(&vars, "slave_compressed_protocol",
622
						      &opt_slave_compressed_protocol);
623 624 625 626 627
static sys_var_set_slave_mode slave_exec_mode(&vars,
                                              "slave_exec_mode",
                                              &slave_exec_mode_options,
                                              &slave_exec_mode_typelib,
                                              0);
unknown's avatar
unknown committed
628
static sys_var_long_ptr	sys_slow_launch_time(&vars, "slow_launch_time",
unknown's avatar
unknown committed
629
					     &slow_launch_time);
unknown's avatar
unknown committed
630
static sys_var_thd_ulong	sys_sort_buffer(&vars, "sort_buffer_size",
unknown's avatar
unknown committed
631
					&SV::sortbuff_size);
632 633 634 635 636 637
/*
  sql_mode should *not* have binlog_mode=SESSION_VARIABLE_IN_BINLOG:
  even though it is written to the binlog, the slave ignores the
  MODE_NO_DIR_IN_CREATE variable, so slave's value differs from
  master's (see log_event.cc: Query_log_event::do_apply_event()).
*/
unknown's avatar
unknown committed
638
static sys_var_thd_sql_mode    sys_sql_mode(&vars, "sql_mode",
639
                                            &SV::sql_mode);
640 641 642
#ifdef HAVE_OPENSSL
extern char *opt_ssl_ca, *opt_ssl_capath, *opt_ssl_cert, *opt_ssl_cipher,
            *opt_ssl_key;
643 644 645 646 647
static sys_var_const_os_str_ptr	sys_ssl_ca(&vars, "ssl_ca", &opt_ssl_ca);
static sys_var_const_os_str_ptr	sys_ssl_capath(&vars, "ssl_capath", &opt_ssl_capath);
static sys_var_const_os_str_ptr	sys_ssl_cert(&vars, "ssl_cert", &opt_ssl_cert);
static sys_var_const_os_str_ptr	sys_ssl_cipher(&vars, "ssl_cipher", &opt_ssl_cipher);
static sys_var_const_os_str_ptr	sys_ssl_key(&vars, "ssl_key", &opt_ssl_key);
648
#else
649 650 651 652 653
static sys_var_const_os_str	sys_ssl_ca(&vars, "ssl_ca", NULL);
static sys_var_const_os_str	sys_ssl_capath(&vars, "ssl_capath", NULL);
static sys_var_const_os_str	sys_ssl_cert(&vars, "ssl_cert", NULL);
static sys_var_const_os_str	sys_ssl_cipher(&vars, "ssl_cipher", NULL);
static sys_var_const_os_str	sys_ssl_key(&vars, "ssl_key", NULL);
654
#endif
unknown's avatar
unknown committed
655 656
static sys_var_thd_enum
sys_updatable_views_with_limit(&vars, "updatable_views_with_limit",
657 658
                               &SV::updatable_views_with_limit,
                               &updatable_views_with_limit_typelib);
unknown's avatar
VIEW  
unknown committed
659

unknown's avatar
unknown committed
660 661 662 663 664 665
static sys_var_thd_table_type  sys_table_type(&vars, "table_type",
				       &SV::table_plugin);
static sys_var_thd_storage_engine sys_storage_engine(&vars, "storage_engine",
				       &SV::table_plugin);
static sys_var_bool_ptr	sys_sync_frm(&vars, "sync_frm", &opt_sync_frm);
static sys_var_const_str	sys_system_time_zone(&vars, "system_time_zone",
666
                                             system_time_zone);
unknown's avatar
unknown committed
667
static sys_var_long_ptr	sys_table_def_size(&vars, "table_definition_cache",
unknown's avatar
unknown committed
668
                                           &table_def_size);
unknown's avatar
unknown committed
669
static sys_var_long_ptr	sys_table_cache_size(&vars, "table_open_cache",
unknown's avatar
unknown committed
670
					     &table_cache_size);
unknown's avatar
unknown committed
671
static sys_var_long_ptr	sys_table_lock_wait_timeout(&vars, "table_lock_wait_timeout",
672
                                                    &table_lock_wait_timeout);
673 674 675 676 677 678

#if defined(ENABLED_DEBUG_SYNC)
/* Debug Sync Facility. Implemented in debug_sync.cc. */
static sys_var_debug_sync sys_debug_sync(&vars, "debug_sync");
#endif /* defined(ENABLED_DEBUG_SYNC) */

unknown's avatar
unknown committed
679
static sys_var_long_ptr	sys_thread_cache_size(&vars, "thread_cache_size",
unknown's avatar
unknown committed
680
					      &thread_cache_size);
unknown's avatar
unknown committed
681
#if HAVE_POOL_OF_THREADS == 1
682 683
static sys_var_long_ptr sys_thread_pool_size(&vars, "thread_pool_size",
                                             &thread_pool_size);
unknown's avatar
unknown committed
684
#endif
unknown's avatar
unknown committed
685
static sys_var_thd_enum	sys_tx_isolation(&vars, "tx_isolation",
unknown's avatar
unknown committed
686 687
					 &SV::tx_isolation,
					 &tx_isolation_typelib,
688 689
					 fix_tx_isolation,
					 check_tx_isolation);
unknown's avatar
unknown committed
690
static sys_var_thd_ulonglong	sys_tmp_table_size(&vars, "tmp_table_size",
unknown's avatar
unknown committed
691
					   &SV::tmp_table_size);
unknown's avatar
unknown committed
692
static sys_var_bool_ptr  sys_timed_mutexes(&vars, "timed_mutexes",
unknown's avatar
unknown committed
693
                                    &timed_mutexes);
unknown's avatar
unknown committed
694 695
static sys_var_const_str	sys_version(&vars, "version", server_version);
static sys_var_const_str	sys_version_comment(&vars, "version_comment",
696
                                            MYSQL_COMPILATION_COMMENT);
unknown's avatar
unknown committed
697
static sys_var_const_str	sys_version_compile_machine(&vars, "version_compile_machine",
698
                                                    MACHINE_TYPE);
unknown's avatar
unknown committed
699
static sys_var_const_str	sys_version_compile_os(&vars, "version_compile_os",
700
                                               SYSTEM_TYPE);
unknown's avatar
unknown committed
701
static sys_var_thd_ulong	sys_net_wait_timeout(&vars, "wait_timeout",
unknown's avatar
unknown committed
702
					     &SV::net_wait_timeout);
unknown's avatar
unknown committed
703

unknown's avatar
unknown committed
704
/* Condition pushdown to storage engine */
unknown's avatar
unknown committed
705 706
static sys_var_thd_bool
sys_engine_condition_pushdown(&vars, "engine_condition_pushdown",
unknown's avatar
unknown committed
707 708
			      &SV::engine_condition_pushdown);

709
#ifdef WITH_NDBCLUSTER_STORAGE_ENGINE
710
/* ndb thread specific variable settings */
unknown's avatar
unknown committed
711 712
static sys_var_thd_ulong
sys_ndb_autoincrement_prefetch_sz(&vars, "ndb_autoincrement_prefetch_sz",
713
				  &SV::ndb_autoincrement_prefetch_sz);
unknown's avatar
unknown committed
714 715
static sys_var_thd_bool
sys_ndb_force_send(&vars, "ndb_force_send", &SV::ndb_force_send);
unknown's avatar
unknown committed
716
#ifdef HAVE_NDB_BINLOG
unknown's avatar
unknown committed
717 718
static sys_var_long_ptr
sys_ndb_report_thresh_binlog_epoch_slip(&vars, "ndb_report_thresh_binlog_epoch_slip",
unknown's avatar
unknown committed
719
                                        &ndb_report_thresh_binlog_epoch_slip);
unknown's avatar
unknown committed
720 721
static sys_var_long_ptr
sys_ndb_report_thresh_binlog_mem_usage(&vars, "ndb_report_thresh_binlog_mem_usage",
unknown's avatar
unknown committed
722 723
                                       &ndb_report_thresh_binlog_mem_usage);
#endif
unknown's avatar
unknown committed
724 725 726 727 728 729
static sys_var_thd_bool
sys_ndb_use_exact_count(&vars, "ndb_use_exact_count", &SV::ndb_use_exact_count);
static sys_var_thd_bool
sys_ndb_use_transactions(&vars, "ndb_use_transactions", &SV::ndb_use_transactions);
static sys_var_long_ptr
sys_ndb_cache_check_time(&vars, "ndb_cache_check_time", &ndb_cache_check_time);
730 731
static sys_var_const_str
sys_ndb_connectstring(&vars, "ndb_connectstring", opt_ndb_constrbuf);
unknown's avatar
unknown committed
732 733
static sys_var_thd_bool
sys_ndb_index_stat_enable(&vars, "ndb_index_stat_enable",
734
                          &SV::ndb_index_stat_enable);
unknown's avatar
unknown committed
735 736
static sys_var_thd_ulong
sys_ndb_index_stat_cache_entries(&vars, "ndb_index_stat_cache_entries",
737
                                 &SV::ndb_index_stat_cache_entries);
unknown's avatar
unknown committed
738 739
static sys_var_thd_ulong
sys_ndb_index_stat_update_freq(&vars, "ndb_index_stat_update_freq",
740
                               &SV::ndb_index_stat_update_freq);
unknown's avatar
unknown committed
741 742 743 744
static sys_var_long_ptr
sys_ndb_extra_logging(&vars, "ndb_extra_logging", &ndb_extra_logging);
static sys_var_thd_bool
sys_ndb_use_copying_alter_table(&vars, "ndb_use_copying_alter_table", &SV::ndb_use_copying_alter_table);
745
#endif //WITH_NDBCLUSTER_STORAGE_ENGINE
746 747 748

/* Time/date/datetime formats */

unknown's avatar
unknown committed
749
static sys_var_thd_date_time_format sys_time_format(&vars, "time_format",
750
					     &SV::time_format,
751
					     MYSQL_TIMESTAMP_TIME);
unknown's avatar
unknown committed
752
static sys_var_thd_date_time_format sys_date_format(&vars, "date_format",
753
					     &SV::date_format,
754
					     MYSQL_TIMESTAMP_DATE);
unknown's avatar
unknown committed
755
static sys_var_thd_date_time_format sys_datetime_format(&vars, "datetime_format",
756
						 &SV::datetime_format,
757
						 MYSQL_TIMESTAMP_DATETIME);
758 759

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

unknown's avatar
unknown committed
761
sys_var_thd_bit sys_autocommit(&vars, "autocommit", 0,
762 763 764
                               set_option_autocommit,
                               OPTION_NOT_AUTOCOMMIT,
                               1);
unknown's avatar
unknown committed
765
static sys_var_thd_bit	sys_big_tables(&vars, "big_tables", 0,
unknown's avatar
unknown committed
766 767 768
				       set_option_bit,
				       OPTION_BIG_TABLES);
#ifndef TO_BE_DELETED	/* Alias for big_tables */
unknown's avatar
unknown committed
769
static sys_var_thd_bit	sys_sql_big_tables(&vars, "sql_big_tables", 0,
unknown's avatar
unknown committed
770 771 772
					   set_option_bit,
					   OPTION_BIG_TABLES);
#endif
unknown's avatar
unknown committed
773
static sys_var_thd_bit	sys_big_selects(&vars, "sql_big_selects", 0,
unknown's avatar
unknown committed
774
					set_option_bit,
775
					OPTION_BIG_SELECTS);
unknown's avatar
unknown committed
776
static sys_var_thd_bit	sys_log_off(&vars, "sql_log_off",
777
				    check_log_update,
unknown's avatar
unknown committed
778 779
				    set_option_bit,
				    OPTION_LOG_OFF);
unknown's avatar
unknown committed
780
static sys_var_thd_bit	sys_log_update(&vars, "sql_log_update",
781
                                       check_log_update,
unknown's avatar
unknown committed
782
				       set_log_update,
783
				       OPTION_BIN_LOG);
unknown's avatar
unknown committed
784
static sys_var_thd_bit	sys_log_binlog(&vars, "sql_log_bin",
785
                                       check_log_update,
786
                                       set_option_log_bin_bit,
787
				       OPTION_BIN_LOG);
unknown's avatar
unknown committed
788
static sys_var_thd_bit	sys_sql_warnings(&vars, "sql_warnings", 0,
unknown's avatar
unknown committed
789 790
					 set_option_bit,
					 OPTION_WARNINGS);
unknown's avatar
unknown committed
791
static sys_var_thd_bit	sys_sql_notes(&vars, "sql_notes", 0,
792
					 set_option_bit,
793
					 OPTION_SQL_NOTES);
unknown's avatar
unknown committed
794
static sys_var_thd_bit	sys_auto_is_null(&vars, "sql_auto_is_null", 0,
unknown's avatar
unknown committed
795
					 set_option_bit,
796 797
                                         OPTION_AUTO_IS_NULL, 0,
                                         sys_var::SESSION_VARIABLE_IN_BINLOG);
unknown's avatar
unknown committed
798
static sys_var_thd_bit	sys_safe_updates(&vars, "sql_safe_updates", 0,
unknown's avatar
unknown committed
799 800
					 set_option_bit,
					 OPTION_SAFE_UPDATES);
unknown's avatar
unknown committed
801
static sys_var_thd_bit	sys_buffer_results(&vars, "sql_buffer_result", 0,
unknown's avatar
unknown committed
802 803
					   set_option_bit,
					   OPTION_BUFFER_RESULT);
unknown's avatar
unknown committed
804
static sys_var_thd_bit	sys_quote_show_create(&vars, "sql_quote_show_create", 0,
unknown's avatar
unknown committed
805 806
					      set_option_bit,
					      OPTION_QUOTE_SHOW_CREATE);
unknown's avatar
unknown committed
807
static sys_var_thd_bit	sys_foreign_key_checks(&vars, "foreign_key_checks", 0,
808 809
					       set_option_bit,
					       OPTION_NO_FOREIGN_KEY_CHECKS,
810
                                               1, sys_var::SESSION_VARIABLE_IN_BINLOG);
unknown's avatar
unknown committed
811
static sys_var_thd_bit	sys_unique_checks(&vars, "unique_checks", 0,
812 813
					  set_option_bit,
					  OPTION_RELAXED_UNIQUE_CHECKS,
814 815
                                          1,
                                          sys_var::SESSION_VARIABLE_IN_BINLOG);
816
#if defined(ENABLED_PROFILING) && defined(COMMUNITY_SERVER)
817 818
static sys_var_thd_bit  sys_profiling(&vars, "profiling", NULL, 
                                      set_option_bit,
819
                                      ulonglong(OPTION_PROFILING));
820
static sys_var_thd_ulong	sys_profiling_history_size(&vars, "profiling_history_size",
821 822
					      &SV::profiling_history_size);
#endif
823

unknown's avatar
unknown committed
824 825
/* Local state variables */

unknown's avatar
unknown committed
826
static sys_var_thd_ha_rows	sys_select_limit(&vars, "sql_select_limit",
unknown's avatar
unknown committed
827
						 &SV::select_limit);
828 829 830 831 832 833 834 835 836 837 838
static sys_var_timestamp sys_timestamp(&vars, "timestamp",
                                       sys_var::SESSION_VARIABLE_IN_BINLOG);
static sys_var_last_insert_id
sys_last_insert_id(&vars, "last_insert_id",
                   sys_var::SESSION_VARIABLE_IN_BINLOG);
/*
  identity is an alias for last_insert_id(), so that we are compatible
  with Sybase
*/
static sys_var_last_insert_id
sys_identity(&vars, "identity", sys_var::SESSION_VARIABLE_IN_BINLOG);
unknown's avatar
unknown committed
839

840 841
static sys_var_thd_lc_time_names
sys_lc_time_names(&vars, "lc_time_names", sys_var::SESSION_VARIABLE_IN_BINLOG);
unknown's avatar
unknown committed
842

843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860 861 862
/*
  insert_id should *not* be marked as written to the binlog (i.e., it
  should *not* have binlog_status==SESSION_VARIABLE_IN_BINLOG),
  because we want any statement that refers to insert_id explicitly to
  be unsafe.  (By "explicitly", we mean using @@session.insert_id,
  whereas insert_id is used "implicitly" when NULL value is inserted
  into an auto_increment column).

  We want statements referring explicitly to @@session.insert_id to be
  unsafe, because insert_id is modified internally by the slave sql
  thread when NULL values are inserted in an AUTO_INCREMENT column.
  This modification interfers with the value of the
  @@session.insert_id variable if @@session.insert_id is referred
  explicitly by an insert statement (as is seen by executing "SET
  @@session.insert_id=0; CREATE TABLE t (a INT, b INT KEY
  AUTO_INCREMENT); INSERT INTO t(a) VALUES (@@session.insert_id);" in
  statement-based logging mode: t will be different on master and
  slave).
*/
static sys_var_insert_id sys_insert_id(&vars, "insert_id");
unknown's avatar
unknown committed
863
static sys_var_readonly		sys_error_count(&vars, "error_count",
864 865 866
						OPT_SESSION,
						SHOW_LONG,
						get_error_count);
unknown's avatar
unknown committed
867
static sys_var_readonly		sys_warning_count(&vars, "warning_count",
868 869 870 871
						  OPT_SESSION,
						  SHOW_LONG,
						  get_warning_count);

872 873 874 875
static sys_var_rand_seed1 sys_rand_seed1(&vars, "rand_seed1",
                                         sys_var::SESSION_VARIABLE_IN_BINLOG);
static sys_var_rand_seed2 sys_rand_seed2(&vars, "rand_seed2",
                                         sys_var::SESSION_VARIABLE_IN_BINLOG);
unknown's avatar
unknown committed
876

unknown's avatar
unknown committed
877
static sys_var_thd_ulong        sys_default_week_format(&vars, "default_week_format",
878
					                &SV::default_week_format);
unknown's avatar
unknown committed
879

unknown's avatar
unknown committed
880
sys_var_thd_ulong               sys_group_concat_max_len(&vars, "group_concat_max_len",
unknown's avatar
unknown committed
881 882
                                                         &SV::group_concat_max_len);

883 884
sys_var_thd_time_zone sys_time_zone(&vars, "time_zone",
                                    sys_var::SESSION_VARIABLE_IN_BINLOG);
885

886 887 888 889 890 891 892 893 894 895 896 897 898 899
/* Unique variables for MariaDB */
static sys_var_thd_ulong  sys_log_slow_rate_limit(&vars,
                                                  "log_slow_rate_limit",
                                                  &SV::log_slow_rate_limit);
static sys_var_thd_set sys_log_slow_filter(&vars, "log_slow_filter",
                                           &SV::log_slow_filter,
                                           &log_slow_filter_typelib,
                                           QPLAN_VISIBLE_MASK,
                                           fix_sys_log_slow_filter);
static sys_var_thd_set sys_log_slow_verbosity(&vars,
                                              "log_slow_verbosity",
                                              &SV::log_slow_verbosity,
                                              &log_slow_verbosity_typelib);

900 901
/* Global read-only variable containing hostname */
static sys_var_const_str        sys_hostname(&vars, "hostname", glob_hostname);
902 903
static sys_var_const_str_ptr    sys_log_basename(&vars, "log_basename",
                                                 &opt_log_basename);
904 905

#ifndef EMBEDDED_LIBRARY
906 907 908 909 910 911 912 913 914 915
static sys_var_const_str_ptr    sys_repl_report_host(&vars, "report_host", &report_host);
static sys_var_const_str_ptr    sys_repl_report_user(&vars, "report_user", &report_user);
static sys_var_const_str_ptr    sys_repl_report_password(&vars, "report_password", &report_password);

static uchar *slave_get_report_port(THD *thd)
{
  thd->sys_var_tmp.long_value= report_port;
  return (uchar*) &thd->sys_var_tmp.long_value;
}

unknown's avatar
unknown committed
916
static sys_var_readonly    sys_repl_report_port(&vars, "report_port", OPT_GLOBAL, SHOW_LONG, slave_get_report_port);
917

918
#endif
919

920
sys_var_thd_bool  sys_keep_files_on_create(&vars, "keep_files_on_create", 
unknown's avatar
unknown committed
921
                                           &SV::keep_files_on_create);
922 923
/* Read only variables */

unknown's avatar
unknown committed
924 925 926 927 928 929 930
static sys_var_have_variable sys_have_compress(&vars, "have_compress", &have_compress);
static sys_var_have_variable sys_have_crypt(&vars, "have_crypt", &have_crypt);
static sys_var_have_plugin sys_have_csv(&vars, "have_csv", C_STRING_WITH_LEN("csv"), MYSQL_STORAGE_ENGINE_PLUGIN);
static sys_var_have_variable sys_have_dlopen(&vars, "have_dynamic_loading", &have_dlopen);
static sys_var_have_variable sys_have_geometry(&vars, "have_geometry", &have_geometry);
static sys_var_have_plugin sys_have_innodb(&vars, "have_innodb", C_STRING_WITH_LEN("innodb"), MYSQL_STORAGE_ENGINE_PLUGIN);
static sys_var_have_plugin sys_have_ndbcluster(&vars, "have_ndbcluster", C_STRING_WITH_LEN("ndbcluster"), MYSQL_STORAGE_ENGINE_PLUGIN);
unknown's avatar
unknown committed
931 932
static sys_var_have_variable sys_have_openssl(&vars, "have_openssl", &have_ssl);
static sys_var_have_variable sys_have_ssl(&vars, "have_ssl", &have_ssl);
unknown's avatar
unknown committed
933 934
static sys_var_have_plugin sys_have_partition_db(&vars, "have_partitioning", C_STRING_WITH_LEN("partition"), MYSQL_STORAGE_ENGINE_PLUGIN);
static sys_var_have_variable sys_have_query_cache(&vars, "have_query_cache",
unknown's avatar
unknown committed
935
                                           &have_query_cache);
936
static sys_var_have_variable sys_have_community_features(&vars, "have_community_features", &have_community_features);
unknown's avatar
unknown committed
937 938
static sys_var_have_variable sys_have_rtree_keys(&vars, "have_rtree_keys", &have_rtree_keys);
static sys_var_have_variable sys_have_symlink(&vars, "have_symlink", &have_symlink);
939
/* Global read-only variable describing server license */
unknown's avatar
unknown committed
940
static sys_var_const_str	sys_license(&vars, "license", STRINGIFY_ARG(LICENSE));
941
/* Global variables which enable|disable logging */
unknown's avatar
unknown committed
942
static sys_var_log_state sys_var_general_log(&vars, "general_log", &opt_log,
943
                                      QUERY_LOG_GENERAL);
944 945 946
/* Synonym of "general_log" for consistency with SHOW VARIABLES output */
static sys_var_log_state sys_var_log(&vars, "log", &opt_log,
                                      QUERY_LOG_GENERAL);
unknown's avatar
unknown committed
947
static sys_var_log_state sys_var_slow_query_log(&vars, "slow_query_log", &opt_slow_log,
948
                                         QUERY_LOG_SLOW);
949 950 951
/* Synonym of "slow_query_log" for consistency with SHOW VARIABLES output */
static sys_var_log_state sys_var_log_slow(&vars, "log_slow_queries",
                                          &opt_slow_log, QUERY_LOG_SLOW);
unknown's avatar
unknown committed
952
sys_var_str sys_var_general_log_path(&vars, "general_log_file", sys_check_log_path,
953 954 955
				     sys_update_general_log_path,
				     sys_default_general_log_path,
				     opt_logname);
unknown's avatar
unknown committed
956
sys_var_str sys_var_slow_log_path(&vars, "slow_query_log_file", sys_check_log_path,
957 958 959
				  sys_update_slow_log_path, 
				  sys_default_slow_log_path,
				  opt_slow_logname);
unknown's avatar
unknown committed
960
static sys_var_log_output sys_var_log_output_state(&vars, "log_output", &log_output_options,
961
					    &log_output_typelib, 0);
962 963 964 965
static sys_var_readonly         sys_myisam_mmap_size(&vars, "myisam_mmap_size",
                                                     OPT_GLOBAL,
                                                     SHOW_LONGLONG,
                                                     get_myisam_mmap_size);
966

967 968 969
static sys_var_enum_const     sys_plugin_maturity(&vars, "plugin_maturity",
                                                  &plugin_maturity,
                                                  &plugin_maturity_values);
970

971 972 973 974 975 976
bool sys_var::check(THD *thd, set_var *var)
{
  var->save_result.ulonglong_value= var->value->val_int();
  return 0;
}

977 978 979 980 981 982 983
bool sys_var_str::check(THD *thd, set_var *var)
{
  int res;
  if (!check_func)
    return 0;

  if ((res=(*check_func)(thd, var)) < 0)
984
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0),
985
             name, var->value->str_value.c_ptr());
986 987 988
  return res;
}

unknown's avatar
unknown committed
989 990 991 992
/*
  Functions to check and update variables
*/

unknown's avatar
unknown committed
993

994 995 996 997 998 999 1000 1001 1002 1003
/*
  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
1004
{
1005 1006 1007 1008
  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*) "";
1009
  if (!(res= my_strndup(old_value, new_length, MYF(0))))
1010
    return 1;
unknown's avatar
unknown committed
1011 1012 1013 1014
  /*
    Replace the old value in such a way that the any thread using
    the value will work.
  */
1015 1016 1017 1018
  rw_wrlock(var_mutex);
  old_value= var_str->value;
  var_str->value= res;
  var_str->value_length= new_length;
1019
  var_str->is_os_charset= FALSE;
1020
  rw_unlock(var_mutex);
unknown's avatar
unknown committed
1021 1022 1023 1024 1025
  my_free(old_value, MYF(MY_ALLOW_ZERO_PTR));
  return 0;
}


1026 1027 1028 1029 1030 1031
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
1032 1033
static void sys_default_init_connect(THD* thd, enum_var_type type)
{
1034
  update_sys_var_str(&sys_init_connect, &LOCK_sys_init_connect, 0);
unknown's avatar
unknown committed
1035 1036 1037 1038 1039
}


static bool sys_update_init_slave(THD *thd, set_var *var)
{
1040
  return update_sys_var_str(&sys_init_slave, &LOCK_sys_init_slave, var);
unknown's avatar
unknown committed
1041 1042 1043 1044 1045
}


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

1049 1050
static int sys_check_ftb_syntax(THD *thd,  set_var *var)
{
1051
  if (thd->security_ctx->master_access & SUPER_ACL)
1052
    return (ft_boolean_check_syntax_string((uchar*)
1053 1054
                                           var->value->str_value.c_ptr()) ?
            -1 : 0);
1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065
  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);
1066 1067 1068 1069 1070

#ifdef HAVE_QUERY_CACHE
  query_cache.flush();
#endif /* HAVE_QUERY_CACHE */

1071 1072 1073 1074 1075
  return 0;
}

static void sys_default_ftb_syntax(THD *thd, enum_var_type type)
{
1076
  strmake(ft_boolean_syntax, def_ft_boolean_syntax,
1077 1078
	  sizeof(ft_boolean_syntax)-1);
}
unknown's avatar
unknown committed
1079

unknown's avatar
unknown committed
1080

unknown's avatar
unknown committed
1081
/**
unknown's avatar
unknown committed
1082
  If one sets the LOW_PRIORIY UPDATES flag, we also must change the
unknown's avatar
unknown committed
1083
  used lock type.
unknown's avatar
unknown committed
1084 1085 1086 1087
*/

static void fix_low_priority_updates(THD *thd, enum_var_type type)
{
1088 1089 1090 1091 1092
  if (type == OPT_GLOBAL)
    thr_upgraded_concurrent_insert_lock= 
      (global_system_variables.low_priority_updates ?
       TL_WRITE_LOW_PRIORITY : TL_WRITE);
  else
unknown's avatar
unknown committed
1093 1094 1095 1096 1097
    thd->update_lock_default= (thd->variables.low_priority_updates ?
			       TL_WRITE_LOW_PRIORITY : TL_WRITE);
}


1098 1099 1100 1101 1102 1103 1104
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
1105 1106
/**
  Set the OPTION_BIG_SELECTS flag if max_join_size == HA_POS_ERROR.
unknown's avatar
unknown committed
1107 1108 1109 1110 1111 1112
*/

static void fix_max_join_size(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
  {
1113
    if (thd->variables.max_join_size == HA_POS_ERROR)
unknown's avatar
unknown committed
1114 1115 1116 1117 1118
      thd->options|= OPTION_BIG_SELECTS;
    else
      thd->options&= ~OPTION_BIG_SELECTS;
  }
}
1119

unknown's avatar
unknown committed
1120

unknown's avatar
unknown committed
1121
/**
1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134
  Can't change the 'next' tx_isolation while we are already in
  a transaction
*/
static int check_tx_isolation(THD *thd, set_var *var)
{
  if (var->type == OPT_DEFAULT && (thd->server_status & SERVER_STATUS_IN_TRANS))
  {
    my_error(ER_CANT_CHANGE_TX_ISOLATION, MYF(0));
    return 1;
  }
  return 0;
}

unknown's avatar
unknown committed
1135 1136
/*
  If one doesn't use the SESSION modifier, the isolation level
unknown's avatar
unknown committed
1137
  is only active for the next command.
unknown's avatar
unknown committed
1138 1139 1140 1141 1142 1143 1144 1145
*/
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);
}

1146 1147
static void fix_completion_type(THD *thd __attribute__((unused)),
				enum_var_type type __attribute__((unused))) {}
unknown's avatar
unknown committed
1148 1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160

static int check_completion_type(THD *thd, set_var *var)
{
  longlong val= var->value->val_int();
  if (val < 0 || val > 2)
  {
    char buf[64];
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), var->var->name, llstr(val, buf));
    return 1;
  }
  return 0;
}

unknown's avatar
unknown committed
1161 1162 1163 1164 1165

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

unknown's avatar
SCRUM  
unknown committed
1166
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
1167 1168 1169
static void fix_net_read_timeout(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
1170
    my_net_set_read_timeout(&thd->net, thd->variables.net_read_timeout);
unknown's avatar
unknown committed
1171 1172 1173 1174 1175 1176
}


static void fix_net_write_timeout(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
1177
    my_net_set_write_timeout(&thd->net, thd->variables.net_write_timeout);
unknown's avatar
unknown committed
1178 1179
}

1180 1181 1182 1183 1184
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
1185
#else /* HAVE_REPLICATION */
1186 1187
static void fix_net_read_timeout(THD *thd __attribute__((unused)),
				 enum_var_type type __attribute__((unused)))
1188
{}
1189 1190
static void fix_net_write_timeout(THD *thd __attribute__((unused)),
				  enum_var_type type __attribute__((unused)))
1191
{}
1192 1193
static void fix_net_retry_count(THD *thd __attribute__((unused)),
				enum_var_type type __attribute__((unused)))
1194
{}
unknown's avatar
SCRUM  
unknown committed
1195
#endif /* HAVE_REPLICATION */
1196

unknown's avatar
unknown committed
1197 1198 1199 1200

static void fix_query_cache_size(THD *thd, enum_var_type type)
{
#ifdef HAVE_QUERY_CACHE
1201 1202 1203 1204 1205 1206 1207 1208
  ulong new_cache_size= query_cache.resize(query_cache_size);

  /*
     Note: query_cache_size is a global variable reflecting the 
     requested cache size. See also query_cache_size_arg
  */

  if (query_cache_size != new_cache_size)
1209 1210
    push_warning_printf(current_thd, MYSQL_ERROR::WARN_LEVEL_WARN,
			ER_WARN_QC_RESIZE, ER(ER_WARN_QC_RESIZE),
1211 1212 1213
			query_cache_size, new_cache_size);
  
  query_cache_size= new_cache_size;
unknown's avatar
unknown committed
1214 1215 1216 1217
#endif
}


1218 1219 1220 1221 1222 1223 1224 1225 1226
#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


1227
extern void fix_delay_key_write(THD *thd, enum_var_type type)
1228 1229 1230 1231
{
  switch ((enum_delay_key_write) delay_key_write_options) {
  case DELAY_KEY_WRITE_NONE:
    myisam_delay_key_write=0;
Sergei Golubchik's avatar
Sergei Golubchik committed
1232
#ifdef WITH_ARIA_STORAGE_ENGINE
1233 1234 1235
    maria_delay_key_write= 0;
#endif
    ha_open_options&= ~HA_OPEN_DELAY_KEY_WRITE;
1236 1237 1238
    break;
  case DELAY_KEY_WRITE_ON:
    myisam_delay_key_write=1;
Sergei Golubchik's avatar
Sergei Golubchik committed
1239
#ifdef WITH_ARIA_STORAGE_ENGINE
1240 1241 1242
    maria_delay_key_write= 1;
#endif
    ha_open_options&= ~HA_OPEN_DELAY_KEY_WRITE;
1243 1244 1245
    break;
  case DELAY_KEY_WRITE_ALL:
    myisam_delay_key_write=1;
Sergei Golubchik's avatar
Sergei Golubchik committed
1246
#ifdef WITH_ARIA_STORAGE_ENGINE
1247 1248
    maria_delay_key_write= 1;
#endif
1249 1250 1251 1252 1253
    ha_open_options|= HA_OPEN_DELAY_KEY_WRITE;
    break;
  }
}

1254 1255 1256 1257
bool sys_var_set::update(THD *thd, set_var *var)
{
  *value= var->save_result.ulong_value;
  return 0;
1258
}
1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285

uchar *sys_var_set::value_ptr(THD *thd, enum_var_type type,
                              LEX_STRING *base)
{
  char buff[256];
  String tmp(buff, sizeof(buff), &my_charset_latin1);
  ulong length;
  ulong val= *value;

  tmp.length(0);
  for (uint i= 0; val; val>>= 1, i++)
  {
    if (val & 1)
    {
      tmp.append(enum_names->type_names[i],
                 enum_names->type_lengths[i]);
      tmp.append(',');
    }
  }

  if ((length= tmp.length()))
    length--;
  return (uchar*) thd->strmake(tmp.ptr(), length);
}

void sys_var_set_slave_mode::set_default(THD *thd, enum_var_type type)
{
1286
  slave_exec_mode_options= SLAVE_EXEC_MODE_STRICT;
1287 1288 1289 1290 1291 1292
}

bool sys_var_set_slave_mode::check(THD *thd, set_var *var)
{
  bool rc=  sys_var_set::check(thd, var);
  if (!rc &&
1293
      test_all_bits(var->save_result.ulong_value,
Michael Widenius's avatar
Michael Widenius committed
1294
                    SLAVE_EXEC_MODE_STRICT | SLAVE_EXEC_MODE_IDEMPOTENT))
1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 1305 1306 1307 1308 1309 1310
  {
    rc= true;
    my_error(ER_SLAVE_AMBIGOUS_EXEC_MODE, MYF(0), "");
  }
  return rc;
}

bool sys_var_set_slave_mode::update(THD *thd, set_var *var)
{
  bool rc;
  pthread_mutex_lock(&LOCK_global_system_variables);
  rc= sys_var_set::update(thd, var);
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return rc;
}

1311
void fix_slave_exec_mode(void)
1312 1313
{
  DBUG_ENTER("fix_slave_exec_mode");
1314

1315
  if (test_all_bits(slave_exec_mode_options,
Michael Widenius's avatar
Michael Widenius committed
1316
                    SLAVE_EXEC_MODE_STRICT | SLAVE_EXEC_MODE_IDEMPOTENT))
1317
  {
1318 1319
    sql_print_error("Ambiguous slave modes combination. STRICT will be used");
    slave_exec_mode_options&= ~SLAVE_EXEC_MODE_IDEMPOTENT;
1320
  }
1321 1322
  if (!(slave_exec_mode_options & SLAVE_EXEC_MODE_IDEMPOTENT))
    slave_exec_mode_options|= SLAVE_EXEC_MODE_STRICT;
unknown's avatar
unknown committed
1323
  DBUG_VOID_RETURN;
1324
}
1325

Mats Kindahl's avatar
Mats Kindahl committed
1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340

bool sys_var_thd_binlog_format::check(THD *thd, set_var *var) {
  /*
    All variables that affect writing to binary log (either format or
    turning logging on and off) use the same checking. We call the
    superclass ::check function to assign the variable correctly, and
    then check the value.
   */
  bool result= sys_var_thd_enum::check(thd, var);
  if (!result)
    result= check_log_update(thd, var);
  return result;
}


1341 1342 1343 1344 1345 1346 1347 1348 1349 1350 1351 1352 1353
bool sys_var_thd_binlog_format::is_readonly() const
{
  /*
    Under certain circumstances, the variable is read-only (unchangeable):
  */
  THD *thd= current_thd;
  /*
    If RBR and open temporary tables, their CREATE TABLE may not be in the
    binlog, so we can't toggle to SBR in this connection.
    The test below will also prevent SET GLOBAL, well it was not easy to test
    if global or not here.
    And this test will also prevent switching from RBR to RBR (a no-op which
    should not happen too often).
1354 1355 1356

    If we don't have row-based replication compiled in, the variable
    is always read-only.
1357 1358 1359 1360 1361 1362 1363 1364
  */
  if ((thd->variables.binlog_format == BINLOG_FORMAT_ROW) &&
      thd->temporary_tables)
  {
    my_error(ER_TEMP_TABLE_PREVENTS_SWITCH_OUT_OF_RBR, MYF(0));
    return 1;
  }
  /*
unknown's avatar
unknown committed
1365
    if in a stored function/trigger, it's too late to change mode
1366
  */
unknown's avatar
unknown committed
1367
  if (thd->in_sub_stmt)
1368 1369
  {
    my_error(ER_STORED_FUNCTION_PREVENTS_SWITCH_BINLOG_FORMAT, MYF(0));
unknown's avatar
unknown committed
1370
    return 1;
1371 1372 1373 1374
  }
  return sys_var_thd_enum::is_readonly();
}

unknown's avatar
unknown committed
1375

1376 1377 1378 1379 1380 1381
void fix_binlog_format_after_update(THD *thd, enum_var_type type)
{
  thd->reset_current_stmt_binlog_row_based();
}


1382
static void fix_max_binlog_size(THD *thd, enum_var_type type)
1383 1384 1385 1386 1387
{
  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);
1388
#ifdef HAVE_REPLICATION
1389 1390
  if (!max_relay_log_size)
    active_mi->rli.relay_log.set_max_size(max_binlog_size);
unknown's avatar
unknown committed
1391
#endif
1392 1393 1394
  DBUG_VOID_RETURN;
}

1395
static void fix_max_relay_log_size(THD *thd, enum_var_type type)
1396 1397 1398 1399
{
  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));
1400
#ifdef HAVE_REPLICATION
1401 1402
  active_mi->rli.relay_log.set_max_size(max_relay_log_size ?
                                        max_relay_log_size: max_binlog_size);
1403
#endif
1404 1405
  DBUG_VOID_RETURN;
}
1406

1407

1408 1409
static int check_max_delayed_threads(THD *thd, set_var *var)
{
unknown's avatar
unknown committed
1410
  longlong val= var->value->val_int();
1411
  if (var->type != OPT_GLOBAL && val != 0 &&
unknown's avatar
unknown committed
1412
      val != (longlong) global_system_variables.max_insert_delayed_threads)
1413 1414
  {
    char buf[64];
1415
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), var->var->name, llstr(val, buf));
1416 1417 1418 1419 1420
    return 1;
  }
  return 0;
}

1421
static void fix_max_connections(THD *thd, enum_var_type type)
1422
{
1423
#ifndef EMBEDDED_LIBRARY
1424
  resize_thr_alarm(max_connections + extra_max_connections +
1425
		   global_system_variables.max_insert_delayed_threads + 10);
1426
#endif
1427 1428 1429 1430 1431 1432
}


static void fix_thd_mem_root(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
unknown's avatar
unknown committed
1433
    reset_root_defaults(thd->mem_root,
1434 1435 1436 1437 1438 1439 1440
                        thd->variables.query_alloc_block_size,
                        thd->variables.query_prealloc_size);
}


static void fix_trans_mem_root(THD *thd, enum_var_type type)
{
1441
#ifdef USING_TRANSACTIONS
1442 1443 1444 1445
  if (type != OPT_GLOBAL)
    reset_root_defaults(&thd->transaction.mem_root,
                        thd->variables.trans_alloc_block_size,
                        thd->variables.trans_prealloc_size);
1446
#endif
1447 1448
}

1449

1450 1451 1452
static void fix_server_id(THD *thd, enum_var_type type)
{
  server_id_supplied = 1;
1453
  thd->server_id= server_id;
1454
}
1455

1456

1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469
/**
  Throw warning (error in STRICT mode) if value for variable needed bounding.
  Only call from check(), not update(), because an error in update() would be
  bad mojo. Plug-in interface also uses this.

  @param thd      thread handle
  @param fixed    did we have to correct the value? (throw warn/err if so)
  @param unsignd  is value's type unsigned?
  @param name     variable's name
  @param val      variable's value

  @retval         TRUE on error, FALSE otherwise (warning or OK)
 */
1470 1471
bool throw_bounds_warning(THD *thd, bool fixed, bool unsignd,
                          const char *name, longlong val)
1472
{
1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492
  if (fixed)
  {
    char buf[22];

    if (unsignd)
      ullstr((ulonglong) val, buf);
    else
      llstr(val, buf);

    if (thd->variables.sql_mode & MODE_STRICT_ALL_TABLES)
    {
      my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, buf);
      return TRUE;
    }

    push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_WARN,
                        ER_TRUNCATED_WRONG_VALUE,
                        ER(ER_TRUNCATED_WRONG_VALUE), name, buf);
  }
  return FALSE;
1493 1494
}

1495 1496 1497 1498

/**
  Get unsigned system-variable.
  Negative value does not wrap around, but becomes zero.
1499 1500 1501
  Check user-supplied value for a systemvariable against bounds.
  If we needed to adjust the value, throw a warning or error depending
  on SQL-mode.
1502

1503 1504 1505
  @param thd             thread handle
  @param var             the system-variable to get
  @param user_max        a limit given with --maximum-variable-name=... or 0
1506
  @param var_type        function will bound on systems where necessary.
1507

1508
  @retval                TRUE on error, FALSE otherwise (warning or OK)
1509
 */
1510
static bool get_unsigned(THD *thd, set_var *var, ulonglong user_max,
1511
                         ulong var_type)
1512
{
1513 1514 1515
  int                     warnings= 0;
  ulonglong               unadjusted;
  const struct my_option *limits= var->var->option_limits;
1516
  struct my_option        fallback;
1517 1518

  /* get_unsigned() */
1519 1520 1521 1522 1523 1524
  if (var->value->unsigned_flag)
    var->save_result.ulonglong_value= (ulonglong) var->value->val_int();
  else
  {
    longlong v= var->value->val_int();
    var->save_result.ulonglong_value= (ulonglong) ((v < 0) ? 0 : v);
1525
    if (v < 0)
1526 1527 1528 1529 1530
    {
      warnings++;
      if (throw_bounds_warning(thd, TRUE, FALSE, var->var->name, v))
        return TRUE;  /* warning was promoted to error, give up */
    }
1531 1532
  }

1533
  unadjusted= var->save_result.ulonglong_value;
1534

1535
  /* max, if any */
1536

1537 1538 1539
  if ((user_max > 0) && (unadjusted > user_max))
  {
    var->save_result.ulonglong_value= user_max;
1540

1541 1542 1543 1544
    if ((warnings == 0) && throw_bounds_warning(thd, TRUE, TRUE,
                                                var->var->name,
                                                (longlong) unadjusted))
      return TRUE;
1545

1546 1547 1548
    warnings++;
  }

1549 1550 1551 1552 1553 1554 1555
  /*
    if the sysvar doesn't have a proper bounds record but the check
    function would like bounding to ULONG where its size differs from
    that of ULONGLONG, we make up a bogus limits record here and let
    the usual suspects handle the actual limiting.
  */

1556
  if (!limits && var_type != GET_ULL)
1557 1558
  {
    bzero(&fallback, sizeof(fallback));
1559
    fallback.var_type= var_type;
1560 1561 1562
    limits= &fallback;
  }

1563 1564 1565 1566 1567
  /* fix_unsigned() */
  if (limits)
  {
    my_bool   fixed;

1568 1569
    var->save_result.ulonglong_value= getopt_ull_limit_value(var->save_result.
                                                             ulonglong_value,
1570
                                                             limits, &fixed);
1571

1572 1573
    if ((warnings == 0) && throw_bounds_warning(thd, fixed, TRUE,
                                                var->var->name,
1574 1575 1576 1577 1578
                                                (longlong) unadjusted))
      return TRUE;
  }

  return FALSE;
1579 1580
}

1581

1582
sys_var_long_ptr::
unknown's avatar
unknown committed
1583
sys_var_long_ptr(sys_var_chain *chain, const char *name_arg, ulong *value_ptr_arg,
1584
                 sys_after_update_func after_update_arg)
unknown's avatar
unknown committed
1585
  :sys_var_long_ptr_global(chain, name_arg, value_ptr_arg,
1586 1587 1588 1589 1590
                           &LOCK_global_system_variables, after_update_arg)
{}


bool sys_var_long_ptr_global::check(THD *thd, set_var *var)
unknown's avatar
unknown committed
1591
{
1592
  return get_unsigned(thd, var, 0, GET_ULONG);
unknown's avatar
unknown committed
1593
}
1594

1595
bool sys_var_long_ptr_global::update(THD *thd, set_var *var)
unknown's avatar
unknown committed
1596
{
1597
  pthread_mutex_lock(guard);
1598
  *value= (ulong) var->save_result.ulonglong_value;
1599
  pthread_mutex_unlock(guard);
unknown's avatar
unknown committed
1600 1601 1602 1603
  return 0;
}


1604
void sys_var_long_ptr_global::set_default(THD *thd, enum_var_type type)
unknown's avatar
unknown committed
1605
{
1606
  my_bool not_used;
1607
  pthread_mutex_lock(guard);
1608 1609
  *value= (ulong) getopt_ull_limit_value((ulong) option_limits->def_value,
                                         option_limits, &not_used);
1610
  pthread_mutex_unlock(guard);
unknown's avatar
unknown committed
1611 1612 1613
}


1614 1615 1616 1617 1618 1619
bool sys_var_ulonglong_ptr::check(THD *thd, set_var *var)
{
  return get_unsigned(thd, var, 0, GET_ULL);
}


1620 1621
bool sys_var_ulonglong_ptr::update(THD *thd, set_var *var)
{
1622
  ulonglong tmp= var->save_result.ulonglong_value;
1623
  pthread_mutex_lock(&LOCK_global_system_variables);
1624
  *value= (ulonglong) tmp;
1625
  pthread_mutex_unlock(&LOCK_global_system_variables);
1626 1627 1628 1629 1630 1631
  return 0;
}


void sys_var_ulonglong_ptr::set_default(THD *thd, enum_var_type type)
{
1632
  my_bool not_used;
1633
  pthread_mutex_lock(&LOCK_global_system_variables);
1634 1635
  *value= getopt_ull_limit_value((ulonglong) option_limits->def_value,
                                 option_limits, &not_used);
1636
  pthread_mutex_unlock(&LOCK_global_system_variables);
1637 1638 1639
}


unknown's avatar
unknown committed
1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652
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;
}


1653 1654 1655 1656 1657 1658 1659
bool sys_var_enum::update(THD *thd, set_var *var)
{
  *value= (uint) var->save_result.ulong_value;
  return 0;
}


1660
uchar *sys_var_enum::value_ptr(THD *thd, enum_var_type type, LEX_STRING *base)
1661
{
1662
  return (uchar*) enum_names->type_names[*value];
1663 1664
}

1665 1666
bool sys_var_thd_ulong::check(THD *thd, set_var *var)
{
1667
  if (get_unsigned(thd, var, max_system_variables.*offset, GET_ULONG))
1668
    return TRUE;
Tatiana A. Nurnberg's avatar
Tatiana A. Nurnberg committed
1669
  DBUG_ASSERT(var->save_result.ulonglong_value <= ULONG_MAX);
1670
  return ((check_func && (*check_func)(thd, var)));
1671
}
1672

unknown's avatar
unknown committed
1673 1674 1675
bool sys_var_thd_ulong::update(THD *thd, set_var *var)
{
  if (var->type == OPT_GLOBAL)
1676
    global_system_variables.*offset= (ulong) var->save_result.ulonglong_value;
unknown's avatar
unknown committed
1677
  else
1678
    thd->variables.*offset= (ulong) var->save_result.ulonglong_value;
1679

unknown's avatar
unknown committed
1680 1681 1682 1683 1684 1685 1686 1687
  return 0;
}


void sys_var_thd_ulong::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
  {
1688
    my_bool not_used;
unknown's avatar
unknown committed
1689
    /* We will not come here if option_limits is not set */
1690
    global_system_variables.*offset=
unknown's avatar
unknown committed
1691 1692
      (ulong) getopt_ull_limit_value((ulong) option_limits->def_value,
                                     option_limits, &not_used);
unknown's avatar
unknown committed
1693 1694 1695 1696 1697 1698
  }
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1699
uchar *sys_var_thd_ulong::value_ptr(THD *thd, enum_var_type type,
1700
				   LEX_STRING *base)
unknown's avatar
unknown committed
1701 1702
{
  if (type == OPT_GLOBAL)
1703 1704
    return (uchar*) &(global_system_variables.*offset);
  return (uchar*) &(thd->variables.*offset);
unknown's avatar
unknown committed
1705 1706 1707
}


1708
bool sys_var_thd_ha_rows::check(THD *thd, set_var *var)
1709
{
1710 1711 1712 1713 1714 1715 1716 1717
  return get_unsigned(thd, var, max_system_variables.*offset,
#ifdef BIG_TABLES
                      GET_ULL
#else
                      GET_ULONG
#endif
                     );
}
1718

1719

1720 1721
bool sys_var_thd_ha_rows::update(THD *thd, set_var *var)
{
1722 1723 1724
  if (var->type == OPT_GLOBAL)
  {
    /* Lock is needed to make things safe on 32 bit systems */
unknown's avatar
unknown committed
1725
    pthread_mutex_lock(&LOCK_global_system_variables);
1726 1727
    global_system_variables.*offset= (ha_rows)
                                     var->save_result.ulonglong_value;
1728 1729 1730
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
  else
1731
    thd->variables.*offset= (ha_rows) var->save_result.ulonglong_value;
1732 1733 1734 1735 1736 1737 1738 1739
  return 0;
}


void sys_var_thd_ha_rows::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
  {
1740
    my_bool not_used;
1741 1742
    /* We will not come here if option_limits is not set */
    pthread_mutex_lock(&LOCK_global_system_variables);
1743 1744 1745
    global_system_variables.*offset=
      (ha_rows) getopt_ull_limit_value((ha_rows) option_limits->def_value,
                                       option_limits, &not_used);
1746 1747 1748 1749 1750 1751 1752
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1753
uchar *sys_var_thd_ha_rows::value_ptr(THD *thd, enum_var_type type,
1754
				     LEX_STRING *base)
1755 1756
{
  if (type == OPT_GLOBAL)
1757 1758
    return (uchar*) &(global_system_variables.*offset);
  return (uchar*) &(thd->variables.*offset);
1759 1760
}

1761 1762
bool sys_var_thd_ulonglong::check(THD *thd, set_var *var)
{
1763
  return get_unsigned(thd, var, max_system_variables.*offset, GET_ULL);
1764 1765
}

unknown's avatar
unknown committed
1766 1767 1768
bool sys_var_thd_ulonglong::update(THD *thd,  set_var *var)
{
  if (var->type == OPT_GLOBAL)
1769 1770 1771
  {
    /* Lock is needed to make things safe on 32 bit systems */
    pthread_mutex_lock(&LOCK_global_system_variables);
1772 1773
    global_system_variables.*offset= (ulonglong)
                                     var->save_result.ulonglong_value;
1774 1775
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
unknown's avatar
unknown committed
1776
  else
1777
    thd->variables.*offset= (ulonglong) var->save_result.ulonglong_value;
unknown's avatar
unknown committed
1778 1779 1780 1781 1782 1783 1784
  return 0;
}


void sys_var_thd_ulonglong::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
1785
  {
1786
    my_bool not_used;
1787
    pthread_mutex_lock(&LOCK_global_system_variables);
1788 1789 1790
    global_system_variables.*offset=
      getopt_ull_limit_value((ulonglong) option_limits->def_value,
                             option_limits, &not_used);
1791 1792
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
unknown's avatar
unknown committed
1793 1794 1795 1796 1797
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1798
uchar *sys_var_thd_ulonglong::value_ptr(THD *thd, enum_var_type type,
1799
				       LEX_STRING *base)
unknown's avatar
unknown committed
1800 1801
{
  if (type == OPT_GLOBAL)
1802 1803
    return (uchar*) &(global_system_variables.*offset);
  return (uchar*) &(thd->variables.*offset);
unknown's avatar
unknown committed
1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821 1822 1823 1824 1825
}


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;
}


1826
uchar *sys_var_thd_bool::value_ptr(THD *thd, enum_var_type type,
1827
				  LEX_STRING *base)
unknown's avatar
unknown committed
1828 1829
{
  if (type == OPT_GLOBAL)
1830 1831
    return (uchar*) &(global_system_variables.*offset);
  return (uchar*) &(thd->variables.*offset);
unknown's avatar
unknown committed
1832 1833 1834
}


1835
bool sys_var::check_enum(THD *thd, set_var *var, const TYPELIB *enum_names)
unknown's avatar
unknown committed
1836
{
unknown's avatar
unknown committed
1837
  char buff[STRING_BUFFER_USUAL_SIZE];
1838
  const char *value;
1839
  String str(buff, sizeof(buff) - 1, system_charset_info), *res;
unknown's avatar
unknown committed
1840 1841 1842 1843 1844

  if (var->value->result_type() == STRING_RESULT)
  {
    if (!(res=var->value->val_str(&str)) ||
	((long) (var->save_result.ulong_value=
1845 1846
		 (ulong) find_type(enum_names, res->ptr(),
				   res->length(),1)-1)) < 0)
unknown's avatar
unknown committed
1847
    {
1848
      value= res ? res->c_ptr() : "NULL";
unknown's avatar
unknown committed
1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865
      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:
1866
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, value);
unknown's avatar
unknown committed
1867 1868 1869
  return 1;
}

1870 1871 1872 1873 1874 1875
/**
   Check vality of set

   Note that this sets 'save_result.ulong_value' for the update function,
   which means that we don't need a separate sys_var::update() function
*/
1876 1877 1878

bool sys_var::check_set(THD *thd, set_var *var, TYPELIB *enum_names)
{
1879
  bool not_used;
1880
  char buff[256], *error= 0;
1881
  uint error_len= 0;
1882
  String str(buff, sizeof(buff) - 1, system_charset_info), *res;
1883 1884 1885 1886

  if (var->value->result_type() == STRING_RESULT)
  {
    if (!(res= var->value->val_str(&str)))
1887
    {
unknown's avatar
unknown committed
1888
      strmov(buff, "NULL");
1889
      goto err;
1890
    }
1891

1892
    if (!m_allow_empty_value && res->length() == 0)
1893 1894 1895 1896 1897
    {
      buff[0]= 0;
      goto err;
    }

unknown's avatar
unknown committed
1898
    var->save_result.ulong_value= ((ulong)
1899
				   find_set(enum_names, res->ptr(),
1900 1901 1902
					    res->length(),
                                            NULL,
                                            &error, &error_len,
unknown's avatar
unknown committed
1903
					    &not_used));
1904 1905
    if (error_len)
    {
1906
      strmake(buff, error, min(sizeof(buff) - 1, error_len));
1907 1908 1909 1910 1911 1912
      goto err;
    }
  }
  else
  {
    ulonglong tmp= var->value->val_int();
1913

1914
    if (!m_allow_empty_value && tmp == 0)
1915 1916 1917 1918 1919 1920 1921 1922 1923 1924
    {
      buff[0]= '0';
      buff[1]= 0;
      goto err;
    }

    /*
      For when the enum is made to contain 64 elements, as 1ULL<<64 is
      undefined, we guard with a "count<64" test.
    */
1925 1926
    if (unlikely((tmp >= ((ULL(1)) << enum_names->count)) &&
                 (enum_names->count < 64)))
1927 1928 1929 1930 1931 1932 1933 1934 1935
    {
      llstr(tmp, buff);
      goto err;
    }
    var->save_result.ulong_value= (ulong) tmp;  // Save for update
  }
  return 0;

err:
1936
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, buff);
1937 1938 1939 1940
  return 1;
}


1941 1942 1943 1944 1945 1946 1947 1948 1949 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962 1963 1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983
/**
  Make string representation of set

  @param[in]  thd    thread handler
  @param[in]  val    sql_mode value
  @param[in]  names  names for the different bits
  @param[out] rep    Result string

  @return
    0 ok
    1 end of memory
*/

bool sys_var::make_set(THD *thd, ulonglong val, TYPELIB *names,
                       LEX_STRING *rep)
{
  /* Strings for typelib may be big; This is reallocated on demand */
  char buff[256];
  String tmp(buff, sizeof(buff) - 1, &my_charset_latin1);
  bool error= 0;

  tmp.length(0);
  for (uint i= 0; val; val>>= 1, i++)
  {
    if (val & 1)
    {
      error|= tmp.append(names->type_names[i],
                 names->type_lengths[i]);
      error|= tmp.append(',');
    }
  }

  if (tmp.length())
    tmp.length(tmp.length() - 1); /* trim the trailing comma */

  /* Allocate temporary copy of string */
  if (!(rep->str= thd->strmake(tmp.ptr(), tmp.length())))
    error= 1;
  rep->length= tmp.length();
  return error;                   /* Error in case of out of memory */
}


1984 1985 1986 1987 1988
CHARSET_INFO *sys_var::charset(THD *thd)
{
  return is_os_charset ? thd->variables.character_set_filesystem : 
    system_charset_info;
}
unknown's avatar
unknown committed
1989

1990

unknown's avatar
unknown committed
1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009
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;
}


2010
uchar *sys_var_thd_enum::value_ptr(THD *thd, enum_var_type type,
2011
				  LEX_STRING *base)
unknown's avatar
unknown committed
2012 2013 2014 2015
{
  ulong tmp= ((type == OPT_GLOBAL) ?
	      global_system_variables.*offset :
	      thd->variables.*offset);
2016
  return (uchar*) enum_names->type_names[tmp];
unknown's avatar
unknown committed
2017 2018
}

2019 2020 2021 2022 2023 2024 2025 2026 2027 2028
uchar *sys_var_thd_set::value_ptr(THD *thd, enum_var_type type,
                                  LEX_STRING *base)
{
  LEX_STRING sql_mode;
  ulong val= ((type == OPT_GLOBAL) ? global_system_variables.*offset :
              thd->variables.*offset);
  (void) make_set(thd, val & visible_value_mask, enum_names, &sql_mode);
  return (uchar *) sql_mode.str;
}

2029 2030 2031 2032 2033
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
2034 2035 2036

bool sys_var_thd_bit::update(THD *thd, set_var *var)
{
2037
  int res= (*update_func)(thd, var);
unknown's avatar
unknown committed
2038 2039 2040 2041
  return res;
}


2042
uchar *sys_var_thd_bit::value_ptr(THD *thd, enum_var_type type,
2043
				 LEX_STRING *base)
unknown's avatar
unknown committed
2044 2045 2046 2047 2048 2049 2050
{
  /*
    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);
2051
  return (uchar*) &thd->sys_var_tmp.my_bool_value;
unknown's avatar
unknown committed
2052 2053 2054
}


unknown's avatar
unknown committed
2055
/** Update a date_time format variable based on given value. */
2056 2057 2058 2059 2060 2061

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");
2062
  DBUG_DUMP("positions", (uchar*) new_value->positions,
2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096
	    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)
{
unknown's avatar
unknown committed
2097
  char buff[STRING_BUFFER_USUAL_SIZE];
2098
  String str(buff,sizeof(buff) - 1, system_charset_info), *res;
2099 2100 2101 2102 2103 2104 2105 2106
  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())))
  {
2107
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, res->c_ptr());
2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 2121 2122 2123 2124 2125 2126 2127 2128 2129 2130 2131 2132 2133 2134 2135 2136 2137 2138 2139 2140 2141
    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);
}


2142
uchar *sys_var_thd_date_time_format::value_ptr(THD *thd, enum_var_type type,
2143 2144 2145 2146 2147 2148 2149 2150 2151 2152 2153 2154
					      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);
2155
    return (uchar*) res;
2156
  }
2157
  return (uchar*) (thd->variables.*offset)->format.str;
2158 2159 2160
}


2161 2162
typedef struct old_names_map_st
{
unknown's avatar
unknown committed
2163 2164 2165
  const char *old_name;
  const char *new_name;
} my_old_conv;
unknown's avatar
unknown committed
2166

unknown's avatar
unknown committed
2167 2168
static my_old_conv old_conv[]= 
{
2169 2170 2171 2172 2173 2174 2175 2176 2177 2178 2179
  {	"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
2180
};
unknown's avatar
unknown committed
2181

unknown's avatar
unknown committed
2182
CHARSET_INFO *get_old_charset_by_name(const char *name)
unknown's avatar
unknown committed
2183
{
unknown's avatar
unknown committed
2184
  my_old_conv *conv;
unknown's avatar
unknown committed
2185
 
unknown's avatar
unknown committed
2186
  for (conv= old_conv; conv->old_name; conv++)
2187
  {
unknown's avatar
unknown committed
2188 2189
    if (!my_strcasecmp(&my_charset_latin1, name, conv->old_name))
      return get_charset_by_csname(conv->new_name, MY_CS_PRIMARY, MYF(0));
2190
  }
unknown's avatar
unknown committed
2191
  return NULL;
unknown's avatar
unknown committed
2192 2193
}

unknown's avatar
unknown committed
2194

2195
bool sys_var_collation::check(THD *thd, set_var *var)
unknown's avatar
unknown committed
2196 2197
{
  CHARSET_INFO *tmp;
2198
  LINT_INIT(tmp);
unknown's avatar
unknown committed
2199

2200
  if (var->value->result_type() == STRING_RESULT)
2201
  {
unknown's avatar
unknown committed
2202
    char buff[STRING_BUFFER_USUAL_SIZE];
2203
    String str(buff,sizeof(buff) - 1, system_charset_info), *res;
2204 2205
    if (!(res=var->value->val_str(&str)))
    {
2206
      my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, "NULL");
2207 2208 2209 2210
      return 1;
    }
    if (!(tmp=get_charset_by_name(res->c_ptr(),MYF(0))))
    {
2211
      my_error(ER_UNKNOWN_COLLATION, MYF(0), res->c_ptr());
2212 2213
      return 1;
    }
2214
  }
2215
  else // INT_RESULT
2216
  {
2217
    if (!(tmp=get_charset((int) var->value->val_int(),MYF(0))))
2218 2219
    {
      char buf[20];
2220
      int10_to_str((int) var->value->val_int(), buf, -10);
2221
      my_error(ER_UNKNOWN_COLLATION, MYF(0), buf);
2222 2223
      return 1;
    }
2224 2225 2226 2227 2228
  }
  var->save_result.charset= tmp;	// Save for update
  return 0;
}

2229

2230 2231 2232
bool sys_var_character_set::check(THD *thd, set_var *var)
{
  CHARSET_INFO *tmp;
2233
  LINT_INIT(tmp);
2234

2235 2236
  if (var->value->result_type() == STRING_RESULT)
  {
unknown's avatar
unknown committed
2237
    char buff[STRING_BUFFER_USUAL_SIZE];
2238
    String str(buff,sizeof(buff) - 1, system_charset_info), *res;
2239
    if (!(res=var->value->val_str(&str)))
2240
    {
2241 2242
      if (!nullable)
      {
2243
        my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, "NULL");
2244 2245 2246 2247
        return 1;
      }
      tmp= NULL;
    }
2248
    else
2249
    {
2250 2251 2252 2253 2254 2255 2256
      const char *name= res->c_ptr_safe();
      if (!(tmp=get_charset_by_csname(name,MY_CS_PRIMARY,MYF(0))) &&
             !(tmp=get_old_charset_by_name(name)))
      {
        my_error(ER_UNKNOWN_CHARACTER_SET, MYF(0), name);
        return 1;
      }
2257 2258
    }
  }
2259
  else // INT_RESULT
unknown's avatar
unknown committed
2260
  {
2261
    if (!(tmp=get_charset((int) var->value->val_int(),MYF(0))))
2262 2263
    {
      char buf[20];
2264
      int10_to_str((int) var->value->val_int(), buf, -10);
2265 2266 2267
      my_error(ER_UNKNOWN_CHARACTER_SET, MYF(0), buf);
      return 1;
    }
unknown's avatar
unknown committed
2268 2269 2270 2271 2272
  }
  var->save_result.charset= tmp;	// Save for update
  return 0;
}

2273

2274
bool sys_var_character_set::update(THD *thd, set_var *var)
unknown's avatar
unknown committed
2275
{
2276
  ci_ptr(thd,var->type)[0]= var->save_result.charset;
unknown's avatar
unknown committed
2277
  thd->update_charset();
unknown's avatar
unknown committed
2278 2279 2280
  return 0;
}

2281

2282
uchar *sys_var_character_set::value_ptr(THD *thd, enum_var_type type,
2283
				       LEX_STRING *base)
unknown's avatar
unknown committed
2284
{
2285
  CHARSET_INFO *cs= ci_ptr(thd,type)[0];
2286
  return cs ? (uchar*) cs->csname : (uchar*) NULL;
unknown's avatar
unknown committed
2287 2288 2289
}


unknown's avatar
unknown committed
2290
void sys_var_character_set_sv::set_default(THD *thd, enum_var_type type)
2291
{
2292
  if (type == OPT_GLOBAL)
unknown's avatar
unknown committed
2293
    global_system_variables.*offset= *global_default;
2294
  else
unknown's avatar
unknown committed
2295 2296 2297 2298
  {
    thd->variables.*offset= global_system_variables.*offset;
    thd->update_charset();
  }
2299
}
unknown's avatar
unknown committed
2300
CHARSET_INFO **sys_var_character_set_sv::ci_ptr(THD *thd, enum_var_type type)
2301 2302
{
  if (type == OPT_GLOBAL)
unknown's avatar
unknown committed
2303
    return &(global_system_variables.*offset);
2304
  else
unknown's avatar
unknown committed
2305
    return &(thd->variables.*offset);
2306 2307
}

2308

2309 2310 2311 2312 2313 2314 2315 2316 2317 2318 2319 2320 2321 2322 2323
bool sys_var_character_set_client::check(THD *thd, set_var *var)
{
  if (sys_var_character_set_sv::check(thd, var))
    return 1;
  /* Currently, UCS-2 cannot be used as a client character set */
  if (var->save_result.charset->mbminlen > 1)
  {
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, 
             var->save_result.charset->csname);
    return 1;
  }
  return 0;
}


2324 2325
CHARSET_INFO ** sys_var_character_set_database::ci_ptr(THD *thd,
						       enum_var_type type)
2326 2327
{
  if (type == OPT_GLOBAL)
2328
    return &global_system_variables.collation_database;
2329
  else
2330
    return &thd->variables.collation_database;
2331 2332
}

2333

2334 2335 2336
void sys_var_character_set_database::set_default(THD *thd, enum_var_type type)
{
 if (type == OPT_GLOBAL)
2337
    global_system_variables.collation_database= default_charset_info;
2338
  else
unknown's avatar
unknown committed
2339
  {
2340
    thd->variables.collation_database= thd->db_charset;
unknown's avatar
unknown committed
2341 2342
    thd->update_charset();
  }
2343 2344
}

2345

unknown's avatar
unknown committed
2346
bool sys_var_collation_sv::update(THD *thd, set_var *var)
2347 2348
{
  if (var->type == OPT_GLOBAL)
unknown's avatar
unknown committed
2349
    global_system_variables.*offset= var->save_result.charset;
2350
  else
unknown's avatar
unknown committed
2351
  {
unknown's avatar
unknown committed
2352
    thd->variables.*offset= var->save_result.charset;
unknown's avatar
unknown committed
2353 2354
    thd->update_charset();
  }
2355 2356 2357
  return 0;
}

2358

unknown's avatar
unknown committed
2359
void sys_var_collation_sv::set_default(THD *thd, enum_var_type type)
2360
{
unknown's avatar
unknown committed
2361 2362
  if (type == OPT_GLOBAL)
    global_system_variables.*offset= *global_default;
2363 2364
  else
  {
unknown's avatar
unknown committed
2365
    thd->variables.*offset= global_system_variables.*offset;
2366 2367 2368 2369 2370
    thd->update_charset();
  }
}


2371
uchar *sys_var_collation_sv::value_ptr(THD *thd, enum_var_type type,
2372
                                       LEX_STRING *base)
2373 2374
{
  CHARSET_INFO *cs= ((type == OPT_GLOBAL) ?
2375
		     global_system_variables.*offset : thd->variables.*offset);
2376
  return cs ? (uchar*) cs->name : (uchar*) "NULL";
2377 2378
}

2379

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

unknown's avatar
unknown committed
2382
static KEY_CACHE zero_key_cache;
unknown's avatar
unknown committed
2383

unknown's avatar
unknown committed
2384
KEY_CACHE *get_key_cache(LEX_STRING *cache_name)
unknown's avatar
unknown committed
2385
{
2386 2387
  safe_mutex_assert_owner(&LOCK_global_system_variables);
  if (!cache_name || ! cache_name->length)
unknown's avatar
unknown committed
2388
    cache_name= &default_key_cache_base;
unknown's avatar
unknown committed
2389
  return ((KEY_CACHE*) find_named(&key_caches,
2390
                                  cache_name->str, cache_name->length, 0));
unknown's avatar
unknown committed
2391 2392
}

2393
uchar *sys_var_key_cache_param::value_ptr(THD *thd, enum_var_type type,
unknown's avatar
unknown committed
2394
					 LEX_STRING *base)
2395
{
unknown's avatar
unknown committed
2396
  KEY_CACHE *key_cache= get_key_cache(base);
unknown's avatar
unknown committed
2397 2398
  if (!key_cache)
    key_cache= &zero_key_cache;
2399
  return (uchar*) key_cache + offset ;
unknown's avatar
unknown committed
2400
}
2401

2402

2403 2404 2405 2406 2407 2408
bool sys_var_key_buffer_size::check(THD *thd, set_var *var)
{
  return get_unsigned(thd, var, 0, GET_ULL);
}


2409 2410
bool sys_var_key_buffer_size::update(THD *thd, set_var *var)
{
2411
  ulonglong tmp= var->save_result.ulonglong_value;
unknown's avatar
unknown committed
2412
  LEX_STRING *base_name= &var->base;
unknown's avatar
unknown committed
2413
  KEY_CACHE *key_cache;
2414 2415 2416
  bool error= 0;

  /* If no basename, assume it's for the key cache named 'default' */
unknown's avatar
unknown committed
2417
  if (!base_name->length)
2418
    base_name= &default_key_cache_base;
2419 2420 2421

  pthread_mutex_lock(&LOCK_global_system_variables);
  key_cache= get_key_cache(base_name);
2422

2423 2424
  if (!key_cache)
  {
2425
    /* Key cache didn't exist */
2426
    if (!tmp)					// Tried to delete cache
2427 2428 2429 2430 2431 2432
      goto end;					// Ok, nothing to do
    if (!(key_cache= create_key_cache(base_name->str, base_name->length)))
    {
      error= 1;
      goto end;
    }
2433
  }
2434 2435 2436 2437 2438 2439 2440 2441 2442

  /*
    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
2443
  if (!tmp)					// Zero size means delete
2444
  {
unknown's avatar
unknown committed
2445
    if (key_cache == dflt_key_cache)
2446
    {
2447 2448
      error= 1;
      my_error(ER_WARN_CANT_DROP_DEFAULT_KEYCACHE, MYF(0));
2449
      goto end;					// Ignore default key cache
2450
    }
2451

unknown's avatar
unknown committed
2452
    if (key_cache->key_cache_inited)		// If initied
2453 2454
    {
      /*
2455 2456
	Move tables using this key cache to the default key cache
	and clear the old key cache.
2457
      */
2458
      NAMED_LIST *list; 
unknown's avatar
unknown committed
2459
      key_cache= (KEY_CACHE *) find_named(&key_caches, base_name->str,
2460
					      base_name->length, &list);
2461 2462
      key_cache->in_init= 1;
      pthread_mutex_unlock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
2463
      error= reassign_keycache_tables(thd, key_cache, dflt_key_cache);
2464 2465
      pthread_mutex_lock(&LOCK_global_system_variables);
      key_cache->in_init= 0;
2466
    }
2467 2468 2469 2470 2471
    /*
      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;
2472 2473
  }

2474
  key_cache->param_buff_size= (ulonglong) tmp;
2475

2476
  /* If key cache didn't exist initialize it, else resize it */
2477 2478 2479
  key_cache->in_init= 1;
  pthread_mutex_unlock(&LOCK_global_system_variables);

unknown's avatar
unknown committed
2480
  if (!key_cache->key_cache_inited)
2481
    error= (bool) (ha_init_key_cache("", key_cache));
unknown's avatar
unknown committed
2482
  else
2483
    error= (bool)(ha_resize_key_cache(key_cache));
2484

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

2488 2489
end:
  pthread_mutex_unlock(&LOCK_global_system_variables);
2490 2491 2492

 var->save_result.ulonglong_value = SIZE_T_MAX;

2493
  return error;
2494 2495
}

2496

2497 2498 2499 2500 2501 2502
bool sys_var_key_cache_long::check(THD *thd, set_var *var)
{
  return get_unsigned(thd, var, 0, GET_ULONG);
}


unknown's avatar
unknown committed
2503 2504 2505 2506 2507 2508
/**
  @todo
  Abort if some other thread is changing the key cache.
  This should be changed so that we wait until the previous
  assignment is done and then do the new assign
*/
2509
bool sys_var_key_cache_long::update(THD *thd, set_var *var)
2510
{
2511
  LEX_STRING *base_name= &var->base;
2512 2513
  bool error= 0;

2514
  if (!base_name->length)
unknown's avatar
unknown committed
2515
    base_name= &default_key_cache_base;
2516 2517

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

unknown's avatar
unknown committed
2520 2521
  if (!key_cache && !(key_cache= create_key_cache(base_name->str,
				                  base_name->length)))
2522 2523 2524 2525
  {
    error= 1;
    goto end;
  }
2526

2527 2528 2529 2530 2531 2532 2533 2534
  /*
    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;

2535 2536
  *((ulong*) (((char*) key_cache) + offset))= (ulong)
                                              var->save_result.ulonglong_value;
unknown's avatar
unknown committed
2537

2538 2539 2540 2541 2542
  /*
    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;
2543

2544
  pthread_mutex_unlock(&LOCK_global_system_variables);
2545

2546
  if (offset == offsetof(KEY_CACHE, param_block_size))
2547
    error= (bool) (ha_resize_key_cache(key_cache));
2548 2549 2550
  else
  if (offset == offsetof(KEY_CACHE, param_division_limit) ||
      offset == offsetof(KEY_CACHE, param_age_threshold))
2551
    error= (bool) (ha_change_key_cache_param(key_cache));
2552 2553
  else
  if (offset == offsetof(KEY_CACHE, param_partitions))
2554
    error= (bool) (ha_repartition_key_cache(key_cache));
2555 2556 2557 2558 2559 2560 2561

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

end:
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return error;
2562 2563
}

2564

2565 2566
bool sys_var_log_state::update(THD *thd, set_var *var)
{
2567
  bool res;
2568 2569 2570 2571 2572
  if (this == &sys_var_log)
    WARN_DEPRECATED(thd, "7.0", "@@log", "'@@general_log'");
  else if (this == &sys_var_log_slow)
    WARN_DEPRECATED(thd, "7.0", "@@log_slow_queries", "'@@slow_query_log'");

2573 2574
  if (!var->save_result.ulong_value)
  {
2575 2576
    logger.deactivate_log_handler(thd, log_type);
    res= false;
2577
  }
2578 2579
  else
    res= logger.activate_log_handler(thd, log_type);
2580 2581 2582 2583 2584
  return res;
}

void sys_var_log_state::set_default(THD *thd, enum_var_type type)
{
2585 2586 2587 2588 2589
  if (this == &sys_var_log)
    WARN_DEPRECATED(thd, "7.0", "@@log", "'@@general_log'");
  else if (this == &sys_var_log_slow)
    WARN_DEPRECATED(thd, "7.0", "@@log_slow_queries", "'@@slow_query_log'");

2590 2591 2592 2593 2594 2595
  logger.deactivate_log_handler(thd, log_type);
}


static int  sys_check_log_path(THD *thd,  set_var *var)
{
2596
  char path[FN_REFLEN], buff[FN_REFLEN];
2597
  MY_STAT f_stat;
2598
  String str(buff, sizeof(buff), system_charset_info), *res;
Michael Widenius's avatar
Michael Widenius committed
2599
  const char *log_file_str= 0;
2600 2601
  size_t path_length;

2602 2603 2604
  if (!(res= var->value->val_str(&str)))
    goto err;

2605
  log_file_str= res->c_ptr_safe();
2606 2607
  bzero(&f_stat, sizeof(MY_STAT));

2608 2609 2610
  path_length= unpack_filename(path, log_file_str);

  if (!path_length)
2611
  {
2612 2613 2614
    /* File name is empty. */

    goto err;
2615
  }
2616 2617

  if (my_stat(path, &f_stat, MYF(0)))
2618 2619
  {
    /*
2620 2621
      A file system object exists. Check if argument is a file and we have
      'write' permission.
2622
    */
2623 2624 2625

    if (!MY_S_ISREG(f_stat.st_mode) ||
        !(f_stat.st_mode & MY_S_IWRITE))
2626
      goto err;
2627 2628

    return 0;
2629
  }
2630 2631 2632 2633 2634 2635 2636 2637 2638 2639 2640 2641 2642 2643 2644

  /* Get dirname of the file path. */
  (void) dirname_part(path, log_file_str, &path_length);

  /* Dirname is empty if file path is relative. */
  if (!path_length)
    return 0;

  /*
    Check if directory exists and we have permission to create file and
    write to file.
  */
  if (my_access(path, (F_OK|W_OK)))
    goto err;

2645
  return 0;
2646 2647 2648

err:
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), var->var->name, 
Michael Widenius's avatar
Michael Widenius committed
2649
           log_file_str ? log_file_str : "NULL");
2650
  return 1;
2651 2652 2653 2654 2655 2656 2657
}


bool update_sys_var_str_path(THD *thd, sys_var_str *var_str,
			     set_var *var, const char *log_ext,
			     bool log_state, uint log_type)
{
Michael Widenius's avatar
Michael Widenius committed
2658
  MYSQL_QUERY_LOG *file_log= 0;
2659 2660 2661 2662 2663 2664 2665 2666 2667 2668 2669 2670 2671
  char buff[FN_REFLEN];
  char *res= 0, *old_value=(char *)(var ? var->value->str_value.ptr() : 0);
  bool result= 0;
  uint str_length= (var ? var->value->str_value.length() : 0);

  switch (log_type) {
  case QUERY_LOG_SLOW:
    file_log= logger.get_slow_log_file_handler();
    break;
  case QUERY_LOG_GENERAL:
    file_log= logger.get_log_file_handler();
    break;
  default:
2672
    MY_ASSERT_UNREACHABLE();
2673 2674 2675 2676 2677 2678 2679
  }

  if (!old_value)
  {
    old_value= make_default_log_name(buff, log_ext);
    str_length= strlen(old_value);
  }
2680
  if (!(res= my_strndup(old_value, str_length, MYF(MY_FAE+MY_WME))))
2681 2682 2683 2684 2685
  {
    result= 1;
    goto err;
  }

2686
  logger.lock_exclusive();
2687 2688 2689 2690

  if (file_log && log_state)
    file_log->close(0);
  if (file_log && log_state)
unknown's avatar
unknown committed
2691 2692 2693
  {
    switch (log_type) {
    case QUERY_LOG_SLOW:
2694
      file_log->open_slow_log(res);
unknown's avatar
unknown committed
2695 2696
      break;
    case QUERY_LOG_GENERAL:
2697
      file_log->open_query_log(res);
unknown's avatar
unknown committed
2698 2699 2700 2701 2702
      break;
    default:
      DBUG_ASSERT(0);
    }
  }
2703 2704

  logger.unlock();
2705 2706 2707 2708 2709 2710 2711

  /* update global variable */
  pthread_mutex_lock(&LOCK_global_system_variables);
  old_value= var_str->value;
  var_str->value= res;
  var_str->value_length= str_length;
  my_free(old_value, MYF(MY_ALLOW_ZERO_PTR));
2712 2713 2714 2715 2716 2717 2718 2719 2720 2721 2722 2723 2724 2725 2726 2727 2728 2729 2730 2731 2732 2733 2734 2735 2736 2737 2738 2739 2740 2741 2742 2743 2744 2745 2746 2747 2748 2749 2750
  pthread_mutex_unlock(&LOCK_global_system_variables);

err:
  return result;
}


static bool sys_update_general_log_path(THD *thd, set_var * var)
{
  return update_sys_var_str_path(thd, &sys_var_general_log_path, 
				 var, ".log", opt_log, QUERY_LOG_GENERAL);
}


static void sys_default_general_log_path(THD *thd, enum_var_type type)
{
  (void) update_sys_var_str_path(thd, &sys_var_general_log_path,
				 0, ".log", opt_log, QUERY_LOG_GENERAL);
}


static bool sys_update_slow_log_path(THD *thd, set_var * var)
{
  return update_sys_var_str_path(thd, &sys_var_slow_log_path,
				 var, "-slow.log", opt_slow_log,
                                 QUERY_LOG_SLOW);
}


static void sys_default_slow_log_path(THD *thd, enum_var_type type)
{
  (void) update_sys_var_str_path(thd, &sys_var_slow_log_path,
				 0, "-slow.log", opt_slow_log,
                                 QUERY_LOG_SLOW);
}


bool sys_var_log_output::update(THD *thd, set_var *var)
{
2751
  logger.lock_exclusive();
2752 2753 2754 2755 2756 2757 2758 2759 2760 2761
  logger.init_slow_log(var->save_result.ulong_value);
  logger.init_general_log(var->save_result.ulong_value);
  *value= var->save_result.ulong_value;
  logger.unlock();
  return 0;
}


void sys_var_log_output::set_default(THD *thd, enum_var_type type)
{
2762 2763 2764 2765
  logger.lock_exclusive();
  logger.init_slow_log(LOG_FILE);
  logger.init_general_log(LOG_FILE);
  *value= LOG_FILE;
2766 2767 2768 2769
  logger.unlock();
}


2770
uchar *sys_var_log_output::value_ptr(THD *thd, enum_var_type type,
unknown's avatar
unknown committed
2771
                                    LEX_STRING *base)
2772 2773 2774 2775 2776 2777 2778 2779 2780 2781 2782 2783 2784 2785 2786 2787 2788 2789 2790
{
  char buff[256];
  String tmp(buff, sizeof(buff), &my_charset_latin1);
  ulong length;
  ulong val= *value;

  tmp.length(0);
  for (uint i= 0; val; val>>= 1, i++)
  {
    if (val & 1)
    {
      tmp.append(log_output_typelib.type_names[i],
                 log_output_typelib.type_lengths[i]);
      tmp.append(',');
    }
  }

  if ((length= tmp.length()))
    length--;
2791
  return (uchar*) thd->strmake(tmp.ptr(), length);
2792 2793 2794
}


2795 2796 2797 2798
/*****************************************************************************
  Functions to handle SET NAMES and SET CHARACTER SET
*****************************************************************************/

unknown's avatar
unknown committed
2799
int set_var_collation_client::check(THD *thd)
2800
{
2801 2802 2803 2804 2805 2806 2807
  /* Currently, UCS-2 cannot be used as a client character set */
  if (character_set_client->mbminlen > 1)
  {
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), "character_set_client",
             character_set_client->csname);
    return 1;
  }
2808 2809 2810
  return 0;
}

unknown's avatar
unknown committed
2811
int set_var_collation_client::update(THD *thd)
2812
{
2813 2814
  thd->variables.character_set_client= character_set_client;
  thd->variables.character_set_results= character_set_results;
unknown's avatar
unknown committed
2815
  thd->variables.collation_connection= collation_connection;
unknown's avatar
unknown committed
2816
  thd->update_charset();
unknown's avatar
unknown committed
2817 2818
  thd->protocol_text.init(thd);
  thd->protocol_binary.init(thd);
2819 2820 2821 2822 2823
  return 0;
}

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

2824 2825 2826 2827 2828 2829 2830 2831 2832 2833 2834 2835 2836 2837 2838 2839
bool sys_var_timestamp::check(THD *thd, set_var *var)
{
  time_t val;
  var->save_result.ulonglong_value= var->value->val_int();
  val= (time_t) var->save_result.ulonglong_value;
  if (val < (time_t) MY_TIME_T_MIN || val > (time_t) MY_TIME_T_MAX)
  {
    my_message(ER_UNKNOWN_ERROR, 
               "This version of MySQL doesn't support dates later than 2038",
               MYF(0));
    return TRUE;
  }
  return FALSE;
}


unknown's avatar
unknown committed
2840 2841
bool sys_var_timestamp::update(THD *thd,  set_var *var)
{
2842
  thd->set_time((time_t) var->save_result.ulonglong_value);
2843
  return FALSE;
unknown's avatar
unknown committed
2844 2845 2846 2847 2848 2849 2850 2851 2852
}


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


2853
uchar *sys_var_timestamp::value_ptr(THD *thd, enum_var_type type,
2854
				   LEX_STRING *base)
unknown's avatar
unknown committed
2855 2856
{
  thd->sys_var_tmp.long_value= (long) thd->start_time;
2857
  return (uchar*) &thd->sys_var_tmp.long_value;
unknown's avatar
unknown committed
2858 2859 2860 2861 2862
}


bool sys_var_last_insert_id::update(THD *thd, set_var *var)
{
2863 2864
  thd->first_successful_insert_id_in_prev_stmt= 
    var->save_result.ulonglong_value;
unknown's avatar
unknown committed
2865 2866 2867 2868
  return 0;
}


2869
uchar *sys_var_last_insert_id::value_ptr(THD *thd, enum_var_type type,
2870
					LEX_STRING *base)
unknown's avatar
unknown committed
2871
{
2872 2873 2874 2875 2876 2877
  /*
    this tmp var makes it robust againt change of type of 
    read_first_successful_insert_id_in_prev_stmt().
  */
  thd->sys_var_tmp.ulonglong_value= 
    thd->read_first_successful_insert_id_in_prev_stmt();
2878
  return (uchar*) &thd->sys_var_tmp.ulonglong_value;
unknown's avatar
unknown committed
2879 2880 2881 2882 2883
}


bool sys_var_insert_id::update(THD *thd, set_var *var)
{
2884
  thd->force_one_auto_inc_interval(var->save_result.ulonglong_value);
unknown's avatar
unknown committed
2885 2886 2887 2888
  return 0;
}


2889
uchar *sys_var_insert_id::value_ptr(THD *thd, enum_var_type type,
2890
				   LEX_STRING *base)
unknown's avatar
unknown committed
2891
{
2892 2893
  thd->sys_var_tmp.ulonglong_value= 
    thd->auto_inc_intervals_forced.minimum();
2894
  return (uchar*) &thd->sys_var_tmp.ulonglong_value;
unknown's avatar
unknown committed
2895
}
2896 2897


2898 2899
bool sys_var_rand_seed1::update(THD *thd, set_var *var)
{
2900
  thd->rand.seed1= (ulong) var->save_result.ulonglong_value;
2901 2902 2903 2904 2905
  return 0;
}

bool sys_var_rand_seed2::update(THD *thd, set_var *var)
{
2906
  thd->rand.seed2= (ulong) var->save_result.ulonglong_value;
2907 2908 2909 2910
  return 0;
}


2911 2912
bool sys_var_thd_time_zone::check(THD *thd, set_var *var)
{
2913
  char buff[MAX_TIME_ZONE_NAME_LENGTH];
2914 2915 2916
  String str(buff, sizeof(buff), &my_charset_latin1);
  String *res= var->value->val_str(&str);

2917
  if (!(var->save_result.time_zone= my_tz_find(thd, res)))
2918
  {
2919
    my_error(ER_UNKNOWN_TIME_ZONE, MYF(0), res ? res->c_ptr() : "NULL");
2920 2921 2922 2923 2924 2925 2926 2927
    return 1;
  }
  return 0;
}


bool sys_var_thd_time_zone::update(THD *thd, set_var *var)
{
2928 2929 2930 2931 2932 2933 2934 2935 2936
  /* We are using Time_zone object found during check() phase. */
  if (var->type == OPT_GLOBAL)
  {
    pthread_mutex_lock(&LOCK_global_system_variables);
    global_system_variables.time_zone= var->save_result.time_zone;
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
  else
    thd->variables.time_zone= var->save_result.time_zone;
2937 2938 2939 2940
  return 0;
}


2941
uchar *sys_var_thd_time_zone::value_ptr(THD *thd, enum_var_type type,
2942 2943 2944 2945 2946 2947 2948
				       LEX_STRING *base)
{
  /* 
    We can use ptr() instead of c_ptr() here because String contaning
    time zone name is guaranteed to be zero ended.
  */
  if (type == OPT_GLOBAL)
2949
    return (uchar *)(global_system_variables.time_zone->get_name()->ptr());
2950
  else
2951 2952 2953 2954 2955 2956 2957 2958 2959 2960
  {
    /*
      This is an ugly fix for replication: we don't replicate properly queries
      invoking system variables' values to update tables; but
      CONVERT_TZ(,,@@session.time_zone) is so popular that we make it
      replicable (i.e. we tell the binlog code to store the session
      timezone). If it's the global value which was used we can't replicate
      (binlog code stores session value only).
    */
    thd->time_zone_used= 1;
2961
    return (uchar *)(thd->variables.time_zone->get_name()->ptr());
2962
  }
2963 2964 2965 2966 2967
}


void sys_var_thd_time_zone::set_default(THD *thd, enum_var_type type)
{
2968
 pthread_mutex_lock(&LOCK_global_system_variables);
2969 2970 2971 2972 2973
 if (type == OPT_GLOBAL)
 {
   if (default_tz_name)
   {
     String str(default_tz_name, &my_charset_latin1);
2974 2975 2976 2977
     /*
       We are guaranteed to find this time zone since its existence
       is checked during start-up.
     */
2978
     global_system_variables.time_zone= my_tz_find(thd, &str);
2979 2980 2981 2982 2983 2984
   }
   else
     global_system_variables.time_zone= my_tz_SYSTEM;
 }
 else
   thd->variables.time_zone= global_system_variables.time_zone;
2985
 pthread_mutex_unlock(&LOCK_global_system_variables);
2986 2987
}

2988 2989 2990 2991 2992 2993 2994 2995 2996

bool sys_var_max_user_conn::check(THD *thd, set_var *var)
{
  if (var->type == OPT_GLOBAL)
    return sys_var_thd::check(thd, var);
  else
  {
    /*
      Per-session values of max_user_connections can't be set directly.
2997
      May be we should have a separate error message for this?
2998 2999 3000 3001 3002 3003 3004 3005 3006 3007
    */
    my_error(ER_GLOBAL_VARIABLE, MYF(0), name);
    return TRUE;
  }
}

bool sys_var_max_user_conn::update(THD *thd, set_var *var)
{
  DBUG_ASSERT(var->type == OPT_GLOBAL);
  pthread_mutex_lock(&LOCK_global_system_variables);
3008
  max_user_connections= (uint)var->save_result.ulonglong_value;
3009 3010 3011 3012 3013 3014 3015 3016 3017 3018 3019 3020 3021 3022
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return 0;
}


void sys_var_max_user_conn::set_default(THD *thd, enum_var_type type)
{
  DBUG_ASSERT(type == OPT_GLOBAL);
  pthread_mutex_lock(&LOCK_global_system_variables);
  max_user_connections= (ulong) option_limits->def_value;
  pthread_mutex_unlock(&LOCK_global_system_variables);
}


3023
uchar *sys_var_max_user_conn::value_ptr(THD *thd, enum_var_type type,
3024 3025 3026 3027
                                       LEX_STRING *base)
{
  if (type != OPT_GLOBAL &&
      thd->user_connect && thd->user_connect->user_resources.user_conn)
3028 3029
    return (uchar*) &(thd->user_connect->user_resources.user_conn);
  return (uchar*) &(max_user_connections);
3030 3031
}

3032

3033 3034 3035 3036 3037 3038 3039 3040 3041 3042 3043 3044
bool sys_var_thd_ulong_session_readonly::check(THD *thd, set_var *var)
{
  if (var->type != OPT_GLOBAL)
  {
    my_error(ER_VARIABLE_IS_READONLY, MYF(0), "SESSION", name, "GLOBAL");
    return TRUE;
  }

  return sys_var_thd_ulong::check(thd, var);
}


unknown's avatar
unknown committed
3045 3046
bool sys_var_thd_lc_time_names::check(THD *thd, set_var *var)
{
3047
  MY_LOCALE *locale_match;
unknown's avatar
unknown committed
3048

3049
  if (var->value->result_type() == INT_RESULT)
unknown's avatar
unknown committed
3050
  {
3051 3052 3053 3054 3055 3056 3057
    if (!(locale_match= my_locale_by_number((uint) var->value->val_int())))
    {
      char buf[20];
      int10_to_str((int) var->value->val_int(), buf, -10);
      my_printf_error(ER_UNKNOWN_ERROR, "Unknown locale: '%s'", MYF(0), buf);
      return 1;
    }
unknown's avatar
unknown committed
3058
  }
3059
  else // STRING_RESULT
unknown's avatar
unknown committed
3060
  {
3061 3062 3063 3064 3065 3066 3067
    char buff[6]; 
    String str(buff, sizeof(buff), &my_charset_latin1), *res;
    if (!(res=var->value->val_str(&str)))
    {
      my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, "NULL");
      return 1;
    }
3068
    const char *locale_str= res->c_ptr_safe();
3069 3070 3071 3072 3073 3074
    if (!(locale_match= my_locale_by_name(locale_str)))
    {
      my_printf_error(ER_UNKNOWN_ERROR,
                      "Unknown locale: '%s'", MYF(0), locale_str);
      return 1;
    }
unknown's avatar
unknown committed
3075
  }
3076

3077 3078
  var->save_result.locale_value= locale_match;
  return 0;
unknown's avatar
unknown committed
3079 3080 3081 3082 3083
}


bool sys_var_thd_lc_time_names::update(THD *thd, set_var *var)
{
3084 3085 3086 3087
  if (var->type == OPT_GLOBAL)
    global_system_variables.lc_time_names= var->save_result.locale_value;
  else
    thd->variables.lc_time_names= var->save_result.locale_value;
unknown's avatar
unknown committed
3088 3089 3090 3091
  return 0;
}


3092
uchar *sys_var_thd_lc_time_names::value_ptr(THD *thd, enum_var_type type,
unknown's avatar
unknown committed
3093 3094
					  LEX_STRING *base)
{
3095
  return type == OPT_GLOBAL ?
3096 3097
                 (uchar *) global_system_variables.lc_time_names->name :
                 (uchar *) thd->variables.lc_time_names->name;
unknown's avatar
unknown committed
3098 3099 3100 3101 3102
}


void sys_var_thd_lc_time_names::set_default(THD *thd, enum_var_type type)
{
3103 3104 3105 3106
  if (type == OPT_GLOBAL)
    global_system_variables.lc_time_names= my_default_lc_time_names;
  else
    thd->variables.lc_time_names= global_system_variables.lc_time_names;
unknown's avatar
unknown committed
3107
}
3108

3109 3110 3111 3112 3113 3114 3115 3116 3117 3118 3119 3120 3121 3122 3123 3124 3125 3126 3127 3128 3129 3130 3131 3132 3133 3134 3135 3136 3137 3138 3139 3140 3141 3142 3143 3144 3145 3146 3147 3148 3149 3150 3151 3152 3153 3154 3155 3156 3157 3158 3159 3160 3161 3162
/*
  Handling of microseoncds given as seconds.part_seconds

  NOTES
    The argument to long query time is in seconds in decimal
    which is converted to ulonglong integer holding microseconds for storage.
    This is used for handling long_query_time
*/

bool sys_var_microseconds::update(THD *thd, set_var *var)
{
  double num= var->value->val_real();
  longlong microseconds;
  if (num > (double) option_limits->max_value)
    num= (double) option_limits->max_value;
  if (num < (double) option_limits->min_value)
    num= (double) option_limits->min_value;
  microseconds= (longlong) (num * 1000000.0 + 0.5);
  if (var->type == OPT_GLOBAL)
  {
    pthread_mutex_lock(&LOCK_global_system_variables);
    (global_system_variables.*offset)= microseconds;
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
  else
    thd->variables.*offset= microseconds;
  return 0;
}


void sys_var_microseconds::set_default(THD *thd, enum_var_type type)
{
  longlong microseconds= (longlong) (option_limits->def_value * 1000000.0);
  if (type == OPT_GLOBAL)
  {
    pthread_mutex_lock(&LOCK_global_system_variables);
    global_system_variables.*offset= microseconds;
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
  else
    thd->variables.*offset= microseconds;
}


uchar *sys_var_microseconds::value_ptr(THD *thd, enum_var_type type,
                                          LEX_STRING *base)
{
  thd->tmp_double_value= (double) ((type == OPT_GLOBAL) ?
                                   global_system_variables.*offset :
                                   thd->variables.*offset) / 1000000.0;
  return (uchar*) &thd->tmp_double_value;
}


unknown's avatar
unknown committed
3163 3164 3165 3166 3167 3168
/*
  Functions to update thd->options bits
*/

static bool set_option_bit(THD *thd, set_var *var)
{
3169 3170 3171
  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
3172
  else
3173
    thd->options|= sys_var->bit_flag;
unknown's avatar
unknown committed
3174 3175 3176
  return 0;
}

3177 3178 3179 3180 3181 3182 3183 3184 3185 3186
/*
  Functions to be only used to update thd->options OPTION_BIN_LOG bit
*/
static bool set_option_log_bin_bit(THD *thd, set_var *var)
{
  set_option_bit(thd, var);
  if (!thd->in_sub_stmt)
    thd->sql_log_bin_toplevel= thd->options & OPTION_BIN_LOG;
  return 0;
}
unknown's avatar
unknown committed
3187 3188 3189 3190 3191

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

3192
  ulonglong org_options= thd->options;
unknown's avatar
unknown committed
3193 3194 3195 3196 3197 3198 3199 3200 3201 3202 3203

  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 */
3204 3205 3206 3207 3208 3209 3210
      if (thd->transaction.xid_state.xa_state != XA_NOTR)
      {
        thd->options= org_options;
        my_error(ER_XAER_RMFAIL, MYF(0),
                 xa_state_names[thd->transaction.xid_state.xa_state]);
        return 1;
      }
unknown's avatar
unknown committed
3211
      thd->options&= ~(ulonglong) (OPTION_BEGIN | OPTION_KEEP_LOG);
unknown's avatar
unknown committed
3212
      thd->transaction.all.modified_non_trans_table= FALSE;
unknown's avatar
unknown committed
3213 3214 3215 3216 3217 3218
      thd->server_status|= SERVER_STATUS_AUTOCOMMIT;
      if (ha_commit(thd))
	return 1;
    }
    else
    {
unknown's avatar
unknown committed
3219
      thd->transaction.all.modified_non_trans_table= FALSE;
unknown's avatar
unknown committed
3220 3221 3222 3223 3224 3225
      thd->server_status&= ~SERVER_STATUS_AUTOCOMMIT;
    }
  }
  return 0;
}

3226 3227 3228
static int check_log_update(THD *thd, set_var *var)
{
#ifndef NO_EMBEDDED_ACCESS_CHECKS
3229
  if (!(thd->security_ctx->master_access & SUPER_ACL))
3230 3231 3232 3233 3234 3235 3236
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
#endif
  return 0;
}
unknown's avatar
unknown committed
3237 3238 3239

static bool set_log_update(THD *thd, set_var *var)
{
3240 3241 3242 3243 3244
  /*
    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
  */
3245

unknown's avatar
unknown committed
3246
  if (opt_sql_bin_update)
3247 3248 3249 3250 3251 3252 3253 3254 3255
  {
    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
3256 3257 3258 3259 3260
  set_option_bit(thd, var);
  return 0;
}


3261 3262 3263 3264
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
3265
  if (thd->security_ctx->master_access & SUPER_ACL)
3266 3267 3268 3269 3270 3271 3272 3273 3274 3275
    return 0;
  else
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
#else
  return 0;
#endif
}
3276

3277
static uchar *get_warning_count(THD *thd)
3278 3279 3280
{
  thd->sys_var_tmp.long_value=
    (thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_NOTE] +
3281
     thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_ERROR] +
3282
     thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_WARN]);
3283
  return (uchar*) &thd->sys_var_tmp.long_value;
3284 3285
}

3286
static uchar *get_error_count(THD *thd)
3287 3288 3289
{
  thd->sys_var_tmp.long_value= 
    thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_ERROR];
3290
  return (uchar*) &thd->sys_var_tmp.long_value;
3291 3292
}

3293

unknown's avatar
unknown committed
3294 3295
/**
  Get the tmpdir that was specified or chosen by default.
3296

unknown's avatar
unknown committed
3297 3298 3299 3300 3301
  This is necessary because if the user does not specify a temporary
  directory via the command line, one is chosen based on the environment
  or system defaults.  But we can't just always use mysql_tmpdir, because
  that is actually a call to my_tmpdir() which cycles among possible
  temporary directories.
3302

unknown's avatar
unknown committed
3303
  @param thd		thread handle
3304

unknown's avatar
unknown committed
3305
  @retval
3306
    ptr		pointer to NUL-terminated string
unknown's avatar
unknown committed
3307
*/
3308
static uchar *get_tmpdir(THD *thd)
3309 3310
{
  if (opt_mysql_tmpdir)
3311 3312
    return (uchar *)opt_mysql_tmpdir;
  return (uchar*)mysql_tmpdir;
3313 3314
}

3315
static uchar *get_myisam_mmap_size(THD *thd)
3316
{
3317
  return (uchar *)&myisam_mmap_size;
3318 3319
}

3320

unknown's avatar
unknown committed
3321 3322 3323 3324 3325 3326 3327
/****************************************************************************
  Main handling of variables:
  - Initialisation
  - Searching during parsing
  - Update loop
****************************************************************************/

unknown's avatar
unknown committed
3328 3329 3330
/**
  Find variable name in option my_getopt structure used for
  command line args.
unknown's avatar
unknown committed
3331

unknown's avatar
unknown committed
3332 3333
  @param opt	option structure array to search in
  @param name	variable name
unknown's avatar
unknown committed
3334

unknown's avatar
unknown committed
3335
  @retval
unknown's avatar
unknown committed
3336
    0		Error
unknown's avatar
unknown committed
3337
  @retval
unknown's avatar
unknown committed
3338 3339 3340 3341 3342 3343 3344 3345 3346 3347 3348 3349 3350 3351 3352 3353 3354 3355 3356 3357 3358 3359
    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;
}


unknown's avatar
unknown committed
3360 3361
/**
  Return variable name and length for hashing of variables.
unknown's avatar
unknown committed
3362 3363
*/

3364 3365
static uchar *get_sys_var_length(const sys_var *var, size_t *length,
                                 my_bool first)
unknown's avatar
unknown committed
3366 3367
{
  *length= var->name_length;
3368
  return (uchar*) var->name;
unknown's avatar
unknown committed
3369 3370 3371 3372
}


/*
unknown's avatar
unknown committed
3373 3374 3375 3376 3377 3378 3379 3380 3381 3382
  Add variables to the dynamic hash of system variables
  
  SYNOPSIS
    mysql_add_sys_var_chain()
    first       Pointer to first system variable to add
    long_opt    (optional)command line arguments may be tied for limit checks.
  
  RETURN VALUES
    0           SUCCESS
    otherwise   FAILURE
unknown's avatar
unknown committed
3383 3384 3385
*/


unknown's avatar
unknown committed
3386
int mysql_add_sys_var_chain(sys_var *first, struct my_option *long_options)
unknown's avatar
unknown committed
3387
{
3388
  sys_var *var;
unknown's avatar
unknown committed
3389 3390 3391 3392
  
  /* A write lock should be held on LOCK_system_variables_hash */
  
  for (var= first; var; var= var->next)
unknown's avatar
unknown committed
3393
  {
3394
    var->name_length= strlen(var->name);
unknown's avatar
unknown committed
3395
    /* this fails if there is a conflicting variable name. see HASH_UNIQUE */
3396
    if (my_hash_insert(&system_variable_hash, (uchar*) var))
unknown's avatar
unknown committed
3397 3398 3399
      goto error;
    if (long_options)
      var->option_limits= find_option(long_options, var->name);
unknown's avatar
unknown committed
3400
  }
unknown's avatar
unknown committed
3401 3402 3403 3404
  return 0;

error:
  for (; first != var; first= first->next)
3405
    hash_delete(&system_variable_hash, (uchar*) first);
unknown's avatar
unknown committed
3406 3407
  return 1;
}
3408 3409
 
 
unknown's avatar
unknown committed
3410 3411
/*
  Remove variables to the dynamic hash of system variables
3412
   
unknown's avatar
unknown committed
3413 3414 3415
  SYNOPSIS
    mysql_del_sys_var_chain()
    first       Pointer to first system variable to remove
3416
   
unknown's avatar
unknown committed
3417 3418 3419 3420
  RETURN VALUES
    0           SUCCESS
    otherwise   FAILURE
*/
3421
 
unknown's avatar
unknown committed
3422 3423 3424
int mysql_del_sys_var_chain(sys_var *first)
{
  int result= 0;
3425
 
unknown's avatar
unknown committed
3426
  /* A write lock should be held on LOCK_system_variables_hash */
3427
   
unknown's avatar
unknown committed
3428
  for (sys_var *var= first; var; var= var->next)
3429
    result|= hash_delete(&system_variable_hash, (uchar*) var);
unknown's avatar
unknown committed
3430 3431 3432

  return result;
}
3433 3434
 
 
unknown's avatar
unknown committed
3435 3436 3437 3438
static int show_cmp(SHOW_VAR *a, SHOW_VAR *b)
{
  return strcmp(a->name, b->name);
}
3439 3440
 
 
unknown's avatar
unknown committed
3441 3442 3443 3444 3445 3446 3447 3448 3449 3450 3451 3452 3453 3454 3455 3456
/*
  Constructs an array of system variables for display to the user.
  
  SYNOPSIS
    enumerate_sys_vars()
    thd         current thread
    sorted      If TRUE, the system variables should be sorted
  
  RETURN VALUES
    pointer     Array of SHOW_VAR elements for display
    NULL        FAILURE
*/

SHOW_VAR* enumerate_sys_vars(THD *thd, bool sorted)
{
  int count= system_variable_hash.records, i;
3457
  int size= sizeof(SHOW_VAR) * (count + 1);
unknown's avatar
unknown committed
3458 3459 3460 3461
  SHOW_VAR *result= (SHOW_VAR*) thd->alloc(size);

  if (result)
  {
3462
    SHOW_VAR *show= result;
unknown's avatar
unknown committed
3463 3464 3465 3466 3467 3468 3469 3470 3471 3472 3473 3474

    for (i= 0; i < count; i++)
    {
      sys_var *var= (sys_var*) hash_element(&system_variable_hash, i);
      show->name= var->name;
      show->value= (char*) var;
      show->type= SHOW_SYS;
      show++;
    }

    /* sort into order */
    if (sorted)
3475
      my_qsort(result, count, sizeof(SHOW_VAR),
3476
               (qsort_cmp) show_cmp);
unknown's avatar
unknown committed
3477 3478 3479
    
    /* make last element empty */
    bzero(show, sizeof(SHOW_VAR));
unknown's avatar
unknown committed
3480
  }
unknown's avatar
unknown committed
3481 3482 3483 3484 3485 3486 3487 3488 3489 3490 3491 3492 3493 3494 3495 3496 3497 3498 3499 3500
  return result;
}


/*
  Initialize the system variables
  
  SYNOPSIS
    set_var_init()
  
  RETURN VALUES
    0           SUCCESS
    otherwise   FAILURE
*/

int set_var_init()
{
  uint count= 0;
  DBUG_ENTER("set_var_init");
  
3501
  for (sys_var *var=vars.first; var; var= var->next, count++) ;
unknown's avatar
unknown committed
3502 3503 3504 3505 3506 3507 3508 3509 3510

  if (hash_init(&system_variable_hash, system_charset_info, count, 0,
                0, (hash_get_key) get_sys_var_length, 0, HASH_UNIQUE))
    goto error;

  vars.last->next= NULL;
  if (mysql_add_sys_var_chain(vars.first, my_long_options))
    goto error;

unknown's avatar
unknown committed
3511 3512 3513 3514 3515 3516 3517
  /*
    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;
unknown's avatar
unknown committed
3518 3519 3520 3521 3522 3523

  DBUG_RETURN(0);

error:
  fprintf(stderr, "failed to initialize system variables");
  DBUG_RETURN(1);
unknown's avatar
unknown committed
3524 3525 3526 3527 3528 3529 3530 3531 3532
}


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


unknown's avatar
unknown committed
3533 3534
/**
  Find a user set-table variable.
unknown's avatar
unknown committed
3535

unknown's avatar
unknown committed
3536 3537 3538 3539
  @param str	   Name of system variable to find
  @param length    Length of variable.  zero means that we should use strlen()
                   on the variable
  @param no_error  Refuse to emit an error, even if one occurred.
unknown's avatar
unknown committed
3540

unknown's avatar
unknown committed
3541
  @retval
unknown's avatar
unknown committed
3542
    pointer	pointer to variable definitions
unknown's avatar
unknown committed
3543
  @retval
unknown's avatar
unknown committed
3544 3545 3546
    0		Unknown variable (error message is given)
*/

unknown's avatar
unknown committed
3547
sys_var *intern_find_sys_var(const char *str, uint length, bool no_error)
unknown's avatar
unknown committed
3548
{
unknown's avatar
unknown committed
3549 3550 3551 3552 3553 3554 3555
  sys_var *var;

  /*
    This function is only called from the sql_plugin.cc.
    A lock on LOCK_system_variable_hash should be held
  */
  var= (sys_var*) hash_search(&system_variable_hash,
3556
			      (uchar*) str, length ? length : strlen(str));
unknown's avatar
unknown committed
3557
  if (!(var || no_error))
3558
    my_error(ER_UNKNOWN_SYSTEM_VARIABLE, MYF(0), (char*) str);
unknown's avatar
unknown committed
3559

unknown's avatar
unknown committed
3560 3561 3562 3563
  return var;
}


unknown's avatar
unknown committed
3564 3565
/**
  Execute update of all variables.
unknown's avatar
unknown committed
3566

unknown's avatar
unknown committed
3567 3568
  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.
unknown's avatar
unknown committed
3569

unknown's avatar
unknown committed
3570 3571
  This should ensure that in all normal cases none all or variables are
  updated.
unknown's avatar
unknown committed
3572

unknown's avatar
unknown committed
3573 3574
  @param THD		Thread id
  @param var_list       List of variables to update
unknown's avatar
unknown committed
3575

unknown's avatar
unknown committed
3576
  @retval
unknown's avatar
unknown committed
3577
    0	ok
unknown's avatar
unknown committed
3578
  @retval
3579
    1	ERROR, message sent (normally no variables was updated)
unknown's avatar
unknown committed
3580
  @retval
3581
    -1  ERROR, message not sent
unknown's avatar
unknown committed
3582 3583
*/

3584
int sql_set_variables(THD *thd, List<set_var_base> *var_list)
unknown's avatar
unknown committed
3585
{
unknown's avatar
unknown committed
3586
  int error;
unknown's avatar
unknown committed
3587
  List_iterator_fast<set_var_base> it(*var_list);
unknown's avatar
unknown committed
3588
  DBUG_ENTER("sql_set_variables");
unknown's avatar
unknown committed
3589 3590 3591 3592

  set_var_base *var;
  while ((var=it++))
  {
unknown's avatar
unknown committed
3593
    if ((error= var->check(thd)))
3594
      goto err;
unknown's avatar
unknown committed
3595
  }
3596
  if (!(error= test(thd->is_error())))
3597 3598 3599 3600 3601
  {
    it.rewind();
    while ((var= it++))
      error|= var->update(thd);         // Returns 0, -1 or 1
  }
unknown's avatar
unknown committed
3602

3603 3604
err:
  free_underlaid_joins(thd, &thd->lex->select_lex);
unknown's avatar
unknown committed
3605
  DBUG_RETURN(error);
unknown's avatar
unknown committed
3606 3607 3608
}


unknown's avatar
unknown committed
3609 3610 3611 3612
/**
  Say if all variables set by a SET support the ONE_SHOT keyword
  (currently, only character set and collation do; later timezones
  will).
3613

unknown's avatar
unknown committed
3614
  @param var_list	List of variables to update
3615

unknown's avatar
unknown committed
3616
  @note
3617 3618
    It has a "not_" because it makes faster tests (no need to "!")

unknown's avatar
unknown committed
3619
  @retval
3620
    0	all variables of the list support ONE_SHOT
unknown's avatar
unknown committed
3621
  @retval
3622 3623 3624 3625 3626 3627 3628 3629 3630 3631 3632 3633 3634 3635 3636 3637
    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
3638 3639 3640 3641
/*****************************************************************************
  Functions to handle SET mysql_internal_variable=const_expr
*****************************************************************************/

3642
int set_var::check(THD *thd)
unknown's avatar
unknown committed
3643
{
3644 3645 3646 3647 3648
  if (var->is_readonly())
  {
    my_error(ER_INCORRECT_GLOBAL_LOCAL_VAR, MYF(0), var->name, "read only");
    return -1;
  }
unknown's avatar
unknown committed
3649 3650
  if (var->check_type(type))
  {
unknown's avatar
unknown committed
3651
    int err= type == OPT_GLOBAL ? ER_LOCAL_VARIABLE : ER_GLOBAL_VARIABLE;
3652
    my_error(err, MYF(0), var->name);
3653
    return -1;
unknown's avatar
unknown committed
3654 3655 3656 3657 3658 3659 3660 3661
  }
  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))
    {
3662
      my_error(ER_NO_DEFAULT, MYF(0), var->name);
3663
      return -1;
unknown's avatar
unknown committed
3664 3665 3666 3667
    }
    return 0;
  }

unknown's avatar
unknown committed
3668
  if ((!value->fixed &&
3669
       value->fix_fields(thd, &value)) || value->check_cols(1))
3670
    return -1;
unknown's avatar
unknown committed
3671 3672
  if (var->check_update_type(value->result_type()))
  {
3673
    my_error(ER_WRONG_TYPE_FOR_VAR, MYF(0), var->name);
3674
    return -1;
3675
  }
3676
  return var->check(thd, this) ? -1 : 0;
unknown's avatar
unknown committed
3677 3678 3679
}


unknown's avatar
unknown committed
3680 3681
/**
  Check variable, but without assigning value (used by PS).
unknown's avatar
unknown committed
3682

unknown's avatar
unknown committed
3683
  @param thd		thread handler
unknown's avatar
unknown committed
3684

unknown's avatar
unknown committed
3685
  @retval
unknown's avatar
unknown committed
3686
    0	ok
unknown's avatar
unknown committed
3687
  @retval
unknown's avatar
unknown committed
3688
    1	ERROR, message sent (normally no variables was updated)
unknown's avatar
unknown committed
3689 3690
  @retval
    -1   ERROR, message not sent
unknown's avatar
unknown committed
3691
*/
3692 3693 3694 3695
int set_var::light_check(THD *thd)
{
  if (var->check_type(type))
  {
unknown's avatar
unknown committed
3696
    int err= type == OPT_GLOBAL ? ER_LOCAL_VARIABLE : ER_GLOBAL_VARIABLE;
3697
    my_error(err, MYF(0), var->name);
3698 3699
    return -1;
  }
unknown's avatar
unknown committed
3700
  if (type == OPT_GLOBAL && check_global_access(thd, SUPER_ACL))
3701 3702
    return 1;

3703
  if (value && ((!value->fixed && value->fix_fields(thd, &value)) ||
unknown's avatar
unknown committed
3704
                value->check_cols(1)))
3705 3706 3707 3708
    return -1;
  return 0;
}

3709 3710
/**
  Update variable
3711

3712 3713 3714 3715 3716 3717 3718 3719 3720
  @param   thd    thread handler
  @returns 0|1    ok or	ERROR

  @note ERROR can be only due to abnormal operations involving
  the server's execution evironment such as
  out of memory, hard disk failure or the computer blows up.
  Consider set_var::check() method if there is a need to return
  an error due to logics.
*/
3721
int set_var::update(THD *thd)
unknown's avatar
unknown committed
3722 3723 3724 3725
{
  if (!value)
    var->set_default(thd, type);
  else if (var->update(thd, this))
3726
    return -1;				// should never happen
unknown's avatar
unknown committed
3727 3728 3729 3730 3731 3732 3733 3734 3735 3736
  if (var->after_update)
    (*var->after_update)(thd, type);
  return 0;
}


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

3737
int set_var_user::check(THD *thd)
unknown's avatar
unknown committed
3738
{
unknown's avatar
unknown committed
3739 3740
  /*
    Item_func_set_user_var can't substitute something else on its place =>
3741
    0 can be passed as last argument (reference on item)
unknown's avatar
unknown committed
3742
  */
3743
  return (user_var_item->fix_fields(thd, (Item**) 0) ||
3744
	  user_var_item->check(0)) ? -1 : 0;
unknown's avatar
unknown committed
3745 3746 3747
}


unknown's avatar
unknown committed
3748 3749
/**
  Check variable, but without assigning value (used by PS).
unknown's avatar
unknown committed
3750

unknown's avatar
unknown committed
3751
  @param thd		thread handler
unknown's avatar
unknown committed
3752

unknown's avatar
unknown committed
3753
  @retval
unknown's avatar
unknown committed
3754
    0	ok
unknown's avatar
unknown committed
3755
  @retval
unknown's avatar
unknown committed
3756
    1	ERROR, message sent (normally no variables was updated)
unknown's avatar
unknown committed
3757 3758
  @retval
    -1   ERROR, message not sent
unknown's avatar
unknown committed
3759
*/
3760 3761 3762 3763 3764 3765
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)
  */
3766
  return (user_var_item->fix_fields(thd, (Item**) 0));
3767 3768 3769
}


3770
int set_var_user::update(THD *thd)
unknown's avatar
unknown committed
3771 3772 3773 3774
{
  if (user_var_item->update())
  {
    /* Give an error if it's not given already */
unknown's avatar
unknown committed
3775
    my_message(ER_SET_CONSTANTS_ONLY, ER(ER_SET_CONSTANTS_ONLY), MYF(0));
3776
    return -1;
unknown's avatar
unknown committed
3777 3778 3779 3780 3781 3782 3783 3784 3785
  }
  return 0;
}


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

3786
int set_var_password::check(THD *thd)
unknown's avatar
unknown committed
3787
{
unknown's avatar
unknown committed
3788
#ifndef NO_EMBEDDED_ACCESS_CHECKS
unknown's avatar
unknown committed
3789
  if (!user->host.str)
3790
  {
3791
    DBUG_ASSERT(thd->security_ctx->priv_host);
3792
    if (*thd->security_ctx->priv_host != 0)
3793
    {
3794 3795
      user->host.str= (char *) thd->security_ctx->priv_host;
      user->host.length= strlen(thd->security_ctx->priv_host);
3796 3797 3798 3799 3800 3801 3802
    }
    else
    {
      user->host.str= (char *)"%";
      user->host.length= 1;
    }
  }
3803 3804 3805 3806 3807 3808
  if (!user->user.str)
  {
    DBUG_ASSERT(thd->security_ctx->priv_user);
    user->user.str= (char *) thd->security_ctx->priv_user;
    user->user.length= strlen(thd->security_ctx->priv_user);
  }
3809
  /* Returns 1 as the function sends error to client */
3810 3811
  return check_change_password(thd, user->host.str, user->user.str,
                               password, strlen(password)) ? 1 : 0;
3812
#else
unknown's avatar
unknown committed
3813 3814
  return 0;
#endif
unknown's avatar
unknown committed
3815 3816
}

3817
int set_var_password::update(THD *thd)
unknown's avatar
unknown committed
3818
{
unknown's avatar
unknown committed
3819
#ifndef NO_EMBEDDED_ACCESS_CHECKS
3820
  /* Returns 1 as the function sends error to client */
3821 3822
  return change_password(thd, user->host.str, user->user.str, password) ?
	  1 : 0;
unknown's avatar
unknown committed
3823 3824 3825
#else
  return 0;
#endif
unknown's avatar
unknown committed
3826 3827
}

3828 3829 3830 3831 3832 3833 3834 3835 3836 3837 3838 3839 3840 3841 3842 3843 3844 3845
/****************************************************************************
 Functions to handle log_slow_filter
****************************************************************************/
  
/* Ensure that the proper bits are set for easy test of logging */
static void fix_sys_log_slow_filter(THD *thd, enum_var_type type)
{
  /* Maintain everything with filters */
  opt_log_slow_admin_statements= 1;
  if (type == OPT_GLOBAL)
    global_system_variables.log_slow_filter=
      fix_log_slow_filter(global_system_variables.log_slow_filter);
  else
    thd->variables.log_slow_filter=
      fix_log_slow_filter(thd->variables.log_slow_filter);
}


3846 3847 3848 3849
/****************************************************************************
 Functions to handle table_type
****************************************************************************/

unknown's avatar
unknown committed
3850 3851
/* Based upon sys_var::check_enum() */

unknown's avatar
unknown committed
3852
bool sys_var_thd_storage_engine::check(THD *thd, set_var *var)
3853
{
unknown's avatar
unknown committed
3854
  char buff[STRING_BUFFER_USUAL_SIZE];
3855
  const char *value;
3856
  String str(buff, sizeof(buff) - 1, &my_charset_latin1), *res;
3857

unknown's avatar
unknown committed
3858
  var->save_result.plugin= NULL;
3859 3860
  if (var->value->result_type() == STRING_RESULT)
  {
3861
    LEX_STRING engine_name;
unknown's avatar
unknown committed
3862
    handlerton *hton;
3863
    if (!(res=var->value->val_str(&str)) ||
3864 3865 3866
        !(engine_name.str= (char *)res->ptr()) ||
        !(engine_name.length= res->length()) ||
	!(var->save_result.plugin= ha_resolve_by_name(thd, &engine_name)) ||
unknown's avatar
unknown committed
3867 3868
        !(hton= plugin_data(var->save_result.plugin, handlerton *)) ||
        ha_checktype(thd, ha_legacy_type(hton), 1, 0) != hton)
3869 3870 3871 3872 3873 3874
    {
      value= res ? res->c_ptr() : "NULL";
      goto err;
    }
    return 0;
  }
unknown's avatar
unknown committed
3875
  value= "unknown";
3876 3877

err:
3878
  my_error(ER_UNKNOWN_STORAGE_ENGINE, MYF(0), value);
unknown's avatar
unknown committed
3879
  return 1;
3880 3881
}

unknown's avatar
unknown committed
3882

3883
uchar *sys_var_thd_storage_engine::value_ptr(THD *thd, enum_var_type type,
unknown's avatar
unknown committed
3884
					    LEX_STRING *base)
3885
{
3886
  uchar* result;
unknown's avatar
unknown committed
3887
  handlerton *hton;
3888
  LEX_STRING *engine_name;
unknown's avatar
unknown committed
3889 3890
  plugin_ref plugin= thd->variables.*offset;
  if (type == OPT_GLOBAL)
3891
    plugin= my_plugin_lock(thd, global_system_variables.*offset);
unknown's avatar
unknown committed
3892
  hton= plugin_data(plugin, handlerton*);
3893
  engine_name= hton_name(hton);
3894
  result= (uchar *) thd->strmake(engine_name->str, engine_name->length);
unknown's avatar
unknown committed
3895 3896 3897
  if (type == OPT_GLOBAL)
    plugin_unlock(thd, plugin);
  return result;
3898 3899
}

unknown's avatar
unknown committed
3900

unknown's avatar
unknown committed
3901
void sys_var_thd_storage_engine::set_default(THD *thd, enum_var_type type)
3902
{
unknown's avatar
unknown committed
3903
  plugin_ref old_value, new_value, *value;
3904
  if (type == OPT_GLOBAL)
unknown's avatar
unknown committed
3905 3906 3907 3908
  {
    value= &(global_system_variables.*offset);
    new_value= ha_lock_engine(NULL, myisam_hton);
  }
3909
  else
unknown's avatar
unknown committed
3910 3911
  {
    value= &(thd->variables.*offset);
3912
    new_value= my_plugin_lock(NULL, global_system_variables.*offset);
unknown's avatar
unknown committed
3913 3914 3915 3916 3917
  }
  DBUG_ASSERT(new_value);
  old_value= *value;
  *value= new_value;
  plugin_unlock(NULL, old_value);
3918 3919
}

unknown's avatar
unknown committed
3920

unknown's avatar
unknown committed
3921
bool sys_var_thd_storage_engine::update(THD *thd, set_var *var)
3922
{
unknown's avatar
unknown committed
3923 3924 3925 3926 3927 3928
  plugin_ref *value= &(global_system_variables.*offset), old_value;
   if (var->type != OPT_GLOBAL)
     value= &(thd->variables.*offset);
  old_value= *value;
  if (old_value != var->save_result.plugin)
  {
3929
    *value= my_plugin_lock(NULL, var->save_result.plugin);
unknown's avatar
unknown committed
3930 3931
    plugin_unlock(NULL, old_value);
  }
3932 3933 3934
  return 0;
}

unknown's avatar
unknown committed
3935 3936
void sys_var_thd_table_type::warn_deprecated(THD *thd)
{
3937
  WARN_DEPRECATED(thd, "6.0", "@@table_type", "'@@storage_engine'");
unknown's avatar
unknown committed
3938 3939 3940 3941 3942 3943 3944 3945 3946 3947 3948 3949 3950 3951
}

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
3952

3953 3954 3955
/****************************************************************************
 Functions to handle sql_mode
****************************************************************************/
3956

3957 3958 3959 3960 3961 3962
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
3963
  {
3964
    thd->variables.sql_mode= fix_sql_mode(thd->variables.sql_mode);
3965 3966 3967 3968 3969 3970 3971 3972
    /*
      Update thd->server_status
     */
    if (thd->variables.sql_mode & MODE_NO_BACKSLASH_ESCAPES)
      thd->server_status|= SERVER_STATUS_NO_BACKSLASH_ESCAPES;
    else
      thd->server_status&= ~SERVER_STATUS_NO_BACKSLASH_ESCAPES;
  }
3973 3974
}

unknown's avatar
unknown committed
3975
/** Map database specific bits to function bits. */
3976

3977 3978 3979 3980 3981 3982 3983 3984 3985
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)
3986
  {
3987
    sql_mode|= (MODE_REAL_AS_FLOAT | MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
3988 3989 3990 3991 3992 3993
		MODE_IGNORE_SPACE);
    /* 
      MODE_ONLY_FULL_GROUP_BY removed from ANSI mode because it is currently
      overly restrictive (see BUG#8510).
    */
  }
3994 3995 3996 3997
  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 |
3998
		MODE_NO_FIELD_OPTIONS | MODE_NO_AUTO_CREATE_USER);
3999 4000 4001 4002 4003 4004 4005 4006 4007 4008 4009 4010 4011 4012 4013
  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);
4014
  if (sql_mode & MODE_MAXDB)
4015 4016 4017
    sql_mode|= (MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE |
		MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS |
4018
		MODE_NO_FIELD_OPTIONS | MODE_NO_AUTO_CREATE_USER);
4019
  if (sql_mode & MODE_MYSQL40)
4020
    sql_mode|= MODE_HIGH_NOT_PRECEDENCE;
4021
  if (sql_mode & MODE_MYSQL323)
4022
    sql_mode|= MODE_HIGH_NOT_PRECEDENCE;
unknown's avatar
unknown committed
4023 4024 4025
  if (sql_mode & MODE_TRADITIONAL)
    sql_mode|= (MODE_STRICT_TRANS_TABLES | MODE_STRICT_ALL_TABLES |
                MODE_NO_ZERO_IN_DATE | MODE_NO_ZERO_DATE |
4026
                MODE_ERROR_FOR_DIVISION_BY_ZERO | MODE_NO_AUTO_CREATE_USER);
4027 4028
  return sql_mode;
}
4029 4030


4031 4032 4033 4034 4035 4036
bool
sys_var_thd_optimizer_switch::
symbolic_mode_representation(THD *thd, ulonglong val, LEX_STRING *rep)
{
  char buff[STRING_BUFFER_USUAL_SIZE*8];
  String tmp(buff, sizeof(buff), &my_charset_latin1);
4037 4038
  int i;
  ulonglong bit;
4039
  tmp.length(0);
4040 4041
 
  for (i= 0, bit=1; bit != OPTIMIZER_SWITCH_LAST; i++, bit= bit << 1)
4042
  {
4043 4044 4045 4046 4047
    tmp.append(optimizer_switch_typelib.type_names[i],
               optimizer_switch_typelib.type_lengths[i]);
    tmp.append('=');
    tmp.append((val & bit)? "on":"off");
    tmp.append(',');
4048 4049 4050 4051 4052 4053 4054 4055 4056 4057 4058 4059 4060 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071
  }

  if (tmp.length())
    tmp.length(tmp.length() - 1); /* trim the trailing comma */

  rep->str= thd->strmake(tmp.ptr(), tmp.length());

  rep->length= rep->str ? tmp.length() : 0;

  return rep->length != tmp.length();
}


uchar *sys_var_thd_optimizer_switch::value_ptr(THD *thd, enum_var_type type,
				               LEX_STRING *base)
{
  LEX_STRING opts;
  ulonglong val= ((type == OPT_GLOBAL) ? global_system_variables.*offset :
                  thd->variables.*offset);
  (void) symbolic_mode_representation(thd, val, &opts);
  return (uchar *) opts.str;
}


4072 4073 4074 4075 4076
/*
  Check (and actually parse) string representation of @@optimizer_switch.
*/

bool sys_var_thd_optimizer_switch::check(THD *thd, set_var *var)
4077
{
4078 4079 4080 4081 4082 4083 4084 4085 4086 4087 4088 4089 4090 4091 4092 4093 4094 4095 4096 4097 4098 4099
  bool not_used;
  char buff[STRING_BUFFER_USUAL_SIZE], *error= 0;
  uint error_len= 0;
  String str(buff, sizeof(buff), system_charset_info), *res;

  if (!(res= var->value->val_str(&str)))
  {
    strmov(buff, "NULL");
    goto err;
  }
  
  if (res->length() == 0)
  {
    buff[0]= 0;
    goto err;
  }

  var->save_result.ulong_value= 
    (ulong)find_set_from_flags(&optimizer_switch_typelib, 
                               optimizer_switch_typelib.count, 
                               thd->variables.optimizer_switch,
                               global_system_variables.optimizer_switch,
4100
                               res->ptr(), res->length(), NULL,
4101 4102 4103 4104 4105 4106 4107 4108 4109 4110
                               &error, &error_len, &not_used);
  if (error_len)
  {
    strmake(buff, error, min(sizeof(buff) - 1, error_len));
    goto err;
  }
  return FALSE;
err:
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, buff);
  return TRUE;
4111 4112 4113
}


4114 4115 4116 4117 4118 4119 4120 4121
void sys_var_thd_optimizer_switch::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
    global_system_variables.*offset= OPTIMIZER_SWITCH_DEFAULT;
  else
    thd->variables.*offset= global_system_variables.*offset;
}

4122 4123 4124 4125
/****************************************************************************
  Named list handling
****************************************************************************/

4126
uchar* find_named(I_List<NAMED_LIST> *list, const char *name, uint length,
unknown's avatar
unknown committed
4127
		NAMED_LIST **found)
4128 4129 4130 4131 4132 4133
{
  I_List_iterator<NAMED_LIST> it(*list);
  NAMED_LIST *element;
  while ((element= it++))
  {
    if (element->cmp(name, length))
unknown's avatar
unknown committed
4134
    {
4135 4136
      if (found)
        *found= element;
4137
      return element->data;
unknown's avatar
unknown committed
4138
    }
4139 4140 4141 4142 4143
  }
  return 0;
}


4144
void delete_elements(I_List<NAMED_LIST> *list,
4145
		     void (*free_element)(const char *name, uchar*))
4146 4147
{
  NAMED_LIST *element;
unknown's avatar
unknown committed
4148
  DBUG_ENTER("delete_elements");
4149 4150
  while ((element= list->get()))
  {
4151
    (*free_element)(element->name, element->data);
4152 4153
    delete element;
  }
unknown's avatar
unknown committed
4154
  DBUG_VOID_RETURN;
4155 4156 4157 4158 4159
}


/* Key cache functions */

unknown's avatar
unknown committed
4160
static KEY_CACHE *create_key_cache(const char *name, uint length)
4161
{
unknown's avatar
unknown committed
4162
  KEY_CACHE *key_cache;
4163 4164 4165
  DBUG_ENTER("create_key_cache");
  DBUG_PRINT("enter",("name: %.*s", length, name));
  
unknown's avatar
unknown committed
4166
  if ((key_cache= (KEY_CACHE*) my_malloc(sizeof(KEY_CACHE),
4167
					     MYF(MY_ZEROFILL | MY_WME))))
unknown's avatar
unknown committed
4168
  {
4169
    if (!new NAMED_LIST(&key_caches, name, length, (uchar*) key_cache))
4170 4171
    {
      my_free((char*) key_cache, MYF(0));
unknown's avatar
unknown committed
4172
      key_cache= 0;
4173 4174 4175 4176 4177 4178 4179 4180 4181
    }
    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
4182 4183 4184
      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;
4185
      key_cache->param_partitions=     dflt_key_cache_var.param_partitions;
4186
    }
unknown's avatar
unknown committed
4187
  }
4188
  DBUG_RETURN(key_cache);
4189 4190 4191
}


unknown's avatar
unknown committed
4192
KEY_CACHE *get_or_create_key_cache(const char *name, uint length)
4193
{
unknown's avatar
unknown committed
4194
  LEX_STRING key_cache_name;
unknown's avatar
unknown committed
4195
  KEY_CACHE *key_cache;
4196

unknown's avatar
unknown committed
4197 4198
  key_cache_name.str= (char *) name;
  key_cache_name.length= length;
4199 4200
  pthread_mutex_lock(&LOCK_global_system_variables);
  if (!(key_cache= get_key_cache(&key_cache_name)))
4201
    key_cache= create_key_cache(name, length);
4202
  pthread_mutex_unlock(&LOCK_global_system_variables);
4203 4204 4205 4206
  return key_cache;
}


unknown's avatar
unknown committed
4207
void free_key_cache(const char *name, KEY_CACHE *key_cache)
4208
{
4209 4210
  ha_end_key_cache(key_cache);
  my_free((char*) key_cache, MYF(0));
unknown's avatar
unknown committed
4211 4212 4213
}


4214
bool process_key_caches(process_key_cache_t func)
4215
{
unknown's avatar
unknown committed
4216 4217
  I_List_iterator<NAMED_LIST> it(key_caches);
  NAMED_LIST *element;
4218

unknown's avatar
unknown committed
4219 4220
  while ((element= it++))
  {
unknown's avatar
unknown committed
4221
    KEY_CACHE *key_cache= (KEY_CACHE *) element->data;
4222
    func(element->name, key_cache);
unknown's avatar
unknown committed
4223 4224
  }
  return 0;
4225 4226
}

4227

4228 4229
void sys_var_trust_routine_creators::warn_deprecated(THD *thd)
{
4230
  WARN_DEPRECATED(thd, VER_CELOSIA, "@@log_bin_trust_routine_creators",
4231
                      "'@@log_bin_trust_function_creators'");
4232 4233 4234 4235 4236 4237 4238 4239 4240 4241 4242 4243 4244 4245
}

void sys_var_trust_routine_creators::set_default(THD *thd, enum_var_type type)
{
  warn_deprecated(thd);
  sys_var_bool_ptr::set_default(thd, type);
}

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

unknown's avatar
unknown committed
4246 4247 4248 4249 4250 4251 4252 4253 4254 4255 4256 4257 4258 4259 4260 4261 4262 4263 4264 4265 4266 4267 4268 4269 4270 4271 4272 4273 4274 4275 4276 4277 4278 4279 4280 4281 4282 4283 4284 4285 4286 4287 4288 4289 4290 4291 4292 4293
bool sys_var_opt_readonly::update(THD *thd, set_var *var)
{
  bool result;

  DBUG_ENTER("sys_var_opt_readonly::update");

  /* Prevent self dead-lock */
  if (thd->locked_tables || thd->active_transaction())
  {
    my_error(ER_LOCK_OR_ACTIVE_TRANSACTION, MYF(0));
    DBUG_RETURN(true);
  }

  if (thd->global_read_lock)
  {
    /*
      This connection already holds the global read lock.
      This can be the case with:
      - FLUSH TABLES WITH READ LOCK
      - SET GLOBAL READ_ONLY = 1
    */
    result= sys_var_bool_ptr::update(thd, var);
    DBUG_RETURN(result);
  }

  /*
    Perform a 'FLUSH TABLES WITH READ LOCK'.
    This is a 3 step process:
    - [1] lock_global_read_lock()
    - [2] close_cached_tables()
    - [3] make_global_read_lock_block_commit()
    [1] prevents new connections from obtaining tables locked for write.
    [2] waits until all existing connections close their tables.
    [3] prevents transactions from being committed.
  */

  if (lock_global_read_lock(thd))
    DBUG_RETURN(true);

  /*
    This call will be blocked by any connection holding a READ or WRITE lock.
    Ideally, we want to wait only for pending WRITE locks, but since:
    con 1> LOCK TABLE T FOR READ;
    con 2> LOCK TABLE T FOR WRITE; (blocked by con 1)
    con 3> SET GLOBAL READ ONLY=1; (blocked by con 2)
    can cause to wait on a read lock, it's required for the client application
    to unlock everything, and acceptable for the server to wait on all locks.
  */
4294
  if ((result= close_cached_tables(thd, NULL, FALSE, TRUE, TRUE)))
unknown's avatar
unknown committed
4295 4296
    goto end_with_read_lock;

4297
  if ((result= make_global_read_lock_block_commit(thd)))
unknown's avatar
unknown committed
4298 4299 4300 4301 4302 4303 4304 4305 4306 4307 4308 4309
    goto end_with_read_lock;

  /* Change the opt_readonly system variable, safe because the lock is held */
  result= sys_var_bool_ptr::update(thd, var);

end_with_read_lock:
  /* Release the lock */
  unlock_global_read_lock(thd);
  DBUG_RETURN(result);
}


4310
#ifndef DBUG_OFF
unknown's avatar
unknown committed
4311 4312 4313 4314 4315 4316 4317 4318
/* even session variable here requires SUPER, because of -#o,file */
bool sys_var_thd_dbug::check(THD *thd, set_var *var)
{
  return check_global_access(thd, SUPER_ACL);
}

bool sys_var_thd_dbug::update(THD *thd, set_var *var)
{
4319 4320
  char buf[256];
  String str(buf, sizeof(buf), system_charset_info), *res;
Michael Widenius's avatar
Michael Widenius committed
4321 4322
  const char *command;
 
4323
  res= var->value->val_str(&str);
Michael Widenius's avatar
Michael Widenius committed
4324 4325 4326
  command= res ? res->c_ptr(): 0;
  if (!command)
    command= "";
4327

unknown's avatar
unknown committed
4328
  if (var->type == OPT_GLOBAL)
4329
    DBUG_SET_INITIAL(command);
unknown's avatar
unknown committed
4330
  else
4331 4332 4333 4334 4335 4336 4337 4338 4339 4340 4341 4342 4343 4344 4345
  {
    if (_db_is_pushed_())
    {
      /* We have already a local state done with DBUG_PUSH; Modify the state */
      DBUG_SET(command);
    }
    else
    {
      /*
        We are sharing the state with the global state;
        Create a local state for this thread.
      */
      DBUG_PUSH(command);
    }
  }
unknown's avatar
unknown committed
4346 4347 4348
  return 0;
}

4349

4350
uchar *sys_var_thd_dbug::value_ptr(THD *thd, enum_var_type type, LEX_STRING *b)
unknown's avatar
unknown committed
4351
{
4352
  char buf[1024];
unknown's avatar
unknown committed
4353
  if (type == OPT_GLOBAL)
4354
  {
unknown's avatar
unknown committed
4355
    DBUG_EXPLAIN_INITIAL(buf, sizeof(buf));
4356
  }
unknown's avatar
unknown committed
4357
  else
4358
  {
unknown's avatar
unknown committed
4359
    DBUG_EXPLAIN(buf, sizeof(buf));
4360
  }
4361
  return (uchar*) thd->strdup(buf);
unknown's avatar
unknown committed
4362
}
4363 4364
#endif /* DBUG_OFF */

unknown's avatar
unknown committed
4365

4366
#ifdef HAVE_EVENT_SCHEDULER
4367 4368 4369 4370 4371
bool sys_var_event_scheduler::check(THD *thd, set_var *var)
{
  return check_enum(thd, var, &Events::var_typelib);
}

4372 4373 4374 4375 4376 4377 4378 4379 4380 4381 4382 4383 4384 4385 4386 4387 4388 4389
/*
   The update method of the global variable event_scheduler.
   If event_scheduler is switched from 0 to 1 then the scheduler main
   thread is resumed and if from 1 to 0 the scheduler thread is suspended

   SYNOPSIS
     sys_var_event_scheduler::update()
       thd  Thread context (unused)
       var  The new value

   Returns
     FALSE  OK
     TRUE   Error
*/

bool
sys_var_event_scheduler::update(THD *thd, set_var *var)
{
unknown's avatar
unknown committed
4390
  int res;
4391 4392
  /* here start the thread if not running. */
  DBUG_ENTER("sys_var_event_scheduler::update");
unknown's avatar
unknown committed
4393
  DBUG_PRINT("info", ("new_value: %d", (int) var->save_result.ulong_value));
4394

4395 4396 4397 4398
  enum Events::enum_opt_event_scheduler
    new_state=
    (enum Events::enum_opt_event_scheduler) var->save_result.ulong_value;

4399
  res= Events::switch_event_scheduler_state(new_state);
4400 4401 4402 4403 4404

  DBUG_RETURN((bool) res);
}


4405
uchar *sys_var_event_scheduler::value_ptr(THD *thd, enum_var_type type,
4406 4407
                                         LEX_STRING *base)
{
4408
  return (uchar *) Events::get_opt_event_scheduler_str();
4409
}
4410
#endif
4411

unknown's avatar
unknown committed
4412 4413 4414 4415
/****************************************************************************
  Used templates
****************************************************************************/

4416
#ifdef HAVE_EXPLICIT_TEMPLATE_INSTANTIATION
unknown's avatar
unknown committed
4417
template class List<set_var_base>;
unknown's avatar
unknown committed
4418
template class List_iterator_fast<set_var_base>;
4419
template class I_List_iterator<NAMED_LIST>;
unknown's avatar
unknown committed
4420
#endif