set_var.cc 115 KB
Newer Older
1
/* Copyright (C) 2000-2003 MySQL AB
unknown's avatar
unknown committed
2 3 4

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

   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
16 17 18 19
/**
  @file

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

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

unknown's avatar
unknown committed
35 36 37 38 39 40 41 42 43 44
  @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
45 46 47
    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
48 49
*/

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

#include "mysql_priv.h"
55
#include <mysql.h>
unknown's avatar
unknown committed
56
#include "slave.h"
57
#include "rpl_mi.h"
unknown's avatar
unknown committed
58
#include <my_getopt.h>
59
#include <thr_alarm.h>
unknown's avatar
unknown committed
60
#include <myisam.h>
61
#include <my_dir.h>
62

63
#include "events.h"
64

65
/* WITH_NDBCLUSTER_STORAGE_ENGINE */
66
#ifdef WITH_NDBCLUSTER_STORAGE_ENGINE
67
extern ulong ndb_cache_check_time;
68
extern char opt_ndb_constrbuf[];
unknown's avatar
unknown committed
69
extern ulong ndb_extra_logging;
70 71
#endif

unknown's avatar
unknown committed
72 73 74 75
#ifdef HAVE_NDB_BINLOG
extern ulong ndb_report_thresh_binlog_epoch_slip;
extern ulong ndb_report_thresh_binlog_mem_usage;
#endif
76

unknown's avatar
unknown committed
77
extern CHARSET_INFO *character_set_filesystem;
78 79


unknown's avatar
unknown committed
80
static DYNAMIC_ARRAY fixed_show_vars;
unknown's avatar
unknown committed
81
static HASH system_variable_hash;
unknown's avatar
unknown committed
82

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

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

96 97 98
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
99 100 101 102
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
103 104
static bool set_option_bit(THD *thd, set_var *var);
static bool set_option_autocommit(THD *thd, set_var *var);
105
static int  check_log_update(THD *thd, set_var *var);
unknown's avatar
unknown committed
106
static bool set_log_update(THD *thd, set_var *var);
107
static int  check_pseudo_thread_id(THD *thd, set_var *var);
108
void fix_binlog_format_after_update(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
109
static void fix_low_priority_updates(THD *thd, enum_var_type type);
110
static int check_tx_isolation(THD *thd, set_var *var);
unknown's avatar
unknown committed
111
static void fix_tx_isolation(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
112 113
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
114 115
static void fix_net_read_timeout(THD *thd, enum_var_type type);
static void fix_net_write_timeout(THD *thd, enum_var_type type);
116
static void fix_net_retry_count(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
117 118
static void fix_max_join_size(THD *thd, enum_var_type type);
static void fix_query_cache_size(THD *thd, enum_var_type type);
119
static void fix_query_cache_min_res_unit(THD *thd, enum_var_type type);
120
static void fix_myisam_max_sort_file_size(THD *thd, enum_var_type type);
121 122
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);
123
static void fix_max_connections(THD *thd, enum_var_type type);
124
static int check_max_delayed_threads(THD *thd, set_var *var);
125 126
static void fix_thd_mem_root(THD *thd, enum_var_type type);
static void fix_trans_mem_root(THD *thd, enum_var_type type);
127
static void fix_server_id(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
128
static KEY_CACHE *create_key_cache(const char *name, uint length);
129
void fix_sql_mode_var(THD *thd, enum_var_type type);
130 131 132
static uchar *get_error_count(THD *thd);
static uchar *get_warning_count(THD *thd);
static uchar *get_tmpdir(THD *thd);
133 134 135 136 137
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);
unknown's avatar
unknown committed
138 139 140 141 142

/*
  Variable definition list

  These are variables that can be set from the command line, in
143 144 145 146
  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
147 148
*/

unknown's avatar
unknown committed
149
static sys_var_chain vars = { NULL, NULL };
150

unknown's avatar
unknown committed
151
static sys_var_thd_ulong	sys_auto_increment_increment(&vars, "auto_increment_increment",
152
                                                     &SV::auto_increment_increment);
unknown's avatar
unknown committed
153
static sys_var_thd_ulong	sys_auto_increment_offset(&vars, "auto_increment_offset",
154 155
                                                  &SV::auto_increment_offset);

unknown's avatar
unknown committed
156
static sys_var_bool_ptr	sys_automatic_sp_privileges(&vars, "automatic_sp_privileges",
157 158
					      &sp_automatic_privileges);

unknown's avatar
unknown committed
159 160
static sys_var_const_str       sys_basedir(&vars, "basedir", mysql_home);
static sys_var_long_ptr	sys_binlog_cache_size(&vars, "binlog_cache_size",
unknown's avatar
unknown committed
161
					      &binlog_cache_size);
unknown's avatar
unknown committed
162
static sys_var_thd_binlog_format sys_binlog_format(&vars, "binlog_format",
163
                                            &SV::binlog_format);
unknown's avatar
unknown committed
164
static sys_var_thd_ulong	sys_bulk_insert_buff_size(&vars, "bulk_insert_buffer_size",
unknown's avatar
unknown committed
165
						  &SV::bulk_insert_buff_size);
unknown's avatar
unknown committed
166 167 168 169
static sys_var_character_set_sv	sys_character_set_server(&vars, "character_set_server",
                                        &SV::collation_server,
                                        &default_charset_info);
sys_var_const_str       sys_charset_system(&vars, "character_set_system",
170
                                           (char *)my_charset_utf8_general_ci.name);
unknown's avatar
unknown committed
171
static sys_var_character_set_database	sys_character_set_database(&vars, "character_set_database");
172 173
static sys_var_character_set_client sys_character_set_client(&vars, 
                                        "character_set_client",
unknown's avatar
unknown committed
174 175 176 177 178 179 180 181 182 183 184 185
                                        &SV::character_set_client,
                                        &default_charset_info);
static sys_var_character_set_sv sys_character_set_connection(&vars, "character_set_connection",
                                        &SV::collation_connection,
                                        &default_charset_info);
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
186 187 188
					 &SV::completion_type,
					 check_completion_type,
					 fix_completion_type);
unknown's avatar
unknown committed
189 190 191 192 193 194 195 196 197 198
static sys_var_collation_sv sys_collation_connection(&vars, "collation_connection",
                                        &SV::collation_connection,
                                        &default_charset_info);
static sys_var_collation_sv sys_collation_database(&vars, "collation_database",
                                        &SV::collation_database,
                                        &default_charset_info);
static sys_var_collation_sv sys_collation_server(&vars, "collation_server",
                                        &SV::collation_server,
                                        &default_charset_info);
static sys_var_long_ptr	sys_concurrent_insert(&vars, "concurrent_insert",
199
                                              &myisam_concurrent_insert);
unknown's avatar
unknown committed
200
static sys_var_long_ptr	sys_connect_timeout(&vars, "connect_timeout",
unknown's avatar
unknown committed
201
					    &connect_timeout);
unknown's avatar
unknown committed
202
static sys_var_const_str       sys_datadir(&vars, "datadir", mysql_real_data_home);
unknown's avatar
unknown committed
203
#ifndef DBUG_OFF
unknown's avatar
unknown committed
204
static sys_var_thd_dbug        sys_dbug(&vars, "debug");
unknown's avatar
unknown committed
205
#endif
unknown's avatar
unknown committed
206
static sys_var_enum		sys_delay_key_write(&vars, "delay_key_write",
207 208 209
					    &delay_key_write_options,
					    &delay_key_write_typelib,
					    fix_delay_key_write);
unknown's avatar
unknown committed
210
static sys_var_long_ptr	sys_delayed_insert_limit(&vars, "delayed_insert_limit",
unknown's avatar
unknown committed
211
						 &delayed_insert_limit);
unknown's avatar
unknown committed
212
static sys_var_long_ptr	sys_delayed_insert_timeout(&vars, "delayed_insert_timeout",
unknown's avatar
unknown committed
213
						   &delayed_insert_timeout);
unknown's avatar
unknown committed
214
static sys_var_long_ptr	sys_delayed_queue_size(&vars, "delayed_queue_size",
unknown's avatar
unknown committed
215
					       &delayed_queue_size);
216

unknown's avatar
unknown committed
217 218
static sys_var_event_scheduler sys_event_scheduler(&vars, "event_scheduler");
static sys_var_long_ptr	sys_expire_logs_days(&vars, "expire_logs_days",
unknown's avatar
unknown committed
219
					     &expire_logs_days);
unknown's avatar
unknown committed
220 221 222
static sys_var_bool_ptr	sys_flush(&vars, "flush", &myisam_flush);
static sys_var_long_ptr	sys_flush_time(&vars, "flush_time", &flush_time);
static sys_var_str             sys_ft_boolean_syntax(&vars, "ft_boolean_syntax",
223 224 225 226
                                         sys_check_ftb_syntax,
                                         sys_update_ftb_syntax,
                                         sys_default_ftb_syntax,
                                         ft_boolean_syntax);
unknown's avatar
unknown committed
227
sys_var_str             sys_init_connect(&vars, "init_connect", 0,
228 229
                                         sys_update_init_connect,
                                         sys_default_init_connect,0);
unknown's avatar
unknown committed
230
sys_var_str             sys_init_slave(&vars, "init_slave", 0,
231 232
                                       sys_update_init_slave,
                                       sys_default_init_slave,0);
unknown's avatar
unknown committed
233
static sys_var_thd_ulong	sys_interactive_timeout(&vars, "interactive_timeout",
unknown's avatar
unknown committed
234
						&SV::net_interactive_timeout);
unknown's avatar
unknown committed
235
static sys_var_thd_ulong	sys_join_buffer_size(&vars, "join_buffer_size",
unknown's avatar
unknown committed
236
					     &SV::join_buff_size);
unknown's avatar
unknown committed
237 238
static sys_var_key_buffer_size	sys_key_buffer_size(&vars, "key_buffer_size");
static sys_var_key_cache_long  sys_key_cache_block_size(&vars, "key_cache_block_size",
unknown's avatar
unknown committed
239 240
						 offsetof(KEY_CACHE,
							  param_block_size));
unknown's avatar
unknown committed
241
static sys_var_key_cache_long	sys_key_cache_division_limit(&vars, "key_cache_division_limit",
unknown's avatar
unknown committed
242 243
						     offsetof(KEY_CACHE,
							      param_division_limit));
unknown's avatar
unknown committed
244
static sys_var_key_cache_long  sys_key_cache_age_threshold(&vars, "key_cache_age_threshold",
unknown's avatar
unknown committed
245 246
						     offsetof(KEY_CACHE,
							      param_age_threshold));
unknown's avatar
unknown committed
247
static sys_var_bool_ptr	sys_local_infile(&vars, "local_infile",
unknown's avatar
unknown committed
248
					 &opt_local_infile);
unknown's avatar
unknown committed
249 250
static sys_var_trust_routine_creators
sys_trust_routine_creators(&vars, "log_bin_trust_routine_creators",
251
                           &trust_function_creators);
unknown's avatar
unknown committed
252 253
static sys_var_bool_ptr       
sys_trust_function_creators(&vars, "log_bin_trust_function_creators",
254
                            &trust_function_creators);
unknown's avatar
unknown committed
255 256
static sys_var_bool_ptr
  sys_log_queries_not_using_indexes(&vars, "log_queries_not_using_indexes",
257
                                    &opt_log_queries_not_using_indexes);
unknown's avatar
unknown committed
258
static sys_var_thd_ulong	sys_log_warnings(&vars, "log_warnings", &SV::log_warnings);
259 260
static sys_var_microseconds	sys_var_long_query_time(&vars, "long_query_time",
                                                        &SV::long_query_time);
unknown's avatar
unknown committed
261
static sys_var_thd_bool	sys_low_priority_updates(&vars, "low_priority_updates",
unknown's avatar
unknown committed
262 263 264
						 &SV::low_priority_updates,
						 fix_low_priority_updates);
#ifndef TO_BE_DELETED	/* Alias for the low_priority_updates */
unknown's avatar
unknown committed
265
static sys_var_thd_bool	sys_sql_low_priority_updates(&vars, "sql_low_priority_updates",
unknown's avatar
unknown committed
266 267 268
						     &SV::low_priority_updates,
						     fix_low_priority_updates);
#endif
unknown's avatar
unknown committed
269
static sys_var_thd_ulong	sys_max_allowed_packet(&vars, "max_allowed_packet",
unknown's avatar
unknown committed
270
					       &SV::max_allowed_packet);
unknown's avatar
unknown committed
271
static sys_var_long_ptr	sys_max_binlog_cache_size(&vars, "max_binlog_cache_size",
unknown's avatar
unknown committed
272
						  &max_binlog_cache_size);
unknown's avatar
unknown committed
273
static sys_var_long_ptr	sys_max_binlog_size(&vars, "max_binlog_size",
274 275
					    &max_binlog_size,
                                            fix_max_binlog_size);
unknown's avatar
unknown committed
276
static sys_var_long_ptr	sys_max_connections(&vars, "max_connections",
277 278
					    &max_connections,
                                            fix_max_connections);
unknown's avatar
unknown committed
279
static sys_var_long_ptr	sys_max_connect_errors(&vars, "max_connect_errors",
unknown's avatar
unknown committed
280
					       &max_connect_errors);
unknown's avatar
unknown committed
281
static sys_var_thd_ulong       sys_max_insert_delayed_threads(&vars, "max_insert_delayed_threads",
282 283 284
						       &SV::max_insert_delayed_threads,
                                                       check_max_delayed_threads,
                                                       fix_max_connections);
unknown's avatar
unknown committed
285
static sys_var_thd_ulong	sys_max_delayed_threads(&vars, "max_delayed_threads",
286
						&SV::max_insert_delayed_threads,
287 288
                                                check_max_delayed_threads,
                                                fix_max_connections);
unknown's avatar
unknown committed
289
static sys_var_thd_ulong	sys_max_error_count(&vars, "max_error_count",
290
					    &SV::max_error_count);
unknown's avatar
unknown committed
291
static sys_var_thd_ulonglong	sys_max_heap_table_size(&vars, "max_heap_table_size",
unknown's avatar
unknown committed
292
						&SV::max_heap_table_size);
unknown's avatar
unknown committed
293
static sys_var_thd_ulong       sys_pseudo_thread_id(&vars, "pseudo_thread_id",
294 295
					     &SV::pseudo_thread_id,
                                             check_pseudo_thread_id, 0);
unknown's avatar
unknown committed
296
static sys_var_thd_ha_rows	sys_max_join_size(&vars, "max_join_size",
unknown's avatar
unknown committed
297 298
					  &SV::max_join_size,
					  fix_max_join_size);
unknown's avatar
unknown committed
299
static sys_var_thd_ulong	sys_max_seeks_for_key(&vars, "max_seeks_for_key",
300
					      &SV::max_seeks_for_key);
unknown's avatar
unknown committed
301
static sys_var_thd_ulong   sys_max_length_for_sort_data(&vars, "max_length_for_sort_data",
302
                                                 &SV::max_length_for_sort_data);
unknown's avatar
unknown committed
303
#ifndef TO_BE_DELETED	/* Alias for max_join_size */
unknown's avatar
unknown committed
304
static sys_var_thd_ha_rows	sys_sql_max_join_size(&vars, "sql_max_join_size",
unknown's avatar
unknown committed
305 306 307
					      &SV::max_join_size,
					      fix_max_join_size);
#endif
308
static sys_var_long_ptr_global
unknown's avatar
unknown committed
309
sys_max_prepared_stmt_count(&vars, "max_prepared_stmt_count",
310 311
                            &max_prepared_stmt_count,
                            &LOCK_prepared_stmt_count);
unknown's avatar
unknown committed
312
static sys_var_long_ptr	sys_max_relay_log_size(&vars, "max_relay_log_size",
313 314
                                               &max_relay_log_size,
                                               fix_max_relay_log_size);
unknown's avatar
unknown committed
315
static sys_var_thd_ulong	sys_max_sort_length(&vars, "max_sort_length",
unknown's avatar
unknown committed
316
					    &SV::max_sort_length);
unknown's avatar
unknown committed
317
static sys_var_thd_ulong	sys_max_sp_recursion_depth(&vars, "max_sp_recursion_depth",
318
                                                   &SV::max_sp_recursion_depth);
unknown's avatar
unknown committed
319 320
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
321
					   &SV::max_tmp_tables);
unknown's avatar
unknown committed
322
static sys_var_long_ptr	sys_max_write_lock_count(&vars, "max_write_lock_count",
unknown's avatar
unknown committed
323
						 &max_write_lock_count);
324 325
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
326
static sys_var_thd_ulong       sys_multi_range_count(&vars, "multi_range_count",
unknown's avatar
unknown committed
327
                                              &SV::multi_range_count);
unknown's avatar
unknown committed
328
static sys_var_long_ptr	sys_myisam_data_pointer_size(&vars, "myisam_data_pointer_size",
unknown's avatar
unknown committed
329
                                                    &myisam_data_pointer_size);
unknown's avatar
unknown committed
330 331 332
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);
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
333
static sys_var_bool_ptr	sys_myisam_use_mmap(&vars, "myisam_use_mmap",
unknown's avatar
unknown committed
334
                                            &opt_myisam_use_mmap);
335

unknown's avatar
unknown committed
336
static sys_var_thd_enum         sys_myisam_stats_method(&vars, "myisam_stats_method",
337 338 339 340
                                                &SV::myisam_stats_method,
                                                &myisam_stats_method_typelib,
                                                NULL);

unknown's avatar
unknown committed
341
static sys_var_thd_ulong	sys_net_buffer_length(&vars, "net_buffer_length",
unknown's avatar
unknown committed
342
					      &SV::net_buffer_length);
unknown's avatar
unknown committed
343
static sys_var_thd_ulong	sys_net_read_timeout(&vars, "net_read_timeout",
unknown's avatar
unknown committed
344
					     &SV::net_read_timeout,
345
					     0, fix_net_read_timeout);
unknown's avatar
unknown committed
346
static sys_var_thd_ulong	sys_net_write_timeout(&vars, "net_write_timeout",
unknown's avatar
unknown committed
347
					      &SV::net_write_timeout,
348
					      0, fix_net_write_timeout);
unknown's avatar
unknown committed
349
static sys_var_thd_ulong	sys_net_retry_count(&vars, "net_retry_count",
350
					    &SV::net_retry_count,
351
					    0, fix_net_retry_count);
unknown's avatar
unknown committed
352
static sys_var_thd_bool	sys_new_mode(&vars, "new", &SV::new_mode);
unknown's avatar
unknown committed
353
static sys_var_bool_ptr_readonly sys_old_mode(&vars, "old",
unknown's avatar
unknown committed
354
                                       &global_system_variables.old_mode);
unknown's avatar
unknown committed
355 356 357 358 359
/* 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);
static sys_var_thd_ulong        sys_optimizer_prune_level(&vars, "optimizer_prune_level",
360
                                                  &SV::optimizer_prune_level);
unknown's avatar
unknown committed
361
static sys_var_thd_ulong        sys_optimizer_search_depth(&vars, "optimizer_search_depth",
362
                                                   &SV::optimizer_search_depth);
unknown's avatar
unknown committed
363
static sys_var_thd_ulong        sys_preload_buff_size(&vars, "preload_buffer_size",
unknown's avatar
unknown committed
364
                                              &SV::preload_buff_size);
unknown's avatar
unknown committed
365
static sys_var_thd_ulong	sys_read_buff_size(&vars, "read_buffer_size",
unknown's avatar
unknown committed
366
					   &SV::read_buff_size);
unknown's avatar
unknown committed
367 368
static sys_var_opt_readonly	sys_readonly(&vars, "read_only", &opt_readonly);
static sys_var_thd_ulong	sys_read_rnd_buff_size(&vars, "read_rnd_buffer_size",
unknown's avatar
unknown committed
369
					       &SV::read_rnd_buff_size);
unknown's avatar
unknown committed
370
static sys_var_thd_ulong	sys_div_precincrement(&vars, "div_precision_increment",
unknown's avatar
unknown committed
371
                                              &SV::div_precincrement);
unknown's avatar
unknown committed
372
static sys_var_long_ptr	sys_rpl_recovery_rank(&vars, "rpl_recovery_rank",
unknown's avatar
unknown committed
373
					      &rpl_recovery_rank);
unknown's avatar
unknown committed
374
static sys_var_long_ptr	sys_query_cache_size(&vars, "query_cache_size",
unknown's avatar
unknown committed
375 376
					     &query_cache_size,
					     fix_query_cache_size);
377

unknown's avatar
unknown committed
378
static sys_var_thd_ulong	sys_range_alloc_block_size(&vars, "range_alloc_block_size",
379
						   &SV::range_alloc_block_size);
unknown's avatar
unknown committed
380
static sys_var_thd_ulong	sys_query_alloc_block_size(&vars, "query_alloc_block_size",
381 382
						   &SV::query_alloc_block_size,
						   0, fix_thd_mem_root);
unknown's avatar
unknown committed
383
static sys_var_thd_ulong	sys_query_prealloc_size(&vars, "query_prealloc_size",
384 385
						&SV::query_prealloc_size,
						0, fix_thd_mem_root);
unknown's avatar
unknown committed
386 387
static sys_var_readonly        sys_tmpdir(&vars, "tmpdir", OPT_GLOBAL, SHOW_CHAR, get_tmpdir);
static sys_var_thd_ulong	sys_trans_alloc_block_size(&vars, "transaction_alloc_block_size",
388 389
						   &SV::trans_alloc_block_size,
						   0, fix_trans_mem_root);
unknown's avatar
unknown committed
390
static sys_var_thd_ulong	sys_trans_prealloc_size(&vars, "transaction_prealloc_size",
391 392
						&SV::trans_prealloc_size,
						0, fix_trans_mem_root);
unknown's avatar
unknown committed
393
sys_var_thd_enum        sys_thread_handling(&vars, "thread_handling",
unknown's avatar
unknown committed
394 395 396
                                            &SV::thread_handling,
                                            &thread_handling_typelib,
                                            NULL);
397

unknown's avatar
unknown committed
398
#ifdef HAVE_QUERY_CACHE
unknown's avatar
unknown committed
399
static sys_var_long_ptr	sys_query_cache_limit(&vars, "query_cache_limit",
unknown's avatar
unknown committed
400
					      &query_cache.query_cache_limit);
unknown's avatar
unknown committed
401
static sys_var_long_ptr        sys_query_cache_min_res_unit(&vars, "query_cache_min_res_unit",
402 403
						     &query_cache_min_res_unit,
						     fix_query_cache_min_res_unit);
unknown's avatar
unknown committed
404
static sys_var_thd_enum	sys_query_cache_type(&vars, "query_cache_type",
unknown's avatar
unknown committed
405 406
					     &SV::query_cache_type,
					     &query_cache_type_typelib);
unknown's avatar
unknown committed
407 408
static sys_var_thd_bool
sys_query_cache_wlock_invalidate(&vars, "query_cache_wlock_invalidate",
409
				 &SV::query_cache_wlock_invalidate);
unknown's avatar
unknown committed
410
#endif /* HAVE_QUERY_CACHE */
unknown's avatar
unknown committed
411
static sys_var_bool_ptr	sys_secure_auth(&vars, "secure_auth", &opt_secure_auth);
412
static sys_var_const_str_ptr sys_secure_file_priv(&vars, "secure_file_priv",
413
                                             &opt_secure_file_priv);
unknown's avatar
unknown committed
414 415
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",
416
						      &opt_slave_compressed_protocol);
unknown's avatar
unknown committed
417
static sys_var_long_ptr	sys_slow_launch_time(&vars, "slow_launch_time",
unknown's avatar
unknown committed
418
					     &slow_launch_time);
unknown's avatar
unknown committed
419
static sys_var_thd_ulong	sys_sort_buffer(&vars, "sort_buffer_size",
unknown's avatar
unknown committed
420
					&SV::sortbuff_size);
unknown's avatar
unknown committed
421
static sys_var_thd_sql_mode    sys_sql_mode(&vars, "sql_mode",
422
                                     &SV::sql_mode);
423 424 425
#ifdef HAVE_OPENSSL
extern char *opt_ssl_ca, *opt_ssl_capath, *opt_ssl_cert, *opt_ssl_cipher,
            *opt_ssl_key;
unknown's avatar
unknown committed
426 427 428 429 430
static sys_var_const_str_ptr	sys_ssl_ca(&vars, "ssl_ca", &opt_ssl_ca);
static sys_var_const_str_ptr	sys_ssl_capath(&vars, "ssl_capath", &opt_ssl_capath);
static sys_var_const_str_ptr	sys_ssl_cert(&vars, "ssl_cert", &opt_ssl_cert);
static sys_var_const_str_ptr	sys_ssl_cipher(&vars, "ssl_cipher", &opt_ssl_cipher);
static sys_var_const_str_ptr	sys_ssl_key(&vars, "ssl_key", &opt_ssl_key);
431
#else
unknown's avatar
unknown committed
432 433 434 435 436
static sys_var_const_str	sys_ssl_ca(&vars, "ssl_ca", NULL);
static sys_var_const_str	sys_ssl_capath(&vars, "ssl_capath", NULL);
static sys_var_const_str	sys_ssl_cert(&vars, "ssl_cert", NULL);
static sys_var_const_str	sys_ssl_cipher(&vars, "ssl_cipher", NULL);
static sys_var_const_str	sys_ssl_key(&vars, "ssl_key", NULL);
437
#endif
unknown's avatar
unknown committed
438 439
static sys_var_thd_enum
sys_updatable_views_with_limit(&vars, "updatable_views_with_limit",
440 441
                               &SV::updatable_views_with_limit,
                               &updatable_views_with_limit_typelib);
unknown's avatar
VIEW  
unknown committed
442

unknown's avatar
unknown committed
443 444 445 446 447 448
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",
449
                                             system_time_zone);
unknown's avatar
unknown committed
450
static sys_var_long_ptr	sys_table_def_size(&vars, "table_definition_cache",
unknown's avatar
unknown committed
451
                                           &table_def_size);
unknown's avatar
unknown committed
452
static sys_var_long_ptr	sys_table_cache_size(&vars, "table_open_cache",
unknown's avatar
unknown committed
453
					     &table_cache_size);
unknown's avatar
unknown committed
454
static sys_var_long_ptr	sys_table_lock_wait_timeout(&vars, "table_lock_wait_timeout",
455
                                                    &table_lock_wait_timeout);
unknown's avatar
unknown committed
456
static sys_var_long_ptr	sys_thread_cache_size(&vars, "thread_cache_size",
unknown's avatar
unknown committed
457
					      &thread_cache_size);
unknown's avatar
unknown committed
458
#if HAVE_POOL_OF_THREADS == 1
unknown's avatar
unknown committed
459
sys_var_long_ptr	sys_thread_pool_size(&vars, "thread_pool_size",
unknown's avatar
unknown committed
460 461
					      &thread_pool_size);
#endif
unknown's avatar
unknown committed
462
static sys_var_thd_enum	sys_tx_isolation(&vars, "tx_isolation",
unknown's avatar
unknown committed
463 464
					 &SV::tx_isolation,
					 &tx_isolation_typelib,
465 466
					 fix_tx_isolation,
					 check_tx_isolation);
unknown's avatar
unknown committed
467
static sys_var_thd_ulonglong	sys_tmp_table_size(&vars, "tmp_table_size",
unknown's avatar
unknown committed
468
					   &SV::tmp_table_size);
unknown's avatar
unknown committed
469
static sys_var_bool_ptr  sys_timed_mutexes(&vars, "timed_mutexes",
unknown's avatar
unknown committed
470
                                    &timed_mutexes);
unknown's avatar
unknown committed
471 472
static sys_var_const_str	sys_version(&vars, "version", server_version);
static sys_var_const_str	sys_version_comment(&vars, "version_comment",
473
                                            MYSQL_COMPILATION_COMMENT);
unknown's avatar
unknown committed
474
static sys_var_const_str	sys_version_compile_machine(&vars, "version_compile_machine",
475
                                                    MACHINE_TYPE);
unknown's avatar
unknown committed
476
static sys_var_const_str	sys_version_compile_os(&vars, "version_compile_os",
477
                                               SYSTEM_TYPE);
unknown's avatar
unknown committed
478
static sys_var_thd_ulong	sys_net_wait_timeout(&vars, "wait_timeout",
unknown's avatar
unknown committed
479
					     &SV::net_wait_timeout);
unknown's avatar
unknown committed
480

unknown's avatar
unknown committed
481
/* Condition pushdown to storage engine */
unknown's avatar
unknown committed
482 483
static sys_var_thd_bool
sys_engine_condition_pushdown(&vars, "engine_condition_pushdown",
unknown's avatar
unknown committed
484 485
			      &SV::engine_condition_pushdown);

486
#ifdef WITH_NDBCLUSTER_STORAGE_ENGINE
487
/* ndb thread specific variable settings */
unknown's avatar
unknown committed
488 489
static sys_var_thd_ulong
sys_ndb_autoincrement_prefetch_sz(&vars, "ndb_autoincrement_prefetch_sz",
490
				  &SV::ndb_autoincrement_prefetch_sz);
unknown's avatar
unknown committed
491 492
static sys_var_thd_bool
sys_ndb_force_send(&vars, "ndb_force_send", &SV::ndb_force_send);
unknown's avatar
unknown committed
493
#ifdef HAVE_NDB_BINLOG
unknown's avatar
unknown committed
494 495
static sys_var_long_ptr
sys_ndb_report_thresh_binlog_epoch_slip(&vars, "ndb_report_thresh_binlog_epoch_slip",
unknown's avatar
unknown committed
496
                                        &ndb_report_thresh_binlog_epoch_slip);
unknown's avatar
unknown committed
497 498
static sys_var_long_ptr
sys_ndb_report_thresh_binlog_mem_usage(&vars, "ndb_report_thresh_binlog_mem_usage",
unknown's avatar
unknown committed
499 500
                                       &ndb_report_thresh_binlog_mem_usage);
#endif
unknown's avatar
unknown committed
501 502 503 504 505 506
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);
507 508
static sys_var_const_str
sys_ndb_connectstring(&vars, "ndb_connectstring", opt_ndb_constrbuf);
unknown's avatar
unknown committed
509 510
static sys_var_thd_bool
sys_ndb_index_stat_enable(&vars, "ndb_index_stat_enable",
511
                          &SV::ndb_index_stat_enable);
unknown's avatar
unknown committed
512 513
static sys_var_thd_ulong
sys_ndb_index_stat_cache_entries(&vars, "ndb_index_stat_cache_entries",
514
                                 &SV::ndb_index_stat_cache_entries);
unknown's avatar
unknown committed
515 516
static sys_var_thd_ulong
sys_ndb_index_stat_update_freq(&vars, "ndb_index_stat_update_freq",
517
                               &SV::ndb_index_stat_update_freq);
unknown's avatar
unknown committed
518 519 520 521
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);
522
#endif //WITH_NDBCLUSTER_STORAGE_ENGINE
523 524 525

/* Time/date/datetime formats */

unknown's avatar
unknown committed
526
static sys_var_thd_date_time_format sys_time_format(&vars, "time_format",
527
					     &SV::time_format,
528
					     MYSQL_TIMESTAMP_TIME);
unknown's avatar
unknown committed
529
static sys_var_thd_date_time_format sys_date_format(&vars, "date_format",
530
					     &SV::date_format,
531
					     MYSQL_TIMESTAMP_DATE);
unknown's avatar
unknown committed
532
static sys_var_thd_date_time_format sys_datetime_format(&vars, "datetime_format",
533
						 &SV::datetime_format,
534
						 MYSQL_TIMESTAMP_DATETIME);
535 536

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

unknown's avatar
unknown committed
538
sys_var_thd_bit sys_autocommit(&vars, "autocommit", 0,
539 540 541
                               set_option_autocommit,
                               OPTION_NOT_AUTOCOMMIT,
                               1);
unknown's avatar
unknown committed
542
static sys_var_thd_bit	sys_big_tables(&vars, "big_tables", 0,
unknown's avatar
unknown committed
543 544 545
				       set_option_bit,
				       OPTION_BIG_TABLES);
#ifndef TO_BE_DELETED	/* Alias for big_tables */
unknown's avatar
unknown committed
546
static sys_var_thd_bit	sys_sql_big_tables(&vars, "sql_big_tables", 0,
unknown's avatar
unknown committed
547 548 549
					   set_option_bit,
					   OPTION_BIG_TABLES);
#endif
unknown's avatar
unknown committed
550
static sys_var_thd_bit	sys_big_selects(&vars, "sql_big_selects", 0,
unknown's avatar
unknown committed
551
					set_option_bit,
552
					OPTION_BIG_SELECTS);
unknown's avatar
unknown committed
553
static sys_var_thd_bit	sys_log_off(&vars, "sql_log_off",
554
				    check_log_update,
unknown's avatar
unknown committed
555 556
				    set_option_bit,
				    OPTION_LOG_OFF);
unknown's avatar
unknown committed
557
static sys_var_thd_bit	sys_log_update(&vars, "sql_log_update",
558
                                       check_log_update,
unknown's avatar
unknown committed
559
				       set_log_update,
560
				       OPTION_BIN_LOG);
unknown's avatar
unknown committed
561
static sys_var_thd_bit	sys_log_binlog(&vars, "sql_log_bin",
562
                                       check_log_update,
563
				       set_option_bit,
564
				       OPTION_BIN_LOG);
unknown's avatar
unknown committed
565
static sys_var_thd_bit	sys_sql_warnings(&vars, "sql_warnings", 0,
unknown's avatar
unknown committed
566 567
					 set_option_bit,
					 OPTION_WARNINGS);
unknown's avatar
unknown committed
568
static sys_var_thd_bit	sys_sql_notes(&vars, "sql_notes", 0,
569
					 set_option_bit,
570
					 OPTION_SQL_NOTES);
unknown's avatar
unknown committed
571
static sys_var_thd_bit	sys_auto_is_null(&vars, "sql_auto_is_null", 0,
unknown's avatar
unknown committed
572 573
					 set_option_bit,
					 OPTION_AUTO_IS_NULL);
unknown's avatar
unknown committed
574
static sys_var_thd_bit	sys_safe_updates(&vars, "sql_safe_updates", 0,
unknown's avatar
unknown committed
575 576
					 set_option_bit,
					 OPTION_SAFE_UPDATES);
unknown's avatar
unknown committed
577
static sys_var_thd_bit	sys_buffer_results(&vars, "sql_buffer_result", 0,
unknown's avatar
unknown committed
578 579
					   set_option_bit,
					   OPTION_BUFFER_RESULT);
unknown's avatar
unknown committed
580
static sys_var_thd_bit	sys_quote_show_create(&vars, "sql_quote_show_create", 0,
unknown's avatar
unknown committed
581 582
					      set_option_bit,
					      OPTION_QUOTE_SHOW_CREATE);
unknown's avatar
unknown committed
583
static sys_var_thd_bit	sys_foreign_key_checks(&vars, "foreign_key_checks", 0,
584 585 586
					       set_option_bit,
					       OPTION_NO_FOREIGN_KEY_CHECKS,
					       1);
unknown's avatar
unknown committed
587
static sys_var_thd_bit	sys_unique_checks(&vars, "unique_checks", 0,
588 589 590 591
					  set_option_bit,
					  OPTION_RELAXED_UNIQUE_CHECKS,
					  1);

unknown's avatar
unknown committed
592 593
/* Local state variables */

unknown's avatar
unknown committed
594
static sys_var_thd_ha_rows	sys_select_limit(&vars, "sql_select_limit",
unknown's avatar
unknown committed
595
						 &SV::select_limit);
unknown's avatar
unknown committed
596 597 598
static sys_var_timestamp	sys_timestamp(&vars, "timestamp");
static sys_var_last_insert_id	sys_last_insert_id(&vars, "last_insert_id");
static sys_var_last_insert_id	sys_identity(&vars, "identity");
unknown's avatar
unknown committed
599

unknown's avatar
unknown committed
600
static sys_var_thd_lc_time_names       sys_lc_time_names(&vars, "lc_time_names");
unknown's avatar
unknown committed
601

unknown's avatar
unknown committed
602 603
static sys_var_insert_id	sys_insert_id(&vars, "insert_id");
static sys_var_readonly		sys_error_count(&vars, "error_count",
604 605 606
						OPT_SESSION,
						SHOW_LONG,
						get_error_count);
unknown's avatar
unknown committed
607
static sys_var_readonly		sys_warning_count(&vars, "warning_count",
608 609 610 611
						  OPT_SESSION,
						  SHOW_LONG,
						  get_warning_count);

unknown's avatar
unknown committed
612
/* alias for last_insert_id() to be compatible with Sybase */
unknown's avatar
unknown committed
613 614
static sys_var_rand_seed1	sys_rand_seed1(&vars, "rand_seed1");
static sys_var_rand_seed2	sys_rand_seed2(&vars, "rand_seed2");
unknown's avatar
unknown committed
615

unknown's avatar
unknown committed
616
static sys_var_thd_ulong        sys_default_week_format(&vars, "default_week_format",
617
					                &SV::default_week_format);
unknown's avatar
unknown committed
618

unknown's avatar
unknown committed
619
sys_var_thd_ulong               sys_group_concat_max_len(&vars, "group_concat_max_len",
unknown's avatar
unknown committed
620 621
                                                         &SV::group_concat_max_len);

unknown's avatar
unknown committed
622
sys_var_thd_time_zone            sys_time_zone(&vars, "time_zone");
623

624 625
/* Global read-only variable containing hostname */
static sys_var_const_str        sys_hostname(&vars, "hostname", glob_hostname);
626

627
sys_var_thd_bool  sys_keep_files_on_create(&vars, "keep_files_on_create", 
unknown's avatar
unknown committed
628
                                           &SV::keep_files_on_create);
629 630
/* Read only variables */

unknown's avatar
unknown committed
631 632 633 634 635 636 637
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
638 639
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
640 641
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
642
                                           &have_query_cache);
unknown's avatar
unknown committed
643 644
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);
645
/* Global read-only variable describing server license */
unknown's avatar
unknown committed
646
static sys_var_const_str	sys_license(&vars, "license", STRINGIFY_ARG(LICENSE));
647
/* Global variables which enable|disable logging */
unknown's avatar
unknown committed
648
static sys_var_log_state sys_var_general_log(&vars, "general_log", &opt_log,
649
                                      QUERY_LOG_GENERAL);
650 651 652
/* 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
653
static sys_var_log_state sys_var_slow_query_log(&vars, "slow_query_log", &opt_slow_log,
654
                                         QUERY_LOG_SLOW);
655 656 657
/* 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
658
sys_var_str sys_var_general_log_path(&vars, "general_log_file", sys_check_log_path,
659 660 661
				     sys_update_general_log_path,
				     sys_default_general_log_path,
				     opt_logname);
unknown's avatar
unknown committed
662
sys_var_str sys_var_slow_log_path(&vars, "slow_query_log_file", sys_check_log_path,
663 664 665
				  sys_update_slow_log_path, 
				  sys_default_slow_log_path,
				  opt_slow_logname);
unknown's avatar
unknown committed
666
static sys_var_log_output sys_var_log_output_state(&vars, "log_output", &log_output_options,
667 668
					    &log_output_typelib, 0);

669

unknown's avatar
unknown committed
670
/*
unknown's avatar
unknown committed
671 672 673 674
  Additional variables (not derived from sys_var class, not accessible as
  @@varname in SELECT or SET). Sorted in alphabetical order to facilitate
  maintenance - SHOW VARIABLES will sort its output.
  TODO: remove this list completely
unknown's avatar
unknown committed
675 676
*/

unknown's avatar
unknown committed
677 678
#define FIXED_VARS_SIZE (sizeof(fixed_vars) / sizeof(SHOW_VAR))
static SHOW_VAR fixed_vars[]= {
unknown's avatar
unknown committed
679
  {"back_log",                (char*) &back_log,                    SHOW_LONG},
680
  {"character_sets_dir",      mysql_charsets_dir,                   SHOW_CHAR},
unknown's avatar
unknown committed
681
  {"ft_max_word_len",         (char*) &ft_max_word_len,             SHOW_LONG},
682
  {"ft_min_word_len",         (char*) &ft_min_word_len,             SHOW_LONG},
683
  {"ft_query_expansion_limit",(char*) &ft_query_expansion_limit,    SHOW_LONG},
684
  {"ft_stopword_file",        (char*) &ft_stopword_file,            SHOW_CHAR_PTR},
685
  {"init_file",               (char*) &opt_init_file,               SHOW_CHAR_PTR},
unknown's avatar
unknown committed
686
  {"language",                language,                             SHOW_CHAR},
687
  {"large_files_support",     (char*) &opt_large_files,             SHOW_BOOL},
688
  {"large_page_size",         (char*) &opt_large_page_size,         SHOW_INT},
unknown's avatar
unknown committed
689
  {"large_pages",             (char*) &opt_large_pages,             SHOW_MY_BOOL},
unknown's avatar
unknown committed
690
#ifdef HAVE_MLOCKALL
unknown's avatar
unknown committed
691
  {"locked_in_memory",	      (char*) &locked_in_memory,	    SHOW_MY_BOOL},
unknown's avatar
unknown committed
692 693
#endif
  {"log_bin",                 (char*) &opt_bin_log,                 SHOW_BOOL},
694
  {"log_error",               (char*) log_error_file,               SHOW_CHAR},
695
  {"lower_case_file_system",  (char*) &lower_case_file_system,      SHOW_MY_BOOL},
696 697
  {"lower_case_table_names",  (char*) &lower_case_table_names,      SHOW_INT},
  {"myisam_recover_options",  (char*) &myisam_recover_options_str,  SHOW_CHAR_PTR},
unknown's avatar
unknown committed
698
#ifdef __NT__
699
  {"named_pipe",	      (char*) &opt_enable_named_pipe,       SHOW_MY_BOOL},
700
#endif
unknown's avatar
unknown committed
701 702
  {"open_files_limit",	      (char*) &open_files_limit,	    SHOW_LONG},
  {"pid_file",                (char*) pidfile_name,                 SHOW_CHAR},
703
  {"plugin_dir",              (char*) opt_plugin_dir,               SHOW_CHAR},
unknown's avatar
unknown committed
704
  {"port",                    (char*) &mysqld_port,                 SHOW_INT},
705
  {"protocol_version",        (char*) &protocol_version,            SHOW_INT},
706 707 708 709
#ifdef HAVE_SMEM
  {"shared_memory",           (char*) &opt_enable_shared_memory,    SHOW_MY_BOOL},
  {"shared_memory_base_name", (char*) &shared_memory_base_name,     SHOW_CHAR_PTR},
#endif
710
  {"skip_external_locking",   (char*) &my_disable_locking,          SHOW_MY_BOOL},
unknown's avatar
unknown committed
711 712
  {"skip_networking",         (char*) &opt_disable_networking,      SHOW_BOOL},
  {"skip_show_database",      (char*) &opt_skip_show_db,            SHOW_BOOL},
713
#ifdef HAVE_SYS_UN_H
unknown's avatar
unknown committed
714
  {"socket",                  (char*) &mysqld_unix_port,            SHOW_CHAR_PTR},
715
#endif
unknown's avatar
unknown committed
716 717 718 719 720 721
#ifdef HAVE_THR_SETCONCURRENCY
  {"thread_concurrency",      (char*) &concurrency,                 SHOW_LONG},
#endif
  {"thread_stack",            (char*) &thread_stack,                SHOW_LONG},
};

722

723 724 725 726 727 728
bool sys_var::check(THD *thd, set_var *var)
{
  var->save_result.ulonglong_value= var->value->val_int();
  return 0;
}

729 730 731 732 733 734 735
bool sys_var_str::check(THD *thd, set_var *var)
{
  int res;
  if (!check_func)
    return 0;

  if ((res=(*check_func)(thd, var)) < 0)
736 737
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0),
             name, var->value->str_value.ptr());
738 739 740
  return res;
}

unknown's avatar
unknown committed
741 742 743 744
/*
  Functions to check and update variables
*/

unknown's avatar
unknown committed
745

746 747 748 749 750 751 752 753 754 755
/*
  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
756
{
757 758 759 760
  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*) "";
761
  if (!(res= my_strndup(old_value, new_length, MYF(0))))
762
    return 1;
unknown's avatar
unknown committed
763 764 765 766
  /*
    Replace the old value in such a way that the any thread using
    the value will work.
  */
767 768 769 770 771
  rw_wrlock(var_mutex);
  old_value= var_str->value;
  var_str->value= res;
  var_str->value_length= new_length;
  rw_unlock(var_mutex);
unknown's avatar
unknown committed
772 773 774 775 776
  my_free(old_value, MYF(MY_ALLOW_ZERO_PTR));
  return 0;
}


777 778 779 780 781 782
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
783 784
static void sys_default_init_connect(THD* thd, enum_var_type type)
{
785
  update_sys_var_str(&sys_init_connect, &LOCK_sys_init_connect, 0);
unknown's avatar
unknown committed
786 787 788 789 790
}


static bool sys_update_init_slave(THD *thd, set_var *var)
{
791
  return update_sys_var_str(&sys_init_slave, &LOCK_sys_init_slave, var);
unknown's avatar
unknown committed
792 793 794 795 796
}


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

800 801
static int sys_check_ftb_syntax(THD *thd,  set_var *var)
{
802
  if (thd->security_ctx->master_access & SUPER_ACL)
803
    return (ft_boolean_check_syntax_string((uchar*)
804 805
                                           var->value->str_value.c_ptr()) ?
            -1 : 0);
806 807 808 809 810 811 812 813 814 815 816
  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);
817 818 819 820 821

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

822 823 824 825 826
  return 0;
}

static void sys_default_ftb_syntax(THD *thd, enum_var_type type)
{
827
  strmake(ft_boolean_syntax, def_ft_boolean_syntax,
828 829
	  sizeof(ft_boolean_syntax)-1);
}
unknown's avatar
unknown committed
830

unknown's avatar
unknown committed
831

unknown's avatar
unknown committed
832
/**
unknown's avatar
unknown committed
833
  If one sets the LOW_PRIORIY UPDATES flag, we also must change the
unknown's avatar
unknown committed
834
  used lock type.
unknown's avatar
unknown committed
835 836 837 838
*/

static void fix_low_priority_updates(THD *thd, enum_var_type type)
{
839 840 841 842 843
  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
844 845 846 847 848
    thd->update_lock_default= (thd->variables.low_priority_updates ?
			       TL_WRITE_LOW_PRIORITY : TL_WRITE);
}


849 850 851 852 853 854 855
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
856 857
/**
  Set the OPTION_BIG_SELECTS flag if max_join_size == HA_POS_ERROR.
unknown's avatar
unknown committed
858 859 860 861 862 863
*/

static void fix_max_join_size(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
  {
864
    if (thd->variables.max_join_size == HA_POS_ERROR)
unknown's avatar
unknown committed
865 866 867 868 869
      thd->options|= OPTION_BIG_SELECTS;
    else
      thd->options&= ~OPTION_BIG_SELECTS;
  }
}
870

unknown's avatar
unknown committed
871

unknown's avatar
unknown committed
872
/**
873 874 875 876 877 878 879 880 881 882 883 884 885
  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
886 887
/*
  If one doesn't use the SESSION modifier, the isolation level
unknown's avatar
unknown committed
888
  is only active for the next command.
unknown's avatar
unknown committed
889 890 891 892 893 894 895 896
*/
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);
}

897 898
static void fix_completion_type(THD *thd __attribute__((unused)),
				enum_var_type type __attribute__((unused))) {}
unknown's avatar
unknown committed
899 900 901 902 903 904 905 906 907 908 909 910 911

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
912 913 914 915 916

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

unknown's avatar
SCRUM  
unknown committed
917
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
918 919 920
static void fix_net_read_timeout(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
921
    my_net_set_read_timeout(&thd->net, thd->variables.net_read_timeout);
unknown's avatar
unknown committed
922 923 924 925 926 927
}


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

931 932 933 934 935
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
936
#else /* HAVE_REPLICATION */
937 938
static void fix_net_read_timeout(THD *thd __attribute__((unused)),
				 enum_var_type type __attribute__((unused)))
939
{}
940 941
static void fix_net_write_timeout(THD *thd __attribute__((unused)),
				  enum_var_type type __attribute__((unused)))
942
{}
943 944
static void fix_net_retry_count(THD *thd __attribute__((unused)),
				enum_var_type type __attribute__((unused)))
945
{}
unknown's avatar
SCRUM  
unknown committed
946
#endif /* HAVE_REPLICATION */
947

unknown's avatar
unknown committed
948 949 950 951

static void fix_query_cache_size(THD *thd, enum_var_type type)
{
#ifdef HAVE_QUERY_CACHE
952 953 954 955 956 957 958 959
  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)
960 961
    push_warning_printf(current_thd, MYSQL_ERROR::WARN_LEVEL_WARN,
			ER_WARN_QC_RESIZE, ER(ER_WARN_QC_RESIZE),
962 963 964
			query_cache_size, new_cache_size);
  
  query_cache_size= new_cache_size;
unknown's avatar
unknown committed
965 966 967 968
#endif
}


969 970 971 972 973 974 975 976 977
#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


978
extern void fix_delay_key_write(THD *thd, enum_var_type type)
979 980 981 982 983 984 985 986 987 988 989 990 991 992 993
{
  switch ((enum_delay_key_write) delay_key_write_options) {
  case DELAY_KEY_WRITE_NONE:
    myisam_delay_key_write=0;
    break;
  case DELAY_KEY_WRITE_ON:
    myisam_delay_key_write=1;
    break;
  case DELAY_KEY_WRITE_ALL:
    myisam_delay_key_write=1;
    ha_open_options|= HA_OPEN_DELAY_KEY_WRITE;
    break;
  }
}

994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007

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).
1008 1009 1010

    If we don't have row-based replication compiled in, the variable
    is always read-only.
1011 1012 1013 1014 1015 1016 1017 1018
  */
  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
1019
    if in a stored function/trigger, it's too late to change mode
1020
  */
unknown's avatar
unknown committed
1021
  if (thd->in_sub_stmt)
1022 1023 1024 1025 1026 1027 1028
  {
    my_error(ER_STORED_FUNCTION_PREVENTS_SWITCH_BINLOG_FORMAT, MYF(0));
    return 1;    
  }
  return sys_var_thd_enum::is_readonly();
}

unknown's avatar
unknown committed
1029

1030 1031 1032 1033 1034 1035
void fix_binlog_format_after_update(THD *thd, enum_var_type type)
{
  thd->reset_current_stmt_binlog_row_based();
}


1036
static void fix_max_binlog_size(THD *thd, enum_var_type type)
1037 1038 1039 1040 1041
{
  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);
1042
#ifdef HAVE_REPLICATION
1043 1044
  if (!max_relay_log_size)
    active_mi->rli.relay_log.set_max_size(max_binlog_size);
unknown's avatar
unknown committed
1045
#endif
1046 1047 1048
  DBUG_VOID_RETURN;
}

1049
static void fix_max_relay_log_size(THD *thd, enum_var_type type)
1050 1051 1052 1053
{
  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));
1054
#ifdef HAVE_REPLICATION
1055 1056
  active_mi->rli.relay_log.set_max_size(max_relay_log_size ?
                                        max_relay_log_size: max_binlog_size);
1057
#endif
1058 1059
  DBUG_VOID_RETURN;
}
1060

1061

1062 1063
static int check_max_delayed_threads(THD *thd, set_var *var)
{
unknown's avatar
unknown committed
1064
  longlong val= var->value->val_int();
1065
  if (var->type != OPT_GLOBAL && val != 0 &&
unknown's avatar
unknown committed
1066
      val != (longlong) global_system_variables.max_insert_delayed_threads)
1067 1068
  {
    char buf[64];
1069
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), var->var->name, llstr(val, buf));
1070 1071 1072 1073 1074
    return 1;
  }
  return 0;
}

1075
static void fix_max_connections(THD *thd, enum_var_type type)
1076
{
1077
#ifndef EMBEDDED_LIBRARY
1078 1079
  resize_thr_alarm(max_connections + 
		   global_system_variables.max_insert_delayed_threads + 10);
1080
#endif
1081 1082 1083 1084 1085 1086
}


static void fix_thd_mem_root(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
unknown's avatar
unknown committed
1087
    reset_root_defaults(thd->mem_root,
1088 1089 1090 1091 1092 1093 1094
                        thd->variables.query_alloc_block_size,
                        thd->variables.query_prealloc_size);
}


static void fix_trans_mem_root(THD *thd, enum_var_type type)
{
1095
#ifdef USING_TRANSACTIONS
1096 1097 1098 1099
  if (type != OPT_GLOBAL)
    reset_root_defaults(&thd->transaction.mem_root,
                        thd->variables.trans_alloc_block_size,
                        thd->variables.trans_prealloc_size);
1100
#endif
1101 1102
}

1103

1104 1105 1106 1107
static void fix_server_id(THD *thd, enum_var_type type)
{
  server_id_supplied = 1;
}
1108

1109 1110

sys_var_long_ptr::
unknown's avatar
unknown committed
1111
sys_var_long_ptr(sys_var_chain *chain, const char *name_arg, ulong *value_ptr_arg,
1112
                 sys_after_update_func after_update_arg)
unknown's avatar
unknown committed
1113
  :sys_var_long_ptr_global(chain, name_arg, value_ptr_arg,
1114 1115 1116 1117 1118
                           &LOCK_global_system_variables, after_update_arg)
{}


bool sys_var_long_ptr_global::check(THD *thd, set_var *var)
unknown's avatar
unknown committed
1119 1120 1121 1122 1123
{
  longlong v= var->value->val_int();
  var->save_result.ulonglong_value= v < 0 ? 0 : v;
  return 0;
}
1124

1125
bool sys_var_long_ptr_global::update(THD *thd, set_var *var)
unknown's avatar
unknown committed
1126
{
1127
  ulonglong tmp= var->save_result.ulonglong_value;
1128
  pthread_mutex_lock(guard);
unknown's avatar
unknown committed
1129 1130 1131 1132
  if (option_limits)
    *value= (ulong) getopt_ull_limit_value(tmp, option_limits);
  else
    *value= (ulong) tmp;
1133
  pthread_mutex_unlock(guard);
unknown's avatar
unknown committed
1134 1135 1136 1137
  return 0;
}


1138
void sys_var_long_ptr_global::set_default(THD *thd, enum_var_type type)
unknown's avatar
unknown committed
1139
{
1140
  pthread_mutex_lock(guard);
unknown's avatar
unknown committed
1141
  *value= (ulong) option_limits->def_value;
1142
  pthread_mutex_unlock(guard);
unknown's avatar
unknown committed
1143 1144 1145
}


1146 1147
bool sys_var_ulonglong_ptr::update(THD *thd, set_var *var)
{
1148
  ulonglong tmp= var->save_result.ulonglong_value;
1149
  pthread_mutex_lock(&LOCK_global_system_variables);
1150 1151 1152 1153
  if (option_limits)
    *value= (ulonglong) getopt_ull_limit_value(tmp, option_limits);
  else
    *value= (ulonglong) tmp;
1154
  pthread_mutex_unlock(&LOCK_global_system_variables);
1155 1156 1157 1158 1159 1160
  return 0;
}


void sys_var_ulonglong_ptr::set_default(THD *thd, enum_var_type type)
{
1161
  pthread_mutex_lock(&LOCK_global_system_variables);
1162
  *value= (ulonglong) option_limits->def_value;
1163
  pthread_mutex_unlock(&LOCK_global_system_variables);
1164 1165 1166
}


unknown's avatar
unknown committed
1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179
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;
}


1180 1181 1182 1183 1184 1185 1186
bool sys_var_enum::update(THD *thd, set_var *var)
{
  *value= (uint) var->save_result.ulong_value;
  return 0;
}


1187
uchar *sys_var_enum::value_ptr(THD *thd, enum_var_type type, LEX_STRING *base)
1188
{
1189
  return (uchar*) enum_names->type_names[*value];
1190 1191
}

1192 1193 1194 1195 1196
bool sys_var_thd_ulong::check(THD *thd, set_var *var)
{
  return (sys_var_thd::check(thd, var) ||
          (check_func && (*check_func)(thd, var)));
}
1197

unknown's avatar
unknown committed
1198 1199
bool sys_var_thd_ulong::update(THD *thd, set_var *var)
{
1200
  ulonglong tmp= var->save_result.ulonglong_value;
1201 1202
  char buf[22];
  bool truncated= false;
unknown's avatar
unknown committed
1203 1204 1205

  /* Don't use bigger value than given with --maximum-variable-name=.. */
  if ((ulong) tmp > max_system_variables.*offset)
1206 1207 1208
  {
    truncated= true;
    llstr(tmp, buf);
unknown's avatar
unknown committed
1209
    tmp= max_system_variables.*offset;
1210
  }
unknown's avatar
unknown committed
1211

1212 1213 1214
#if SIZEOF_LONG == 4
  /* Avoid overflows on 32 bit systems */
  if (tmp > (ulonglong) ~(ulong) 0)
1215 1216 1217
  {
    truncated= true;
    llstr(tmp, buf);
1218
    tmp= ((ulonglong) ~(ulong) 0);
1219
  }
1220
#endif
1221 1222 1223 1224 1225
  if (truncated)
    push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_WARN,
                        ER_TRUNCATED_WRONG_VALUE,
                        ER(ER_TRUNCATED_WRONG_VALUE), name,
                        buf);
1226

unknown's avatar
unknown committed
1227 1228 1229
  if (option_limits)
    tmp= (ulong) getopt_ull_limit_value(tmp, option_limits);
  if (var->type == OPT_GLOBAL)
1230
    global_system_variables.*offset= (ulong) tmp;
unknown's avatar
unknown committed
1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248
  else
    thd->variables.*offset= (ulong) tmp;
  return 0;
}


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


1249
uchar *sys_var_thd_ulong::value_ptr(THD *thd, enum_var_type type,
1250
				   LEX_STRING *base)
unknown's avatar
unknown committed
1251 1252
{
  if (type == OPT_GLOBAL)
1253 1254
    return (uchar*) &(global_system_variables.*offset);
  return (uchar*) &(thd->variables.*offset);
unknown's avatar
unknown committed
1255 1256 1257
}


1258 1259
bool sys_var_thd_ha_rows::update(THD *thd, set_var *var)
{
1260
  ulonglong tmp= var->save_result.ulonglong_value;
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 1286 1287 1288 1289 1290 1291 1292 1293 1294

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

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


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


1295
uchar *sys_var_thd_ha_rows::value_ptr(THD *thd, enum_var_type type,
1296
				     LEX_STRING *base)
1297 1298
{
  if (type == OPT_GLOBAL)
1299 1300
    return (uchar*) &(global_system_variables.*offset);
  return (uchar*) &(thd->variables.*offset);
1301 1302
}

unknown's avatar
unknown committed
1303 1304
bool sys_var_thd_ulonglong::update(THD *thd,  set_var *var)
{
1305
  ulonglong tmp= var->save_result.ulonglong_value;
1306

1307
  if (tmp > max_system_variables.*offset)
1308 1309 1310
    tmp= max_system_variables.*offset;

  if (option_limits)
1311
    tmp= getopt_ull_limit_value(tmp, option_limits);
unknown's avatar
unknown committed
1312
  if (var->type == OPT_GLOBAL)
1313 1314 1315
  {
    /* Lock is needed to make things safe on 32 bit systems */
    pthread_mutex_lock(&LOCK_global_system_variables);
1316
    global_system_variables.*offset= (ulonglong) tmp;
1317 1318
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
unknown's avatar
unknown committed
1319
  else
1320
    thd->variables.*offset= (ulonglong) tmp;
unknown's avatar
unknown committed
1321 1322 1323 1324 1325 1326 1327
  return 0;
}


void sys_var_thd_ulonglong::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
1328 1329
  {
    pthread_mutex_lock(&LOCK_global_system_variables);
1330
    global_system_variables.*offset= (ulonglong) option_limits->def_value;
1331 1332
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
unknown's avatar
unknown committed
1333 1334 1335 1336 1337
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1338
uchar *sys_var_thd_ulonglong::value_ptr(THD *thd, enum_var_type type,
1339
				       LEX_STRING *base)
unknown's avatar
unknown committed
1340 1341
{
  if (type == OPT_GLOBAL)
1342 1343
    return (uchar*) &(global_system_variables.*offset);
  return (uchar*) &(thd->variables.*offset);
unknown's avatar
unknown committed
1344 1345 1346 1347 1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365
}


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


1366
uchar *sys_var_thd_bool::value_ptr(THD *thd, enum_var_type type,
1367
				  LEX_STRING *base)
unknown's avatar
unknown committed
1368 1369
{
  if (type == OPT_GLOBAL)
1370 1371
    return (uchar*) &(global_system_variables.*offset);
  return (uchar*) &(thd->variables.*offset);
unknown's avatar
unknown committed
1372 1373 1374
}


1375
bool sys_var::check_enum(THD *thd, set_var *var, const TYPELIB *enum_names)
unknown's avatar
unknown committed
1376
{
unknown's avatar
unknown committed
1377
  char buff[STRING_BUFFER_USUAL_SIZE];
1378
  const char *value;
1379
  String str(buff, sizeof(buff), system_charset_info), *res;
unknown's avatar
unknown committed
1380 1381 1382 1383 1384

  if (var->value->result_type() == STRING_RESULT)
  {
    if (!(res=var->value->val_str(&str)) ||
	((long) (var->save_result.ulong_value=
1385 1386
		 (ulong) find_type(enum_names, res->ptr(),
				   res->length(),1)-1)) < 0)
unknown's avatar
unknown committed
1387
    {
1388
      value= res ? res->c_ptr() : "NULL";
unknown's avatar
unknown committed
1389 1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405
      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:
1406
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, value);
unknown's avatar
unknown committed
1407 1408 1409
  return 1;
}

1410 1411 1412

bool sys_var::check_set(THD *thd, set_var *var, TYPELIB *enum_names)
{
1413
  bool not_used;
unknown's avatar
unknown committed
1414
  char buff[STRING_BUFFER_USUAL_SIZE], *error= 0;
1415 1416 1417 1418 1419 1420
  uint error_len= 0;
  String str(buff, sizeof(buff), system_charset_info), *res;

  if (var->value->result_type() == STRING_RESULT)
  {
    if (!(res= var->value->val_str(&str)))
1421
    {
unknown's avatar
unknown committed
1422
      strmov(buff, "NULL");
1423
      goto err;
1424
    }
unknown's avatar
unknown committed
1425 1426
    var->save_result.ulong_value= ((ulong)
				   find_set(enum_names, res->c_ptr(),
1427 1428 1429
					    res->length(),
                                            NULL,
                                            &error, &error_len,
unknown's avatar
unknown committed
1430
					    &not_used));
1431 1432
    if (error_len)
    {
1433
      strmake(buff, error, min(sizeof(buff) - 1, error_len));
1434 1435 1436 1437 1438 1439
      goto err;
    }
  }
  else
  {
    ulonglong tmp= var->value->val_int();
1440 1441 1442 1443 1444 1445
   /*
     For when the enum is made to contain 64 elements, as 1ULL<<64 is
     undefined, we guard with a "count<64" test.
   */
    if (unlikely((tmp >= ((ULL(1)) << enum_names->count)) &&
                 (enum_names->count < 64)))
1446 1447 1448 1449 1450 1451 1452 1453 1454
    {
      llstr(tmp, buff);
      goto err;
    }
    var->save_result.ulong_value= (ulong) tmp;  // Save for update
  }
  return 0;

err:
1455
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, buff);
1456 1457 1458 1459
  return 1;
}


unknown's avatar
unknown committed
1460 1461 1462 1463 1464 1465
/**
  Return an Item for a variable.

  Used with @@[global.]variable_name.

  If type is not given, return local value if exists, else global.
unknown's avatar
unknown committed
1466 1467
*/

1468
Item *sys_var::item(THD *thd, enum_var_type var_type, LEX_STRING *base)
unknown's avatar
unknown committed
1469 1470 1471 1472 1473
{
  if (check_type(var_type))
  {
    if (var_type != OPT_DEFAULT)
    {
1474 1475
      my_error(ER_INCORRECT_GLOBAL_LOCAL_VAR, MYF(0),
               name, var_type == OPT_GLOBAL ? "SESSION" : "GLOBAL");
unknown's avatar
unknown committed
1476 1477 1478 1479 1480
      return 0;
    }
    /* As there was no local variable, return the global value */
    var_type= OPT_GLOBAL;
  }
1481
  switch (show_type()) {
1482 1483 1484 1485 1486 1487
  case SHOW_INT:
  {
    uint value;
    pthread_mutex_lock(&LOCK_global_system_variables);
    value= *(uint*) value_ptr(thd, var_type, base);
    pthread_mutex_unlock(&LOCK_global_system_variables);
1488
    return new Item_uint((ulonglong) value);
1489
  }
unknown's avatar
unknown committed
1490
  case SHOW_LONG:
1491 1492 1493 1494 1495
  {
    ulong value;
    pthread_mutex_lock(&LOCK_global_system_variables);
    value= *(ulong*) value_ptr(thd, var_type, base);
    pthread_mutex_unlock(&LOCK_global_system_variables);
1496
    return new Item_uint((ulonglong) value);
1497
  }
unknown's avatar
unknown committed
1498
  case SHOW_LONGLONG:
1499 1500 1501
  {
    longlong value;
    pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1502
    value= *(longlong*) value_ptr(thd, var_type, base);
1503 1504 1505
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return new Item_int(value);
  }
1506 1507 1508 1509 1510 1511 1512 1513 1514
  case SHOW_DOUBLE:
  {
    double value;
    pthread_mutex_lock(&LOCK_global_system_variables);
    value= *(double*) value_ptr(thd, var_type, base);
    pthread_mutex_unlock(&LOCK_global_system_variables);
    /* 6, as this is for now only used with microseconds */
    return new Item_float(value, 6);
  }
1515
  case SHOW_HA_ROWS:
1516 1517 1518
  {
    ha_rows value;
    pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1519
    value= *(ha_rows*) value_ptr(thd, var_type, base);
1520 1521 1522
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return new Item_int((longlong) value);
  }
unknown's avatar
unknown committed
1523
  case SHOW_MY_BOOL:
unknown's avatar
unknown committed
1524 1525 1526 1527 1528 1529 1530
  {
    int32 value;
    pthread_mutex_lock(&LOCK_global_system_variables);
    value= *(my_bool*) value_ptr(thd, var_type, base);
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return new Item_int(value,1);
  }
unknown's avatar
unknown committed
1531 1532 1533 1534 1535 1536 1537 1538 1539 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549
  case SHOW_CHAR_PTR:
  {
    Item *tmp;
    pthread_mutex_lock(&LOCK_global_system_variables);
    char *str= *(char**) value_ptr(thd, var_type, base);
    if (str)
    {
      uint length= strlen(str);
      tmp= new Item_string(thd->strmake(str, length), length,
                           system_charset_info, DERIVATION_SYSCONST);
    }
    else
    {
      tmp= new Item_null();
      tmp->collation.set(system_charset_info, DERIVATION_SYSCONST);
    }
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return tmp;
  }
unknown's avatar
unknown committed
1550 1551
  case SHOW_CHAR:
  {
unknown's avatar
unknown committed
1552
    Item *tmp;
1553
    pthread_mutex_lock(&LOCK_global_system_variables);
1554
    char *str= (char*) value_ptr(thd, var_type, base);
unknown's avatar
unknown committed
1555 1556 1557 1558 1559 1560 1561 1562
    if (str)
      tmp= new Item_string(str, strlen(str),
                           system_charset_info, DERIVATION_SYSCONST);
    else
    {
      tmp= new Item_null();
      tmp->collation.set(system_charset_info, DERIVATION_SYSCONST);
    }
1563 1564
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return tmp;
unknown's avatar
unknown committed
1565 1566
  }
  default:
1567
    my_error(ER_VAR_CANT_BE_READ, MYF(0), name);
unknown's avatar
unknown committed
1568 1569 1570 1571 1572 1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588 1589 1590 1591
  }
  return 0;
}


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


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


1592
uchar *sys_var_thd_enum::value_ptr(THD *thd, enum_var_type type,
1593
				  LEX_STRING *base)
unknown's avatar
unknown committed
1594 1595 1596 1597
{
  ulong tmp= ((type == OPT_GLOBAL) ?
	      global_system_variables.*offset :
	      thd->variables.*offset);
1598
  return (uchar*) enum_names->type_names[tmp];
unknown's avatar
unknown committed
1599 1600
}

1601 1602 1603 1604 1605
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
1606 1607 1608

bool sys_var_thd_bit::update(THD *thd, set_var *var)
{
1609
  int res= (*update_func)(thd, var);
unknown's avatar
unknown committed
1610 1611 1612 1613
  return res;
}


1614
uchar *sys_var_thd_bit::value_ptr(THD *thd, enum_var_type type,
1615
				 LEX_STRING *base)
unknown's avatar
unknown committed
1616 1617 1618 1619 1620 1621 1622
{
  /*
    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);
1623
  return (uchar*) &thd->sys_var_tmp.my_bool_value;
unknown's avatar
unknown committed
1624 1625 1626
}


unknown's avatar
unknown committed
1627
/** Update a date_time format variable based on given value. */
1628 1629 1630 1631 1632 1633

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");
1634
  DBUG_DUMP("positions", (uchar*) new_value->positions,
1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657 1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668
	    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
1669
  char buff[STRING_BUFFER_USUAL_SIZE];
1670 1671 1672 1673 1674 1675 1676 1677 1678
  String str(buff,sizeof(buff), system_charset_info), *res;
  DATE_TIME_FORMAT *format;

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

  if (!(format= date_time_format_make(date_time_type,
				      res->ptr(), res->length())))
  {
1679
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, res->c_ptr());
1680 1681 1682 1683 1684 1685 1686 1687 1688 1689 1690 1691 1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713
    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);
}


1714
uchar *sys_var_thd_date_time_format::value_ptr(THD *thd, enum_var_type type,
1715 1716 1717 1718 1719 1720 1721 1722 1723 1724 1725 1726
					      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);
1727
    return (uchar*) res;
1728
  }
1729
  return (uchar*) (thd->variables.*offset)->format.str;
1730 1731 1732
}


1733 1734
typedef struct old_names_map_st
{
unknown's avatar
unknown committed
1735 1736 1737
  const char *old_name;
  const char *new_name;
} my_old_conv;
unknown's avatar
unknown committed
1738

unknown's avatar
unknown committed
1739 1740
static my_old_conv old_conv[]= 
{
1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751
  {	"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
1752
};
unknown's avatar
unknown committed
1753

unknown's avatar
unknown committed
1754
CHARSET_INFO *get_old_charset_by_name(const char *name)
unknown's avatar
unknown committed
1755
{
unknown's avatar
unknown committed
1756
  my_old_conv *conv;
unknown's avatar
unknown committed
1757
 
unknown's avatar
unknown committed
1758
  for (conv= old_conv; conv->old_name; conv++)
1759
  {
unknown's avatar
unknown committed
1760 1761
    if (!my_strcasecmp(&my_charset_latin1, name, conv->old_name))
      return get_charset_by_csname(conv->new_name, MY_CS_PRIMARY, MYF(0));
1762
  }
unknown's avatar
unknown committed
1763
  return NULL;
unknown's avatar
unknown committed
1764 1765
}

unknown's avatar
unknown committed
1766

1767
bool sys_var_collation::check(THD *thd, set_var *var)
unknown's avatar
unknown committed
1768 1769
{
  CHARSET_INFO *tmp;
1770
  LINT_INIT(tmp);
unknown's avatar
unknown committed
1771

1772
  if (var->value->result_type() == STRING_RESULT)
1773
  {
unknown's avatar
unknown committed
1774
    char buff[STRING_BUFFER_USUAL_SIZE];
1775 1776 1777
    String str(buff,sizeof(buff), system_charset_info), *res;
    if (!(res=var->value->val_str(&str)))
    {
1778
      my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, "NULL");
1779 1780 1781 1782
      return 1;
    }
    if (!(tmp=get_charset_by_name(res->c_ptr(),MYF(0))))
    {
1783
      my_error(ER_UNKNOWN_COLLATION, MYF(0), res->c_ptr());
1784 1785
      return 1;
    }
1786
  }
1787
  else // INT_RESULT
1788
  {
1789
    if (!(tmp=get_charset((int) var->value->val_int(),MYF(0))))
1790 1791
    {
      char buf[20];
1792
      int10_to_str((int) var->value->val_int(), buf, -10);
1793
      my_error(ER_UNKNOWN_COLLATION, MYF(0), buf);
1794 1795
      return 1;
    }
1796 1797 1798 1799 1800
  }
  var->save_result.charset= tmp;	// Save for update
  return 0;
}

1801

1802 1803 1804
bool sys_var_character_set::check(THD *thd, set_var *var)
{
  CHARSET_INFO *tmp;
1805
  LINT_INIT(tmp);
1806

1807 1808
  if (var->value->result_type() == STRING_RESULT)
  {
unknown's avatar
unknown committed
1809
    char buff[STRING_BUFFER_USUAL_SIZE];
1810 1811
    String str(buff,sizeof(buff), system_charset_info), *res;
    if (!(res=var->value->val_str(&str)))
1812
    {
1813 1814
      if (!nullable)
      {
1815
        my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, "NULL");
1816 1817 1818 1819 1820 1821 1822
        return 1;
      }
      tmp= NULL;
    }
    else if (!(tmp=get_charset_by_csname(res->c_ptr(),MY_CS_PRIMARY,MYF(0))) &&
             !(tmp=get_old_charset_by_name(res->c_ptr())))
    {
1823
      my_error(ER_UNKNOWN_CHARACTER_SET, MYF(0), res->c_ptr());
1824 1825 1826
      return 1;
    }
  }
1827
  else // INT_RESULT
unknown's avatar
unknown committed
1828
  {
1829
    if (!(tmp=get_charset((int) var->value->val_int(),MYF(0))))
1830 1831
    {
      char buf[20];
1832
      int10_to_str((int) var->value->val_int(), buf, -10);
1833 1834 1835
      my_error(ER_UNKNOWN_CHARACTER_SET, MYF(0), buf);
      return 1;
    }
unknown's avatar
unknown committed
1836 1837 1838 1839 1840
  }
  var->save_result.charset= tmp;	// Save for update
  return 0;
}

1841

1842
bool sys_var_character_set::update(THD *thd, set_var *var)
unknown's avatar
unknown committed
1843
{
1844
  ci_ptr(thd,var->type)[0]= var->save_result.charset;
unknown's avatar
unknown committed
1845
  thd->update_charset();
unknown's avatar
unknown committed
1846 1847 1848
  return 0;
}

1849

1850
uchar *sys_var_character_set::value_ptr(THD *thd, enum_var_type type,
1851
				       LEX_STRING *base)
unknown's avatar
unknown committed
1852
{
1853
  CHARSET_INFO *cs= ci_ptr(thd,type)[0];
1854
  return cs ? (uchar*) cs->csname : (uchar*) NULL;
unknown's avatar
unknown committed
1855 1856
}

1857

unknown's avatar
unknown committed
1858
void sys_var_character_set_sv::set_default(THD *thd, enum_var_type type)
unknown's avatar
unknown committed
1859 1860
{
  if (type == OPT_GLOBAL)
unknown's avatar
unknown committed
1861
    global_system_variables.*offset= *global_default;
unknown's avatar
unknown committed
1862
  else
unknown's avatar
unknown committed
1863 1864 1865 1866
  {
    thd->variables.*offset= global_system_variables.*offset;
    thd->update_charset();
  }
1867
}
unknown's avatar
unknown committed
1868
CHARSET_INFO **sys_var_character_set_sv::ci_ptr(THD *thd, enum_var_type type)
1869 1870
{
  if (type == OPT_GLOBAL)
unknown's avatar
unknown committed
1871
    return &(global_system_variables.*offset);
1872
  else
unknown's avatar
unknown committed
1873
    return &(thd->variables.*offset);
1874 1875
}

1876

1877 1878 1879 1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 1891
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;
}


1892 1893
CHARSET_INFO ** sys_var_character_set_database::ci_ptr(THD *thd,
						       enum_var_type type)
1894 1895
{
  if (type == OPT_GLOBAL)
1896
    return &global_system_variables.collation_database;
1897
  else
1898
    return &thd->variables.collation_database;
1899 1900
}

1901

1902 1903 1904
void sys_var_character_set_database::set_default(THD *thd, enum_var_type type)
{
 if (type == OPT_GLOBAL)
1905
    global_system_variables.collation_database= default_charset_info;
1906
  else
unknown's avatar
unknown committed
1907
  {
1908
    thd->variables.collation_database= thd->db_charset;
unknown's avatar
unknown committed
1909 1910
    thd->update_charset();
  }
1911 1912
}

1913

unknown's avatar
unknown committed
1914
bool sys_var_collation_sv::update(THD *thd, set_var *var)
1915 1916
{
  if (var->type == OPT_GLOBAL)
unknown's avatar
unknown committed
1917
    global_system_variables.*offset= var->save_result.charset;
1918
  else
unknown's avatar
unknown committed
1919
  {
unknown's avatar
unknown committed
1920
    thd->variables.*offset= var->save_result.charset;
unknown's avatar
unknown committed
1921 1922
    thd->update_charset();
  }
1923 1924 1925
  return 0;
}

1926

unknown's avatar
unknown committed
1927
void sys_var_collation_sv::set_default(THD *thd, enum_var_type type)
1928
{
unknown's avatar
unknown committed
1929 1930
  if (type == OPT_GLOBAL)
    global_system_variables.*offset= *global_default;
1931 1932
  else
  {
unknown's avatar
unknown committed
1933
    thd->variables.*offset= global_system_variables.*offset;
1934 1935 1936 1937 1938
    thd->update_charset();
  }
}


1939
uchar *sys_var_collation_sv::value_ptr(THD *thd, enum_var_type type,
1940
                                       LEX_STRING *base)
1941 1942
{
  CHARSET_INFO *cs= ((type == OPT_GLOBAL) ?
1943
		     global_system_variables.*offset : thd->variables.*offset);
1944
  return cs ? (uchar*) cs->name : (uchar*) "NULL";
1945 1946 1947
}


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

unknown's avatar
unknown committed
1950
static KEY_CACHE zero_key_cache;
unknown's avatar
unknown committed
1951

unknown's avatar
unknown committed
1952
KEY_CACHE *get_key_cache(LEX_STRING *cache_name)
unknown's avatar
unknown committed
1953
{
1954 1955
  safe_mutex_assert_owner(&LOCK_global_system_variables);
  if (!cache_name || ! cache_name->length)
unknown's avatar
unknown committed
1956
    cache_name= &default_key_cache_base;
unknown's avatar
unknown committed
1957
  return ((KEY_CACHE*) find_named(&key_caches,
1958
                                      cache_name->str, cache_name->length, 0));
unknown's avatar
unknown committed
1959 1960
}

1961

1962
uchar *sys_var_key_cache_param::value_ptr(THD *thd, enum_var_type type,
unknown's avatar
unknown committed
1963
					 LEX_STRING *base)
1964
{
unknown's avatar
unknown committed
1965
  KEY_CACHE *key_cache= get_key_cache(base);
unknown's avatar
unknown committed
1966 1967
  if (!key_cache)
    key_cache= &zero_key_cache;
1968
  return (uchar*) key_cache + offset ;
unknown's avatar
unknown committed
1969
}
1970

1971

1972 1973
bool sys_var_key_buffer_size::update(THD *thd, set_var *var)
{
1974
  ulonglong tmp= var->save_result.ulonglong_value;
unknown's avatar
unknown committed
1975
  LEX_STRING *base_name= &var->base;
unknown's avatar
unknown committed
1976
  KEY_CACHE *key_cache;
1977 1978 1979
  bool error= 0;

  /* If no basename, assume it's for the key cache named 'default' */
unknown's avatar
unknown committed
1980
  if (!base_name->length)
1981
    base_name= &default_key_cache_base;
1982 1983 1984

  pthread_mutex_lock(&LOCK_global_system_variables);
  key_cache= get_key_cache(base_name);
unknown's avatar
unknown committed
1985
                            
1986 1987
  if (!key_cache)
  {
1988
    /* Key cache didn't exists */
1989
    if (!tmp)					// Tried to delete cache
1990 1991 1992 1993 1994 1995
      goto end;					// Ok, nothing to do
    if (!(key_cache= create_key_cache(base_name->str, base_name->length)))
    {
      error= 1;
      goto end;
    }
1996
  }
1997 1998 1999 2000 2001 2002 2003 2004 2005

  /*
    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
2006
  if (!tmp)					// Zero size means delete
2007
  {
unknown's avatar
unknown committed
2008
    if (key_cache == dflt_key_cache)
2009 2010 2011 2012
    {
      push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_WARN,
                          ER_WARN_CANT_DROP_DEFAULT_KEYCACHE,
                          ER(ER_WARN_CANT_DROP_DEFAULT_KEYCACHE));
2013
      goto end;					// Ignore default key cache
2014
    }
2015

unknown's avatar
unknown committed
2016
    if (key_cache->key_cache_inited)		// If initied
2017 2018
    {
      /*
2019 2020
	Move tables using this key cache to the default key cache
	and clear the old key cache.
2021
      */
2022
      NAMED_LIST *list; 
unknown's avatar
unknown committed
2023
      key_cache= (KEY_CACHE *) find_named(&key_caches, base_name->str,
2024
					      base_name->length, &list);
2025 2026
      key_cache->in_init= 1;
      pthread_mutex_unlock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
2027
      error= reassign_keycache_tables(thd, key_cache, dflt_key_cache);
2028 2029
      pthread_mutex_lock(&LOCK_global_system_variables);
      key_cache->in_init= 0;
2030
    }
2031 2032 2033 2034 2035
    /*
      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;
2036 2037
  }

unknown's avatar
unknown committed
2038 2039
  key_cache->param_buff_size=
    (ulonglong) getopt_ull_limit_value(tmp, option_limits);
2040

2041 2042 2043 2044
  /* If key cache didn't existed initialize it, else resize it */
  key_cache->in_init= 1;
  pthread_mutex_unlock(&LOCK_global_system_variables);

unknown's avatar
unknown committed
2045
  if (!key_cache->key_cache_inited)
2046
    error= (bool) (ha_init_key_cache("", key_cache));
unknown's avatar
unknown committed
2047
  else
2048
    error= (bool)(ha_resize_key_cache(key_cache));
2049

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

2053 2054 2055
end:
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return error;
2056 2057
}

2058

unknown's avatar
unknown committed
2059 2060 2061 2062 2063 2064
/**
  @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
*/
2065
bool sys_var_key_cache_long::update(THD *thd, set_var *var)
2066
{
unknown's avatar
unknown committed
2067
  ulong tmp= (ulong) var->value->val_int();
2068
  LEX_STRING *base_name= &var->base;
2069 2070
  bool error= 0;

2071
  if (!base_name->length)
unknown's avatar
unknown committed
2072
    base_name= &default_key_cache_base;
2073 2074

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

unknown's avatar
unknown committed
2077 2078
  if (!key_cache && !(key_cache= create_key_cache(base_name->str,
				                  base_name->length)))
2079 2080 2081 2082
  {
    error= 1;
    goto end;
  }
2083

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

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

2095 2096 2097 2098 2099
  /*
    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;
2100

2101
  pthread_mutex_unlock(&LOCK_global_system_variables);
2102

2103 2104 2105 2106 2107 2108 2109 2110
  error= (bool) (ha_resize_key_cache(key_cache));

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

end:
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return error;
2111 2112
}

2113

2114 2115
bool sys_var_log_state::update(THD *thd, set_var *var)
{
2116
  bool res;
2117 2118 2119
  pthread_mutex_lock(&LOCK_global_system_variables);
  if (!var->save_result.ulong_value)
  {
2120 2121
    logger.deactivate_log_handler(thd, log_type);
    res= false;
2122
  }
2123 2124
  else
    res= logger.activate_log_handler(thd, log_type);
2125 2126 2127 2128 2129 2130 2131 2132 2133 2134 2135 2136 2137 2138
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return res;
}

void sys_var_log_state::set_default(THD *thd, enum_var_type type)
{
  pthread_mutex_lock(&LOCK_global_system_variables);
  logger.deactivate_log_handler(thd, log_type);
  pthread_mutex_unlock(&LOCK_global_system_variables);
}


static int  sys_check_log_path(THD *thd,  set_var *var)
{
2139
  char path[FN_REFLEN], buff[FN_REFLEN];
2140
  MY_STAT f_stat;
2141 2142 2143 2144 2145 2146 2147
  String str(buff, sizeof(buff), system_charset_info), *res;
  const char *log_file_str;
      
  if (!(res= var->value->val_str(&str)))
    goto err;

  log_file_str= res->c_ptr();
2148 2149
  bzero(&f_stat, sizeof(MY_STAT));

2150
  (void) unpack_filename(path, log_file_str);
2151 2152 2153 2154 2155
  if (my_stat(path, &f_stat, MYF(0)))
  {
    /* Check if argument is a file and we have 'write' permission */
    if (!MY_S_ISREG(f_stat.st_mode) ||
        !(f_stat.st_mode & MY_S_IWRITE))
2156
      goto err;
2157 2158 2159
  }
  else
  {
2160
    size_t path_length;
2161 2162 2163 2164
    /*
      Check if directory exists and 
      we have permission to create file & write to file
    */
2165
    (void) dirname_part(path, log_file_str, &path_length);
2166
    if (my_access(path, (F_OK|W_OK)))
2167
      goto err;
2168 2169
  }
  return 0;
2170 2171 2172 2173 2174

err:
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), var->var->name, 
           res ? log_file_str : "NULL");
  return 1;
2175 2176 2177 2178 2179 2180 2181
}


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)
{
unknown's avatar
unknown committed
2182
  MYSQL_QUERY_LOG *file_log;
2183 2184 2185 2186 2187 2188 2189 2190 2191 2192 2193 2194 2195
  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:
unknown's avatar
unknown committed
2196
    assert(0);                                  // Impossible
2197 2198 2199 2200 2201 2202 2203
  }

  if (!old_value)
  {
    old_value= make_default_log_name(buff, log_ext);
    str_length= strlen(old_value);
  }
2204
  if (!(res= my_strndup(old_value, str_length, MYF(MY_FAE+MY_WME))))
2205 2206 2207 2208 2209 2210
  {
    result= 1;
    goto err;
  }

  pthread_mutex_lock(&LOCK_global_system_variables);
2211
  logger.lock_exclusive();
2212 2213 2214 2215 2216 2217 2218 2219

  if (file_log && log_state)
    file_log->close(0);
  old_value= var_str->value;
  var_str->value= res;
  var_str->value_length= str_length;
  my_free(old_value, MYF(MY_ALLOW_ZERO_PTR));
  if (file_log && log_state)
unknown's avatar
unknown committed
2220 2221 2222
  {
    switch (log_type) {
    case QUERY_LOG_SLOW:
2223
      file_log->open_slow_log(sys_var_slow_log_path.value);
unknown's avatar
unknown committed
2224 2225 2226 2227 2228 2229 2230 2231
      break;
    case QUERY_LOG_GENERAL:
      file_log->open_query_log(sys_var_general_log_path.value);
      break;
    default:
      DBUG_ASSERT(0);
    }
  }
2232 2233 2234 2235 2236 2237 2238 2239 2240 2241 2242 2243 2244 2245 2246 2247 2248 2249 2250 2251 2252 2253 2254 2255 2256 2257 2258 2259 2260 2261 2262 2263 2264 2265 2266 2267 2268 2269 2270 2271 2272 2273

  logger.unlock();
  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)
{
  pthread_mutex_lock(&LOCK_global_system_variables);
2274
  logger.lock_exclusive();
2275 2276 2277 2278 2279 2280 2281 2282 2283 2284 2285 2286
  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();
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return 0;
}


void sys_var_log_output::set_default(THD *thd, enum_var_type type)
{
  pthread_mutex_lock(&LOCK_global_system_variables);
2287 2288 2289 2290
  logger.lock_exclusive();
  logger.init_slow_log(LOG_FILE);
  logger.init_general_log(LOG_FILE);
  *value= LOG_FILE;
2291 2292 2293 2294 2295
  logger.unlock();
  pthread_mutex_unlock(&LOCK_global_system_variables);
}


2296
uchar *sys_var_log_output::value_ptr(THD *thd, enum_var_type type,
unknown's avatar
unknown committed
2297
                                    LEX_STRING *base)
2298 2299 2300 2301 2302 2303 2304 2305 2306 2307 2308 2309 2310 2311 2312 2313 2314 2315 2316
{
  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--;
2317
  return (uchar*) thd->strmake(tmp.ptr(), length);
2318 2319 2320
}


2321 2322 2323 2324
/*****************************************************************************
  Functions to handle SET NAMES and SET CHARACTER SET
*****************************************************************************/

unknown's avatar
unknown committed
2325
int set_var_collation_client::check(THD *thd)
2326
{
2327 2328 2329 2330 2331 2332 2333
  /* 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;
  }
2334 2335 2336
  return 0;
}

unknown's avatar
unknown committed
2337
int set_var_collation_client::update(THD *thd)
2338
{
2339 2340
  thd->variables.character_set_client= character_set_client;
  thd->variables.character_set_results= character_set_results;
unknown's avatar
unknown committed
2341
  thd->variables.collation_connection= collation_connection;
unknown's avatar
unknown committed
2342
  thd->update_charset();
unknown's avatar
unknown committed
2343 2344
  thd->protocol_text.init(thd);
  thd->protocol_binary.init(thd);
2345 2346 2347 2348 2349
  return 0;
}

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

unknown's avatar
unknown committed
2350 2351
bool sys_var_timestamp::update(THD *thd,  set_var *var)
{
2352
  thd->set_time((time_t) var->save_result.ulonglong_value);
unknown's avatar
unknown committed
2353 2354 2355 2356 2357 2358 2359 2360 2361 2362
  return 0;
}


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


2363
uchar *sys_var_timestamp::value_ptr(THD *thd, enum_var_type type,
2364
				   LEX_STRING *base)
unknown's avatar
unknown committed
2365 2366
{
  thd->sys_var_tmp.long_value= (long) thd->start_time;
2367
  return (uchar*) &thd->sys_var_tmp.long_value;
unknown's avatar
unknown committed
2368 2369 2370 2371 2372
}


bool sys_var_last_insert_id::update(THD *thd, set_var *var)
{
2373 2374
  thd->first_successful_insert_id_in_prev_stmt= 
    var->save_result.ulonglong_value;
unknown's avatar
unknown committed
2375 2376 2377 2378
  return 0;
}


2379
uchar *sys_var_last_insert_id::value_ptr(THD *thd, enum_var_type type,
2380
					LEX_STRING *base)
unknown's avatar
unknown committed
2381
{
2382 2383 2384 2385 2386 2387
  /*
    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();
2388
  return (uchar*) &thd->sys_var_tmp.ulonglong_value;
unknown's avatar
unknown committed
2389 2390 2391 2392 2393
}


bool sys_var_insert_id::update(THD *thd, set_var *var)
{
2394
  thd->force_one_auto_inc_interval(var->save_result.ulonglong_value);
unknown's avatar
unknown committed
2395 2396 2397 2398
  return 0;
}


2399
uchar *sys_var_insert_id::value_ptr(THD *thd, enum_var_type type,
2400
				   LEX_STRING *base)
unknown's avatar
unknown committed
2401
{
2402 2403
  thd->sys_var_tmp.ulonglong_value= 
    thd->auto_inc_intervals_forced.minimum();
2404
  return (uchar*) &thd->sys_var_tmp.ulonglong_value;
unknown's avatar
unknown committed
2405 2406 2407
}


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

bool sys_var_rand_seed2::update(THD *thd, set_var *var)
{
2416
  thd->rand.seed2= (ulong) var->save_result.ulonglong_value;
2417 2418 2419 2420
  return 0;
}


2421 2422
bool sys_var_thd_time_zone::check(THD *thd, set_var *var)
{
2423
  char buff[MAX_TIME_ZONE_NAME_LENGTH];
2424 2425 2426
  String str(buff, sizeof(buff), &my_charset_latin1);
  String *res= var->value->val_str(&str);

2427
  if (!(var->save_result.time_zone= my_tz_find(thd, res)))
2428
  {
2429
    my_error(ER_UNKNOWN_TIME_ZONE, MYF(0), res ? res->c_ptr() : "NULL");
2430 2431 2432 2433 2434 2435 2436 2437
    return 1;
  }
  return 0;
}


bool sys_var_thd_time_zone::update(THD *thd, set_var *var)
{
2438 2439 2440 2441 2442 2443 2444 2445 2446
  /* 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;
2447 2448 2449 2450
  return 0;
}


2451
uchar *sys_var_thd_time_zone::value_ptr(THD *thd, enum_var_type type,
2452 2453 2454 2455 2456 2457 2458
				       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)
2459
    return (uchar *)(global_system_variables.time_zone->get_name()->ptr());
2460
  else
2461 2462 2463 2464 2465 2466 2467 2468 2469 2470
  {
    /*
      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;
2471
    return (uchar *)(thd->variables.time_zone->get_name()->ptr());
2472
  }
2473 2474 2475 2476 2477
}


void sys_var_thd_time_zone::set_default(THD *thd, enum_var_type type)
{
2478
 pthread_mutex_lock(&LOCK_global_system_variables);
2479 2480 2481 2482 2483
 if (type == OPT_GLOBAL)
 {
   if (default_tz_name)
   {
     String str(default_tz_name, &my_charset_latin1);
2484 2485 2486 2487
     /*
       We are guaranteed to find this time zone since its existence
       is checked during start-up.
     */
2488
     global_system_variables.time_zone= my_tz_find(thd, &str);
2489 2490 2491 2492 2493 2494
   }
   else
     global_system_variables.time_zone= my_tz_SYSTEM;
 }
 else
   thd->variables.time_zone= global_system_variables.time_zone;
2495
 pthread_mutex_unlock(&LOCK_global_system_variables);
2496 2497
}

2498 2499 2500 2501 2502 2503 2504 2505 2506

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.
2507
      May be we should have a separate error message for this?
2508 2509 2510 2511 2512 2513 2514 2515 2516 2517
    */
    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);
2518
  max_user_connections= (uint)var->save_result.ulonglong_value;
2519 2520 2521 2522 2523 2524 2525 2526 2527 2528 2529 2530 2531 2532
  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);
}


2533
uchar *sys_var_max_user_conn::value_ptr(THD *thd, enum_var_type type,
2534 2535 2536 2537
                                       LEX_STRING *base)
{
  if (type != OPT_GLOBAL &&
      thd->user_connect && thd->user_connect->user_resources.user_conn)
2538 2539
    return (uchar*) &(thd->user_connect->user_resources.user_conn);
  return (uchar*) &(max_user_connections);
2540 2541
}

2542

unknown's avatar
unknown committed
2543 2544
bool sys_var_thd_lc_time_names::check(THD *thd, set_var *var)
{
2545
  MY_LOCALE *locale_match;
unknown's avatar
unknown committed
2546

2547
  if (var->value->result_type() == INT_RESULT)
unknown's avatar
unknown committed
2548
  {
2549 2550 2551 2552 2553 2554 2555
    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
2556
  }
2557
  else // STRING_RESULT
unknown's avatar
unknown committed
2558
  {
2559 2560 2561 2562 2563 2564 2565 2566 2567 2568 2569 2570 2571 2572
    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;
    }
    const char *locale_str= res->c_ptr();
    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
2573
  }
2574

2575 2576
  var->save_result.locale_value= locale_match;
  return 0;
unknown's avatar
unknown committed
2577 2578 2579 2580 2581
}


bool sys_var_thd_lc_time_names::update(THD *thd, set_var *var)
{
2582 2583 2584 2585
  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
2586 2587 2588 2589
  return 0;
}


2590
uchar *sys_var_thd_lc_time_names::value_ptr(THD *thd, enum_var_type type,
unknown's avatar
unknown committed
2591 2592
					  LEX_STRING *base)
{
2593
  return type == OPT_GLOBAL ?
2594 2595
                 (uchar *) global_system_variables.lc_time_names->name :
                 (uchar *) thd->variables.lc_time_names->name;
unknown's avatar
unknown committed
2596 2597 2598 2599 2600
}


void sys_var_thd_lc_time_names::set_default(THD *thd, enum_var_type type)
{
2601 2602 2603 2604
  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
2605
}
2606

2607 2608 2609 2610 2611 2612 2613 2614 2615 2616 2617 2618 2619 2620 2621 2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639 2640 2641 2642 2643 2644 2645 2646 2647 2648 2649 2650 2651 2652 2653 2654 2655 2656 2657 2658 2659 2660
/*
  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
2661 2662 2663 2664 2665 2666
/*
  Functions to update thd->options bits
*/

static bool set_option_bit(THD *thd, set_var *var)
{
2667 2668 2669
  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
2670
  else
2671
    thd->options|= sys_var->bit_flag;
unknown's avatar
unknown committed
2672 2673 2674 2675 2676 2677 2678 2679
  return 0;
}


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

2680
  ulonglong org_options= thd->options;
unknown's avatar
unknown committed
2681 2682 2683 2684 2685 2686 2687 2688 2689 2690 2691

  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 */
unknown's avatar
unknown committed
2692
      thd->options&= ~(ulonglong) (OPTION_BEGIN | OPTION_KEEP_LOG);
unknown's avatar
unknown committed
2693
      thd->transaction.all.modified_non_trans_table= FALSE;
unknown's avatar
unknown committed
2694 2695 2696 2697 2698 2699
      thd->server_status|= SERVER_STATUS_AUTOCOMMIT;
      if (ha_commit(thd))
	return 1;
    }
    else
    {
unknown's avatar
unknown committed
2700
      thd->transaction.all.modified_non_trans_table= FALSE;
unknown's avatar
unknown committed
2701 2702 2703 2704 2705 2706
      thd->server_status&= ~SERVER_STATUS_AUTOCOMMIT;
    }
  }
  return 0;
}

2707 2708 2709
static int check_log_update(THD *thd, set_var *var)
{
#ifndef NO_EMBEDDED_ACCESS_CHECKS
2710
  if (!(thd->security_ctx->master_access & SUPER_ACL))
2711 2712 2713 2714 2715 2716 2717
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
#endif
  return 0;
}
unknown's avatar
unknown committed
2718 2719 2720

static bool set_log_update(THD *thd, set_var *var)
{
2721 2722 2723 2724 2725
  /*
    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
  */
2726

unknown's avatar
unknown committed
2727
  if (opt_sql_bin_update)
2728 2729 2730 2731 2732 2733 2734 2735 2736
  {
    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
2737 2738 2739 2740 2741
  set_option_bit(thd, var);
  return 0;
}


2742 2743 2744 2745
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
2746
  if (thd->security_ctx->master_access & SUPER_ACL)
2747 2748 2749 2750 2751 2752 2753 2754 2755 2756
    return 0;
  else
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
#else
  return 0;
#endif
}
2757

2758
static uchar *get_warning_count(THD *thd)
2759 2760 2761
{
  thd->sys_var_tmp.long_value=
    (thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_NOTE] +
2762
     thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_ERROR] +
2763
     thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_WARN]);
2764
  return (uchar*) &thd->sys_var_tmp.long_value;
2765 2766
}

2767
static uchar *get_error_count(THD *thd)
2768 2769 2770
{
  thd->sys_var_tmp.long_value= 
    thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_ERROR];
2771
  return (uchar*) &thd->sys_var_tmp.long_value;
2772 2773
}

2774

unknown's avatar
unknown committed
2775 2776
/**
  Get the tmpdir that was specified or chosen by default.
2777

unknown's avatar
unknown committed
2778 2779 2780 2781 2782
  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.
2783

unknown's avatar
unknown committed
2784
  @param thd		thread handle
2785

unknown's avatar
unknown committed
2786
  @retval
2787
    ptr		pointer to NUL-terminated string
unknown's avatar
unknown committed
2788
*/
2789
static uchar *get_tmpdir(THD *thd)
2790 2791
{
  if (opt_mysql_tmpdir)
2792 2793
    return (uchar *)opt_mysql_tmpdir;
  return (uchar*)mysql_tmpdir;
2794 2795
}

unknown's avatar
unknown committed
2796 2797 2798 2799 2800 2801 2802
/****************************************************************************
  Main handling of variables:
  - Initialisation
  - Searching during parsing
  - Update loop
****************************************************************************/

unknown's avatar
unknown committed
2803 2804 2805
/**
  Find variable name in option my_getopt structure used for
  command line args.
unknown's avatar
unknown committed
2806

unknown's avatar
unknown committed
2807 2808
  @param opt	option structure array to search in
  @param name	variable name
unknown's avatar
unknown committed
2809

unknown's avatar
unknown committed
2810
  @retval
unknown's avatar
unknown committed
2811
    0		Error
unknown's avatar
unknown committed
2812
  @retval
unknown's avatar
unknown committed
2813 2814 2815 2816 2817 2818 2819 2820 2821 2822 2823 2824 2825 2826 2827 2828 2829 2830 2831 2832 2833 2834
    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
2835 2836
/**
  Return variable name and length for hashing of variables.
unknown's avatar
unknown committed
2837 2838
*/

2839 2840
static uchar *get_sys_var_length(const sys_var *var, size_t *length,
                                 my_bool first)
unknown's avatar
unknown committed
2841 2842
{
  *length= var->name_length;
2843
  return (uchar*) var->name;
unknown's avatar
unknown committed
2844 2845 2846 2847
}


/*
unknown's avatar
unknown committed
2848 2849 2850 2851 2852 2853 2854 2855 2856 2857
  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
2858 2859 2860
*/


unknown's avatar
unknown committed
2861
int mysql_add_sys_var_chain(sys_var *first, struct my_option *long_options)
unknown's avatar
unknown committed
2862
{
2863
  sys_var *var;
unknown's avatar
unknown committed
2864 2865 2866 2867
  
  /* A write lock should be held on LOCK_system_variables_hash */
  
  for (var= first; var; var= var->next)
unknown's avatar
unknown committed
2868
  {
2869
    var->name_length= strlen(var->name);
unknown's avatar
unknown committed
2870
    /* this fails if there is a conflicting variable name. see HASH_UNIQUE */
2871
    if (my_hash_insert(&system_variable_hash, (uchar*) var))
unknown's avatar
unknown committed
2872 2873 2874
      goto error;
    if (long_options)
      var->option_limits= find_option(long_options, var->name);
unknown's avatar
unknown committed
2875
  }
unknown's avatar
unknown committed
2876 2877 2878 2879
  return 0;

error:
  for (; first != var; first= first->next)
2880
    hash_delete(&system_variable_hash, (uchar*) first);
unknown's avatar
unknown committed
2881 2882
  return 1;
}
2883 2884
 
 
unknown's avatar
unknown committed
2885 2886
/*
  Remove variables to the dynamic hash of system variables
2887
   
unknown's avatar
unknown committed
2888 2889 2890
  SYNOPSIS
    mysql_del_sys_var_chain()
    first       Pointer to first system variable to remove
2891
   
unknown's avatar
unknown committed
2892 2893 2894 2895
  RETURN VALUES
    0           SUCCESS
    otherwise   FAILURE
*/
2896
 
unknown's avatar
unknown committed
2897 2898 2899
int mysql_del_sys_var_chain(sys_var *first)
{
  int result= 0;
2900
 
unknown's avatar
unknown committed
2901
  /* A write lock should be held on LOCK_system_variables_hash */
2902
   
unknown's avatar
unknown committed
2903
  for (sys_var *var= first; var; var= var->next)
2904
    result|= hash_delete(&system_variable_hash, (uchar*) var);
unknown's avatar
unknown committed
2905 2906 2907

  return result;
}
2908 2909
 
 
unknown's avatar
unknown committed
2910 2911 2912 2913
static int show_cmp(SHOW_VAR *a, SHOW_VAR *b)
{
  return strcmp(a->name, b->name);
}
2914 2915
 
 
unknown's avatar
unknown committed
2916 2917 2918 2919 2920 2921 2922 2923 2924 2925 2926 2927 2928 2929 2930 2931 2932 2933 2934 2935 2936 2937 2938 2939 2940 2941 2942 2943 2944 2945 2946 2947 2948 2949 2950 2951
/*
  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;
  int fixed_count= fixed_show_vars.elements;
  int size= sizeof(SHOW_VAR) * (count + fixed_count + 1);
  SHOW_VAR *result= (SHOW_VAR*) thd->alloc(size);

  if (result)
  {
    SHOW_VAR *show= result + fixed_count;
    memcpy(result, fixed_show_vars.buffer, fixed_count * sizeof(SHOW_VAR));

    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)
2952 2953
      my_qsort(result, count + fixed_count, sizeof(SHOW_VAR),
               (qsort_cmp) show_cmp);
unknown's avatar
unknown committed
2954 2955 2956 2957 2958 2959 2960 2961 2962 2963 2964 2965 2966 2967 2968 2969 2970 2971 2972 2973 2974 2975 2976 2977 2978 2979 2980 2981 2982 2983 2984 2985 2986 2987 2988 2989 2990 2991 2992 2993 2994
    
    /* make last element empty */
    bzero(show, sizeof(SHOW_VAR));
  }
  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");
  
  for (sys_var *var=vars.first; var; var= var->next, count++);

  if (my_init_dynamic_array(&fixed_show_vars, sizeof(SHOW_VAR),
                            FIXED_VARS_SIZE + 64, 64))
    goto error;

  fixed_show_vars.elements= FIXED_VARS_SIZE;
  memcpy(fixed_show_vars.buffer, fixed_vars, sizeof(fixed_vars));

  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
2995 2996 2997 2998 2999 3000 3001
  /*
    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
3002 3003 3004 3005 3006 3007

  DBUG_RETURN(0);

error:
  fprintf(stderr, "failed to initialize system variables");
  DBUG_RETURN(1);
unknown's avatar
unknown committed
3008 3009 3010 3011 3012 3013
}


void set_var_free()
{
  hash_free(&system_variable_hash);
unknown's avatar
unknown committed
3014 3015 3016 3017 3018 3019 3020 3021 3022 3023 3024 3025 3026 3027 3028 3029 3030 3031 3032
  delete_dynamic(&fixed_show_vars);
}


/*
  Add elements to the dynamic list of read-only system variables.
  
  SYNOPSIS
    mysql_append_static_vars()
    show_vars	Pointer to start of array
    count       Number of elements
  
  RETURN VALUES
    0           SUCCESS
    otherwise   FAILURE
*/
int mysql_append_static_vars(const SHOW_VAR *show_vars, uint count)
{
  for (; count > 0; count--, show_vars++)
unknown's avatar
unknown committed
3033
    if (insert_dynamic(&fixed_show_vars, (uchar*) show_vars))
unknown's avatar
unknown committed
3034 3035
      return 1;
  return 0;
unknown's avatar
unknown committed
3036 3037 3038
}


unknown's avatar
unknown committed
3039 3040
/**
  Find a user set-table variable.
unknown's avatar
unknown committed
3041

unknown's avatar
unknown committed
3042 3043 3044 3045
  @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
3046

unknown's avatar
unknown committed
3047
  @retval
unknown's avatar
unknown committed
3048
    pointer	pointer to variable definitions
unknown's avatar
unknown committed
3049
  @retval
unknown's avatar
unknown committed
3050 3051 3052
    0		Unknown variable (error message is given)
*/

unknown's avatar
unknown committed
3053
sys_var *intern_find_sys_var(const char *str, uint length, bool no_error)
unknown's avatar
unknown committed
3054
{
unknown's avatar
unknown committed
3055 3056 3057 3058 3059 3060 3061
  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,
3062
			      (uchar*) str, length ? length : strlen(str));
unknown's avatar
unknown committed
3063
  if (!(var || no_error))
3064
    my_error(ER_UNKNOWN_SYSTEM_VARIABLE, MYF(0), (char*) str);
unknown's avatar
unknown committed
3065

unknown's avatar
unknown committed
3066 3067 3068 3069
  return var;
}


unknown's avatar
unknown committed
3070 3071
/**
  Execute update of all variables.
unknown's avatar
unknown committed
3072

unknown's avatar
unknown committed
3073 3074
  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
3075

unknown's avatar
unknown committed
3076 3077
  This should ensure that in all normal cases none all or variables are
  updated.
unknown's avatar
unknown committed
3078

unknown's avatar
unknown committed
3079 3080
  @param THD		Thread id
  @param var_list       List of variables to update
unknown's avatar
unknown committed
3081

unknown's avatar
unknown committed
3082
  @retval
unknown's avatar
unknown committed
3083
    0	ok
unknown's avatar
unknown committed
3084
  @retval
3085
    1	ERROR, message sent (normally no variables was updated)
unknown's avatar
unknown committed
3086
  @retval
3087
    -1  ERROR, message not sent
unknown's avatar
unknown committed
3088 3089
*/

3090
int sql_set_variables(THD *thd, List<set_var_base> *var_list)
unknown's avatar
unknown committed
3091
{
unknown's avatar
unknown committed
3092
  int error;
unknown's avatar
unknown committed
3093
  List_iterator_fast<set_var_base> it(*var_list);
unknown's avatar
unknown committed
3094
  DBUG_ENTER("sql_set_variables");
unknown's avatar
unknown committed
3095 3096 3097 3098

  set_var_base *var;
  while ((var=it++))
  {
unknown's avatar
unknown committed
3099
    if ((error= var->check(thd)))
3100
      goto err;
unknown's avatar
unknown committed
3101
  }
3102
  if (!(error= test(thd->is_error())))
3103 3104 3105 3106 3107
  {
    it.rewind();
    while ((var= it++))
      error|= var->update(thd);         // Returns 0, -1 or 1
  }
unknown's avatar
unknown committed
3108

3109 3110
err:
  free_underlaid_joins(thd, &thd->lex->select_lex);
unknown's avatar
unknown committed
3111
  DBUG_RETURN(error);
unknown's avatar
unknown committed
3112 3113 3114
}


unknown's avatar
unknown committed
3115 3116 3117 3118
/**
  Say if all variables set by a SET support the ONE_SHOT keyword
  (currently, only character set and collation do; later timezones
  will).
3119

unknown's avatar
unknown committed
3120
  @param var_list	List of variables to update
3121

unknown's avatar
unknown committed
3122
  @note
3123 3124
    It has a "not_" because it makes faster tests (no need to "!")

unknown's avatar
unknown committed
3125
  @retval
3126
    0	all variables of the list support ONE_SHOT
unknown's avatar
unknown committed
3127
  @retval
3128 3129 3130 3131 3132 3133 3134 3135 3136 3137 3138 3139 3140 3141 3142 3143
    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
3144 3145 3146 3147
/*****************************************************************************
  Functions to handle SET mysql_internal_variable=const_expr
*****************************************************************************/

3148
int set_var::check(THD *thd)
unknown's avatar
unknown committed
3149
{
3150 3151 3152 3153 3154
  if (var->is_readonly())
  {
    my_error(ER_INCORRECT_GLOBAL_LOCAL_VAR, MYF(0), var->name, "read only");
    return -1;
  }
unknown's avatar
unknown committed
3155 3156
  if (var->check_type(type))
  {
unknown's avatar
unknown committed
3157
    int err= type == OPT_GLOBAL ? ER_LOCAL_VARIABLE : ER_GLOBAL_VARIABLE;
3158
    my_error(err, MYF(0), var->name);
3159
    return -1;
unknown's avatar
unknown committed
3160 3161 3162 3163 3164 3165 3166 3167
  }
  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))
    {
3168
      my_error(ER_NO_DEFAULT, MYF(0), var->name);
3169
      return -1;
unknown's avatar
unknown committed
3170 3171 3172 3173
    }
    return 0;
  }

unknown's avatar
unknown committed
3174
  if ((!value->fixed &&
3175
       value->fix_fields(thd, &value)) || value->check_cols(1))
3176
    return -1;
unknown's avatar
unknown committed
3177 3178
  if (var->check_update_type(value->result_type()))
  {
3179
    my_error(ER_WRONG_TYPE_FOR_VAR, MYF(0), var->name);
3180
    return -1;
3181
  }
3182
  return var->check(thd, this) ? -1 : 0;
unknown's avatar
unknown committed
3183 3184 3185
}


unknown's avatar
unknown committed
3186 3187
/**
  Check variable, but without assigning value (used by PS).
unknown's avatar
unknown committed
3188

unknown's avatar
unknown committed
3189
  @param thd		thread handler
unknown's avatar
unknown committed
3190

unknown's avatar
unknown committed
3191
  @retval
unknown's avatar
unknown committed
3192
    0	ok
unknown's avatar
unknown committed
3193
  @retval
unknown's avatar
unknown committed
3194
    1	ERROR, message sent (normally no variables was updated)
unknown's avatar
unknown committed
3195 3196
  @retval
    -1   ERROR, message not sent
unknown's avatar
unknown committed
3197
*/
3198 3199 3200 3201
int set_var::light_check(THD *thd)
{
  if (var->check_type(type))
  {
unknown's avatar
unknown committed
3202
    int err= type == OPT_GLOBAL ? ER_LOCAL_VARIABLE : ER_GLOBAL_VARIABLE;
3203
    my_error(err, MYF(0), var->name);
3204 3205
    return -1;
  }
unknown's avatar
unknown committed
3206
  if (type == OPT_GLOBAL && check_global_access(thd, SUPER_ACL))
3207 3208
    return 1;

3209
  if (value && ((!value->fixed && value->fix_fields(thd, &value)) ||
unknown's avatar
unknown committed
3210
                value->check_cols(1)))
3211 3212 3213 3214 3215
    return -1;
  return 0;
}


3216
int set_var::update(THD *thd)
unknown's avatar
unknown committed
3217 3218 3219 3220
{
  if (!value)
    var->set_default(thd, type);
  else if (var->update(thd, this))
3221
    return -1;				// should never happen
unknown's avatar
unknown committed
3222 3223 3224 3225 3226 3227 3228 3229 3230 3231
  if (var->after_update)
    (*var->after_update)(thd, type);
  return 0;
}


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

3232
int set_var_user::check(THD *thd)
unknown's avatar
unknown committed
3233
{
unknown's avatar
unknown committed
3234 3235
  /*
    Item_func_set_user_var can't substitute something else on its place =>
3236
    0 can be passed as last argument (reference on item)
unknown's avatar
unknown committed
3237
  */
3238
  return (user_var_item->fix_fields(thd, (Item**) 0) ||
3239
	  user_var_item->check(0)) ? -1 : 0;
unknown's avatar
unknown committed
3240 3241 3242
}


unknown's avatar
unknown committed
3243 3244
/**
  Check variable, but without assigning value (used by PS).
unknown's avatar
unknown committed
3245

unknown's avatar
unknown committed
3246
  @param thd		thread handler
unknown's avatar
unknown committed
3247

unknown's avatar
unknown committed
3248
  @retval
unknown's avatar
unknown committed
3249
    0	ok
unknown's avatar
unknown committed
3250
  @retval
unknown's avatar
unknown committed
3251
    1	ERROR, message sent (normally no variables was updated)
unknown's avatar
unknown committed
3252 3253
  @retval
    -1   ERROR, message not sent
unknown's avatar
unknown committed
3254
*/
3255 3256 3257 3258 3259 3260
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)
  */
3261
  return (user_var_item->fix_fields(thd, (Item**) 0));
3262 3263 3264
}


3265
int set_var_user::update(THD *thd)
unknown's avatar
unknown committed
3266 3267 3268 3269
{
  if (user_var_item->update())
  {
    /* Give an error if it's not given already */
unknown's avatar
unknown committed
3270
    my_message(ER_SET_CONSTANTS_ONLY, ER(ER_SET_CONSTANTS_ONLY), MYF(0));
3271
    return -1;
unknown's avatar
unknown committed
3272 3273 3274 3275 3276 3277 3278 3279 3280
  }
  return 0;
}


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

3281
int set_var_password::check(THD *thd)
unknown's avatar
unknown committed
3282
{
unknown's avatar
unknown committed
3283
#ifndef NO_EMBEDDED_ACCESS_CHECKS
unknown's avatar
unknown committed
3284
  if (!user->host.str)
3285
  {
3286
    if (*thd->security_ctx->priv_host != 0)
3287
    {
3288 3289
      user->host.str= (char *) thd->security_ctx->priv_host;
      user->host.length= strlen(thd->security_ctx->priv_host);
3290 3291 3292 3293 3294 3295 3296
    }
    else
    {
      user->host.str= (char *)"%";
      user->host.length= 1;
    }
  }
3297
  /* Returns 1 as the function sends error to client */
3298 3299
  return check_change_password(thd, user->host.str, user->user.str,
                               password, strlen(password)) ? 1 : 0;
3300
#else
unknown's avatar
unknown committed
3301 3302
  return 0;
#endif
unknown's avatar
unknown committed
3303 3304
}

3305
int set_var_password::update(THD *thd)
unknown's avatar
unknown committed
3306
{
unknown's avatar
unknown committed
3307
#ifndef NO_EMBEDDED_ACCESS_CHECKS
3308
  /* Returns 1 as the function sends error to client */
3309 3310
  return change_password(thd, user->host.str, user->user.str, password) ?
	  1 : 0;
unknown's avatar
unknown committed
3311 3312 3313
#else
  return 0;
#endif
unknown's avatar
unknown committed
3314 3315
}

3316 3317 3318 3319
/****************************************************************************
 Functions to handle table_type
****************************************************************************/

unknown's avatar
unknown committed
3320 3321
/* Based upon sys_var::check_enum() */

unknown's avatar
unknown committed
3322
bool sys_var_thd_storage_engine::check(THD *thd, set_var *var)
3323
{
unknown's avatar
unknown committed
3324
  char buff[STRING_BUFFER_USUAL_SIZE];
3325 3326 3327
  const char *value;
  String str(buff, sizeof(buff), &my_charset_latin1), *res;

unknown's avatar
unknown committed
3328
  var->save_result.plugin= NULL;
3329 3330
  if (var->value->result_type() == STRING_RESULT)
  {
3331
    LEX_STRING engine_name;
unknown's avatar
unknown committed
3332
    handlerton *hton;
3333
    if (!(res=var->value->val_str(&str)) ||
3334 3335 3336
        !(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
3337 3338
        !(hton= plugin_data(var->save_result.plugin, handlerton *)) ||
        ha_checktype(thd, ha_legacy_type(hton), 1, 0) != hton)
3339 3340 3341 3342 3343 3344
    {
      value= res ? res->c_ptr() : "NULL";
      goto err;
    }
    return 0;
  }
unknown's avatar
unknown committed
3345
  value= "unknown";
3346 3347

err:
3348
  my_error(ER_UNKNOWN_STORAGE_ENGINE, MYF(0), value);
unknown's avatar
unknown committed
3349
  return 1;
3350 3351
}

unknown's avatar
unknown committed
3352

3353
uchar *sys_var_thd_storage_engine::value_ptr(THD *thd, enum_var_type type,
unknown's avatar
unknown committed
3354
					    LEX_STRING *base)
3355
{
3356
  uchar* result;
unknown's avatar
unknown committed
3357
  handlerton *hton;
3358
  LEX_STRING *engine_name;
unknown's avatar
unknown committed
3359 3360 3361 3362
  plugin_ref plugin= thd->variables.*offset;
  if (type == OPT_GLOBAL)
    plugin= my_plugin_lock(thd, &(global_system_variables.*offset));
  hton= plugin_data(plugin, handlerton*);
3363 3364
  engine_name= &hton2plugin[hton->slot]->name;
  result= (uchar *) thd->strmake(engine_name->str, engine_name->length);
unknown's avatar
unknown committed
3365 3366 3367
  if (type == OPT_GLOBAL)
    plugin_unlock(thd, plugin);
  return result;
3368 3369
}

unknown's avatar
unknown committed
3370

unknown's avatar
unknown committed
3371
void sys_var_thd_storage_engine::set_default(THD *thd, enum_var_type type)
3372
{
unknown's avatar
unknown committed
3373
  plugin_ref old_value, new_value, *value;
3374
  if (type == OPT_GLOBAL)
unknown's avatar
unknown committed
3375 3376 3377 3378
  {
    value= &(global_system_variables.*offset);
    new_value= ha_lock_engine(NULL, myisam_hton);
  }
3379
  else
unknown's avatar
unknown committed
3380 3381 3382 3383 3384 3385 3386 3387
  {
    value= &(thd->variables.*offset);
    new_value= my_plugin_lock(NULL, &(global_system_variables.*offset));
  }
  DBUG_ASSERT(new_value);
  old_value= *value;
  *value= new_value;
  plugin_unlock(NULL, old_value);
3388 3389
}

unknown's avatar
unknown committed
3390

unknown's avatar
unknown committed
3391
bool sys_var_thd_storage_engine::update(THD *thd, set_var *var)
3392
{
unknown's avatar
unknown committed
3393 3394 3395 3396 3397 3398 3399 3400 3401
  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)
  {
    *value= my_plugin_lock(NULL, &var->save_result.plugin);
    plugin_unlock(NULL, old_value);
  }
3402 3403 3404
  return 0;
}

unknown's avatar
unknown committed
3405 3406
void sys_var_thd_table_type::warn_deprecated(THD *thd)
{
3407
  WARN_DEPRECATED(thd, "5.2", "table_type", "'storage_engine'");
unknown's avatar
unknown committed
3408 3409 3410 3411 3412 3413 3414 3415 3416 3417 3418 3419 3420 3421
}

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
3422

3423 3424 3425
/****************************************************************************
 Functions to handle sql_mode
****************************************************************************/
3426

unknown's avatar
unknown committed
3427 3428
/**
  Make string representation of mode.
3429

unknown's avatar
unknown committed
3430 3431 3432 3433 3434 3435
  @param[in]  thd    thread handler
  @param[in]  val    sql_mode value
  @param[out] len    pointer on length of string

  @return
    pointer to string with sql_mode representation
3436 3437
*/

3438 3439 3440
bool
sys_var_thd_sql_mode::
symbolic_mode_representation(THD *thd, ulonglong val, LEX_STRING *rep)
3441
{
3442
  char buff[STRING_BUFFER_USUAL_SIZE*8];
3443 3444 3445
  String tmp(buff, sizeof(buff), &my_charset_latin1);

  tmp.length(0);
3446

3447 3448 3449 3450
  for (uint i= 0; val; val>>= 1, i++)
  {
    if (val & 1)
    {
3451 3452
      tmp.append(sql_mode_typelib.type_names[i],
                 sql_mode_typelib.type_lengths[i]);
3453 3454 3455
      tmp.append(',');
    }
  }
unknown's avatar
unknown committed
3456

3457 3458 3459 3460 3461 3462 3463 3464
  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();
3465 3466
}

unknown's avatar
unknown committed
3467

3468
uchar *sys_var_thd_sql_mode::value_ptr(THD *thd, enum_var_type type,
3469 3470
				      LEX_STRING *base)
{
3471
  LEX_STRING sql_mode;
3472 3473
  ulonglong val= ((type == OPT_GLOBAL) ? global_system_variables.*offset :
                  thd->variables.*offset);
3474
  (void) symbolic_mode_representation(thd, val, &sql_mode);
3475
  return (uchar *) sql_mode.str;
3476 3477 3478 3479 3480 3481 3482 3483 3484 3485 3486
}


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

unknown's avatar
unknown committed
3487

3488 3489 3490 3491 3492 3493
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
3494
  {
3495
    thd->variables.sql_mode= fix_sql_mode(thd->variables.sql_mode);
3496 3497 3498 3499 3500 3501 3502 3503
    /*
      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;
  }
3504 3505
}

unknown's avatar
unknown committed
3506
/** Map database specific bits to function bits. */
3507

3508 3509 3510 3511 3512 3513 3514 3515 3516
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)
3517
  {
3518
    sql_mode|= (MODE_REAL_AS_FLOAT | MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
3519 3520 3521 3522 3523 3524
		MODE_IGNORE_SPACE);
    /* 
      MODE_ONLY_FULL_GROUP_BY removed from ANSI mode because it is currently
      overly restrictive (see BUG#8510).
    */
  }
3525 3526 3527 3528
  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 |
3529
		MODE_NO_FIELD_OPTIONS | MODE_NO_AUTO_CREATE_USER);
3530 3531 3532 3533 3534 3535 3536 3537 3538 3539 3540 3541 3542 3543 3544
  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);
3545
  if (sql_mode & MODE_MAXDB)
3546 3547 3548
    sql_mode|= (MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE |
		MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS |
3549
		MODE_NO_FIELD_OPTIONS | MODE_NO_AUTO_CREATE_USER);
3550
  if (sql_mode & MODE_MYSQL40)
3551
    sql_mode|= MODE_HIGH_NOT_PRECEDENCE;
3552
  if (sql_mode & MODE_MYSQL323)
3553
    sql_mode|= MODE_HIGH_NOT_PRECEDENCE;
unknown's avatar
unknown committed
3554 3555 3556
  if (sql_mode & MODE_TRADITIONAL)
    sql_mode|= (MODE_STRICT_TRANS_TABLES | MODE_STRICT_ALL_TABLES |
                MODE_NO_ZERO_IN_DATE | MODE_NO_ZERO_DATE |
3557
                MODE_ERROR_FOR_DIVISION_BY_ZERO | MODE_NO_AUTO_CREATE_USER);
3558 3559
  return sql_mode;
}
3560 3561


3562 3563 3564 3565
/****************************************************************************
  Named list handling
****************************************************************************/

3566
uchar* find_named(I_List<NAMED_LIST> *list, const char *name, uint length,
unknown's avatar
unknown committed
3567
		NAMED_LIST **found)
3568 3569 3570 3571 3572 3573
{
  I_List_iterator<NAMED_LIST> it(*list);
  NAMED_LIST *element;
  while ((element= it++))
  {
    if (element->cmp(name, length))
unknown's avatar
unknown committed
3574
    {
3575 3576
      if (found)
        *found= element;
3577
      return element->data;
unknown's avatar
unknown committed
3578
    }
3579 3580 3581 3582 3583
  }
  return 0;
}


3584
void delete_elements(I_List<NAMED_LIST> *list,
3585
		     void (*free_element)(const char *name, uchar*))
3586 3587
{
  NAMED_LIST *element;
unknown's avatar
unknown committed
3588
  DBUG_ENTER("delete_elements");
3589 3590
  while ((element= list->get()))
  {
3591
    (*free_element)(element->name, element->data);
3592 3593
    delete element;
  }
unknown's avatar
unknown committed
3594
  DBUG_VOID_RETURN;
3595 3596 3597 3598 3599
}


/* Key cache functions */

unknown's avatar
unknown committed
3600
static KEY_CACHE *create_key_cache(const char *name, uint length)
3601
{
unknown's avatar
unknown committed
3602
  KEY_CACHE *key_cache;
3603 3604 3605
  DBUG_ENTER("create_key_cache");
  DBUG_PRINT("enter",("name: %.*s", length, name));
  
unknown's avatar
unknown committed
3606
  if ((key_cache= (KEY_CACHE*) my_malloc(sizeof(KEY_CACHE),
3607
					     MYF(MY_ZEROFILL | MY_WME))))
unknown's avatar
unknown committed
3608
  {
3609
    if (!new NAMED_LIST(&key_caches, name, length, (uchar*) key_cache))
3610 3611
    {
      my_free((char*) key_cache, MYF(0));
unknown's avatar
unknown committed
3612
      key_cache= 0;
3613 3614 3615 3616 3617 3618 3619 3620 3621
    }
    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
3622 3623 3624
      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;
3625
    }
unknown's avatar
unknown committed
3626
  }
3627
  DBUG_RETURN(key_cache);
3628 3629 3630
}


unknown's avatar
unknown committed
3631
KEY_CACHE *get_or_create_key_cache(const char *name, uint length)
3632
{
unknown's avatar
unknown committed
3633
  LEX_STRING key_cache_name;
unknown's avatar
unknown committed
3634
  KEY_CACHE *key_cache;
3635

unknown's avatar
unknown committed
3636 3637
  key_cache_name.str= (char *) name;
  key_cache_name.length= length;
3638 3639
  pthread_mutex_lock(&LOCK_global_system_variables);
  if (!(key_cache= get_key_cache(&key_cache_name)))
3640
    key_cache= create_key_cache(name, length);
3641
  pthread_mutex_unlock(&LOCK_global_system_variables);
3642 3643 3644 3645
  return key_cache;
}


unknown's avatar
unknown committed
3646
void free_key_cache(const char *name, KEY_CACHE *key_cache)
3647
{
3648 3649
  ha_end_key_cache(key_cache);
  my_free((char*) key_cache, MYF(0));
unknown's avatar
unknown committed
3650 3651 3652
}


3653
bool process_key_caches(process_key_cache_t func)
3654
{
unknown's avatar
unknown committed
3655 3656
  I_List_iterator<NAMED_LIST> it(key_caches);
  NAMED_LIST *element;
3657

unknown's avatar
unknown committed
3658 3659
  while ((element= it++))
  {
unknown's avatar
unknown committed
3660
    KEY_CACHE *key_cache= (KEY_CACHE *) element->data;
3661
    func(element->name, key_cache);
unknown's avatar
unknown committed
3662 3663
  }
  return 0;
3664 3665
}

3666

3667 3668
void sys_var_trust_routine_creators::warn_deprecated(THD *thd)
{
3669 3670
  WARN_DEPRECATED(thd, "5.2", "log_bin_trust_routine_creators",
                      "'log_bin_trust_function_creators'");
3671 3672 3673 3674 3675 3676 3677 3678 3679 3680 3681 3682 3683 3684
}

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
3685 3686 3687 3688 3689 3690 3691 3692 3693 3694 3695 3696 3697 3698 3699 3700 3701 3702 3703 3704 3705 3706 3707 3708 3709 3710 3711 3712 3713 3714 3715 3716 3717 3718 3719 3720 3721 3722 3723 3724 3725 3726 3727 3728 3729 3730 3731 3732
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.
  */
3733
  if (result= close_cached_tables(thd, true, NULL, false))
unknown's avatar
unknown committed
3734 3735 3736 3737 3738 3739 3740 3741 3742 3743 3744 3745 3746 3747 3748
    goto end_with_read_lock;

  if (result= make_global_read_lock_block_commit(thd))
    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);
}


unknown's avatar
unknown committed
3749 3750 3751 3752 3753 3754 3755 3756 3757 3758 3759 3760 3761 3762 3763 3764 3765 3766
/* 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)
{
  if (var->type == OPT_GLOBAL)
    DBUG_SET_INITIAL(var ? var->value->str_value.c_ptr() : "");
  else
  {
    DBUG_POP();
    DBUG_PUSH(var ? var->value->str_value.c_ptr() : "");
  }
  return 0;
}

3767

3768
uchar *sys_var_thd_dbug::value_ptr(THD *thd, enum_var_type type, LEX_STRING *b)
unknown's avatar
unknown committed
3769 3770 3771 3772 3773 3774
{
  char buf[256];
  if (type == OPT_GLOBAL)
    DBUG_EXPLAIN_INITIAL(buf, sizeof(buf));
  else
    DBUG_EXPLAIN(buf, sizeof(buf));
3775
  return (uchar*) thd->strdup(buf);
unknown's avatar
unknown committed
3776
}
unknown's avatar
unknown committed
3777

3778

3779 3780 3781 3782 3783 3784
bool sys_var_event_scheduler::check(THD *thd, set_var *var)
{
  return check_enum(thd, var, &Events::var_typelib);
}


3785 3786 3787 3788 3789 3790 3791 3792 3793 3794 3795 3796 3797 3798 3799 3800 3801 3802
/*
   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
3803
  int res;
3804 3805
  /* here start the thread if not running. */
  DBUG_ENTER("sys_var_event_scheduler::update");
unknown's avatar
unknown committed
3806
  DBUG_PRINT("info", ("new_value: %d", (int) var->save_result.ulong_value));
3807

3808 3809 3810 3811
  enum Events::enum_opt_event_scheduler
    new_state=
    (enum Events::enum_opt_event_scheduler) var->save_result.ulong_value;

3812
  res= Events::switch_event_scheduler_state(new_state);
3813 3814 3815 3816 3817

  DBUG_RETURN((bool) res);
}


3818
uchar *sys_var_event_scheduler::value_ptr(THD *thd, enum_var_type type,
3819 3820
                                         LEX_STRING *base)
{
3821
  return (uchar *) Events::get_opt_event_scheduler_str();
3822 3823 3824
}


unknown's avatar
unknown committed
3825 3826 3827 3828
/****************************************************************************
  Used templates
****************************************************************************/

3829
#ifdef HAVE_EXPLICIT_TEMPLATE_INSTANTIATION
unknown's avatar
unknown committed
3830
template class List<set_var_base>;
unknown's avatar
unknown committed
3831
template class List_iterator_fast<set_var_base>;
3832
template class I_List_iterator<NAMED_LIST>;
unknown's avatar
unknown committed
3833
#endif