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

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

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

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

/*
  Handling of MySQL SQL variables

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

  - Use one of the 'sys_var... classes from set_var.h or write a specific
    one for the variable type.
  - Define it in the 'variable definition list' in this file.
25 26
  - If the variable should be changeable or one should be able to access it
    with @@variable_name, it should be added to the 'list of all variables'
27 28 29
    list (sys_variables) in this file.
  - If the variable is thread specific, add it to 'system_variables' struct.
    If not, add it to mysqld.cc and an declaration in 'mysql_priv.h'
30
  - If the variable should be changed from the command line, add a definition
ingo@mysql.com's avatar
ingo@mysql.com 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!
34 35 36
  - If the variable should show up in 'show variables' add it to the
    init_vars[] struct in this file

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

43 44 45 46 47 48 49 50
  TODO:
    - Add full support for the variable character_set (for 4.1)

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

51
#ifdef USE_PRAGMA_IMPLEMENTATION
52 53 54 55
#pragma implementation				// gcc: Class implementation
#endif

#include "mysql_priv.h"
56
#include <mysql.h>
57 58
#include "slave.h"
#include <my_getopt.h>
59
#include <thr_alarm.h>
60
#include <myisam.h>
61 62 63

/* WITH_BERKELEY_STORAGE_ENGINE */
extern bool berkeley_shared_data;
64 65 66
extern ulong berkeley_max_lock, berkeley_log_buffer_size;
extern ulonglong berkeley_cache_size;
extern ulong berkeley_region_size, berkeley_cache_parts;
67 68 69 70 71 72
extern char *berkeley_home, *berkeley_tmpdir, *berkeley_logdir;

/* WITH_INNOBASE_STORAGE_ENGINE */
extern uint innobase_flush_log_at_trx_commit;
extern ulong innobase_fast_shutdown;
extern long innobase_mirrored_log_groups, innobase_log_files_in_group;
kent@mysql.com's avatar
kent@mysql.com committed
73 74 75 76
extern longlong innobase_log_file_size;
extern long innobase_log_buffer_size;
extern longlong innobase_buffer_pool_size;
extern long innobase_additional_mem_pool_size;
77 78 79 80 81 82 83 84 85 86 87 88 89 90
extern long innobase_buffer_pool_awe_mem_mb;
extern long innobase_file_io_threads, innobase_lock_wait_timeout;
extern long innobase_force_recovery;
extern long innobase_open_files;
extern char *innobase_data_home_dir, *innobase_data_file_path;
extern char *innobase_log_group_home_dir, *innobase_log_arch_dir;
extern char *innobase_unix_file_flush_method;
/* The following variables have to be my_bool for SHOW VARIABLES to work */
extern my_bool innobase_log_archive,
               innobase_use_doublewrite,
               innobase_use_checksums,
               innobase_file_per_table,
               innobase_locks_unsafe_for_binlog;

91
extern "C" {
92 93 94 95 96 97 98 99
extern ulong srv_max_buf_pool_modified_pct;
extern ulong srv_max_purge_lag;
extern ulong srv_auto_extend_increment;
extern ulong srv_n_spin_wait_rounds;
extern ulong srv_n_free_tickets_to_enter;
extern ulong srv_thread_sleep_delay;
extern ulong srv_thread_concurrency;
extern ulong srv_commit_concurrency;
100
}
101 102 103

/* WITH_NDBCLUSTER_STORAGE_ENGINE */
extern ulong ndb_cache_check_time;
tomas@poseidon.ndb.mysql.com's avatar
tomas@poseidon.ndb.mysql.com committed
104 105 106 107 108
extern ulong ndb_extra_logging;
#ifdef HAVE_NDB_BINLOG
extern ulong ndb_report_thresh_binlog_epoch_slip;
extern ulong ndb_report_thresh_binlog_mem_usage;
#endif
109 110 111



112
extern my_bool event_executor_running_global_var;
113 114 115 116 117

static HASH system_variable_hash;
const char *bool_type_names[]= { "OFF", "ON", NullS };
TYPELIB bool_typelib=
{
118
  array_elements(bool_type_names)-1, "", bool_type_names, NULL
119 120
};

121 122 123
const char *delay_key_write_type_names[]= { "OFF", "ON", "ALL", NullS };
TYPELIB delay_key_write_typelib=
{
124 125
  array_elements(delay_key_write_type_names)-1, "",
  delay_key_write_type_names, NULL
126 127
};

128
static int sys_check_charset(THD *thd, set_var *var);
129 130
static bool sys_update_charset(THD *thd, set_var *var);
static void sys_set_default_charset(THD *thd, enum_var_type type);
131 132 133
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);
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
134 135 136 137
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);
138 139
static bool set_option_bit(THD *thd, set_var *var);
static bool set_option_autocommit(THD *thd, set_var *var);
140
static int  check_log_update(THD *thd, set_var *var);
141
static bool set_log_update(THD *thd, set_var *var);
142
static int  check_pseudo_thread_id(THD *thd, set_var *var);
143
static bool set_log_bin(THD *thd, set_var *var);
144 145
static void fix_low_priority_updates(THD *thd, enum_var_type type);
static void fix_tx_isolation(THD *thd, enum_var_type type);
146 147
static int check_completion_type(THD *thd, set_var *var);
static void fix_completion_type(THD *thd, enum_var_type type);
148 149
static void fix_net_read_timeout(THD *thd, enum_var_type type);
static void fix_net_write_timeout(THD *thd, enum_var_type type);
150
static void fix_net_retry_count(THD *thd, enum_var_type type);
151 152
static void fix_max_join_size(THD *thd, enum_var_type type);
static void fix_query_cache_size(THD *thd, enum_var_type type);
153
static void fix_query_cache_min_res_unit(THD *thd, enum_var_type type);
154
static void fix_myisam_max_sort_file_size(THD *thd, enum_var_type type);
155 156
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);
157
static void fix_max_connections(THD *thd, enum_var_type type);
158
static int check_max_delayed_threads(THD *thd, set_var *var);
159 160
static void fix_thd_mem_root(THD *thd, enum_var_type type);
static void fix_trans_mem_root(THD *thd, enum_var_type type);
161
static void fix_server_id(THD *thd, enum_var_type type);
162
static KEY_CACHE *create_key_cache(const char *name, uint length);
163
void fix_sql_mode_var(THD *thd, enum_var_type type);
164 165
static byte *get_error_count(THD *thd);
static byte *get_warning_count(THD *thd);
166 167 168 169 170 171 172 173

/*
  Variable definition list

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

174 175 176
sys_var *sys_var::first= NULL;
uint sys_var::sys_vars= 0;

177 178 179 180 181
sys_var_thd_ulong	sys_auto_increment_increment("auto_increment_increment",
                                                     &SV::auto_increment_increment);
sys_var_thd_ulong	sys_auto_increment_offset("auto_increment_offset",
                                                  &SV::auto_increment_offset);

182 183 184
sys_var_bool_ptr	sys_automatic_sp_privileges("automatic_sp_privileges",
					      &sp_automatic_privileges);

185 186 187 188
sys_var_long_ptr	sys_binlog_cache_size("binlog_cache_size",
					      &binlog_cache_size);
sys_var_thd_ulong	sys_bulk_insert_buff_size("bulk_insert_buffer_size",
						  &SV::bulk_insert_buff_size);
189
sys_var_character_set_server	sys_character_set_server("character_set_server");
190 191
sys_var_const_str       sys_charset_system("character_set_system",
                                           (char *)my_charset_utf8_general_ci.name);
192
sys_var_character_set_database	sys_character_set_database("character_set_database");
193
sys_var_character_set_client  sys_character_set_client("character_set_client");
194
sys_var_character_set_connection  sys_character_set_connection("character_set_connection");
195
sys_var_character_set_results sys_character_set_results("character_set_results");
196
sys_var_character_set_filesystem  sys_character_set_filesystem("character_set_filesystem");
197 198 199 200
sys_var_thd_ulong	sys_completion_type("completion_type",
					 &SV::completion_type,
					 check_completion_type,
					 fix_completion_type);
201
sys_var_collation_connection sys_collation_connection("collation_connection");
202 203
sys_var_collation_database sys_collation_database("collation_database");
sys_var_collation_server sys_collation_server("collation_server");
204 205
sys_var_long_ptr	sys_concurrent_insert("concurrent_insert",
                                              &myisam_concurrent_insert);
206 207
sys_var_long_ptr	sys_connect_timeout("connect_timeout",
					    &connect_timeout);
208 209 210 211
sys_var_enum		sys_delay_key_write("delay_key_write",
					    &delay_key_write_options,
					    &delay_key_write_typelib,
					    fix_delay_key_write);
212 213 214 215 216 217
sys_var_long_ptr	sys_delayed_insert_limit("delayed_insert_limit",
						 &delayed_insert_limit);
sys_var_long_ptr	sys_delayed_insert_timeout("delayed_insert_timeout",
						   &delayed_insert_timeout);
sys_var_long_ptr	sys_delayed_queue_size("delayed_queue_size",
					       &delayed_queue_size);
andrey@lmy004's avatar
andrey@lmy004 committed
218
sys_var_event_executor        sys_event_executor("event_scheduler",
219
                                               &event_executor_running_global_var);
220 221
sys_var_long_ptr	sys_expire_logs_days("expire_logs_days",
					     &expire_logs_days);
222 223
sys_var_bool_ptr	sys_flush("flush", &myisam_flush);
sys_var_long_ptr	sys_flush_time("flush_time", &flush_time);
224 225 226 227 228 229 230 231 232 233 234
sys_var_str             sys_ft_boolean_syntax("ft_boolean_syntax",
                                         sys_check_ftb_syntax,
                                         sys_update_ftb_syntax,
                                         sys_default_ftb_syntax,
                                         ft_boolean_syntax);
sys_var_str             sys_init_connect("init_connect", 0,
                                         sys_update_init_connect,
                                         sys_default_init_connect,0);
sys_var_str             sys_init_slave("init_slave", 0,
                                       sys_update_init_slave,
                                       sys_default_init_slave,0);
235 236 237 238
sys_var_thd_ulong	sys_interactive_timeout("interactive_timeout",
						&SV::net_interactive_timeout);
sys_var_thd_ulong	sys_join_buffer_size("join_buffer_size",
					     &SV::join_buff_size);
239
sys_var_key_buffer_size	sys_key_buffer_size("key_buffer_size");
240
sys_var_key_cache_long  sys_key_cache_block_size("key_cache_block_size",
241 242
						 offsetof(KEY_CACHE,
							  param_block_size));
243
sys_var_key_cache_long	sys_key_cache_division_limit("key_cache_division_limit",
244 245
						     offsetof(KEY_CACHE,
							      param_division_limit));
246
sys_var_key_cache_long  sys_key_cache_age_threshold("key_cache_age_threshold",
247 248
						     offsetof(KEY_CACHE,
							      param_age_threshold));
249 250
sys_var_bool_ptr	sys_local_infile("local_infile",
					 &opt_local_infile);
251
sys_var_trust_routine_creators
252
sys_trust_routine_creators("log_bin_trust_routine_creators",
253 254 255 256
                           &trust_function_creators);
sys_var_bool_ptr       
sys_trust_function_creators("log_bin_trust_function_creators",
                            &trust_function_creators);
257
sys_var_thd_ulong	sys_log_warnings("log_warnings", &SV::log_warnings);
258 259 260 261 262 263 264 265 266 267 268 269 270 271 272
sys_var_thd_ulong	sys_long_query_time("long_query_time",
					     &SV::long_query_time);
sys_var_thd_bool	sys_low_priority_updates("low_priority_updates",
						 &SV::low_priority_updates,
						 fix_low_priority_updates);
#ifndef TO_BE_DELETED	/* Alias for the low_priority_updates */
sys_var_thd_bool	sys_sql_low_priority_updates("sql_low_priority_updates",
						     &SV::low_priority_updates,
						     fix_low_priority_updates);
#endif
sys_var_thd_ulong	sys_max_allowed_packet("max_allowed_packet",
					       &SV::max_allowed_packet);
sys_var_long_ptr	sys_max_binlog_cache_size("max_binlog_cache_size",
						  &max_binlog_cache_size);
sys_var_long_ptr	sys_max_binlog_size("max_binlog_size",
273 274
					    &max_binlog_size,
                                            fix_max_binlog_size);
275
sys_var_long_ptr	sys_max_connections("max_connections",
276 277
					    &max_connections,
                                            fix_max_connections);
278 279
sys_var_long_ptr	sys_max_connect_errors("max_connect_errors",
					       &max_connect_errors);
280
sys_var_thd_ulong       sys_max_insert_delayed_threads("max_insert_delayed_threads",
281 282 283
						       &SV::max_insert_delayed_threads,
                                                       check_max_delayed_threads,
                                                       fix_max_connections);
284 285
sys_var_thd_ulong	sys_max_delayed_threads("max_delayed_threads",
						&SV::max_insert_delayed_threads,
286 287
                                                check_max_delayed_threads,
                                                fix_max_connections);
288 289
sys_var_thd_ulong	sys_max_error_count("max_error_count",
					    &SV::max_error_count);
290 291
sys_var_thd_ulong	sys_max_heap_table_size("max_heap_table_size",
						&SV::max_heap_table_size);
292 293 294
sys_var_thd_ulong       sys_pseudo_thread_id("pseudo_thread_id",
					     &SV::pseudo_thread_id,
                                             check_pseudo_thread_id, 0);
295
sys_var_thd_ha_rows	sys_max_join_size("max_join_size",
296 297
					  &SV::max_join_size,
					  fix_max_join_size);
298 299
sys_var_thd_ulong	sys_max_seeks_for_key("max_seeks_for_key",
					      &SV::max_seeks_for_key);
igor@hundin.mysql.fi's avatar
igor@hundin.mysql.fi committed
300
sys_var_thd_ulong   sys_max_length_for_sort_data("max_length_for_sort_data",
301
                                                 &SV::max_length_for_sort_data);
302
#ifndef TO_BE_DELETED	/* Alias for max_join_size */
303
sys_var_thd_ha_rows	sys_sql_max_join_size("sql_max_join_size",
304 305 306
					      &SV::max_join_size,
					      fix_max_join_size);
#endif
307 308 309
sys_var_long_ptr	sys_max_relay_log_size("max_relay_log_size",
                                               &max_relay_log_size,
                                               fix_max_relay_log_size);
310 311
sys_var_thd_ulong	sys_max_sort_length("max_sort_length",
					    &SV::max_sort_length);
312 313
sys_var_thd_ulong	sys_max_sp_recursion_depth("max_sp_recursion_depth",
                                                   &SV::max_sp_recursion_depth);
314
sys_var_max_user_conn   sys_max_user_connections("max_user_connections");
315 316 317 318
sys_var_thd_ulong	sys_max_tmp_tables("max_tmp_tables",
					   &SV::max_tmp_tables);
sys_var_long_ptr	sys_max_write_lock_count("max_write_lock_count",
						 &max_write_lock_count);
ingo@mysql.com's avatar
ingo@mysql.com committed
319 320
sys_var_thd_ulong       sys_multi_range_count("multi_range_count",
                                              &SV::multi_range_count);
serg@serg.mylan's avatar
serg@serg.mylan committed
321 322
sys_var_long_ptr	sys_myisam_data_pointer_size("myisam_data_pointer_size",
                                                    &myisam_data_pointer_size);
323
sys_var_thd_ulonglong	sys_myisam_max_sort_file_size("myisam_max_sort_file_size", &SV::myisam_max_sort_file_size, fix_myisam_max_sort_file_size, 1);
324
sys_var_thd_ulong       sys_myisam_repair_threads("myisam_repair_threads", &SV::myisam_repair_threads);
325
sys_var_thd_ulong	sys_myisam_sort_buffer_size("myisam_sort_buffer_size", &SV::myisam_sort_buff_size);
vtkachenko@quadxeon.mysql.com's avatar
vtkachenko@quadxeon.mysql.com committed
326 327
sys_var_bool_ptr	sys_myisam_use_mmap("myisam_use_mmap", 
                                            &opt_myisam_use_mmap);
328 329 330 331 332 333

sys_var_thd_enum        sys_myisam_stats_method("myisam_stats_method",
                                                &SV::myisam_stats_method,
                                                &myisam_stats_method_typelib,
                                                NULL);

334 335 336 337
sys_var_thd_ulong	sys_net_buffer_length("net_buffer_length",
					      &SV::net_buffer_length);
sys_var_thd_ulong	sys_net_read_timeout("net_read_timeout",
					     &SV::net_read_timeout,
338
					     0, fix_net_read_timeout);
339 340
sys_var_thd_ulong	sys_net_write_timeout("net_write_timeout",
					      &SV::net_write_timeout,
341
					      0, fix_net_write_timeout);
342 343
sys_var_thd_ulong	sys_net_retry_count("net_retry_count",
					    &SV::net_retry_count,
344
					    0, fix_net_retry_count);
345
sys_var_thd_bool	sys_new_mode("new", &SV::new_mode);
346 347
sys_var_thd_bool	sys_old_alter_table("old_alter_table",
					    &SV::old_alter_table);
348
sys_var_thd_bool	sys_old_passwords("old_passwords", &SV::old_passwords);
349 350 351 352
sys_var_thd_ulong       sys_optimizer_prune_level("optimizer_prune_level",
                                                  &SV::optimizer_prune_level);
sys_var_thd_ulong       sys_optimizer_search_depth("optimizer_search_depth",
                                                   &SV::optimizer_search_depth);
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
353 354
sys_var_thd_ulong       sys_preload_buff_size("preload_buffer_size",
                                              &SV::preload_buff_size);
355 356
sys_var_thd_ulong	sys_read_buff_size("read_buffer_size",
					   &SV::read_buff_size);
357
sys_var_bool_ptr	sys_readonly("read_only", &opt_readonly);
358 359
sys_var_thd_ulong	sys_read_rnd_buff_size("read_rnd_buffer_size",
					       &SV::read_rnd_buff_size);
360 361
sys_var_thd_ulong	sys_div_precincrement("div_precision_increment",
                                              &SV::div_precincrement);
362 363 364 365
#ifdef HAVE_REPLICATION
sys_var_bool_ptr	sys_relay_log_purge("relay_log_purge",
                                            &relay_log_purge);
#endif
366 367 368 369 370
sys_var_long_ptr	sys_rpl_recovery_rank("rpl_recovery_rank",
					      &rpl_recovery_rank);
sys_var_long_ptr	sys_query_cache_size("query_cache_size",
					     &query_cache_size,
					     fix_query_cache_size);
371 372 373 374

sys_var_thd_ulong	sys_range_alloc_block_size("range_alloc_block_size",
						   &SV::range_alloc_block_size);
sys_var_thd_ulong	sys_query_alloc_block_size("query_alloc_block_size",
375 376
						   &SV::query_alloc_block_size,
						   0, fix_thd_mem_root);
377
sys_var_thd_ulong	sys_query_prealloc_size("query_prealloc_size",
378 379
						&SV::query_prealloc_size,
						0, fix_thd_mem_root);
380
sys_var_thd_ulong	sys_trans_alloc_block_size("transaction_alloc_block_size",
381 382
						   &SV::trans_alloc_block_size,
						   0, fix_trans_mem_root);
383
sys_var_thd_ulong	sys_trans_prealloc_size("transaction_prealloc_size",
384 385
						&SV::trans_prealloc_size,
						0, fix_trans_mem_root);
386

387 388 389
#ifdef HAVE_QUERY_CACHE
sys_var_long_ptr	sys_query_cache_limit("query_cache_limit",
					      &query_cache.query_cache_limit);
390 391 392
sys_var_long_ptr        sys_query_cache_min_res_unit("query_cache_min_res_unit",
						     &query_cache_min_res_unit,
						     fix_query_cache_min_res_unit);
393 394 395
sys_var_thd_enum	sys_query_cache_type("query_cache_type",
					     &SV::query_cache_type,
					     &query_cache_type_typelib);
396 397 398
sys_var_thd_bool
sys_query_cache_wlock_invalidate("query_cache_wlock_invalidate",
				 &SV::query_cache_wlock_invalidate);
399
#endif /* HAVE_QUERY_CACHE */
400
sys_var_bool_ptr	sys_secure_auth("secure_auth", &opt_secure_auth);
401
sys_var_long_ptr	sys_server_id("server_id", &server_id, fix_server_id);
402 403
sys_var_bool_ptr	sys_slave_compressed_protocol("slave_compressed_protocol",
						      &opt_slave_compressed_protocol);
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
404
#ifdef HAVE_REPLICATION
405 406
sys_var_long_ptr	sys_slave_net_timeout("slave_net_timeout",
					      &slave_net_timeout);
407 408
sys_var_long_ptr	sys_slave_trans_retries("slave_transaction_retries",
                                                &slave_trans_retries);
409
#endif
410 411 412 413
sys_var_long_ptr	sys_slow_launch_time("slow_launch_time",
					     &slow_launch_time);
sys_var_thd_ulong	sys_sort_buffer("sort_buffer_size",
					&SV::sortbuff_size);
414 415
sys_var_thd_sql_mode    sys_sql_mode("sql_mode",
                                     &SV::sql_mode);
416 417 418 419
sys_var_thd_enum
sys_updatable_views_with_limit("updatable_views_with_limit",
                               &SV::updatable_views_with_limit,
                               &updatable_views_with_limit_typelib);
bell@sanja.is.com.ua's avatar
VIEW  
bell@sanja.is.com.ua committed
420

421 422
sys_var_thd_table_type  sys_table_type("table_type",
				       &SV::table_type);
423 424
sys_var_thd_storage_engine sys_storage_engine("storage_engine",
				       &SV::table_type);
425 426
#ifdef HAVE_REPLICATION
sys_var_sync_binlog_period sys_sync_binlog_period("sync_binlog", &sync_binlog_period);
427 428 429 430 431 432 433 434
sys_var_thd_ulong	sys_sync_replication("sync_replication",
                                               &SV::sync_replication);
sys_var_thd_ulong	sys_sync_replication_slave_id(
						"sync_replication_slave_id",
                                               &SV::sync_replication_slave_id);
sys_var_thd_ulong	sys_sync_replication_timeout(
						"sync_replication_timeout",
                                               &SV::sync_replication_timeout);
435 436
#endif
sys_var_bool_ptr	sys_sync_frm("sync_frm", &opt_sync_frm);
437 438 439
sys_var_long_ptr	sys_table_def_size("table_definition_cache",
                                           &table_def_size);
sys_var_long_ptr	sys_table_cache_size("table_open_cache",
440
					     &table_cache_size);
441 442
sys_var_long_ptr	sys_table_lock_wait_timeout("table_lock_wait_timeout",
                                                    &table_lock_wait_timeout);
443 444 445 446 447 448 449 450
sys_var_long_ptr	sys_thread_cache_size("thread_cache_size",
					      &thread_cache_size);
sys_var_thd_enum	sys_tx_isolation("tx_isolation",
					 &SV::tx_isolation,
					 &tx_isolation_typelib,
					 fix_tx_isolation);
sys_var_thd_ulong	sys_tmp_table_size("tmp_table_size",
					   &SV::tmp_table_size);
vtkachenko@intelp4d.mysql.com's avatar
vtkachenko@intelp4d.mysql.com committed
451 452
sys_var_bool_ptr  sys_timed_mutexes("timed_mutexes",
                                    &timed_mutexes);
453 454
sys_var_thd_ulong	sys_net_wait_timeout("wait_timeout",
					     &SV::net_wait_timeout);
455

456 457
sys_var_long_ptr	sys_innodb_fast_shutdown("innodb_fast_shutdown",
						 &innobase_fast_shutdown);
458 459
sys_var_long_ptr        sys_innodb_max_dirty_pages_pct("innodb_max_dirty_pages_pct",
                                                        &srv_max_buf_pool_modified_pct);
460 461
sys_var_long_ptr	sys_innodb_max_purge_lag("innodb_max_purge_lag",
							&srv_max_purge_lag);
462 463
sys_var_thd_bool	sys_innodb_table_locks("innodb_table_locks",
                                               &SV::innodb_table_locks);
464 465
sys_var_thd_bool	sys_innodb_support_xa("innodb_support_xa",
                                               &SV::innodb_support_xa);
466 467
sys_var_long_ptr	sys_innodb_autoextend_increment("innodb_autoextend_increment",
							&srv_auto_extend_increment);
468 469
sys_var_long_ptr	sys_innodb_sync_spin_loops("innodb_sync_spin_loops",
                                             &srv_n_spin_wait_rounds);
vtkachenko@mail.mysql.com's avatar
vtkachenko@mail.mysql.com committed
470
sys_var_long_ptr  sys_innodb_concurrency_tickets("innodb_concurrency_tickets",
vtkachenko@intelp4d.mysql.com's avatar
vtkachenko@intelp4d.mysql.com committed
471 472 473 474 475
                                             &srv_n_free_tickets_to_enter);
sys_var_long_ptr  sys_innodb_thread_sleep_delay("innodb_thread_sleep_delay",
                                                &srv_thread_sleep_delay);
sys_var_long_ptr  sys_innodb_thread_concurrency("innodb_thread_concurrency",
                                                &srv_thread_concurrency);
476 477
sys_var_long_ptr  sys_innodb_commit_concurrency("innodb_commit_concurrency",
                                                &srv_commit_concurrency);
478

mskold@mysql.com's avatar
mskold@mysql.com committed
479 480 481 482 483
/* Condition pushdown to storage engine */
sys_var_thd_bool
sys_engine_condition_pushdown("engine_condition_pushdown",
			      &SV::engine_condition_pushdown);

484
/* ndb thread specific variable settings */
485
sys_var_thd_ulong
486 487 488
sys_ndb_autoincrement_prefetch_sz("ndb_autoincrement_prefetch_sz",
				  &SV::ndb_autoincrement_prefetch_sz);
sys_var_thd_bool
489
sys_ndb_force_send("ndb_force_send", &SV::ndb_force_send);
tomas@poseidon.ndb.mysql.com's avatar
tomas@poseidon.ndb.mysql.com committed
490 491 492 493 494 495 496 497
#ifdef HAVE_NDB_BINLOG
sys_var_long_ptr
sys_ndb_report_thresh_binlog_epoch_slip("ndb_report_thresh_binlog_epoch_slip",
                                        &ndb_report_thresh_binlog_epoch_slip);
sys_var_long_ptr
sys_ndb_report_thresh_binlog_mem_usage("ndb_report_thresh_binlog_mem_usage",
                                       &ndb_report_thresh_binlog_mem_usage);
#endif
498
sys_var_thd_bool
499
sys_ndb_use_exact_count("ndb_use_exact_count", &SV::ndb_use_exact_count);
500
sys_var_thd_bool
501
sys_ndb_use_transactions("ndb_use_transactions", &SV::ndb_use_transactions);
502 503
sys_var_long_ptr
sys_ndb_cache_check_time("ndb_cache_check_time", &ndb_cache_check_time);
504 505 506 507 508 509 510 511 512
sys_var_thd_bool
sys_ndb_index_stat_enable("ndb_index_stat_enable",
                          &SV::ndb_index_stat_enable);
sys_var_thd_ulong
sys_ndb_index_stat_cache_entries("ndb_index_stat_cache_entries",
                                 &SV::ndb_index_stat_cache_entries);
sys_var_thd_ulong
sys_ndb_index_stat_update_freq("ndb_index_stat_update_freq",
                               &SV::ndb_index_stat_update_freq);
tomas@poseidon.ndb.mysql.com's avatar
tomas@poseidon.ndb.mysql.com committed
513 514
sys_var_long_ptr
sys_ndb_extra_logging("ndb_extra_logging", &ndb_extra_logging);
515 516 517 518 519

/* Time/date/datetime formats */

sys_var_thd_date_time_format sys_time_format("time_format",
					     &SV::time_format,
520
					     MYSQL_TIMESTAMP_TIME);
521 522
sys_var_thd_date_time_format sys_date_format("date_format",
					     &SV::date_format,
523
					     MYSQL_TIMESTAMP_DATE);
524 525
sys_var_thd_date_time_format sys_datetime_format("datetime_format",
						 &SV::datetime_format,
526
						 MYSQL_TIMESTAMP_DATETIME);
527 528

/* Variables that are bits in THD */
529

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

583 584
/* Local state variables */

585
static sys_var_thd_ha_rows	sys_select_limit("sql_select_limit",
586 587 588 589 590
						 &SV::select_limit);
static sys_var_timestamp	sys_timestamp("timestamp");
static sys_var_last_insert_id	sys_last_insert_id("last_insert_id");
static sys_var_last_insert_id	sys_identity("identity");
static sys_var_insert_id	sys_insert_id("insert_id");
591 592 593 594 595 596 597 598 599
static sys_var_readonly		sys_error_count("error_count",
						OPT_SESSION,
						SHOW_LONG,
						get_error_count);
static sys_var_readonly		sys_warning_count("warning_count",
						  OPT_SESSION,
						  SHOW_LONG,
						  get_warning_count);

600
/* alias for last_insert_id() to be compatible with Sybase */
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
601
#ifdef HAVE_REPLICATION
602
static sys_var_slave_skip_counter sys_slave_skip_counter("sql_slave_skip_counter");
603
#endif
604 605
static sys_var_rand_seed1	sys_rand_seed1("rand_seed1");
static sys_var_rand_seed2	sys_rand_seed2("rand_seed2");
606

607 608
static sys_var_thd_ulong        sys_default_week_format("default_week_format",
					                &SV::default_week_format);
609

610 611 612
sys_var_thd_ulong               sys_group_concat_max_len("group_concat_max_len",
                                                         &SV::group_concat_max_len);

613
sys_var_thd_time_zone            sys_time_zone("time_zone");
614 615 616 617

/* Read only variables */

sys_var_const_str		sys_os("version_compile_os", SYSTEM_TYPE);
618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640
sys_var_have_variable sys_have_archive_db("have_archive", &have_archive_db);
sys_var_have_variable sys_have_berkeley_db("have_bdb", &have_berkeley_db);
sys_var_have_variable sys_have_blackhole_db("have_blackhole_engine",
                                            &have_blackhole_db);
sys_var_have_variable sys_have_compress("have_compress", &have_compress);
sys_var_have_variable sys_have_crypt("have_crypt", &have_crypt);
sys_var_have_variable sys_have_csv_db("have_csv", &have_csv_db);
sys_var_have_variable sys_have_example_db("have_example_engine",
                                          &have_example_db);
sys_var_have_variable sys_have_federated_db("have_federated_engine",
                                            &have_federated_db);
sys_var_have_variable sys_have_geometry("have_geometry", &have_geometry);
sys_var_have_variable sys_have_innodb("have_innodb", &have_innodb);
sys_var_have_variable sys_have_isam("have_isam", &have_isam);
sys_var_have_variable sys_have_ndbcluster("have_ndbcluster", &have_ndbcluster);
sys_var_have_variable sys_have_openssl("have_openssl", &have_openssl);
sys_var_have_variable sys_have_partition_db("have_partition_engine",
                                            &have_partition_db);
sys_var_have_variable sys_have_query_cache("have_query_cache",
                                           &have_query_cache);
sys_var_have_variable sys_have_raid("have_raid", &have_raid);
sys_var_have_variable sys_have_rtree_keys("have_rtree_keys", &have_rtree_keys);
sys_var_have_variable sys_have_symlink("have_symlink", &have_symlink);
641
sys_var_have_variable sys_have_row_based_replication("have_row_based_replication",&have_row_based_replication);
642 643
/* Global read-only variable describing server license */
sys_var_const_str		sys_license("license", STRINGIFY_ARG(LICENSE));
644

645
#ifdef HAVE_REPLICATION
646
static int show_slave_skip_errors(THD *thd, SHOW_VAR *var, char *buff)
647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683
{
  var->type=SHOW_CHAR;
  var->value= buff;
  if (!use_slave_mask || bitmap_is_clear_all(&slave_error_mask))
  {
    var->value= "OFF";
  }
  else if (bitmap_is_set_all(&slave_error_mask))
  {
    var->value= "ALL";
  }
  else
  {
    /* 10 is enough assuming errors are max 4 digits */
    int i;
    var->value= buff;
    for (i= 1;
         i < MAX_SLAVE_ERROR &&
         (buff - var->value) < SHOW_VAR_FUNC_BUFF_SIZE;
         i++)
    {
      if (bitmap_is_set(&slave_error_mask, i))
      {
        buff= int10_to_str(i, buff, 10);
        *buff++= ',';
      }
    }
    if (var->value != buff)
      buff--;				// Remove last ','
    if (i < MAX_SLAVE_ERROR)
      buff= strmov(buff, "...");  // Couldn't show all errors
    *buff=0;
  }
  return 0;
}
#endif /* HAVE_REPLICATION */

684 685 686 687 688

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

689
SHOW_VAR init_vars[]= {
690
  {"auto_increment_increment", (char*) &sys_auto_increment_increment, SHOW_SYS},
691
  {"auto_increment_offset",   (char*) &sys_auto_increment_offset, SHOW_SYS},
692
  {sys_automatic_sp_privileges.name,(char*) &sys_automatic_sp_privileges,       SHOW_SYS},
693 694
  {"back_log",                (char*) &back_log,                    SHOW_LONG},
  {"basedir",                 mysql_home,                           SHOW_CHAR},
695
  {"bdb_cache_parts",         (char*) &berkeley_cache_parts,        SHOW_LONG},
696
  {"bdb_cache_size",          (char*) &berkeley_cache_size,         SHOW_LONGLONG},
697
  {"bdb_home",                (char*) &berkeley_home,               SHOW_CHAR_PTR},
698
  {"bdb_log_buffer_size",     (char*) &berkeley_log_buffer_size,    SHOW_LONG},
699
  {"bdb_logdir",              (char*) &berkeley_logdir,             SHOW_CHAR_PTR},
700
  {"bdb_max_lock",            (char*) &berkeley_max_lock,	    SHOW_LONG},
701
  {"bdb_region_size",         (char*) &berkeley_region_size,	    SHOW_LONG},
702 703 704
  {"bdb_shared_data",	      (char*) &berkeley_shared_data,	    SHOW_BOOL},
  {"bdb_tmpdir",              (char*) &berkeley_tmpdir,             SHOW_CHAR_PTR},
  {sys_binlog_cache_size.name,(char*) &sys_binlog_cache_size,	    SHOW_SYS},
705
  {"binlog_format",           (char*) &opt_binlog_format,           SHOW_CHAR_PTR},
706
  {sys_bulk_insert_buff_size.name,(char*) &sys_bulk_insert_buff_size,SHOW_SYS},
707
  {sys_character_set_client.name,(char*) &sys_character_set_client, SHOW_SYS},
708
  {sys_character_set_connection.name,(char*) &sys_character_set_connection,SHOW_SYS},
709
  {sys_character_set_database.name, (char*) &sys_character_set_database,SHOW_SYS},
710
  {sys_character_set_filesystem.name,(char*) &sys_character_set_filesystem, SHOW_SYS},
711
  {sys_character_set_results.name,(char*) &sys_character_set_results, SHOW_SYS},
712 713 714
  {sys_character_set_server.name, (char*) &sys_character_set_server,SHOW_SYS},
  {sys_charset_system.name,   (char*) &sys_charset_system,          SHOW_SYS},
  {"character_sets_dir",      mysql_charsets_dir,                   SHOW_CHAR},
715
  {sys_collation_connection.name,(char*) &sys_collation_connection, SHOW_SYS},
716 717
  {sys_collation_database.name,(char*) &sys_collation_database,     SHOW_SYS},
  {sys_collation_server.name,(char*) &sys_collation_server,         SHOW_SYS},
718
  {sys_completion_type.name,  (char*) &sys_completion_type,	    SHOW_SYS},
719 720 721
  {sys_concurrent_insert.name,(char*) &sys_concurrent_insert,       SHOW_SYS},
  {sys_connect_timeout.name,  (char*) &sys_connect_timeout,         SHOW_SYS},
  {"datadir",                 mysql_real_data_home,                 SHOW_CHAR},
722 723 724
  {sys_date_format.name,      (char*) &sys_date_format,		    SHOW_SYS},
  {sys_datetime_format.name,  (char*) &sys_datetime_format,	    SHOW_SYS},
  {sys_default_week_format.name, (char*) &sys_default_week_format,  SHOW_SYS},
725 726 727 728
  {sys_delay_key_write.name,  (char*) &sys_delay_key_write,         SHOW_SYS},
  {sys_delayed_insert_limit.name, (char*) &sys_delayed_insert_limit,SHOW_SYS},
  {sys_delayed_insert_timeout.name, (char*) &sys_delayed_insert_timeout, SHOW_SYS},
  {sys_delayed_queue_size.name,(char*) &sys_delayed_queue_size,     SHOW_SYS},
paul@kite-hub.kitebird.com's avatar
paul@kite-hub.kitebird.com committed
729 730 731
  {sys_div_precincrement.name,(char*) &sys_div_precincrement,SHOW_SYS},
  {sys_engine_condition_pushdown.name, 
   (char*) &sys_engine_condition_pushdown,                          SHOW_SYS},
732
  {sys_event_executor.name,   (char*) &sys_event_executor,          SHOW_SYS},
733
  {sys_expire_logs_days.name, (char*) &sys_expire_logs_days,        SHOW_SYS},
734 735
  {sys_flush.name,             (char*) &sys_flush,                  SHOW_SYS},
  {sys_flush_time.name,        (char*) &sys_flush_time,             SHOW_SYS},
736
  {sys_ft_boolean_syntax.name,(char*) &ft_boolean_syntax,	    SHOW_CHAR},
737
  {"ft_max_word_len",         (char*) &ft_max_word_len,             SHOW_LONG},
738
  {"ft_min_word_len",         (char*) &ft_min_word_len,             SHOW_LONG},
739
  {"ft_query_expansion_limit",(char*) &ft_query_expansion_limit,    SHOW_LONG},
740
  {"ft_stopword_file",        (char*) &ft_stopword_file,            SHOW_CHAR_PTR},
741
  {sys_group_concat_max_len.name, (char*) &sys_group_concat_max_len,  SHOW_SYS},
742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757
  {sys_have_archive_db.name,  (char*) &have_archive_db,             SHOW_HAVE},
  {sys_have_berkeley_db.name, (char*) &have_berkeley_db,            SHOW_HAVE},
  {sys_have_blackhole_db.name,(char*) &have_blackhole_db,           SHOW_HAVE},
  {sys_have_compress.name,    (char*) &have_compress,               SHOW_HAVE},
  {sys_have_crypt.name,       (char*) &have_crypt,                  SHOW_HAVE},
  {sys_have_csv_db.name,      (char*) &have_csv_db,                 SHOW_HAVE},
  {sys_have_example_db.name,  (char*) &have_example_db,             SHOW_HAVE},
  {sys_have_federated_db.name,(char*) &have_federated_db,           SHOW_HAVE},
  {sys_have_geometry.name,    (char*) &have_geometry,               SHOW_HAVE},
  {sys_have_innodb.name,      (char*) &have_innodb,                 SHOW_HAVE},
  {sys_have_isam.name,        (char*) &have_isam,                   SHOW_HAVE},
  {sys_have_ndbcluster.name,  (char*) &have_ndbcluster,             SHOW_HAVE},
  {sys_have_openssl.name,     (char*) &have_openssl,                SHOW_HAVE},
  {sys_have_partition_db.name,(char*) &have_partition_db,           SHOW_HAVE},
  {sys_have_query_cache.name, (char*) &have_query_cache,            SHOW_HAVE},
  {sys_have_raid.name,        (char*) &have_raid,                   SHOW_HAVE},
paul@snake-hub.snake.net's avatar
paul@snake-hub.snake.net committed
758
  {sys_have_row_based_replication.name, (char*) &have_row_based_replication, SHOW_HAVE},
759 760
  {sys_have_rtree_keys.name,  (char*) &have_rtree_keys,             SHOW_HAVE},
  {sys_have_symlink.name,     (char*) &have_symlink,                SHOW_HAVE},
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
761
  {"init_connect",            (char*) &sys_init_connect,            SHOW_SYS},
762
  {"init_file",               (char*) &opt_init_file,               SHOW_CHAR_PTR},
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
763
  {"init_slave",              (char*) &sys_init_slave,              SHOW_SYS},
764
  {"innodb_additional_mem_pool_size", (char*) &innobase_additional_mem_pool_size, SHOW_LONG },
765
  {sys_innodb_autoextend_increment.name, (char*) &sys_innodb_autoextend_increment, SHOW_SYS},
766
  {"innodb_buffer_pool_awe_mem_mb", (char*) &innobase_buffer_pool_awe_mem_mb, SHOW_LONG },
767
  {"innodb_buffer_pool_size", (char*) &innobase_buffer_pool_size, SHOW_LONGLONG },
768
  {"innodb_checksums", (char*) &innobase_use_checksums, SHOW_MY_BOOL},
paul@kite-hub.kitebird.com's avatar
paul@kite-hub.kitebird.com committed
769
  {sys_innodb_commit_concurrency.name, (char*) &sys_innodb_commit_concurrency, SHOW_SYS},
770
  {sys_innodb_concurrency_tickets.name, (char*) &sys_innodb_concurrency_tickets, SHOW_SYS},
771 772
  {"innodb_data_file_path", (char*) &innobase_data_file_path,	    SHOW_CHAR_PTR},
  {"innodb_data_home_dir",  (char*) &innobase_data_home_dir,	    SHOW_CHAR_PTR},
773
  {"innodb_doublewrite", (char*) &innobase_use_doublewrite, SHOW_MY_BOOL},
774
  {sys_innodb_fast_shutdown.name,(char*) &sys_innodb_fast_shutdown, SHOW_SYS},
775
  {"innodb_file_io_threads", (char*) &innobase_file_io_threads, SHOW_LONG },
heikki@hundin.mysql.fi's avatar
heikki@hundin.mysql.fi committed
776
  {"innodb_file_per_table", (char*) &innobase_file_per_table, SHOW_MY_BOOL},
777
  {"innodb_flush_log_at_trx_commit", (char*) &innobase_flush_log_at_trx_commit, SHOW_INT},
778
  {"innodb_flush_method",    (char*) &innobase_unix_file_flush_method, SHOW_CHAR_PTR},
779
  {"innodb_force_recovery", (char*) &innobase_force_recovery, SHOW_LONG },
780
  {"innodb_lock_wait_timeout", (char*) &innobase_lock_wait_timeout, SHOW_LONG },
paul@kite-hub.kitebird.com's avatar
paul@kite-hub.kitebird.com committed
781
  {"innodb_locks_unsafe_for_binlog", (char*) &innobase_locks_unsafe_for_binlog, SHOW_MY_BOOL},
782 783 784
  {"innodb_log_arch_dir",   (char*) &innobase_log_arch_dir, 	    SHOW_CHAR_PTR},
  {"innodb_log_archive",    (char*) &innobase_log_archive, 	    SHOW_MY_BOOL},
  {"innodb_log_buffer_size", (char*) &innobase_log_buffer_size, SHOW_LONG },
785
  {"innodb_log_file_size", (char*) &innobase_log_file_size, SHOW_LONGLONG},
786 787
  {"innodb_log_files_in_group", (char*) &innobase_log_files_in_group,	SHOW_LONG},
  {"innodb_log_group_home_dir", (char*) &innobase_log_group_home_dir, SHOW_CHAR_PTR},
788
  {sys_innodb_max_dirty_pages_pct.name, (char*) &sys_innodb_max_dirty_pages_pct, SHOW_SYS},
789
  {sys_innodb_max_purge_lag.name, (char*) &sys_innodb_max_purge_lag, SHOW_SYS},
790 791
  {"innodb_mirrored_log_groups", (char*) &innobase_mirrored_log_groups, SHOW_LONG},
  {"innodb_open_files", (char*) &innobase_open_files, SHOW_LONG },
paul@kite-hub.kitebird.com's avatar
paul@kite-hub.kitebird.com committed
792
  {sys_innodb_support_xa.name, (char*) &sys_innodb_support_xa, SHOW_SYS},
793
  {sys_innodb_sync_spin_loops.name, (char*) &sys_innodb_sync_spin_loops, SHOW_SYS},
paul@kite-hub.kitebird.com's avatar
paul@kite-hub.kitebird.com committed
794
  {sys_innodb_table_locks.name, (char*) &sys_innodb_table_locks, SHOW_SYS},
795 796
  {sys_innodb_thread_concurrency.name, (char*) &sys_innodb_thread_concurrency, SHOW_SYS},
  {sys_innodb_thread_sleep_delay.name, (char*) &sys_innodb_thread_sleep_delay, SHOW_SYS},
797 798 799
  {sys_interactive_timeout.name,(char*) &sys_interactive_timeout,   SHOW_SYS},
  {sys_join_buffer_size.name,   (char*) &sys_join_buffer_size,	    SHOW_SYS},
  {sys_key_buffer_size.name,	(char*) &sys_key_buffer_size,	    SHOW_SYS},
800 801
  {sys_key_cache_age_threshold.name,   (char*) &sys_key_cache_age_threshold,
                                                                    SHOW_SYS},
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
802
  {sys_key_cache_block_size.name,   (char*) &sys_key_cache_block_size,
803
                                                                    SHOW_SYS},
804
  {sys_key_cache_division_limit.name,   (char*) &sys_key_cache_division_limit,
805
                                                                    SHOW_SYS},
806
  {"language",                language,                             SHOW_CHAR},
807
  {"large_files_support",     (char*) &opt_large_files,             SHOW_BOOL},
808
  {"large_page_size",         (char*) &opt_large_page_size,         SHOW_INT},
paul@kite-hub.kitebird.com's avatar
paul@kite-hub.kitebird.com committed
809
  {"large_pages",             (char*) &opt_large_pages,             SHOW_MY_BOOL},
810
  {sys_license.name,	      (char*) &sys_license,                 SHOW_SYS},
811 812 813 814 815 816
  {sys_local_infile.name,     (char*) &sys_local_infile,	    SHOW_SYS},
#ifdef HAVE_MLOCKALL
  {"locked_in_memory",	      (char*) &locked_in_memory,	    SHOW_BOOL},
#endif
  {"log",                     (char*) &opt_log,                     SHOW_BOOL},
  {"log_bin",                 (char*) &opt_bin_log,                 SHOW_BOOL},
817
  {sys_trust_function_creators.name,(char*) &sys_trust_function_creators, SHOW_SYS},
818
  {"log_error",               (char*) log_error_file,               SHOW_CHAR},
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
819
#ifdef HAVE_REPLICATION
820
  {"log_slave_updates",       (char*) &opt_log_slave_updates,       SHOW_MY_BOOL},
821
#endif
822 823 824 825
  {"log_slow_queries",        (char*) &opt_slow_log,                SHOW_BOOL},
  {sys_log_warnings.name,     (char*) &sys_log_warnings,	    SHOW_SYS},
  {sys_long_query_time.name,  (char*) &sys_long_query_time, 	    SHOW_SYS},
  {sys_low_priority_updates.name, (char*) &sys_low_priority_updates, SHOW_SYS},
826
  {"lower_case_file_system",  (char*) &lower_case_file_system,      SHOW_MY_BOOL},
827
  {"lower_case_table_names",  (char*) &lower_case_table_names,      SHOW_INT},
828 829 830 831
  {sys_max_allowed_packet.name,(char*) &sys_max_allowed_packet,	    SHOW_SYS},
  {sys_max_binlog_cache_size.name,(char*) &sys_max_binlog_cache_size, SHOW_SYS},
  {sys_max_binlog_size.name,    (char*) &sys_max_binlog_size,	    SHOW_SYS},
  {sys_max_connect_errors.name, (char*) &sys_max_connect_errors,    SHOW_SYS},
832
  {sys_max_connections.name,    (char*) &sys_max_connections,	    SHOW_SYS},
833
  {sys_max_delayed_threads.name,(char*) &sys_max_delayed_threads,   SHOW_SYS},
834
  {sys_max_error_count.name,	(char*) &sys_max_error_count,	    SHOW_SYS},
835
  {sys_max_heap_table_size.name,(char*) &sys_max_heap_table_size,   SHOW_SYS},
836 837
  {sys_max_insert_delayed_threads.name,
   (char*) &sys_max_insert_delayed_threads,   SHOW_SYS},
838
  {sys_max_join_size.name,	(char*) &sys_max_join_size,	    SHOW_SYS},
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
839
  {sys_max_length_for_sort_data.name, (char*) &sys_max_length_for_sort_data,
igor@hundin.mysql.fi's avatar
igor@hundin.mysql.fi committed
840
   SHOW_SYS},
841 842
  {sys_max_relay_log_size.name, (char*) &sys_max_relay_log_size,    SHOW_SYS},
  {sys_max_seeks_for_key.name,  (char*) &sys_max_seeks_for_key,	    SHOW_SYS},
843
  {sys_max_sort_length.name,	(char*) &sys_max_sort_length,	    SHOW_SYS},
844 845
  {sys_max_sp_recursion_depth.name,
    (char*) &sys_max_sp_recursion_depth, SHOW_SYS},
846
  {sys_max_tmp_tables.name,	(char*) &sys_max_tmp_tables,	    SHOW_SYS},
847
  {sys_max_user_connections.name,(char*) &sys_max_user_connections, SHOW_SYS},
848
  {sys_max_write_lock_count.name, (char*) &sys_max_write_lock_count,SHOW_SYS},
ingo@mysql.com's avatar
ingo@mysql.com committed
849
  {sys_multi_range_count.name,  (char*) &sys_multi_range_count,     SHOW_SYS},
serg@serg.mylan's avatar
serg@serg.mylan committed
850
  {sys_myisam_data_pointer_size.name, (char*) &sys_myisam_data_pointer_size, SHOW_SYS},
851 852
  {sys_myisam_max_sort_file_size.name, (char*) &sys_myisam_max_sort_file_size,
   SHOW_SYS},
853
  {"myisam_recover_options",  (char*) &myisam_recover_options_str,  SHOW_CHAR_PTR},
854
  {sys_myisam_repair_threads.name, (char*) &sys_myisam_repair_threads,
855 856
   SHOW_SYS},
  {sys_myisam_sort_buffer_size.name, (char*) &sys_myisam_sort_buffer_size, SHOW_SYS},
857 858
  
  {sys_myisam_stats_method.name, (char*) &sys_myisam_stats_method, SHOW_SYS},
paul@kite-hub.kitebird.com's avatar
paul@kite-hub.kitebird.com committed
859
  {sys_myisam_use_mmap.name, (char*) &sys_myisam_use_mmap, SHOW_SYS},
860
  
861
#ifdef __NT__
862
  {"named_pipe",	      (char*) &opt_enable_named_pipe,       SHOW_MY_BOOL},
863 864 865
#endif
  {sys_ndb_autoincrement_prefetch_sz.name,
   (char*) &sys_ndb_autoincrement_prefetch_sz,                      SHOW_SYS},
866
  {sys_ndb_cache_check_time.name,(char*) &sys_ndb_cache_check_time, SHOW_SYS},
tomas@poseidon.ndb.mysql.com's avatar
tomas@poseidon.ndb.mysql.com committed
867
  {sys_ndb_extra_logging.name,(char*) &sys_ndb_extra_logging,       SHOW_SYS},
868
  {sys_ndb_force_send.name,   (char*) &sys_ndb_force_send,          SHOW_SYS},
869 870 871
  {sys_ndb_index_stat_cache_entries.name, (char*) &sys_ndb_index_stat_cache_entries, SHOW_SYS},
  {sys_ndb_index_stat_enable.name, (char*) &sys_ndb_index_stat_enable, SHOW_SYS},
  {sys_ndb_index_stat_update_freq.name, (char*) &sys_ndb_index_stat_update_freq, SHOW_SYS},
tomas@poseidon.ndb.mysql.com's avatar
tomas@poseidon.ndb.mysql.com committed
872 873 874 875 876 877
#ifdef HAVE_NDB_BINLOG
  {sys_ndb_report_thresh_binlog_epoch_slip.name,
   (char*) &sys_ndb_report_thresh_binlog_epoch_slip,                SHOW_SYS},
  {sys_ndb_report_thresh_binlog_mem_usage.name,
   (char*) &sys_ndb_report_thresh_binlog_mem_usage,                 SHOW_SYS},
#endif
878 879
  {sys_ndb_use_exact_count.name,(char*) &sys_ndb_use_exact_count,   SHOW_SYS},
  {sys_ndb_use_transactions.name,(char*) &sys_ndb_use_transactions, SHOW_SYS},
880 881
  {sys_net_buffer_length.name,(char*) &sys_net_buffer_length,       SHOW_SYS},
  {sys_net_read_timeout.name, (char*) &sys_net_read_timeout,        SHOW_SYS},
882
  {sys_net_retry_count.name,  (char*) &sys_net_retry_count,	    SHOW_SYS},
883
  {sys_net_write_timeout.name,(char*) &sys_net_write_timeout,       SHOW_SYS},
884
  {sys_new_mode.name,         (char*) &sys_new_mode,                SHOW_SYS},
885
  {sys_old_alter_table.name,  (char*) &sys_old_alter_table,         SHOW_SYS},
886
  {sys_old_passwords.name,    (char*) &sys_old_passwords,           SHOW_SYS},
887
  {"open_files_limit",	      (char*) &open_files_limit,	    SHOW_LONG},
888 889 890 891
  {sys_optimizer_prune_level.name, (char*) &sys_optimizer_prune_level,
   SHOW_SYS},
  {sys_optimizer_search_depth.name,(char*) &sys_optimizer_search_depth,
   SHOW_SYS},
892
  {"pid_file",                (char*) pidfile_name,                 SHOW_CHAR},
893
  {"plugin_dir",              (char*) opt_plugin_dir,               SHOW_CHAR},
894
  {"port",                    (char*) &mysqld_port,                  SHOW_INT},
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
895
  {sys_preload_buff_size.name, (char*) &sys_preload_buff_size,      SHOW_SYS},
896
  {"protocol_version",        (char*) &protocol_version,            SHOW_INT},
897 898
  {sys_query_alloc_block_size.name, (char*) &sys_query_alloc_block_size,
   SHOW_SYS},
899
#ifdef HAVE_QUERY_CACHE
900
  {sys_query_cache_limit.name,(char*) &sys_query_cache_limit,	    SHOW_SYS},
901 902
  {sys_query_cache_min_res_unit.name, (char*) &sys_query_cache_min_res_unit,
   SHOW_SYS},
903 904
  {sys_query_cache_size.name, (char*) &sys_query_cache_size,	    SHOW_SYS},
  {sys_query_cache_type.name, (char*) &sys_query_cache_type,        SHOW_SYS},
paul@ice.snake.net's avatar
paul@ice.snake.net committed
905 906
  {sys_query_cache_wlock_invalidate.name,
   (char *) &sys_query_cache_wlock_invalidate, SHOW_SYS},
907
#endif /* HAVE_QUERY_CACHE */
908
  {sys_query_prealloc_size.name, (char*) &sys_query_prealloc_size,  SHOW_SYS},
909 910
  {sys_range_alloc_block_size.name, (char*) &sys_range_alloc_block_size,
   SHOW_SYS},
serg@serg.mylan's avatar
serg@serg.mylan committed
911 912 913
  {sys_read_buff_size.name,   (char*) &sys_read_buff_size,	    SHOW_SYS},
  {sys_readonly.name,         (char*) &sys_readonly,                SHOW_SYS},
  {sys_read_rnd_buff_size.name,(char*) &sys_read_rnd_buff_size,	    SHOW_SYS},
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
914 915
#ifdef HAVE_REPLICATION
  {sys_relay_log_purge.name,  (char*) &sys_relay_log_purge,         SHOW_SYS},
916
  {"relay_log_space_limit",  (char*) &relay_log_space_limit,        SHOW_LONGLONG},
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
917
#endif
serg@serg.mylan's avatar
serg@serg.mylan committed
918
  {sys_rpl_recovery_rank.name,(char*) &sys_rpl_recovery_rank,       SHOW_SYS},
919
  {"secure_auth",             (char*) &sys_secure_auth,             SHOW_SYS},
920 921 922 923
#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
924
  {sys_server_id.name,	      (char*) &sys_server_id,		    SHOW_SYS},
925
  {"skip_external_locking",   (char*) &my_disable_locking,          SHOW_MY_BOOL},
926 927
  {"skip_networking",         (char*) &opt_disable_networking,      SHOW_BOOL},
  {"skip_show_database",      (char*) &opt_skip_show_db,            SHOW_BOOL},
928
#ifdef HAVE_REPLICATION
929 930 931
  {sys_slave_compressed_protocol.name,
    (char*) &sys_slave_compressed_protocol,           SHOW_SYS},
  {"slave_load_tmpdir",       (char*) &slave_load_tmpdir,           SHOW_CHAR_PTR},
932
  {sys_slave_net_timeout.name,(char*) &sys_slave_net_timeout,	    SHOW_SYS},
933
  {"slave_skip_errors",       (char*) &show_slave_skip_errors,      SHOW_FUNC},
934
  {sys_slave_trans_retries.name,(char*) &sys_slave_trans_retries,   SHOW_SYS},
935
#endif
936
  {sys_slow_launch_time.name, (char*) &sys_slow_launch_time,        SHOW_SYS},
937
#ifdef HAVE_SYS_UN_H
938
  {"socket",                  (char*) &mysqld_unix_port,             SHOW_CHAR_PTR},
939
#endif
940
  {sys_sort_buffer.name,      (char*) &sys_sort_buffer, 	    SHOW_SYS},
941
  {sys_sql_mode.name,         (char*) &sys_sql_mode,                SHOW_SYS},
942 943
  {"sql_notes",               (char*) &sys_sql_notes,               SHOW_BOOL},
  {"sql_warnings",            (char*) &sys_sql_warnings,            SHOW_BOOL},
paul@frost.snake.net's avatar
paul@frost.snake.net committed
944
  {sys_storage_engine.name,   (char*) &sys_storage_engine,          SHOW_SYS},
945 946
#ifdef HAVE_REPLICATION
  {sys_sync_binlog_period.name,(char*) &sys_sync_binlog_period,     SHOW_SYS},
paul@frost.snake.net's avatar
paul@frost.snake.net committed
947 948 949
#endif
  {sys_sync_frm.name,         (char*) &sys_sync_frm,               SHOW_SYS},
#ifdef HAVE_REPLICATION
950 951 952
  {sys_sync_replication.name, (char*) &sys_sync_replication,        SHOW_SYS},
  {sys_sync_replication_slave_id.name, (char*) &sys_sync_replication_slave_id,SHOW_SYS},
  {sys_sync_replication_timeout.name, (char*) &sys_sync_replication_timeout,SHOW_SYS},
953
#endif
954 955 956
#ifdef HAVE_TZNAME
  {"system_time_zone",        system_time_zone,                     SHOW_CHAR},
#endif
957
  {"table_definition_cache",  (char*) &table_def_size,              SHOW_LONG},
958
  {"table_lock_wait_timeout", (char*) &table_lock_wait_timeout,     SHOW_LONG },
paul@kite-hub.kitebird.com's avatar
paul@kite-hub.kitebird.com committed
959
  {"table_open_cache",        (char*) &table_cache_size,            SHOW_LONG},
960 961 962 963 964 965
  {sys_table_type.name,	      (char*) &sys_table_type,	            SHOW_SYS},
  {sys_thread_cache_size.name,(char*) &sys_thread_cache_size,       SHOW_SYS},
#ifdef HAVE_THR_SETCONCURRENCY
  {"thread_concurrency",      (char*) &concurrency,                 SHOW_LONG},
#endif
  {"thread_stack",            (char*) &thread_stack,                SHOW_LONG},
966
  {sys_time_format.name,      (char*) &sys_time_format,		    SHOW_SYS},
967
  {"time_zone",               (char*) &sys_time_zone,               SHOW_SYS},
vtkachenko@intelp4d.mysql.com's avatar
vtkachenko@intelp4d.mysql.com committed
968
  {sys_timed_mutexes.name,    (char*) &sys_timed_mutexes,       SHOW_SYS},
969
  {sys_tmp_table_size.name,   (char*) &sys_tmp_table_size,	    SHOW_SYS},
970
  {"tmpdir",                  (char*) &opt_mysql_tmpdir,            SHOW_CHAR_PTR},
971 972 973
  {sys_trans_alloc_block_size.name, (char*) &sys_trans_alloc_block_size,
   SHOW_SYS},
  {sys_trans_prealloc_size.name, (char*) &sys_trans_prealloc_size,  SHOW_SYS},
974
  {sys_tx_isolation.name,     (char*) &sys_tx_isolation,	    SHOW_SYS},
975 976
  {sys_updatable_views_with_limit.name,
                              (char*) &sys_updatable_views_with_limit,SHOW_SYS},
977
  {"version",                 server_version,                       SHOW_CHAR},
978
  {"version_comment",         (char*) MYSQL_COMPILATION_COMMENT,    SHOW_CHAR},
979
  {"version_compile_machine", (char*) MACHINE_TYPE,		    SHOW_CHAR},
980
  {sys_os.name,		      (char*) &sys_os,			    SHOW_SYS},
981 982 983 984
  {sys_net_wait_timeout.name, (char*) &sys_net_wait_timeout,	    SHOW_SYS},
  {NullS, NullS, SHOW_LONG}
};

985

986 987 988 989 990 991
bool sys_var::check(THD *thd, set_var *var)
{
  var->save_result.ulonglong_value= var->value->val_int();
  return 0;
}

992 993 994 995 996 997 998
bool sys_var_str::check(THD *thd, set_var *var)
{
  int res;
  if (!check_func)
    return 0;

  if ((res=(*check_func)(thd, var)) < 0)
999 1000
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0),
             name, var->value->str_value.ptr());
1001 1002 1003
  return res;
}

1004 1005 1006 1007
/*
  Functions to check and update variables
*/

gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
1008

1009 1010 1011 1012 1013 1014 1015 1016 1017 1018
/*
  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)
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
1019
{
1020 1021 1022 1023
  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*) "";
1024
  if (!(res= my_strdup_with_length((byte*)old_value, new_length, MYF(0))))
1025
    return 1;
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
1026 1027 1028 1029
  /*
    Replace the old value in such a way that the any thread using
    the value will work.
  */
1030 1031 1032 1033 1034
  rw_wrlock(var_mutex);
  old_value= var_str->value;
  var_str->value= res;
  var_str->value_length= new_length;
  rw_unlock(var_mutex);
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
1035 1036 1037 1038 1039
  my_free(old_value, MYF(MY_ALLOW_ZERO_PTR));
  return 0;
}


1040 1041 1042 1043 1044 1045
static bool sys_update_init_connect(THD *thd, set_var *var)
{
  return update_sys_var_str(&sys_init_connect, &LOCK_sys_init_connect, var);
}


gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
1046 1047
static void sys_default_init_connect(THD* thd, enum_var_type type)
{
1048
  update_sys_var_str(&sys_init_connect, &LOCK_sys_init_connect, 0);
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
1049 1050 1051 1052 1053
}


static bool sys_update_init_slave(THD *thd, set_var *var)
{
1054
  return update_sys_var_str(&sys_init_slave, &LOCK_sys_init_slave, var);
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
1055 1056 1057 1058 1059
}


static void sys_default_init_slave(THD* thd, enum_var_type type)
{
1060
  update_sys_var_str(&sys_init_slave, &LOCK_sys_init_slave, 0);
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
1061 1062
}

1063 1064
static int sys_check_ftb_syntax(THD *thd,  set_var *var)
{
1065 1066 1067 1068
  if (thd->security_ctx->master_access & SUPER_ACL)
    return (ft_boolean_check_syntax_string((byte*)
                                           var->value->str_value.c_ptr()) ?
            -1 : 0);
1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084
  else
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
}

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

static void sys_default_ftb_syntax(THD *thd, enum_var_type type)
{
1085
  strmake(ft_boolean_syntax, def_ft_boolean_syntax,
1086 1087
	  sizeof(ft_boolean_syntax)-1);
}
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
1088

1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102

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

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


1103 1104 1105 1106 1107 1108 1109
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;
}

1110 1111 1112 1113 1114 1115 1116 1117
/*
  Set the OPTION_BIG_SELECTS flag if max_join_size == HA_POS_ERROR
*/

static void fix_max_join_size(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
  {
1118
    if (thd->variables.max_join_size == HA_POS_ERROR)
1119 1120 1121 1122 1123
      thd->options|= OPTION_BIG_SELECTS;
    else
      thd->options&= ~OPTION_BIG_SELECTS;
  }
}
1124

1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137

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

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

1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149 1150 1151 1152
static void fix_completion_type(THD *thd __attribute__(unused), 
				enum_var_type type __attribute__(unused)) {}

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

1153 1154 1155 1156 1157

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

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1158
#ifdef HAVE_REPLICATION
1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171
static void fix_net_read_timeout(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
    thd->net.read_timeout=thd->variables.net_read_timeout;
}


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

1172 1173 1174 1175 1176
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;
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1177 1178 1179
#else /* HAVE_REPLICATION */
static void fix_net_read_timeout(THD *thd __attribute__(unused),
				 enum_var_type type __attribute__(unused))
1180
{}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1181 1182
static void fix_net_write_timeout(THD *thd __attribute__(unused),
				  enum_var_type type __attribute__(unused))
1183
{}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1184 1185
static void fix_net_retry_count(THD *thd __attribute__(unused),
				enum_var_type type __attribute__(unused))
1186
{}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1187
#endif /* HAVE_REPLICATION */
1188

1189 1190 1191 1192

static void fix_query_cache_size(THD *thd, enum_var_type type)
{
#ifdef HAVE_QUERY_CACHE
1193
  ulong requested= query_cache_size;
1194
  query_cache.resize(query_cache_size);
1195 1196 1197 1198
  if (requested != query_cache_size)
    push_warning_printf(current_thd, MYSQL_ERROR::WARN_LEVEL_WARN,
			ER_WARN_QC_RESIZE, ER(ER_WARN_QC_RESIZE),
			requested, query_cache_size);
1199 1200 1201 1202
#endif
}


1203 1204 1205 1206 1207 1208 1209 1210 1211
#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


1212
extern void fix_delay_key_write(THD *thd, enum_var_type type)
1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227
{
  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;
  }
}

1228
static void fix_max_binlog_size(THD *thd, enum_var_type type)
1229 1230 1231 1232 1233
{
  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);
1234
#ifdef HAVE_REPLICATION
1235 1236
  if (!max_relay_log_size)
    active_mi->rli.relay_log.set_max_size(max_binlog_size);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1237
#endif
1238 1239 1240
  DBUG_VOID_RETURN;
}

1241
static void fix_max_relay_log_size(THD *thd, enum_var_type type)
1242 1243 1244 1245
{
  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));
1246
#ifdef HAVE_REPLICATION
1247 1248
  active_mi->rli.relay_log.set_max_size(max_relay_log_size ?
                                        max_relay_log_size: max_binlog_size);
1249
#endif
1250 1251
  DBUG_VOID_RETURN;
}
1252

1253

1254 1255
static int check_max_delayed_threads(THD *thd, set_var *var)
{
monty@mishka.local's avatar
monty@mishka.local committed
1256
  longlong val= var->value->val_int();
1257
  if (var->type != OPT_GLOBAL && val != 0 &&
monty@mishka.local's avatar
monty@mishka.local committed
1258
      val != (longlong) global_system_variables.max_insert_delayed_threads)
1259 1260
  {
    char buf[64];
1261
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), var->var->name, llstr(val, buf));
1262 1263 1264 1265 1266
    return 1;
  }
  return 0;
}

1267
static void fix_max_connections(THD *thd, enum_var_type type)
1268
{
1269
#ifndef EMBEDDED_LIBRARY
1270 1271
  resize_thr_alarm(max_connections + 
		   global_system_variables.max_insert_delayed_threads + 10);
1272
#endif
1273 1274 1275 1276 1277 1278
}


static void fix_thd_mem_root(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
1279
    reset_root_defaults(thd->mem_root,
1280 1281 1282 1283 1284 1285 1286
                        thd->variables.query_alloc_block_size,
                        thd->variables.query_prealloc_size);
}


static void fix_trans_mem_root(THD *thd, enum_var_type type)
{
1287
#ifdef USING_TRANSACTIONS
1288 1289 1290 1291
  if (type != OPT_GLOBAL)
    reset_root_defaults(&thd->transaction.mem_root,
                        thd->variables.trans_alloc_block_size,
                        thd->variables.trans_prealloc_size);
1292
#endif
1293 1294
}

1295

1296 1297 1298 1299
static void fix_server_id(THD *thd, enum_var_type type)
{
  server_id_supplied = 1;
}
1300

svoj@mysql.com's avatar
svoj@mysql.com committed
1301 1302 1303 1304 1305 1306
bool sys_var_long_ptr::check(THD *thd, set_var *var)
{
  longlong v= var->value->val_int();
  var->save_result.ulonglong_value= v < 0 ? 0 : v;
  return 0;
}
1307

1308 1309
bool sys_var_long_ptr::update(THD *thd, set_var *var)
{
1310
  ulonglong tmp= var->save_result.ulonglong_value;
1311
  pthread_mutex_lock(&LOCK_global_system_variables);
1312 1313 1314 1315
  if (option_limits)
    *value= (ulong) getopt_ull_limit_value(tmp, option_limits);
  else
    *value= (ulong) tmp;
1316
  pthread_mutex_unlock(&LOCK_global_system_variables);
1317 1318 1319 1320 1321 1322 1323 1324 1325 1326
  return 0;
}


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


1327 1328
bool sys_var_ulonglong_ptr::update(THD *thd, set_var *var)
{
1329
  ulonglong tmp= var->save_result.ulonglong_value;
1330
  pthread_mutex_lock(&LOCK_global_system_variables);
1331 1332 1333 1334
  if (option_limits)
    *value= (ulonglong) getopt_ull_limit_value(tmp, option_limits);
  else
    *value= (ulonglong) tmp;
1335
  pthread_mutex_unlock(&LOCK_global_system_variables);
1336 1337 1338 1339 1340 1341
  return 0;
}


void sys_var_ulonglong_ptr::set_default(THD *thd, enum_var_type type)
{
1342
  pthread_mutex_lock(&LOCK_global_system_variables);
1343
  *value= (ulonglong) option_limits->def_value;
1344
  pthread_mutex_unlock(&LOCK_global_system_variables);
1345 1346 1347
}


1348 1349 1350 1351 1352 1353 1354 1355 1356 1357 1358 1359 1360
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;
}


1361 1362 1363 1364 1365 1366 1367
bool sys_var_enum::update(THD *thd, set_var *var)
{
  *value= (uint) var->save_result.ulong_value;
  return 0;
}


1368
byte *sys_var_enum::value_ptr(THD *thd, enum_var_type type, LEX_STRING *base)
1369 1370 1371 1372
{
  return (byte*) enum_names->type_names[*value];
}

1373 1374 1375 1376 1377
bool sys_var_thd_ulong::check(THD *thd, set_var *var)
{
  return (sys_var_thd::check(thd, var) ||
          (check_func && (*check_func)(thd, var)));
}
1378

1379 1380
bool sys_var_thd_ulong::update(THD *thd, set_var *var)
{
1381
  ulonglong tmp= var->save_result.ulonglong_value;
1382 1383 1384 1385 1386

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

1387 1388 1389 1390 1391 1392
#if SIZEOF_LONG == 4
  /* Avoid overflows on 32 bit systems */
  if (tmp > (ulonglong) ~(ulong) 0)
    tmp= ((ulonglong) ~(ulong) 0);
#endif

1393 1394 1395
  if (option_limits)
    tmp= (ulong) getopt_ull_limit_value(tmp, option_limits);
  if (var->type == OPT_GLOBAL)
1396
    global_system_variables.*offset= (ulong) tmp;
1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414
  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;
}


1415 1416
byte *sys_var_thd_ulong::value_ptr(THD *thd, enum_var_type type,
				   LEX_STRING *base)
1417 1418 1419 1420 1421 1422 1423
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}


1424 1425
bool sys_var_thd_ha_rows::update(THD *thd, set_var *var)
{
1426
  ulonglong tmp= var->save_result.ulonglong_value;
1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460

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


1461 1462
byte *sys_var_thd_ha_rows::value_ptr(THD *thd, enum_var_type type,
				     LEX_STRING *base)
1463 1464 1465 1466 1467 1468
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}

1469 1470
bool sys_var_thd_ulonglong::update(THD *thd,  set_var *var)
{
1471
  ulonglong tmp= var->save_result.ulonglong_value;
1472

1473
  if (tmp > max_system_variables.*offset)
1474 1475 1476
    tmp= max_system_variables.*offset;

  if (option_limits)
1477
    tmp= getopt_ull_limit_value(tmp, option_limits);
1478
  if (var->type == OPT_GLOBAL)
1479 1480 1481
  {
    /* Lock is needed to make things safe on 32 bit systems */
    pthread_mutex_lock(&LOCK_global_system_variables);
1482
    global_system_variables.*offset= (ulonglong) tmp;
1483 1484
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
1485
  else
1486
    thd->variables.*offset= (ulonglong) tmp;
1487 1488 1489 1490 1491 1492 1493
  return 0;
}


void sys_var_thd_ulonglong::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
1494 1495
  {
    pthread_mutex_lock(&LOCK_global_system_variables);
1496
    global_system_variables.*offset= (ulonglong) option_limits->def_value;
1497 1498
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
1499 1500 1501 1502 1503
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1504 1505
byte *sys_var_thd_ulonglong::value_ptr(THD *thd, enum_var_type type,
				       LEX_STRING *base)
1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}


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


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


1532 1533
byte *sys_var_thd_bool::value_ptr(THD *thd, enum_var_type type,
				  LEX_STRING *base)
1534 1535 1536 1537 1538 1539 1540 1541 1542
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}


bool sys_var::check_enum(THD *thd, set_var *var, TYPELIB *enum_names)
{
1543
  char buff[STRING_BUFFER_USUAL_SIZE];
1544
  const char *value;
1545
  String str(buff, sizeof(buff), system_charset_info), *res;
1546 1547 1548 1549 1550

  if (var->value->result_type() == STRING_RESULT)
  {
    if (!(res=var->value->val_str(&str)) ||
	((long) (var->save_result.ulong_value=
1551 1552
		 (ulong) find_type(enum_names, res->ptr(),
				   res->length(),1)-1)) < 0)
1553
    {
1554
      value= res ? res->c_ptr() : "NULL";
1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570 1571
      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:
1572
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, value);
1573 1574 1575
  return 1;
}

1576 1577 1578

bool sys_var::check_set(THD *thd, set_var *var, TYPELIB *enum_names)
{
1579
  bool not_used;
1580
  char buff[STRING_BUFFER_USUAL_SIZE], *error= 0;
1581 1582 1583 1584 1585 1586
  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)))
1587
    {
1588
      strmov(buff, "NULL");
1589
      goto err;
1590
    }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1591 1592
    var->save_result.ulong_value= ((ulong)
				   find_set(enum_names, res->c_ptr(),
1593 1594 1595
					    res->length(),
                                            NULL,
                                            &error, &error_len,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1596
					    &not_used));
1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615
    if (error_len)
    {
      strmake(buff, error, min(sizeof(buff), error_len));
      goto err;
    }
  }
  else
  {
    ulonglong tmp= var->value->val_int();
    if (tmp >= enum_names->count)
    {
      llstr(tmp, buff);
      goto err;
    }
    var->save_result.ulong_value= (ulong) tmp;  // Save for update
  }
  return 0;

err:
1616
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, buff);
1617 1618 1619 1620
  return 1;
}


1621 1622 1623 1624 1625
/*
  Return an Item for a variable.  Used with @@[global.]variable_name
  If type is not given, return local value if exists, else global
*/

1626
Item *sys_var::item(THD *thd, enum_var_type var_type, LEX_STRING *base)
1627 1628 1629 1630 1631
{
  if (check_type(var_type))
  {
    if (var_type != OPT_DEFAULT)
    {
1632 1633
      my_error(ER_INCORRECT_GLOBAL_LOCAL_VAR, MYF(0),
               name, var_type == OPT_GLOBAL ? "SESSION" : "GLOBAL");
1634 1635 1636 1637 1638 1639
      return 0;
    }
    /* As there was no local variable, return the global value */
    var_type= OPT_GLOBAL;
  }
  switch (type()) {
1640 1641 1642 1643 1644 1645
  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);
1646
    return new Item_uint((ulonglong) value);
1647
  }
1648
  case SHOW_LONG:
1649 1650 1651 1652 1653
  {
    ulong value;
    pthread_mutex_lock(&LOCK_global_system_variables);
    value= *(ulong*) value_ptr(thd, var_type, base);
    pthread_mutex_unlock(&LOCK_global_system_variables);
1654
    return new Item_uint((ulonglong) value);
1655
  }
1656
  case SHOW_LONGLONG:
1657 1658 1659
  {
    longlong value;
    pthread_mutex_lock(&LOCK_global_system_variables);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1660
    value= *(longlong*) value_ptr(thd, var_type, base);
1661 1662 1663
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return new Item_int(value);
  }
1664
  case SHOW_HA_ROWS:
1665 1666 1667
  {
    ha_rows value;
    pthread_mutex_lock(&LOCK_global_system_variables);
monty@narttu.mysql.fi's avatar
monty@narttu.mysql.fi committed
1668
    value= *(ha_rows*) value_ptr(thd, var_type, base);
1669 1670 1671
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return new Item_int((longlong) value);
  }
1672
  case SHOW_MY_BOOL:
1673
    return new Item_int((int32) *(my_bool*) value_ptr(thd, var_type, base),1);
1674 1675
  case SHOW_CHAR:
  {
bar@mysql.com's avatar
bar@mysql.com committed
1676
    Item *tmp;
1677
    pthread_mutex_lock(&LOCK_global_system_variables);
1678
    char *str= (char*) value_ptr(thd, var_type, base);
bar@mysql.com's avatar
bar@mysql.com committed
1679 1680 1681 1682 1683 1684 1685 1686
    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);
    }
1687 1688
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return tmp;
1689 1690
  }
  default:
1691
    my_error(ER_VAR_CANT_BE_READ, MYF(0), name);
1692 1693 1694 1695 1696 1697 1698 1699 1700 1701 1702 1703 1704 1705 1706 1707 1708 1709 1710 1711 1712 1713 1714 1715
  }
  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;
}


1716 1717
byte *sys_var_thd_enum::value_ptr(THD *thd, enum_var_type type,
				  LEX_STRING *base)
1718 1719 1720 1721 1722 1723 1724
{
  ulong tmp= ((type == OPT_GLOBAL) ?
	      global_system_variables.*offset :
	      thd->variables.*offset);
  return (byte*) enum_names->type_names[tmp];
}

1725 1726 1727 1728 1729
bool sys_var_thd_bit::check(THD *thd, set_var *var)
{
  return (check_enum(thd, var, &bool_typelib) ||
          (check_func && (*check_func)(thd, var)));
}
1730 1731 1732

bool sys_var_thd_bit::update(THD *thd, set_var *var)
{
1733
  int res= (*update_func)(thd, var);
1734 1735 1736 1737
  return res;
}


1738 1739
byte *sys_var_thd_bit::value_ptr(THD *thd, enum_var_type type,
				 LEX_STRING *base)
1740 1741 1742 1743 1744 1745 1746 1747 1748 1749 1750
{
  /*
    If reverse is 0 (default) return 1 if bit is set.
    If reverse is 1, return 0 if bit is set
  */
  thd->sys_var_tmp.my_bool_value= ((thd->options & bit_flag) ?
				   !reverse : reverse);
  return (byte*) &thd->sys_var_tmp.my_bool_value;
}


1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761 1762 1763 1764 1765 1766 1767 1768 1769 1770 1771 1772 1773 1774 1775 1776 1777 1778 1779 1780 1781 1782 1783 1784 1785 1786 1787 1788 1789 1790 1791 1792
/* Update a date_time format variable based on given value */

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

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


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


bool sys_var_thd_date_time_format::check(THD *thd, set_var *var)
{
1793
  char buff[STRING_BUFFER_USUAL_SIZE];
1794 1795 1796 1797 1798 1799 1800 1801 1802
  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())))
  {
1803
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, res->c_ptr());
1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821 1822 1823 1824 1825 1826 1827 1828 1829 1830 1831 1832 1833 1834 1835 1836 1837 1838 1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856
    return 1;
  }
  
  /*
    We must copy result to thread space to not get a memory leak if
    update is aborted
  */
  var->save_result.date_time_format= date_time_format_copy(thd, format);
  my_free((char*) format, MYF(0));
  return var->save_result.date_time_format == 0;
}


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

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

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


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


1857 1858
typedef struct old_names_map_st
{
1859 1860 1861
  const char *old_name;
  const char *new_name;
} my_old_conv;
1862

1863 1864
static my_old_conv old_conv[]= 
{
1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875
  {	"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		}
1876
};
1877

1878
CHARSET_INFO *get_old_charset_by_name(const char *name)
1879
{
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1880
  my_old_conv *conv;
1881
 
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1882
  for (conv= old_conv; conv->old_name; conv++)
1883
  {
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1884 1885
    if (!my_strcasecmp(&my_charset_latin1, name, conv->old_name))
      return get_charset_by_csname(conv->new_name, MY_CS_PRIMARY, MYF(0));
1886
  }
1887
  return NULL;
1888 1889
}

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1890

1891
bool sys_var_collation::check(THD *thd, set_var *var)
1892 1893 1894
{
  CHARSET_INFO *tmp;

1895
  if (var->value->result_type() == STRING_RESULT)
1896
  {
1897
    char buff[STRING_BUFFER_USUAL_SIZE];
1898 1899 1900
    String str(buff,sizeof(buff), system_charset_info), *res;
    if (!(res=var->value->val_str(&str)))
    {
1901
      my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, "NULL");
1902 1903 1904 1905
      return 1;
    }
    if (!(tmp=get_charset_by_name(res->c_ptr(),MYF(0))))
    {
1906
      my_error(ER_UNKNOWN_COLLATION, MYF(0), res->c_ptr());
1907 1908
      return 1;
    }
1909
  }
1910
  else // INT_RESULT
1911
  {
1912
    if (!(tmp=get_charset((int) var->value->val_int(),MYF(0))))
1913 1914
    {
      char buf[20];
1915
      int10_to_str((int) var->value->val_int(), buf, -10);
1916
      my_error(ER_UNKNOWN_COLLATION, MYF(0), buf);
1917 1918
      return 1;
    }
1919 1920 1921 1922 1923
  }
  var->save_result.charset= tmp;	// Save for update
  return 0;
}

1924

1925 1926 1927 1928
bool sys_var_character_set::check(THD *thd, set_var *var)
{
  CHARSET_INFO *tmp;

1929 1930
  if (var->value->result_type() == STRING_RESULT)
  {
1931
    char buff[STRING_BUFFER_USUAL_SIZE];
1932 1933
    String str(buff,sizeof(buff), system_charset_info), *res;
    if (!(res=var->value->val_str(&str)))
1934
    {
1935 1936
      if (!nullable)
      {
1937
        my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, "NULL");
1938 1939 1940 1941 1942 1943 1944
        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())))
    {
1945
      my_error(ER_UNKNOWN_CHARACTER_SET, MYF(0), res->c_ptr());
1946 1947 1948
      return 1;
    }
  }
1949
  else // INT_RESULT
1950
  {
1951
    if (!(tmp=get_charset((int) var->value->val_int(),MYF(0))))
1952 1953
    {
      char buf[20];
1954
      int10_to_str((int) var->value->val_int(), buf, -10);
1955 1956 1957
      my_error(ER_UNKNOWN_CHARACTER_SET, MYF(0), buf);
      return 1;
    }
1958 1959 1960 1961 1962
  }
  var->save_result.charset= tmp;	// Save for update
  return 0;
}

1963

1964
bool sys_var_character_set::update(THD *thd, set_var *var)
1965
{
1966
  ci_ptr(thd,var->type)[0]= var->save_result.charset;
bar@bar.mysql.r18.ru's avatar
bar@bar.mysql.r18.ru committed
1967
  thd->update_charset();
1968 1969 1970
  return 0;
}

1971 1972 1973

byte *sys_var_character_set::value_ptr(THD *thd, enum_var_type type,
				       LEX_STRING *base)
1974
{
1975
  CHARSET_INFO *cs= ci_ptr(thd,type)[0];
bar@mysql.com's avatar
bar@mysql.com committed
1976
  return cs ? (byte*) cs->csname : (byte*) NULL;
1977 1978
}

1979

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

1989 1990 1991

void sys_var_character_set_connection::set_default(THD *thd,
						   enum_var_type type)
1992 1993 1994 1995
{
 if (type == OPT_GLOBAL)
   global_system_variables.collation_connection= default_charset_info;
 else
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1996
 {
1997
   thd->variables.collation_connection= global_system_variables.collation_connection;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1998 1999
   thd->update_charset();
 }
2000 2001
}

2002

2003 2004
CHARSET_INFO ** sys_var_character_set_client::ci_ptr(THD *thd,
						     enum_var_type type)
2005 2006 2007 2008 2009 2010 2011
{
  if (type == OPT_GLOBAL)
    return &global_system_variables.character_set_client;
  else
    return &thd->variables.character_set_client;
}

2012

2013
void sys_var_character_set_client::set_default(THD *thd, enum_var_type type)
2014 2015
{
 if (type == OPT_GLOBAL)
2016
   global_system_variables.character_set_client= default_charset_info;
2017
 else
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2018 2019 2020 2021 2022
 {
   thd->variables.character_set_client= (global_system_variables.
					 character_set_client);
   thd->update_charset();
 }
2023
}
2024

2025

2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051
CHARSET_INFO **
sys_var_character_set_filesystem::ci_ptr(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
    return &global_system_variables.character_set_filesystem;
  else
    return &thd->variables.character_set_filesystem;
}


extern CHARSET_INFO *character_set_filesystem;

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


monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2052 2053
CHARSET_INFO **
sys_var_character_set_results::ci_ptr(THD *thd, enum_var_type type)
2054
{
2055 2056
  if (type == OPT_GLOBAL)
    return &global_system_variables.character_set_results;
2057
  else
2058
    return &thd->variables.character_set_results;
2059 2060
}

2061

2062
void sys_var_character_set_results::set_default(THD *thd, enum_var_type type)
2063
{
2064
 if (type == OPT_GLOBAL)
2065
   global_system_variables.character_set_results= default_charset_info;
2066
 else
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2067 2068 2069 2070 2071
 {
   thd->variables.character_set_results= (global_system_variables.
					  character_set_results);
   thd->update_charset();
 }
2072 2073
}

2074

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2075 2076
CHARSET_INFO **
sys_var_character_set_server::ci_ptr(THD *thd, enum_var_type type)
2077 2078
{
  if (type == OPT_GLOBAL)
2079
    return &global_system_variables.collation_server;
2080
  else
2081
    return &thd->variables.collation_server;
2082 2083
}

2084

2085
void sys_var_character_set_server::set_default(THD *thd, enum_var_type type)
2086 2087
{
 if (type == OPT_GLOBAL)
2088
   global_system_variables.collation_server= default_charset_info;
2089
 else
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2090
 {
2091
   thd->variables.collation_server= global_system_variables.collation_server;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2092 2093
   thd->update_charset();
 }
2094 2095
}

2096 2097
CHARSET_INFO ** sys_var_character_set_database::ci_ptr(THD *thd,
						       enum_var_type type)
2098 2099
{
  if (type == OPT_GLOBAL)
2100
    return &global_system_variables.collation_database;
2101
  else
2102
    return &thd->variables.collation_database;
2103 2104
}

2105

2106 2107 2108
void sys_var_character_set_database::set_default(THD *thd, enum_var_type type)
{
 if (type == OPT_GLOBAL)
2109
    global_system_variables.collation_database= default_charset_info;
2110
  else
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2111
  {
2112
    thd->variables.collation_database= thd->db_charset;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2113 2114
    thd->update_charset();
  }
2115 2116
}

2117

2118
bool sys_var_collation_connection::update(THD *thd, set_var *var)
2119 2120
{
  if (var->type == OPT_GLOBAL)
2121
    global_system_variables.collation_connection= var->save_result.charset;
2122
  else
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2123
  {
2124
    thd->variables.collation_connection= var->save_result.charset;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2125 2126
    thd->update_charset();
  }
2127 2128 2129
  return 0;
}

2130 2131 2132

byte *sys_var_collation_connection::value_ptr(THD *thd, enum_var_type type,
					      LEX_STRING *base)
2133 2134
{
  CHARSET_INFO *cs= ((type == OPT_GLOBAL) ?
2135 2136 2137
		  global_system_variables.collation_connection :
		  thd->variables.collation_connection);
  return cs ? (byte*) cs->name : (byte*) "NULL";
2138 2139
}

2140

2141
void sys_var_collation_connection::set_default(THD *thd, enum_var_type type)
2142 2143
{
 if (type == OPT_GLOBAL)
2144
   global_system_variables.collation_connection= default_charset_info;
2145
 else
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2146 2147 2148 2149 2150
 {
   thd->variables.collation_connection= (global_system_variables.
					 collation_connection);
   thd->update_charset();
 }
2151 2152
}

2153 2154 2155 2156 2157 2158 2159 2160 2161 2162 2163 2164 2165 2166 2167 2168 2169 2170 2171 2172 2173 2174 2175 2176 2177 2178 2179 2180 2181 2182 2183 2184 2185 2186 2187 2188 2189 2190 2191 2192 2193 2194 2195 2196 2197 2198 2199 2200 2201 2202 2203 2204 2205 2206 2207 2208 2209 2210 2211 2212 2213 2214 2215 2216 2217 2218 2219 2220 2221 2222 2223
bool sys_var_collation_database::update(THD *thd, set_var *var)
{
  if (var->type == OPT_GLOBAL)
    global_system_variables.collation_database= var->save_result.charset;
  else
  {
    thd->variables.collation_database= var->save_result.charset;
    thd->update_charset();
  }
  return 0;
}


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


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


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


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


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

2224

2225
LEX_STRING default_key_cache_base= {(char *) "default", 7 };
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2226

2227
static KEY_CACHE zero_key_cache;
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2228

2229
KEY_CACHE *get_key_cache(LEX_STRING *cache_name)
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2230
{
2231 2232
  safe_mutex_assert_owner(&LOCK_global_system_variables);
  if (!cache_name || ! cache_name->length)
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2233
    cache_name= &default_key_cache_base;
2234
  return ((KEY_CACHE*) find_named(&key_caches,
2235
                                      cache_name->str, cache_name->length, 0));
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2236 2237
}

2238

igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2239 2240
byte *sys_var_key_cache_param::value_ptr(THD *thd, enum_var_type type,
					 LEX_STRING *base)
2241
{
2242
  KEY_CACHE *key_cache= get_key_cache(base);
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2243 2244 2245 2246
  if (!key_cache)
    key_cache= &zero_key_cache;
  return (byte*) key_cache + offset ;
}
2247

2248

2249 2250
bool sys_var_key_buffer_size::update(THD *thd, set_var *var)
{
2251
  ulonglong tmp= var->save_result.ulonglong_value;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2252
  LEX_STRING *base_name= &var->base;
2253
  KEY_CACHE *key_cache;
2254 2255 2256
  bool error= 0;

  /* If no basename, assume it's for the key cache named 'default' */
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2257
  if (!base_name->length)
2258
    base_name= &default_key_cache_base;
2259 2260 2261

  pthread_mutex_lock(&LOCK_global_system_variables);
  key_cache= get_key_cache(base_name);
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2262
                            
2263 2264
  if (!key_cache)
  {
2265
    /* Key cache didn't exists */
2266
    if (!tmp)					// Tried to delete cache
2267 2268 2269 2270 2271 2272
      goto end;					// Ok, nothing to do
    if (!(key_cache= create_key_cache(base_name->str, base_name->length)))
    {
      error= 1;
      goto end;
    }
2273
  }
2274 2275 2276 2277 2278 2279 2280 2281 2282

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

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2283
  if (!tmp)					// Zero size means delete
2284
  {
timour@mysql.com's avatar
timour@mysql.com committed
2285
    if (key_cache == dflt_key_cache)
2286 2287 2288 2289
    {
      push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_WARN,
                          ER_WARN_CANT_DROP_DEFAULT_KEYCACHE,
                          ER(ER_WARN_CANT_DROP_DEFAULT_KEYCACHE));
2290
      goto end;					// Ignore default key cache
2291
    }
2292

2293
    if (key_cache->key_cache_inited)		// If initied
2294 2295
    {
      /*
2296 2297
	Move tables using this key cache to the default key cache
	and clear the old key cache.
2298
      */
2299
      NAMED_LIST *list; 
2300
      key_cache= (KEY_CACHE *) find_named(&key_caches, base_name->str,
2301
					      base_name->length, &list);
2302 2303
      key_cache->in_init= 1;
      pthread_mutex_unlock(&LOCK_global_system_variables);
timour@mysql.com's avatar
timour@mysql.com committed
2304
      error= reassign_keycache_tables(thd, key_cache, dflt_key_cache);
2305 2306
      pthread_mutex_lock(&LOCK_global_system_variables);
      key_cache->in_init= 0;
2307
    }
2308 2309 2310 2311 2312
    /*
      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;
2313 2314
  }

2315 2316
  key_cache->param_buff_size=
    (ulonglong) getopt_ull_limit_value(tmp, option_limits);
2317

2318 2319 2320 2321
  /* If key cache didn't existed initialize it, else resize it */
  key_cache->in_init= 1;
  pthread_mutex_unlock(&LOCK_global_system_variables);

2322
  if (!key_cache->key_cache_inited)
2323
    error= (bool) (ha_init_key_cache("", key_cache));
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2324
  else
2325
    error= (bool)(ha_resize_key_cache(key_cache));
2326

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

2330 2331 2332
end:
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return error;
2333 2334
}

2335 2336

bool sys_var_key_cache_long::update(THD *thd, set_var *var)
2337
{
monty@mysql.com's avatar
monty@mysql.com committed
2338
  ulong tmp= (ulong) var->value->val_int();
2339
  LEX_STRING *base_name= &var->base;
2340 2341
  bool error= 0;

2342
  if (!base_name->length)
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2343
    base_name= &default_key_cache_base;
2344 2345

  pthread_mutex_lock(&LOCK_global_system_variables);
2346
  KEY_CACHE *key_cache= get_key_cache(base_name);
2347

igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2348 2349
  if (!key_cache && !(key_cache= create_key_cache(base_name->str,
				                  base_name->length)))
2350 2351 2352 2353
  {
    error= 1;
    goto end;
  }
2354

2355 2356 2357 2358 2359 2360 2361 2362 2363
  /*
    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))=
2364
    (ulong) getopt_ull_limit_value(tmp, option_limits);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2365

2366 2367 2368 2369 2370
  /*
    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;
2371

2372
  pthread_mutex_unlock(&LOCK_global_system_variables);
2373

2374 2375 2376 2377 2378 2379 2380 2381
  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;
2382 2383
}

2384

2385 2386 2387 2388
/*****************************************************************************
  Functions to handle SET NAMES and SET CHARACTER SET
*****************************************************************************/

2389
int set_var_collation_client::check(THD *thd)
2390 2391 2392 2393
{
  return 0;
}

2394
int set_var_collation_client::update(THD *thd)
2395
{
2396 2397
  thd->variables.character_set_client= character_set_client;
  thd->variables.character_set_results= character_set_results;
2398
  thd->variables.collation_connection= collation_connection;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2399
  thd->update_charset();
2400 2401 2402 2403 2404 2405 2406
  thd->protocol_simple.init(thd);
  thd->protocol_prep.init(thd);
  return 0;
}

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

2407 2408
bool sys_var_timestamp::update(THD *thd,  set_var *var)
{
2409
  thd->set_time((time_t) var->save_result.ulonglong_value);
2410 2411 2412 2413 2414 2415 2416 2417 2418 2419
  return 0;
}


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


2420 2421
byte *sys_var_timestamp::value_ptr(THD *thd, enum_var_type type,
				   LEX_STRING *base)
2422 2423 2424 2425 2426 2427 2428 2429
{
  thd->sys_var_tmp.long_value= (long) thd->start_time;
  return (byte*) &thd->sys_var_tmp.long_value;
}


bool sys_var_last_insert_id::update(THD *thd, set_var *var)
{
2430
  thd->insert_id(var->save_result.ulonglong_value);
2431 2432 2433 2434
  return 0;
}


2435 2436
byte *sys_var_last_insert_id::value_ptr(THD *thd, enum_var_type type,
					LEX_STRING *base)
2437 2438 2439 2440 2441 2442 2443 2444
{
  thd->sys_var_tmp.long_value= (long) thd->insert_id();
  return (byte*) &thd->last_insert_id;
}


bool sys_var_insert_id::update(THD *thd, set_var *var)
{
2445
  thd->next_insert_id= var->save_result.ulonglong_value;
2446 2447 2448 2449
  return 0;
}


2450 2451
byte *sys_var_insert_id::value_ptr(THD *thd, enum_var_type type,
				   LEX_STRING *base)
2452 2453 2454 2455 2456
{
  return (byte*) &thd->current_insert_id;
}


hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2457
#ifdef HAVE_REPLICATION
2458 2459
bool sys_var_slave_skip_counter::check(THD *thd, set_var *var)
{
2460
  int result= 0;
2461
  pthread_mutex_lock(&LOCK_active_mi);
2462 2463 2464
  pthread_mutex_lock(&active_mi->rli.run_lock);
  if (active_mi->rli.slave_running)
  {
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2465
    my_message(ER_SLAVE_MUST_STOP, ER(ER_SLAVE_MUST_STOP), MYF(0));
2466 2467 2468
    result=1;
  }
  pthread_mutex_unlock(&active_mi->rli.run_lock);
2469
  pthread_mutex_unlock(&LOCK_active_mi);
2470
  var->save_result.ulong_value= (ulong) var->value->val_int();
2471 2472 2473 2474 2475 2476
  return result;
}


bool sys_var_slave_skip_counter::update(THD *thd, set_var *var)
{
2477
  pthread_mutex_lock(&LOCK_active_mi);
2478 2479 2480 2481 2482 2483 2484 2485 2486
  pthread_mutex_lock(&active_mi->rli.run_lock);
  /*
    The following test should normally never be true as we test this
    in the check function;  To be safe against multiple
    SQL_SLAVE_SKIP_COUNTER request, we do the check anyway
  */
  if (!active_mi->rli.slave_running)
  {
    pthread_mutex_lock(&active_mi->rli.data_lock);
2487
    active_mi->rli.slave_skip_counter= var->save_result.ulong_value;
2488 2489 2490
    pthread_mutex_unlock(&active_mi->rli.data_lock);
  }
  pthread_mutex_unlock(&active_mi->rli.run_lock);
2491
  pthread_mutex_unlock(&LOCK_active_mi);
2492 2493
  return 0;
}
2494 2495 2496 2497 2498


bool sys_var_sync_binlog_period::update(THD *thd, set_var *var)
{
  pthread_mutex_t *lock_log= mysql_bin_log.get_log_lock();
2499
  sync_binlog_period= (ulong) var->save_result.ulonglong_value;
2500
  return 0;
2501
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
2502
#endif /* HAVE_REPLICATION */
2503

2504 2505
bool sys_var_rand_seed1::update(THD *thd, set_var *var)
{
2506
  thd->rand.seed1= (ulong) var->save_result.ulonglong_value;
2507 2508 2509 2510 2511
  return 0;
}

bool sys_var_rand_seed2::update(THD *thd, set_var *var)
{
2512
  thd->rand.seed2= (ulong) var->save_result.ulonglong_value;
2513 2514 2515 2516
  return 0;
}


2517 2518
bool sys_var_thd_time_zone::check(THD *thd, set_var *var)
{
2519
  char buff[MAX_TIME_ZONE_NAME_LENGTH];
2520 2521 2522
  String str(buff, sizeof(buff), &my_charset_latin1);
  String *res= var->value->val_str(&str);

2523
  if (!(var->save_result.time_zone=
2524
        my_tz_find(res, thd->lex->time_zone_tables_used)))
2525
  {
2526
    my_error(ER_UNKNOWN_TIME_ZONE, MYF(0), res ? res->c_ptr() : "NULL");
2527 2528 2529 2530 2531 2532 2533 2534
    return 1;
  }
  return 0;
}


bool sys_var_thd_time_zone::update(THD *thd, set_var *var)
{
2535 2536 2537 2538 2539 2540 2541 2542 2543
  /* 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;
2544 2545 2546 2547 2548 2549 2550 2551 2552 2553 2554 2555
  return 0;
}


byte *sys_var_thd_time_zone::value_ptr(THD *thd, enum_var_type type,
				       LEX_STRING *base)
{
  /* 
    We can use ptr() instead of c_ptr() here because String contaning
    time zone name is guaranteed to be zero ended.
  */
  if (type == OPT_GLOBAL)
2556
    return (byte *)(global_system_variables.time_zone->get_name()->ptr());
2557
  else
2558 2559 2560 2561 2562 2563 2564 2565 2566 2567
  {
    /*
      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;
2568
    return (byte *)(thd->variables.time_zone->get_name()->ptr());
2569
  }
2570 2571 2572 2573 2574
}


void sys_var_thd_time_zone::set_default(THD *thd, enum_var_type type)
{
2575
 pthread_mutex_lock(&LOCK_global_system_variables);
2576 2577 2578 2579 2580
 if (type == OPT_GLOBAL)
 {
   if (default_tz_name)
   {
     String str(default_tz_name, &my_charset_latin1);
2581 2582 2583 2584
     /*
       We are guaranteed to find this time zone since its existence
       is checked during start-up.
     */
2585 2586
     global_system_variables.time_zone=
       my_tz_find(&str, thd->lex->time_zone_tables_used);
2587 2588 2589 2590 2591 2592
   }
   else
     global_system_variables.time_zone= my_tz_SYSTEM;
 }
 else
   thd->variables.time_zone= global_system_variables.time_zone;
2593
 pthread_mutex_unlock(&LOCK_global_system_variables);
2594 2595
}

2596 2597 2598 2599 2600 2601 2602 2603 2604 2605 2606 2607 2608 2609 2610 2611 2612 2613 2614 2615

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.
      QQ: May be we should have a separate error message for this?
    */
    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);
2616
  max_user_connections= (uint)var->save_result.ulonglong_value;
2617 2618 2619 2620 2621 2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639 2640
  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);
}


byte *sys_var_max_user_conn::value_ptr(THD *thd, enum_var_type type,
                                       LEX_STRING *base)
{
  if (type != OPT_GLOBAL &&
      thd->user_connect && thd->user_connect->user_resources.user_conn)
    return (byte*) &(thd->user_connect->user_resources.user_conn);
  return (byte*) &(max_user_connections);
}


2641 2642 2643 2644 2645 2646
/*
  Functions to update thd->options bits
*/

static bool set_option_bit(THD *thd, set_var *var)
{
2647 2648 2649
  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;
2650
  else
2651
    thd->options|= sys_var->bit_flag;
2652 2653 2654 2655 2656 2657 2658 2659 2660 2661 2662 2663 2664 2665 2666 2667 2668 2669 2670 2671 2672 2673 2674 2675 2676 2677 2678 2679 2680 2681 2682 2683 2684 2685
  return 0;
}


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

  ulong org_options=thd->options;

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

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

2686 2687 2688
static int check_log_update(THD *thd, set_var *var)
{
#ifndef NO_EMBEDDED_ACCESS_CHECKS
2689
  if (!(thd->security_ctx->master_access & SUPER_ACL))
2690 2691 2692 2693 2694 2695 2696
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
#endif
  return 0;
}
2697 2698 2699

static bool set_log_update(THD *thd, set_var *var)
{
2700 2701 2702 2703 2704 2705
  /*
    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
  */
    
2706
  if (opt_sql_bin_update)
2707
  {
2708 2709
    ((sys_var_thd_bit*) var->var)->bit_flag|= (OPTION_BIN_LOG |
					       OPTION_UPDATE_LOG);
2710 2711 2712 2713 2714 2715 2716 2717
    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));
2718 2719 2720 2721
  set_option_bit(thd, var);
  return 0;
}

2722
static bool set_log_bin(THD *thd, set_var *var)
2723 2724 2725 2726 2727 2728 2729 2730
{
  if (opt_sql_bin_update)
    ((sys_var_thd_bit*) var->var)->bit_flag|= (OPTION_BIN_LOG |
					       OPTION_UPDATE_LOG);
  set_option_bit(thd, var);
  return 0;
}

2731 2732 2733 2734
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
2735
  if (thd->security_ctx->master_access & SUPER_ACL)
2736 2737 2738 2739 2740 2741 2742 2743 2744 2745
    return 0;
  else
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
#else
  return 0;
#endif
}
2746

2747 2748 2749 2750 2751 2752 2753 2754 2755 2756 2757 2758 2759 2760 2761
static byte *get_warning_count(THD *thd)
{
  thd->sys_var_tmp.long_value=
    (thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_NOTE] +
     thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_WARN]);
  return (byte*) &thd->sys_var_tmp.long_value;
}

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

2762 2763 2764 2765 2766 2767 2768 2769 2770 2771 2772 2773 2774 2775 2776 2777 2778 2779 2780 2781 2782 2783 2784 2785 2786 2787 2788 2789 2790 2791 2792 2793 2794 2795 2796 2797 2798 2799 2800 2801 2802 2803 2804 2805 2806 2807 2808 2809 2810 2811 2812 2813 2814 2815 2816 2817 2818 2819 2820

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

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

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

  RETURN VALUES
    0		Error
    ptr		pointer to option structure
*/

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


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

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


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


void set_var_init()
{
2821 2822 2823 2824 2825
  sys_var *var;

  hash_init(&system_variable_hash, system_charset_info, sys_var::sys_vars, 0,
	    0, (hash_get_key) get_sys_var_length, 0, 0);
  for (var= sys_var::first; var; var= var->next)
2826
  {
2827 2828 2829
    var->name_length= strlen(var->name);
    var->option_limits= find_option(my_long_options, var->name);
    my_hash_insert(&system_variable_hash, (byte*) var);
2830 2831 2832 2833 2834 2835 2836 2837 2838 2839 2840 2841 2842 2843 2844 2845 2846 2847 2848 2849 2850 2851 2852 2853 2854 2855 2856 2857 2858 2859 2860
  }
  /*
    Special cases
    Needed because MySQL can't find the limits for a variable it it has
    a different name than the command line option.
    As these variables are deprecated, this code will disappear soon...
  */
  sys_sql_max_join_size.option_limits= sys_max_join_size.option_limits;
}


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


/*
  Find a user set-table variable

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

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

2861
sys_var *find_sys_var(const char *str, uint length)
2862
{
2863 2864
  sys_var *var= (sys_var*) hash_search(&system_variable_hash,
				       (byte*) str,
2865 2866 2867
				       length ? length :
				       strlen(str));
  if (!var)
2868
    my_error(ER_UNKNOWN_SYSTEM_VARIABLE, MYF(0), (char*) str);
2869 2870 2871 2872 2873 2874 2875 2876 2877 2878 2879 2880 2881 2882 2883 2884 2885 2886 2887 2888 2889 2890
  return var;
}


/*
  Execute update of all variables

  SYNOPSIS

  sql_set
    THD		Thread id
    set_var	List of variables to update

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

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

    RETURN VALUE
    0	ok
2891 2892
    1	ERROR, message sent (normally no variables was updated)
    -1  ERROR, message not sent
2893 2894
*/

2895
int sql_set_variables(THD *thd, List<set_var_base> *var_list)
2896
{
2897
  int error;
2898
  List_iterator_fast<set_var_base> it(*var_list);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2899
  DBUG_ENTER("sql_set_variables");
2900 2901 2902 2903

  set_var_base *var;
  while ((var=it++))
  {
2904
    if ((error= var->check(thd)))
2905
      goto err;
2906
  }
2907
  if (!(error= test(thd->net.report_error)))
2908 2909 2910 2911 2912
  {
    it.rewind();
    while ((var= it++))
      error|= var->update(thd);         // Returns 0, -1 or 1
  }
2913

2914 2915
err:
  free_underlaid_joins(thd, &thd->lex->select_lex);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2916
  DBUG_RETURN(error);
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
/*
  Say if all variables set by a SET support the ONE_SHOT keyword (currently,
  only character set and collation do; later timezones will).

  SYNOPSIS

  not_all_support_one_shot
    set_var	List of variables to update

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

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

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


2950 2951 2952 2953
/*****************************************************************************
  Functions to handle SET mysql_internal_variable=const_expr
*****************************************************************************/

2954
int set_var::check(THD *thd)
2955
{
2956 2957 2958 2959 2960
  if (var->is_readonly())
  {
    my_error(ER_INCORRECT_GLOBAL_LOCAL_VAR, MYF(0), var->name, "read only");
    return -1;
  }
2961 2962
  if (var->check_type(type))
  {
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2963
    int err= type == OPT_GLOBAL ? ER_LOCAL_VARIABLE : ER_GLOBAL_VARIABLE;
2964
    my_error(err, MYF(0), var->name);
2965
    return -1;
2966 2967 2968 2969 2970 2971 2972 2973
  }
  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))
    {
2974
      my_error(ER_NO_DEFAULT, MYF(0), var->name);
2975
      return -1;
2976 2977 2978 2979
    }
    return 0;
  }

2980
  if ((!value->fixed &&
2981
       value->fix_fields(thd, &value)) || value->check_cols(1))
2982
    return -1;
2983 2984
  if (var->check_update_type(value->result_type()))
  {
2985
    my_error(ER_WRONG_TYPE_FOR_VAR, MYF(0), var->name);
2986
    return -1;
2987
  }
2988
  return var->check(thd, this) ? -1 : 0;
2989 2990 2991
}


bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
2992 2993 2994 2995 2996 2997 2998 2999 3000 3001 3002 3003
/*
  Check variable, but without assigning value (used by PS)

  SYNOPSIS
    set_var::light_check()
    thd		thread handler

  RETURN VALUE
    0	ok
    1	ERROR, message sent (normally no variables was updated)
    -1  ERROR, message not sent
*/
3004 3005 3006 3007
int set_var::light_check(THD *thd)
{
  if (var->check_type(type))
  {
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
3008
    int err= type == OPT_GLOBAL ? ER_LOCAL_VARIABLE : ER_GLOBAL_VARIABLE;
3009
    my_error(err, MYF(0), var->name);
3010 3011
    return -1;
  }
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
3012
  if (type == OPT_GLOBAL && check_global_access(thd, SUPER_ACL))
3013 3014
    return 1;

3015
  if (value && ((!value->fixed && value->fix_fields(thd, &value)) ||
3016
                value->check_cols(1)))
3017 3018 3019 3020 3021
    return -1;
  return 0;
}


3022
int set_var::update(THD *thd)
3023 3024 3025 3026
{
  if (!value)
    var->set_default(thd, type);
  else if (var->update(thd, this))
3027
    return -1;				// should never happen
3028 3029 3030 3031 3032 3033 3034 3035 3036 3037
  if (var->after_update)
    (*var->after_update)(thd, type);
  return 0;
}


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

3038
int set_var_user::check(THD *thd)
3039
{
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
3040 3041
  /*
    Item_func_set_user_var can't substitute something else on its place =>
3042
    0 can be passed as last argument (reference on item)
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
3043
  */
3044
  return (user_var_item->fix_fields(thd, (Item**) 0) ||
3045
	  user_var_item->check()) ? -1 : 0;
3046 3047 3048
}


bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
3049 3050 3051 3052 3053 3054 3055 3056 3057 3058 3059 3060
/*
  Check variable, but without assigning value (used by PS)

  SYNOPSIS
    set_var_user::light_check()
    thd		thread handler

  RETURN VALUE
    0	ok
    1	ERROR, message sent (normally no variables was updated)
    -1  ERROR, message not sent
*/
3061 3062 3063 3064 3065 3066
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)
  */
3067
  return (user_var_item->fix_fields(thd, (Item**) 0));
3068 3069 3070
}


3071
int set_var_user::update(THD *thd)
3072 3073 3074 3075
{
  if (user_var_item->update())
  {
    /* Give an error if it's not given already */
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
3076
    my_message(ER_SET_CONSTANTS_ONLY, ER(ER_SET_CONSTANTS_ONLY), MYF(0));
3077
    return -1;
3078 3079 3080 3081 3082 3083 3084 3085 3086
  }
  return 0;
}


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

3087
int set_var_password::check(THD *thd)
3088
{
hf@deer.(none)'s avatar
hf@deer.(none) committed
3089
#ifndef NO_EMBEDDED_ACCESS_CHECKS
3090
  if (!user->host.str)
3091
  {
3092
    if (*thd->security_ctx->priv_host != 0)
3093
    {
3094 3095
      user->host.str= (char *) thd->security_ctx->priv_host;
      user->host.length= strlen(thd->security_ctx->priv_host);
3096 3097 3098 3099 3100 3101 3102
    }
    else
    {
      user->host.str= (char *)"%";
      user->host.length= 1;
    }
  }
3103
  /* Returns 1 as the function sends error to client */
3104 3105
  return check_change_password(thd, user->host.str, user->user.str,
                               password, strlen(password)) ? 1 : 0;
3106
#else
hf@deer.(none)'s avatar
hf@deer.(none) committed
3107 3108
  return 0;
#endif
3109 3110
}

3111
int set_var_password::update(THD *thd)
3112
{
hf@deer.(none)'s avatar
hf@deer.(none) committed
3113
#ifndef NO_EMBEDDED_ACCESS_CHECKS
3114
  /* Returns 1 as the function sends error to client */
3115 3116
  return change_password(thd, user->host.str, user->user.str, password) ?
	  1 : 0;
hf@deer.(none)'s avatar
hf@deer.(none) committed
3117 3118 3119
#else
  return 0;
#endif
3120 3121
}

3122 3123 3124 3125
/****************************************************************************
 Functions to handle table_type
****************************************************************************/

3126 3127
/* Based upon sys_var::check_enum() */

3128
bool sys_var_thd_storage_engine::check(THD *thd, set_var *var)
3129
{
3130
  char buff[STRING_BUFFER_USUAL_SIZE];
3131 3132 3133 3134 3135
  const char *value;
  String str(buff, sizeof(buff), &my_charset_latin1), *res;

  if (var->value->result_type() == STRING_RESULT)
  {
3136 3137
    LEX_STRING name;
    handlerton *db_type;
3138
    if (!(res=var->value->val_str(&str)) ||
3139 3140 3141
        !(name.str= (char *)res->ptr()) || !(name.length= res->length()) ||
	!(var->save_result.hton= db_type= ha_resolve_by_name(thd, &name)) ||
        ha_checktype(thd, ha_legacy_type(db_type), 1, 0) != db_type)
3142 3143 3144 3145 3146 3147
    {
      value= res ? res->c_ptr() : "NULL";
      goto err;
    }
    return 0;
  }
monty@mysql.com's avatar
monty@mysql.com committed
3148
  value= "unknown";
3149 3150

err:
3151
  my_error(ER_UNKNOWN_STORAGE_ENGINE, MYF(0), value);
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
3152
  return 1;
3153 3154
}

3155

3156 3157
byte *sys_var_thd_storage_engine::value_ptr(THD *thd, enum_var_type type,
					    LEX_STRING *base)
3158
{
3159 3160 3161 3162
  handlerton *val;
  val= (type == OPT_GLOBAL) ? global_system_variables.*offset :
        thd->variables.*offset;
  return (byte *) val->name;
3163 3164
}

3165

3166
void sys_var_thd_storage_engine::set_default(THD *thd, enum_var_type type)
3167 3168
{
  if (type == OPT_GLOBAL)
3169
    global_system_variables.*offset= &myisam_hton;
3170
  else
3171
    thd->variables.*offset= global_system_variables.*offset;
3172 3173
}

3174

3175
bool sys_var_thd_storage_engine::update(THD *thd, set_var *var)
3176
{
3177 3178 3179 3180
  handlerton **value= &(global_system_variables.*offset);
  if (var->type != OPT_GLOBAL)
    value= &(thd->variables.*offset);
  *value= var->save_result.hton;
3181 3182 3183
  return 0;
}

3184 3185 3186 3187
void sys_var_thd_table_type::warn_deprecated(THD *thd)
{
  push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_WARN,
		      ER_WARN_DEPRECATED_SYNTAX,
3188 3189
		      ER(ER_WARN_DEPRECATED_SYNTAX), "table_type",
                      "storage_engine"); 
3190 3191 3192 3193 3194 3195 3196 3197 3198 3199 3200 3201 3202 3203
}

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

3204

3205 3206 3207
/****************************************************************************
 Functions to handle sql_mode
****************************************************************************/
3208

3209 3210 3211
/*
  Make string representation of mode

3212 3213 3214 3215 3216 3217 3218
  SYNOPSIS
    thd   in  thread handler
    val   in  sql_mode value
    len   out pointer on length of string

  RETURN
    pointer to string with sql_mode representation
3219 3220 3221 3222
*/

byte *sys_var_thd_sql_mode::symbolic_mode_representation(THD *thd, ulong val,
                                                         ulong *len)
3223 3224 3225
{
  char buff[256];
  String tmp(buff, sizeof(buff), &my_charset_latin1);
monty@mishka.local's avatar
monty@mishka.local committed
3226
  ulong length;
3227 3228 3229 3230 3231 3232

  tmp.length(0);
  for (uint i= 0; val; val>>= 1, i++)
  {
    if (val & 1)
    {
3233 3234
      tmp.append(sql_mode_typelib.type_names[i],
                 sql_mode_typelib.type_lengths[i]);
3235 3236 3237
      tmp.append(',');
    }
  }
monty@mishka.local's avatar
monty@mishka.local committed
3238 3239 3240 3241 3242

  if ((length= tmp.length()))
    length--;
  *len= length;
  return (byte*) thd->strmake(tmp.ptr(), length);
3243 3244
}

monty@mishka.local's avatar
monty@mishka.local committed
3245

3246 3247 3248 3249 3250 3251 3252
byte *sys_var_thd_sql_mode::value_ptr(THD *thd, enum_var_type type,
				      LEX_STRING *base)
{
  ulong val= ((type == OPT_GLOBAL) ? global_system_variables.*offset :
              thd->variables.*offset);
  ulong length_unused;
  return symbolic_mode_representation(thd, val, &length_unused);
3253 3254 3255 3256 3257 3258 3259 3260 3261 3262 3263
}


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

monty@mishka.local's avatar
monty@mishka.local committed
3264

3265 3266 3267 3268 3269 3270
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
3271
  {
3272
    thd->variables.sql_mode= fix_sql_mode(thd->variables.sql_mode);
3273 3274 3275 3276 3277 3278 3279 3280
    /*
      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;
  }
3281 3282 3283
}

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

3285 3286 3287 3288 3289 3290 3291 3292 3293
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)
3294
  {
3295
    sql_mode|= (MODE_REAL_AS_FLOAT | MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
3296 3297 3298 3299 3300 3301
		MODE_IGNORE_SPACE);
    /* 
      MODE_ONLY_FULL_GROUP_BY removed from ANSI mode because it is currently
      overly restrictive (see BUG#8510).
    */
  }
3302 3303 3304 3305
  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 |
3306
		MODE_NO_FIELD_OPTIONS | MODE_NO_AUTO_CREATE_USER);
3307 3308 3309 3310 3311 3312 3313 3314 3315 3316 3317 3318 3319 3320 3321
  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);
3322
  if (sql_mode & MODE_MAXDB)
3323 3324 3325
    sql_mode|= (MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE |
		MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS |
3326
		MODE_NO_FIELD_OPTIONS | MODE_NO_AUTO_CREATE_USER);
3327
  if (sql_mode & MODE_MYSQL40)
3328
    sql_mode|= MODE_NO_FIELD_OPTIONS | MODE_HIGH_NOT_PRECEDENCE;
3329
  if (sql_mode & MODE_MYSQL323)
3330
    sql_mode|= MODE_NO_FIELD_OPTIONS | MODE_HIGH_NOT_PRECEDENCE;
3331 3332 3333
  if (sql_mode & MODE_TRADITIONAL)
    sql_mode|= (MODE_STRICT_TRANS_TABLES | MODE_STRICT_ALL_TABLES |
                MODE_NO_ZERO_IN_DATE | MODE_NO_ZERO_DATE |
3334
                MODE_ERROR_FOR_DIVISION_BY_ZERO | MODE_NO_AUTO_CREATE_USER);
3335 3336
  return sql_mode;
}
3337 3338


3339 3340 3341 3342
/****************************************************************************
  Named list handling
****************************************************************************/

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3343 3344
gptr find_named(I_List<NAMED_LIST> *list, const char *name, uint length,
		NAMED_LIST **found)
3345 3346 3347 3348 3349 3350
{
  I_List_iterator<NAMED_LIST> it(*list);
  NAMED_LIST *element;
  while ((element= it++))
  {
    if (element->cmp(name, length))
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3351
    {
3352 3353
      if (found)
        *found= element;
3354
      return element->data;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3355
    }
3356 3357 3358 3359 3360
  }
  return 0;
}


3361 3362
void delete_elements(I_List<NAMED_LIST> *list,
		     void (*free_element)(const char *name, gptr))
3363 3364
{
  NAMED_LIST *element;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3365
  DBUG_ENTER("delete_elements");
3366 3367
  while ((element= list->get()))
  {
3368
    (*free_element)(element->name, element->data);
3369 3370
    delete element;
  }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3371
  DBUG_VOID_RETURN;
3372 3373 3374 3375 3376
}


/* Key cache functions */

3377
static KEY_CACHE *create_key_cache(const char *name, uint length)
3378
{
3379
  KEY_CACHE *key_cache;
3380 3381 3382
  DBUG_ENTER("create_key_cache");
  DBUG_PRINT("enter",("name: %.*s", length, name));
  
3383
  if ((key_cache= (KEY_CACHE*) my_malloc(sizeof(KEY_CACHE),
3384
					     MYF(MY_ZEROFILL | MY_WME))))
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3385 3386
  {
    if (!new NAMED_LIST(&key_caches, name, length, (gptr) key_cache))
3387 3388
    {
      my_free((char*) key_cache, MYF(0));
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3389
      key_cache= 0;
3390 3391 3392 3393 3394 3395 3396 3397 3398
    }
    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
      */
3399 3400 3401
      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;
3402
    }
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3403
  }
3404
  DBUG_RETURN(key_cache);
3405 3406 3407
}


3408
KEY_CACHE *get_or_create_key_cache(const char *name, uint length)
3409
{
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3410
  LEX_STRING key_cache_name;
3411
  KEY_CACHE *key_cache;
3412

igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3413 3414
  key_cache_name.str= (char *) name;
  key_cache_name.length= length;
3415 3416
  pthread_mutex_lock(&LOCK_global_system_variables);
  if (!(key_cache= get_key_cache(&key_cache_name)))
3417
    key_cache= create_key_cache(name, length);
3418
  pthread_mutex_unlock(&LOCK_global_system_variables);
3419 3420 3421 3422
  return key_cache;
}


3423
void free_key_cache(const char *name, KEY_CACHE *key_cache)
3424
{
3425 3426
  ha_end_key_cache(key_cache);
  my_free((char*) key_cache, MYF(0));
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3427 3428 3429
}


3430
bool process_key_caches(int (* func) (const char *name, KEY_CACHE *))
3431
{
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3432 3433
  I_List_iterator<NAMED_LIST> it(key_caches);
  NAMED_LIST *element;
3434

igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3435 3436
  while ((element= it++))
  {
3437
    KEY_CACHE *key_cache= (KEY_CACHE *) element->data;
3438
    func(element->name, key_cache);
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3439 3440
  }
  return 0;
3441 3442
}

3443

3444 3445 3446 3447 3448 3449 3450 3451 3452 3453 3454 3455 3456 3457 3458 3459 3460 3461 3462 3463
void sys_var_trust_routine_creators::warn_deprecated(THD *thd)
{
  push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_WARN,
		      ER_WARN_DEPRECATED_SYNTAX,
		      ER(ER_WARN_DEPRECATED_SYNTAX), "log_bin_trust_routine_creators",
                      "log_bin_trust_function_creators"); 
}

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

andrey@lmy004's avatar
andrey@lmy004 committed
3464

3465 3466 3467 3468
/****************************************************************************
  Used templates
****************************************************************************/

3469
#ifdef HAVE_EXPLICIT_TEMPLATE_INSTANTIATION
3470
template class List<set_var_base>;
3471
template class List_iterator_fast<set_var_base>;
3472
template class I_List_iterator<NAMED_LIST>;
3473
#endif