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

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

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

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

/*
  Handling of MySQL SQL variables

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

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

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

unknown's avatar
unknown committed
43 44 45 46 47 48 49 50
  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
unknown's avatar
unknown committed
52 53 54 55
#pragma implementation				// gcc: Class implementation
#endif

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

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

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

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

/*
  Variable definition list

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

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

136 137 138
sys_var_bool_ptr	sys_automatic_sp_privileges("automatic_sp_privileges",
					      &sp_automatic_privileges);

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

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",
314 315
						   &SV::query_alloc_block_size,
						   0, fix_thd_mem_root);
316
sys_var_thd_ulong	sys_query_prealloc_size("query_prealloc_size",
317 318
						&SV::query_prealloc_size,
						0, fix_thd_mem_root);
319
sys_var_thd_ulong	sys_trans_alloc_block_size("transaction_alloc_block_size",
320 321
						   &SV::trans_alloc_block_size,
						   0, fix_trans_mem_root);
322
sys_var_thd_ulong	sys_trans_prealloc_size("transaction_prealloc_size",
323 324
						&SV::trans_prealloc_size,
						0, fix_trans_mem_root);
325

unknown's avatar
unknown committed
326 327 328
#ifdef HAVE_QUERY_CACHE
sys_var_long_ptr	sys_query_cache_limit("query_cache_limit",
					      &query_cache.query_cache_limit);
329 330 331
sys_var_long_ptr        sys_query_cache_min_res_unit("query_cache_min_res_unit",
						     &query_cache_min_res_unit,
						     fix_query_cache_min_res_unit);
unknown's avatar
unknown committed
332 333 334
sys_var_thd_enum	sys_query_cache_type("query_cache_type",
					     &SV::query_cache_type,
					     &query_cache_type_typelib);
335 336 337
sys_var_thd_bool
sys_query_cache_wlock_invalidate("query_cache_wlock_invalidate",
				 &SV::query_cache_wlock_invalidate);
unknown's avatar
unknown committed
338
#endif /* HAVE_QUERY_CACHE */
339
sys_var_bool_ptr	sys_secure_auth("secure_auth", &opt_secure_auth);
340
sys_var_long_ptr	sys_server_id("server_id", &server_id, fix_server_id);
341 342
sys_var_bool_ptr	sys_slave_compressed_protocol("slave_compressed_protocol",
						      &opt_slave_compressed_protocol);
unknown's avatar
SCRUM  
unknown committed
343
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
344 345
sys_var_long_ptr	sys_slave_net_timeout("slave_net_timeout",
					      &slave_net_timeout);
346 347
sys_var_long_ptr	sys_slave_trans_retries("slave_transaction_retries",
                                                &slave_trans_retries);
348
#endif
unknown's avatar
unknown committed
349 350 351 352
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);
353 354
sys_var_thd_sql_mode    sys_sql_mode("sql_mode",
                                     &SV::sql_mode);
355 356 357 358
sys_var_thd_enum
sys_updatable_views_with_limit("updatable_views_with_limit",
                               &SV::updatable_views_with_limit,
                               &updatable_views_with_limit_typelib);
unknown's avatar
VIEW  
unknown committed
359

360 361
sys_var_thd_table_type  sys_table_type("table_type",
				       &SV::table_type);
unknown's avatar
unknown committed
362 363
sys_var_thd_storage_engine sys_storage_engine("storage_engine",
				       &SV::table_type);
364 365
#ifdef HAVE_REPLICATION
sys_var_sync_binlog_period sys_sync_binlog_period("sync_binlog", &sync_binlog_period);
366 367 368 369 370 371 372 373
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);
374 375
#endif
sys_var_bool_ptr	sys_sync_frm("sync_frm", &opt_sync_frm);
unknown's avatar
unknown committed
376 377
sys_var_long_ptr	sys_table_cache_size("table_cache",
					     &table_cache_size);
378 379
sys_var_long_ptr	sys_table_lock_wait_timeout("table_lock_wait_timeout",
                                                    &table_lock_wait_timeout);
unknown's avatar
unknown committed
380 381 382 383 384 385 386 387
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);
unknown's avatar
unknown committed
388 389
sys_var_bool_ptr  sys_timed_mutexes("timed_mutexes",
                                    &timed_mutexes);
unknown's avatar
unknown committed
390 391
sys_var_thd_ulong	sys_net_wait_timeout("wait_timeout",
					     &SV::net_wait_timeout);
392

393
#ifdef HAVE_INNOBASE_DB
394 395
sys_var_long_ptr	sys_innodb_fast_shutdown("innodb_fast_shutdown",
						 &innobase_fast_shutdown);
396 397
sys_var_long_ptr        sys_innodb_max_dirty_pages_pct("innodb_max_dirty_pages_pct",
                                                        &srv_max_buf_pool_modified_pct);
398 399
sys_var_long_ptr	sys_innodb_max_purge_lag("innodb_max_purge_lag",
							&srv_max_purge_lag);
400 401
sys_var_thd_bool	sys_innodb_table_locks("innodb_table_locks",
                                               &SV::innodb_table_locks);
402 403
sys_var_thd_bool	sys_innodb_support_xa("innodb_support_xa",
                                               &SV::innodb_support_xa);
404 405
sys_var_long_ptr	sys_innodb_autoextend_increment("innodb_autoextend_increment",
							&srv_auto_extend_increment);
406 407
sys_var_long_ptr	sys_innodb_sync_spin_loops("innodb_sync_spin_loops",
                                             &srv_n_spin_wait_rounds);
unknown's avatar
unknown committed
408
sys_var_long_ptr  sys_innodb_concurrency_tickets("innodb_concurrency_tickets",
unknown's avatar
unknown committed
409 410 411 412 413
                                             &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);
414
#endif
415

unknown's avatar
unknown committed
416 417 418 419 420
/* Condition pushdown to storage engine */
sys_var_thd_bool
sys_engine_condition_pushdown("engine_condition_pushdown",
			      &SV::engine_condition_pushdown);

421
#ifdef HAVE_NDBCLUSTER_DB
422
/* ndb thread specific variable settings */
423
sys_var_thd_ulong
424 425 426
sys_ndb_autoincrement_prefetch_sz("ndb_autoincrement_prefetch_sz",
				  &SV::ndb_autoincrement_prefetch_sz);
sys_var_thd_bool
427
sys_ndb_force_send("ndb_force_send", &SV::ndb_force_send);
428
sys_var_thd_bool
429
sys_ndb_use_exact_count("ndb_use_exact_count", &SV::ndb_use_exact_count);
430
sys_var_thd_bool
431
sys_ndb_use_transactions("ndb_use_transactions", &SV::ndb_use_transactions);
432 433
sys_var_long_ptr
sys_ndb_cache_check_time("ndb_cache_check_time", &ndb_cache_check_time);
434
#endif
435 436 437 438 439

/* Time/date/datetime formats */

sys_var_thd_date_time_format sys_time_format("time_format",
					     &SV::time_format,
440
					     MYSQL_TIMESTAMP_TIME);
441 442
sys_var_thd_date_time_format sys_date_format("date_format",
					     &SV::date_format,
443
					     MYSQL_TIMESTAMP_DATE);
444 445
sys_var_thd_date_time_format sys_datetime_format("datetime_format",
						 &SV::datetime_format,
446
						 MYSQL_TIMESTAMP_DATETIME);
447 448

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

450
static sys_var_thd_bit	sys_autocommit("autocommit", 0,
unknown's avatar
unknown committed
451 452 453
				       set_option_autocommit,
				       OPTION_NOT_AUTOCOMMIT,
				       1);
454
static sys_var_thd_bit	sys_big_tables("big_tables", 0,
unknown's avatar
unknown committed
455 456 457
				       set_option_bit,
				       OPTION_BIG_TABLES);
#ifndef TO_BE_DELETED	/* Alias for big_tables */
458
static sys_var_thd_bit	sys_sql_big_tables("sql_big_tables", 0,
unknown's avatar
unknown committed
459 460 461
					   set_option_bit,
					   OPTION_BIG_TABLES);
#endif
462
static sys_var_thd_bit	sys_big_selects("sql_big_selects", 0,
unknown's avatar
unknown committed
463
					set_option_bit,
464
					OPTION_BIG_SELECTS);
465
static sys_var_thd_bit	sys_log_off("sql_log_off", 0,
unknown's avatar
unknown committed
466 467 468
				    set_option_bit,
				    OPTION_LOG_OFF);
static sys_var_thd_bit	sys_log_update("sql_log_update",
469
                                       check_log_update,
unknown's avatar
unknown committed
470 471 472
				       set_log_update,
				       OPTION_UPDATE_LOG);
static sys_var_thd_bit	sys_log_binlog("sql_log_bin",
473 474 475 476
                                       check_log_update,
				       set_log_bin,
				       OPTION_BIN_LOG);
static sys_var_thd_bit	sys_sql_warnings("sql_warnings", 0,
unknown's avatar
unknown committed
477 478
					 set_option_bit,
					 OPTION_WARNINGS);
479 480
static sys_var_thd_bit	sys_sql_notes("sql_notes", 0,
					 set_option_bit,
481
					 OPTION_SQL_NOTES);
482
static sys_var_thd_bit	sys_auto_is_null("sql_auto_is_null", 0,
unknown's avatar
unknown committed
483 484
					 set_option_bit,
					 OPTION_AUTO_IS_NULL);
485
static sys_var_thd_bit	sys_safe_updates("sql_safe_updates", 0,
unknown's avatar
unknown committed
486 487
					 set_option_bit,
					 OPTION_SAFE_UPDATES);
488
static sys_var_thd_bit	sys_buffer_results("sql_buffer_result", 0,
unknown's avatar
unknown committed
489 490
					   set_option_bit,
					   OPTION_BUFFER_RESULT);
491
static sys_var_thd_bit	sys_quote_show_create("sql_quote_show_create", 0,
unknown's avatar
unknown committed
492 493
					      set_option_bit,
					      OPTION_QUOTE_SHOW_CREATE);
494
static sys_var_thd_bit	sys_foreign_key_checks("foreign_key_checks", 0,
495 496 497
					       set_option_bit,
					       OPTION_NO_FOREIGN_KEY_CHECKS,
					       1);
498
static sys_var_thd_bit	sys_unique_checks("unique_checks", 0,
499 500 501 502
					  set_option_bit,
					  OPTION_RELAXED_UNIQUE_CHECKS,
					  1);

unknown's avatar
unknown committed
503 504
/* Local state variables */

505
static sys_var_thd_ha_rows	sys_select_limit("sql_select_limit",
unknown's avatar
unknown committed
506 507 508 509 510
						 &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");
511 512 513 514 515 516 517 518 519
static sys_var_readonly		sys_error_count("error_count",
						OPT_SESSION,
						SHOW_LONG,
						get_error_count);
static sys_var_readonly		sys_warning_count("warning_count",
						  OPT_SESSION,
						  SHOW_LONG,
						  get_warning_count);

unknown's avatar
unknown committed
520
/* alias for last_insert_id() to be compatible with Sybase */
unknown's avatar
SCRUM  
unknown committed
521
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
522
static sys_var_slave_skip_counter sys_slave_skip_counter("sql_slave_skip_counter");
523
#endif
524 525
static sys_var_rand_seed1	sys_rand_seed1("rand_seed1");
static sys_var_rand_seed2	sys_rand_seed2("rand_seed2");
unknown's avatar
unknown committed
526

527 528
static sys_var_thd_ulong        sys_default_week_format("default_week_format",
					                &SV::default_week_format);
unknown's avatar
unknown committed
529

unknown's avatar
unknown committed
530 531 532
sys_var_thd_ulong               sys_group_concat_max_len("group_concat_max_len",
                                                         &SV::group_concat_max_len);

533
sys_var_thd_time_zone            sys_time_zone("time_zone");
534 535 536 537 538

/* Read only variables */

sys_var_const_str		sys_os("version_compile_os", SYSTEM_TYPE);
/* Global read-only variable describing server license */
539
sys_var_const_str		sys_license("license", STRINGIFY_ARG(LICENSE));
540 541


unknown's avatar
unknown committed
542 543 544 545 546 547 548 549 550 551 552
/*
  List of all variables for initialisation and storage in hash
  This is sorted in alphabetical order to make it easy to add new variables

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

sys_var *sys_variables[]=
{
  &sys_auto_is_null,
553 554
  &sys_auto_increment_increment,
  &sys_auto_increment_offset,
unknown's avatar
unknown committed
555
  &sys_autocommit,
556
  &sys_automatic_sp_privileges,
unknown's avatar
unknown committed
557 558 559 560 561
  &sys_big_tables,
  &sys_big_selects,
  &sys_binlog_cache_size,
  &sys_buffer_results,
  &sys_bulk_insert_buff_size,
562 563
  &sys_character_set_server,
  &sys_character_set_database,
564
  &sys_character_set_client,
unknown's avatar
unknown committed
565
  &sys_character_set_connection,
566
  &sys_character_set_results,
unknown's avatar
unknown committed
567
  &sys_collation_connection,
568 569
  &sys_collation_database,
  &sys_collation_server,
unknown's avatar
unknown committed
570
  &sys_completion_type,
unknown's avatar
unknown committed
571 572
  &sys_concurrent_insert,
  &sys_connect_timeout,
573 574
  &sys_date_format,
  &sys_datetime_format,
unknown's avatar
unknown committed
575
  &sys_div_precincrement,
576
  &sys_default_week_format,
unknown's avatar
unknown committed
577 578 579 580
  &sys_delay_key_write,
  &sys_delayed_insert_limit,
  &sys_delayed_insert_timeout,
  &sys_delayed_queue_size,
581
  &sys_error_count,
unknown's avatar
unknown committed
582
  &sys_expire_logs_days,
unknown's avatar
unknown committed
583 584
  &sys_flush,
  &sys_flush_time,
585
  &sys_ft_boolean_syntax,
586
  &sys_foreign_key_checks,
unknown's avatar
unknown committed
587
  &sys_group_concat_max_len,
unknown's avatar
unknown committed
588
  &sys_identity,
unknown's avatar
unknown committed
589 590
  &sys_init_connect,
  &sys_init_slave,
unknown's avatar
unknown committed
591 592 593 594
  &sys_insert_id,
  &sys_interactive_timeout,
  &sys_join_buffer_size,
  &sys_key_buffer_size,
unknown's avatar
unknown committed
595
  &sys_key_cache_block_size,
596 597
  &sys_key_cache_division_limit,
  &sys_key_cache_age_threshold,
unknown's avatar
unknown committed
598
  &sys_last_insert_id,
599
  &sys_license,
unknown's avatar
unknown committed
600 601 602 603 604 605 606 607 608 609 610 611 612
  &sys_local_infile,
  &sys_log_binlog,
  &sys_log_off,
  &sys_log_update,
  &sys_log_warnings,
  &sys_long_query_time,
  &sys_low_priority_updates,
  &sys_max_allowed_packet,
  &sys_max_binlog_cache_size,
  &sys_max_binlog_size,
  &sys_max_connect_errors,
  &sys_max_connections,
  &sys_max_delayed_threads,
613
  &sys_max_error_count,
614
  &sys_max_insert_delayed_threads,
unknown's avatar
unknown committed
615 616
  &sys_max_heap_table_size,
  &sys_max_join_size,
unknown's avatar
unknown committed
617
  &sys_max_length_for_sort_data,
618
  &sys_max_relay_log_size,
619
  &sys_max_seeks_for_key,
unknown's avatar
unknown committed
620 621 622 623
  &sys_max_sort_length,
  &sys_max_tmp_tables,
  &sys_max_user_connections,
  &sys_max_write_lock_count,
unknown's avatar
unknown committed
624
  &sys_multi_range_count,
unknown's avatar
unknown committed
625
  &sys_myisam_data_pointer_size,
unknown's avatar
unknown committed
626
  &sys_myisam_max_sort_file_size,
627
  &sys_myisam_repair_threads,
unknown's avatar
unknown committed
628 629 630
  &sys_myisam_sort_buffer_size,
  &sys_net_buffer_length,
  &sys_net_read_timeout,
631
  &sys_net_retry_count,
unknown's avatar
unknown committed
632 633
  &sys_net_wait_timeout,
  &sys_net_write_timeout,
634
  &sys_new_mode,
635
  &sys_old_passwords,
636 637
  &sys_optimizer_prune_level,
  &sys_optimizer_search_depth,
unknown's avatar
unknown committed
638
  &sys_preload_buff_size,
unknown's avatar
unknown committed
639
  &sys_pseudo_thread_id,
640
  &sys_query_alloc_block_size,
unknown's avatar
unknown committed
641
  &sys_query_cache_size,
642
  &sys_query_prealloc_size,
unknown's avatar
unknown committed
643 644
#ifdef HAVE_QUERY_CACHE
  &sys_query_cache_limit,
645
  &sys_query_cache_min_res_unit,
unknown's avatar
unknown committed
646
  &sys_query_cache_type,
647
  &sys_query_cache_wlock_invalidate,
648
#endif /* HAVE_QUERY_CACHE */
unknown's avatar
unknown committed
649
  &sys_quote_show_create,
650 651
  &sys_rand_seed1,
  &sys_rand_seed2,
652
  &sys_range_alloc_block_size,
653
  &sys_readonly,
unknown's avatar
unknown committed
654 655
  &sys_read_buff_size,
  &sys_read_rnd_buff_size,
656 657 658
#ifdef HAVE_REPLICATION
  &sys_relay_log_purge,
#endif
unknown's avatar
unknown committed
659 660
  &sys_rpl_recovery_rank,
  &sys_safe_updates,
661
  &sys_secure_auth,
unknown's avatar
unknown committed
662 663
  &sys_select_limit,
  &sys_server_id,
unknown's avatar
SCRUM  
unknown committed
664
#ifdef HAVE_REPLICATION
665
  &sys_slave_compressed_protocol,
unknown's avatar
unknown committed
666
  &sys_slave_net_timeout,
667
  &sys_slave_trans_retries,
unknown's avatar
unknown committed
668
  &sys_slave_skip_counter,
669
#endif
unknown's avatar
unknown committed
670 671 672 673 674
  &sys_slow_launch_time,
  &sys_sort_buffer,
  &sys_sql_big_tables,
  &sys_sql_low_priority_updates,
  &sys_sql_max_join_size,
675
  &sys_sql_mode,
unknown's avatar
unknown committed
676
  &sys_sql_warnings,
677
  &sys_sql_notes,
unknown's avatar
unknown committed
678
  &sys_storage_engine,
679 680
#ifdef HAVE_REPLICATION
  &sys_sync_binlog_period,
681 682 683
  &sys_sync_replication,
  &sys_sync_replication_slave_id,
  &sys_sync_replication_timeout,
684 685
#endif
  &sys_sync_frm,
unknown's avatar
unknown committed
686
  &sys_table_cache_size,
687
  &sys_table_lock_wait_timeout,
unknown's avatar
unknown committed
688 689
  &sys_table_type,
  &sys_thread_cache_size,
690
  &sys_time_format,
unknown's avatar
unknown committed
691
  &sys_timed_mutexes,
unknown's avatar
unknown committed
692
  &sys_timestamp,
693
  &sys_time_zone,
unknown's avatar
unknown committed
694
  &sys_tmp_table_size,
695 696
  &sys_trans_alloc_block_size,
  &sys_trans_prealloc_size,
unknown's avatar
unknown committed
697
  &sys_tx_isolation,
698
  &sys_os,
699
#ifdef HAVE_INNOBASE_DB
700
  &sys_innodb_fast_shutdown,
701
  &sys_innodb_max_dirty_pages_pct,
702
  &sys_innodb_max_purge_lag,
703
  &sys_innodb_table_locks,
704
  &sys_innodb_support_xa,
705
  &sys_innodb_max_purge_lag,
706
  &sys_innodb_autoextend_increment,
707
  &sys_innodb_sync_spin_loops,
unknown's avatar
unknown committed
708
  &sys_innodb_concurrency_tickets,
unknown's avatar
unknown committed
709 710
  &sys_innodb_thread_sleep_delay,
  &sys_innodb_thread_concurrency,
711
#endif  
712
  &sys_trust_routine_creators,
unknown's avatar
unknown committed
713
  &sys_engine_condition_pushdown,
714 715
#ifdef HAVE_NDBCLUSTER_DB
  &sys_ndb_autoincrement_prefetch_sz,
716
  &sys_ndb_cache_check_time,
717 718 719
  &sys_ndb_force_send,
  &sys_ndb_use_exact_count,
  &sys_ndb_use_transactions,
720
#endif
721
  &sys_unique_checks,
722
  &sys_updatable_views_with_limit,
723
  &sys_warning_count
unknown's avatar
unknown committed
724 725 726 727 728 729 730 731
};


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

struct show_var_st init_vars[]= {
732
  {"auto_increment_increment", (char*) &sys_auto_increment_increment, SHOW_SYS},
733
  {"auto_increment_offset",   (char*) &sys_auto_increment_offset, SHOW_SYS},
734
  {sys_automatic_sp_privileges.name,(char*) &sys_automatic_sp_privileges,       SHOW_SYS},
unknown's avatar
unknown committed
735 736 737 738 739
  {"back_log",                (char*) &back_log,                    SHOW_LONG},
  {"basedir",                 mysql_home,                           SHOW_CHAR},
#ifdef HAVE_BERKELEY_DB
  {"bdb_cache_size",          (char*) &berkeley_cache_size,         SHOW_LONG},
  {"bdb_home",                (char*) &berkeley_home,               SHOW_CHAR_PTR},
740
  {"bdb_log_buffer_size",     (char*) &berkeley_log_buffer_size,    SHOW_LONG},
unknown's avatar
unknown committed
741
  {"bdb_logdir",              (char*) &berkeley_logdir,             SHOW_CHAR_PTR},
742
  {"bdb_max_lock",            (char*) &berkeley_max_lock,	    SHOW_LONG},
unknown's avatar
unknown committed
743 744 745 746 747
  {"bdb_shared_data",	      (char*) &berkeley_shared_data,	    SHOW_BOOL},
  {"bdb_tmpdir",              (char*) &berkeley_tmpdir,             SHOW_CHAR_PTR},
#endif
  {sys_binlog_cache_size.name,(char*) &sys_binlog_cache_size,	    SHOW_SYS},
  {sys_bulk_insert_buff_size.name,(char*) &sys_bulk_insert_buff_size,SHOW_SYS},
748
  {sys_character_set_client.name,(char*) &sys_character_set_client, SHOW_SYS},
unknown's avatar
unknown committed
749
  {sys_character_set_connection.name,(char*) &sys_character_set_connection,SHOW_SYS},
750
  {sys_character_set_database.name, (char*) &sys_character_set_database,SHOW_SYS},
751
  {sys_character_set_results.name,(char*) &sys_character_set_results, SHOW_SYS},
752 753 754
  {sys_character_set_server.name, (char*) &sys_character_set_server,SHOW_SYS},
  {sys_charset_system.name,   (char*) &sys_charset_system,          SHOW_SYS},
  {"character_sets_dir",      mysql_charsets_dir,                   SHOW_CHAR},
unknown's avatar
unknown committed
755
  {sys_collation_connection.name,(char*) &sys_collation_connection, SHOW_SYS},
756 757
  {sys_collation_database.name,(char*) &sys_collation_database,     SHOW_SYS},
  {sys_collation_server.name,(char*) &sys_collation_server,         SHOW_SYS},
unknown's avatar
unknown committed
758
  {sys_completion_type.name,  (char*) &sys_completion_type,	    SHOW_SYS},
unknown's avatar
unknown committed
759 760 761
  {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},
762 763
  {sys_date_format.name,      (char*) &sys_date_format,		    SHOW_SYS},
  {sys_datetime_format.name,  (char*) &sys_datetime_format,	    SHOW_SYS},
unknown's avatar
unknown committed
764
  {sys_div_precincrement.name,(char*) &sys_div_precincrement,SHOW_SYS},
765
  {sys_default_week_format.name, (char*) &sys_default_week_format,  SHOW_SYS},
unknown's avatar
unknown committed
766 767 768 769
  {sys_delay_key_write.name,  (char*) &sys_delay_key_write,         SHOW_SYS},
  {sys_delayed_insert_limit.name, (char*) &sys_delayed_insert_limit,SHOW_SYS},
  {sys_delayed_insert_timeout.name, (char*) &sys_delayed_insert_timeout, SHOW_SYS},
  {sys_delayed_queue_size.name,(char*) &sys_delayed_queue_size,     SHOW_SYS},
unknown's avatar
unknown committed
770
  {sys_expire_logs_days.name, (char*) &sys_expire_logs_days,        SHOW_SYS},
unknown's avatar
unknown committed
771 772
  {sys_flush.name,             (char*) &sys_flush,                  SHOW_SYS},
  {sys_flush_time.name,        (char*) &sys_flush_time,             SHOW_SYS},
773
  {sys_ft_boolean_syntax.name,(char*) &ft_boolean_syntax,	    SHOW_CHAR},
unknown's avatar
unknown committed
774
  {"ft_max_word_len",         (char*) &ft_max_word_len,             SHOW_LONG},
775
  {"ft_min_word_len",         (char*) &ft_min_word_len,             SHOW_LONG},
776
  {"ft_query_expansion_limit",(char*) &ft_query_expansion_limit,    SHOW_LONG},
777
  {"ft_stopword_file",        (char*) &ft_stopword_file,            SHOW_CHAR_PTR},
778
  {sys_group_concat_max_len.name, (char*) &sys_group_concat_max_len,  SHOW_SYS},
779
  {"have_archive",	      (char*) &have_archive_db,	            SHOW_HAVE},
unknown's avatar
unknown committed
780
  {"have_bdb",		      (char*) &have_berkeley_db,	    SHOW_HAVE},
781
  {"have_blackhole_engine",   (char*) &have_blackhole_db,	    SHOW_HAVE},
unknown's avatar
unknown committed
782
  {"have_compress",	      (char*) &have_compress,		    SHOW_HAVE},
783
  {"have_crypt",	      (char*) &have_crypt,		    SHOW_HAVE},
784
  {"have_csv",	              (char*) &have_csv_db,	            SHOW_HAVE},
785
  {"have_example_engine",     (char*) &have_example_db,	            SHOW_HAVE},
786
  {"have_federated_engine",   (char*) &have_federated_db,           SHOW_HAVE},
unknown's avatar
unknown committed
787
  {"have_geometry",           (char*) &have_geometry,               SHOW_HAVE},
unknown's avatar
unknown committed
788
  {"have_innodb",	      (char*) &have_innodb,		    SHOW_HAVE},
789
  {"have_isam",		      (char*) &have_isam,		    SHOW_HAVE},
unknown's avatar
unknown committed
790
  {"have_ndbcluster",         (char*) &have_ndbcluster,             SHOW_HAVE},
unknown's avatar
unknown committed
791 792
  {"have_openssl",	      (char*) &have_openssl,		    SHOW_HAVE},
  {"have_query_cache",        (char*) &have_query_cache,            SHOW_HAVE},
793
  {"have_raid",		      (char*) &have_raid,		    SHOW_HAVE},
794
  {"have_rtree_keys",         (char*) &have_rtree_keys,             SHOW_HAVE},
795
  {"have_symlink",            (char*) &have_symlink,                SHOW_HAVE},
unknown's avatar
unknown committed
796
  {"init_connect",            (char*) &sys_init_connect,            SHOW_SYS},
797
  {"init_file",               (char*) &opt_init_file,               SHOW_CHAR_PTR},
unknown's avatar
unknown committed
798
  {"init_slave",              (char*) &sys_init_slave,              SHOW_SYS},
unknown's avatar
unknown committed
799 800
#ifdef HAVE_INNOBASE_DB
  {"innodb_additional_mem_pool_size", (char*) &innobase_additional_mem_pool_size, SHOW_LONG },
801
  {sys_innodb_autoextend_increment.name, (char*) &sys_innodb_autoextend_increment, SHOW_SYS},
unknown's avatar
unknown committed
802
  {"innodb_buffer_pool_awe_mem_mb", (char*) &innobase_buffer_pool_awe_mem_mb, SHOW_LONG },
803
  {"innodb_buffer_pool_size", (char*) &innobase_buffer_pool_size, SHOW_LONG },
unknown's avatar
unknown committed
804 805
  {"innodb_checksums", (char*) &innobase_use_checksums, SHOW_MY_BOOL},
  {sys_innodb_concurrency_tickets.name, (char*) &sys_innodb_concurrency_tickets, SHOW_SYS},
unknown's avatar
unknown committed
806 807
  {"innodb_data_file_path", (char*) &innobase_data_file_path,	    SHOW_CHAR_PTR},
  {"innodb_data_home_dir",  (char*) &innobase_data_home_dir,	    SHOW_CHAR_PTR},
808
  {"innodb_doublewrite", (char*) &innobase_use_doublewrite, SHOW_MY_BOOL},
809
  {sys_innodb_fast_shutdown.name,(char*) &sys_innodb_fast_shutdown, SHOW_SYS},
810
  {"innodb_file_io_threads", (char*) &innobase_file_io_threads, SHOW_LONG },
unknown's avatar
unknown committed
811
  {"innodb_file_per_table", (char*) &innobase_file_per_table, SHOW_MY_BOOL},
812
  {"innodb_flush_log_at_trx_commit", (char*) &innobase_flush_log_at_trx_commit, SHOW_INT},
unknown's avatar
unknown committed
813
  {"innodb_flush_method",    (char*) &innobase_unix_file_flush_method, SHOW_CHAR_PTR},
814
  {"innodb_force_recovery", (char*) &innobase_force_recovery, SHOW_LONG },
unknown's avatar
unknown committed
815
  {"innodb_lock_wait_timeout", (char*) &innobase_lock_wait_timeout, SHOW_LONG },
unknown's avatar
unknown committed
816
  {"innodb_locks_unsafe_for_binlog", (char*) &innobase_locks_unsafe_for_binlog, SHOW_MY_BOOL},
unknown's avatar
unknown committed
817 818 819 820 821 822
  {"innodb_log_arch_dir",   (char*) &innobase_log_arch_dir, 	    SHOW_CHAR_PTR},
  {"innodb_log_archive",    (char*) &innobase_log_archive, 	    SHOW_MY_BOOL},
  {"innodb_log_buffer_size", (char*) &innobase_log_buffer_size, SHOW_LONG },
  {"innodb_log_file_size", (char*) &innobase_log_file_size, SHOW_LONG},
  {"innodb_log_files_in_group", (char*) &innobase_log_files_in_group,	SHOW_LONG},
  {"innodb_log_group_home_dir", (char*) &innobase_log_group_home_dir, SHOW_CHAR_PTR},
823
  {sys_innodb_max_dirty_pages_pct.name, (char*) &sys_innodb_max_dirty_pages_pct, SHOW_SYS},
824
  {sys_innodb_max_purge_lag.name, (char*) &sys_innodb_max_purge_lag, SHOW_SYS},
825 826
  {"innodb_mirrored_log_groups", (char*) &innobase_mirrored_log_groups, SHOW_LONG},
  {"innodb_open_files", (char*) &innobase_open_files, SHOW_LONG },
827
  {sys_innodb_sync_spin_loops.name, (char*) &sys_innodb_sync_spin_loops, SHOW_SYS},
unknown's avatar
unknown committed
828
  {sys_innodb_table_locks.name, (char*) &sys_innodb_table_locks, SHOW_SYS},
829
  {sys_innodb_support_xa.name, (char*) &sys_innodb_support_xa, SHOW_SYS},
unknown's avatar
unknown committed
830 831
  {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},
unknown's avatar
unknown committed
832 833 834 835
#endif
  {sys_interactive_timeout.name,(char*) &sys_interactive_timeout,   SHOW_SYS},
  {sys_join_buffer_size.name,   (char*) &sys_join_buffer_size,	    SHOW_SYS},
  {sys_key_buffer_size.name,	(char*) &sys_key_buffer_size,	    SHOW_SYS},
836 837
  {sys_key_cache_age_threshold.name,   (char*) &sys_key_cache_age_threshold,
                                                                    SHOW_SYS},
unknown's avatar
unknown committed
838
  {sys_key_cache_block_size.name,   (char*) &sys_key_cache_block_size,
839
                                                                    SHOW_SYS},
840
  {sys_key_cache_division_limit.name,   (char*) &sys_key_cache_division_limit,
841
                                                                    SHOW_SYS},
unknown's avatar
unknown committed
842
  {"language",                language,                             SHOW_CHAR},
843
  {"large_files_support",     (char*) &opt_large_files,             SHOW_BOOL},
844 845
  {"large_pages",             (char*) &opt_large_pages,             SHOW_MY_BOOL},
  {"large_page_size",         (char*) &opt_large_page_size,         SHOW_INT},
846
  {sys_license.name,	      (char*) &sys_license,                 SHOW_SYS},
unknown's avatar
unknown committed
847 848 849 850 851 852
  {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},
853
  {sys_trust_routine_creators.name,(char*) &sys_trust_routine_creators, SHOW_SYS},
854
  {"log_error",               (char*) log_error_file,               SHOW_CHAR},
unknown's avatar
SCRUM  
unknown committed
855
#ifdef HAVE_REPLICATION
856
  {"log_slave_updates",       (char*) &opt_log_slave_updates,       SHOW_MY_BOOL},
857
#endif
unknown's avatar
unknown committed
858 859 860 861
  {"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},
862
  {"lower_case_file_system",  (char*) &lower_case_file_system,      SHOW_MY_BOOL},
863
  {"lower_case_table_names",  (char*) &lower_case_table_names,      SHOW_INT},
unknown's avatar
unknown committed
864 865 866 867
  {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},
868
  {sys_max_connections.name,    (char*) &sys_max_connections,	    SHOW_SYS},
unknown's avatar
unknown committed
869
  {sys_max_delayed_threads.name,(char*) &sys_max_delayed_threads,   SHOW_SYS},
870
  {sys_max_error_count.name,	(char*) &sys_max_error_count,	    SHOW_SYS},
unknown's avatar
unknown committed
871
  {sys_max_heap_table_size.name,(char*) &sys_max_heap_table_size,   SHOW_SYS},
872 873
  {sys_max_insert_delayed_threads.name,
   (char*) &sys_max_insert_delayed_threads,   SHOW_SYS},
unknown's avatar
unknown committed
874
  {sys_max_join_size.name,	(char*) &sys_max_join_size,	    SHOW_SYS},
unknown's avatar
unknown committed
875
  {sys_max_length_for_sort_data.name, (char*) &sys_max_length_for_sort_data,
unknown's avatar
unknown committed
876
   SHOW_SYS},
877 878
  {sys_max_relay_log_size.name, (char*) &sys_max_relay_log_size,    SHOW_SYS},
  {sys_max_seeks_for_key.name,  (char*) &sys_max_seeks_for_key,	    SHOW_SYS},
unknown's avatar
unknown committed
879
  {sys_max_sort_length.name,	(char*) &sys_max_sort_length,	    SHOW_SYS},
880
  {sys_max_tmp_tables.name,	(char*) &sys_max_tmp_tables,	    SHOW_SYS},
881
  {sys_max_user_connections.name,(char*) &sys_max_user_connections, SHOW_SYS},
unknown's avatar
unknown committed
882
  {sys_max_write_lock_count.name, (char*) &sys_max_write_lock_count,SHOW_SYS},
unknown's avatar
unknown committed
883
  {sys_multi_range_count.name,  (char*) &sys_multi_range_count,     SHOW_SYS},
unknown's avatar
unknown committed
884
  {sys_myisam_data_pointer_size.name, (char*) &sys_myisam_data_pointer_size, SHOW_SYS},
885 886
  {sys_myisam_max_sort_file_size.name, (char*) &sys_myisam_max_sort_file_size,
   SHOW_SYS},
887
  {"myisam_recover_options",  (char*) &myisam_recover_options_str,  SHOW_CHAR_PTR},
888
  {sys_myisam_repair_threads.name, (char*) &sys_myisam_repair_threads,
unknown's avatar
unknown committed
889 890 891
   SHOW_SYS},
  {sys_myisam_sort_buffer_size.name, (char*) &sys_myisam_sort_buffer_size, SHOW_SYS},
#ifdef __NT__
892
  {"named_pipe",	      (char*) &opt_enable_named_pipe,       SHOW_MY_BOOL},
893
#endif
unknown's avatar
unknown committed
894 895
  {sys_engine_condition_pushdown.name, 
   (char*) &sys_engine_condition_pushdown,                          SHOW_SYS},
896 897 898 899 900 901
#ifdef HAVE_NDBCLUSTER_DB
  {sys_ndb_autoincrement_prefetch_sz.name,
   (char*) &sys_ndb_autoincrement_prefetch_sz,                      SHOW_SYS},
  {sys_ndb_force_send.name,   (char*) &sys_ndb_force_send,          SHOW_SYS},
  {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},
unknown's avatar
unknown committed
902
  {sys_ndb_cache_check_time.name,(char*) &sys_ndb_cache_check_time, SHOW_SYS},
unknown's avatar
unknown committed
903 904 905
#endif
  {sys_net_buffer_length.name,(char*) &sys_net_buffer_length,       SHOW_SYS},
  {sys_net_read_timeout.name, (char*) &sys_net_read_timeout,        SHOW_SYS},
906
  {sys_net_retry_count.name,  (char*) &sys_net_retry_count,	    SHOW_SYS},
unknown's avatar
unknown committed
907
  {sys_net_write_timeout.name,(char*) &sys_net_write_timeout,       SHOW_SYS},
908
  {sys_new_mode.name,         (char*) &sys_new_mode,                SHOW_SYS},
909
  {sys_old_passwords.name,    (char*) &sys_old_passwords,           SHOW_SYS},
unknown's avatar
unknown committed
910
  {"open_files_limit",	      (char*) &open_files_limit,	    SHOW_LONG},
911 912 913 914
  {sys_optimizer_prune_level.name, (char*) &sys_optimizer_prune_level,
   SHOW_SYS},
  {sys_optimizer_search_depth.name,(char*) &sys_optimizer_search_depth,
   SHOW_SYS},
unknown's avatar
unknown committed
915
  {"pid_file",                (char*) pidfile_name,                 SHOW_CHAR},
916
  {"port",                    (char*) &mysqld_port,                  SHOW_INT},
unknown's avatar
unknown committed
917
  {sys_preload_buff_size.name, (char*) &sys_preload_buff_size,      SHOW_SYS},
918
  {"protocol_version",        (char*) &protocol_version,            SHOW_INT},
919 920
  {sys_query_alloc_block_size.name, (char*) &sys_query_alloc_block_size,
   SHOW_SYS},
unknown's avatar
unknown committed
921
#ifdef HAVE_QUERY_CACHE
unknown's avatar
unknown committed
922
  {sys_query_cache_limit.name,(char*) &sys_query_cache_limit,	    SHOW_SYS},
923 924
  {sys_query_cache_min_res_unit.name, (char*) &sys_query_cache_min_res_unit,
   SHOW_SYS},
unknown's avatar
unknown committed
925 926
  {sys_query_cache_size.name, (char*) &sys_query_cache_size,	    SHOW_SYS},
  {sys_query_cache_type.name, (char*) &sys_query_cache_type,        SHOW_SYS},
unknown's avatar
unknown committed
927 928
  {sys_query_cache_wlock_invalidate.name,
   (char *) &sys_query_cache_wlock_invalidate, SHOW_SYS},
unknown's avatar
unknown committed
929
#endif /* HAVE_QUERY_CACHE */
930
  {sys_query_prealloc_size.name, (char*) &sys_query_prealloc_size,  SHOW_SYS},
931 932
  {sys_range_alloc_block_size.name, (char*) &sys_range_alloc_block_size,
   SHOW_SYS},
unknown's avatar
unknown committed
933 934 935
  {sys_read_buff_size.name,   (char*) &sys_read_buff_size,	    SHOW_SYS},
  {sys_readonly.name,         (char*) &sys_readonly,                SHOW_SYS},
  {sys_read_rnd_buff_size.name,(char*) &sys_read_rnd_buff_size,	    SHOW_SYS},
unknown's avatar
unknown committed
936 937
#ifdef HAVE_REPLICATION
  {sys_relay_log_purge.name,  (char*) &sys_relay_log_purge,         SHOW_SYS},
938
  {"relay_log_space_limit",  (char*) &relay_log_space_limit,        SHOW_LONGLONG},
unknown's avatar
unknown committed
939
#endif
unknown's avatar
unknown committed
940
  {sys_rpl_recovery_rank.name,(char*) &sys_rpl_recovery_rank,       SHOW_SYS},
941
  {"secure_auth",             (char*) &sys_secure_auth,             SHOW_SYS},
942 943 944 945
#ifdef HAVE_SMEM
  {"shared_memory",           (char*) &opt_enable_shared_memory,    SHOW_MY_BOOL},
  {"shared_memory_base_name", (char*) &shared_memory_base_name,     SHOW_CHAR_PTR},
#endif
unknown's avatar
unknown committed
946
  {sys_server_id.name,	      (char*) &sys_server_id,		    SHOW_SYS},
947
  {"skip_external_locking",   (char*) &my_disable_locking,          SHOW_MY_BOOL},
unknown's avatar
unknown committed
948 949
  {"skip_networking",         (char*) &opt_disable_networking,      SHOW_BOOL},
  {"skip_show_database",      (char*) &opt_skip_show_db,            SHOW_BOOL},
950
#ifdef HAVE_REPLICATION
951 952 953
  {sys_slave_compressed_protocol.name,
    (char*) &sys_slave_compressed_protocol,           SHOW_SYS},
  {"slave_load_tmpdir",       (char*) &slave_load_tmpdir,           SHOW_CHAR_PTR},
954
  {sys_slave_net_timeout.name,(char*) &sys_slave_net_timeout,	    SHOW_SYS},
955
  {"slave_skip_errors",       (char*) &slave_error_mask,            SHOW_SLAVE_SKIP_ERRORS},
956
  {sys_slave_trans_retries.name,(char*) &sys_slave_trans_retries,   SHOW_SYS},
957
#endif
unknown's avatar
unknown committed
958
  {sys_slow_launch_time.name, (char*) &sys_slow_launch_time,        SHOW_SYS},
959
#ifdef HAVE_SYS_UN_H
960
  {"socket",                  (char*) &mysqld_unix_port,             SHOW_CHAR_PTR},
961
#endif
unknown's avatar
unknown committed
962
  {sys_sort_buffer.name,      (char*) &sys_sort_buffer, 	    SHOW_SYS},
963
  {sys_sql_mode.name,         (char*) &sys_sql_mode,                SHOW_SYS},
unknown's avatar
unknown committed
964
  {sys_storage_engine.name,   (char*) &sys_storage_engine,          SHOW_SYS},
965 966
  {"sql_notes",               (char*) &sys_sql_notes,               SHOW_BOOL},
  {"sql_warnings",            (char*) &sys_sql_warnings,            SHOW_BOOL},
967 968
#ifdef HAVE_REPLICATION
  {sys_sync_binlog_period.name,(char*) &sys_sync_binlog_period,     SHOW_SYS},
969 970 971
  {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},
972 973
#endif
  {sys_sync_frm.name,         (char*) &sys_sync_frm,               SHOW_SYS},
974 975 976
#ifdef HAVE_TZNAME
  {"system_time_zone",        system_time_zone,                     SHOW_CHAR},
#endif
unknown's avatar
unknown committed
977
  {"table_cache",             (char*) &table_cache_size,            SHOW_LONG},
978
  {"table_lock_wait_timeout", (char*) &table_lock_wait_timeout,     SHOW_LONG },
unknown's avatar
unknown committed
979 980 981 982 983 984
  {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},
985
  {sys_time_format.name,      (char*) &sys_time_format,		    SHOW_SYS},
986
  {"time_zone",               (char*) &sys_time_zone,               SHOW_SYS},
unknown's avatar
unknown committed
987
  {sys_timed_mutexes.name,    (char*) &sys_timed_mutexes,       SHOW_SYS},
unknown's avatar
unknown committed
988
  {sys_tmp_table_size.name,   (char*) &sys_tmp_table_size,	    SHOW_SYS},
unknown's avatar
unknown committed
989
  {"tmpdir",                  (char*) &opt_mysql_tmpdir,            SHOW_CHAR_PTR},
990 991 992
  {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},
993
  {sys_tx_isolation.name,     (char*) &sys_tx_isolation,	    SHOW_SYS},
994 995
  {sys_updatable_views_with_limit.name,
                              (char*) &sys_updatable_views_with_limit,SHOW_SYS},
unknown's avatar
unknown committed
996
  {"version",                 server_version,                       SHOW_CHAR},
997 998 999
#ifdef HAVE_BERKELEY_DB
  {"version_bdb",             (char*) DB_VERSION_STRING,            SHOW_CHAR},
#endif
1000
  {"version_comment",         (char*) MYSQL_COMPILATION_COMMENT,    SHOW_CHAR},
1001
  {"version_compile_machine", (char*) MACHINE_TYPE,		    SHOW_CHAR},
1002
  {sys_os.name,		      (char*) &sys_os,			    SHOW_SYS},
unknown's avatar
unknown committed
1003 1004 1005 1006
  {sys_net_wait_timeout.name, (char*) &sys_net_wait_timeout,	    SHOW_SYS},
  {NullS, NullS, SHOW_LONG}
};

1007

1008 1009 1010 1011 1012 1013
bool sys_var::check(THD *thd, set_var *var)
{
  var->save_result.ulonglong_value= var->value->val_int();
  return 0;
}

1014 1015 1016 1017 1018 1019 1020
bool sys_var_str::check(THD *thd, set_var *var)
{
  int res;
  if (!check_func)
    return 0;

  if ((res=(*check_func)(thd, var)) < 0)
1021 1022
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0),
             name, var->value->str_value.ptr());
1023 1024 1025
  return res;
}

unknown's avatar
unknown committed
1026 1027 1028 1029
/*
  Functions to check and update variables
*/

unknown's avatar
unknown committed
1030

1031 1032 1033 1034 1035 1036 1037 1038 1039 1040
/*
  Update variables 'init_connect, init_slave'.

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

bool update_sys_var_str(sys_var_str *var_str, rw_lock_t *var_mutex,
			set_var *var)
unknown's avatar
unknown committed
1041
{
1042 1043 1044 1045
  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*) "";
1046
  if (!(res= my_strdup_with_length((byte*)old_value, new_length, MYF(0))))
1047
    return 1;
unknown's avatar
unknown committed
1048 1049 1050 1051
  /*
    Replace the old value in such a way that the any thread using
    the value will work.
  */
1052 1053 1054 1055 1056
  rw_wrlock(var_mutex);
  old_value= var_str->value;
  var_str->value= res;
  var_str->value_length= new_length;
  rw_unlock(var_mutex);
unknown's avatar
unknown committed
1057 1058 1059 1060 1061
  my_free(old_value, MYF(MY_ALLOW_ZERO_PTR));
  return 0;
}


1062 1063 1064 1065 1066 1067
static bool sys_update_init_connect(THD *thd, set_var *var)
{
  return update_sys_var_str(&sys_init_connect, &LOCK_sys_init_connect, var);
}


unknown's avatar
unknown committed
1068 1069
static void sys_default_init_connect(THD* thd, enum_var_type type)
{
1070
  update_sys_var_str(&sys_init_connect, &LOCK_sys_init_connect, 0);
unknown's avatar
unknown committed
1071 1072 1073 1074 1075
}


static bool sys_update_init_slave(THD *thd, set_var *var)
{
1076
  return update_sys_var_str(&sys_init_slave, &LOCK_sys_init_slave, var);
unknown's avatar
unknown committed
1077 1078 1079 1080 1081
}


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

1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105
static int sys_check_ftb_syntax(THD *thd,  set_var *var)
{
  if (thd->master_access & SUPER_ACL)
    return ft_boolean_check_syntax_string((byte*) var->value->str_value.c_ptr()) ?
      -1 : 0;
  else
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
}

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

static void sys_default_ftb_syntax(THD *thd, enum_var_type type)
{
1106
  strmake(ft_boolean_syntax, def_ft_boolean_syntax,
1107 1108
	  sizeof(ft_boolean_syntax)-1);
}
unknown's avatar
unknown committed
1109

unknown's avatar
unknown committed
1110 1111 1112 1113 1114
/*
  The following 3 functions need to be changed in 4.1 when we allow
  one to change character sets
*/

1115
static int sys_check_charset(THD *thd, set_var *var)
unknown's avatar
unknown committed
1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144
{
  return 0;
}


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


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


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

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


1145 1146 1147 1148 1149 1150 1151
static void
fix_myisam_max_sort_file_size(THD *thd, enum_var_type type)
{
  myisam_max_temp_length=
    (my_off_t) global_system_variables.myisam_max_sort_file_size;
}

unknown's avatar
unknown committed
1152 1153 1154 1155 1156 1157 1158 1159
/*
  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)
  {
1160
    if (thd->variables.max_join_size == HA_POS_ERROR)
unknown's avatar
unknown committed
1161 1162 1163 1164 1165
      thd->options|= OPTION_BIG_SELECTS;
    else
      thd->options&= ~OPTION_BIG_SELECTS;
  }
}
1166

unknown's avatar
unknown committed
1167 1168 1169 1170 1171 1172 1173 1174 1175 1176 1177 1178 1179

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

unknown's avatar
unknown committed
1180 1181 1182 1183 1184 1185 1186 1187 1188 1189 1190 1191 1192 1193 1194
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;
}

unknown's avatar
unknown committed
1195 1196 1197 1198 1199

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

unknown's avatar
SCRUM  
unknown committed
1200
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211 1212 1213
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;
}

1214 1215 1216 1217 1218
static void fix_net_retry_count(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
    thd->net.retry_count=thd->variables.net_retry_count;
}
unknown's avatar
SCRUM  
unknown committed
1219 1220 1221
#else /* HAVE_REPLICATION */
static void fix_net_read_timeout(THD *thd __attribute__(unused),
				 enum_var_type type __attribute__(unused))
1222
{}
unknown's avatar
SCRUM  
unknown committed
1223 1224
static void fix_net_write_timeout(THD *thd __attribute__(unused),
				  enum_var_type type __attribute__(unused))
1225
{}
unknown's avatar
SCRUM  
unknown committed
1226 1227
static void fix_net_retry_count(THD *thd __attribute__(unused),
				enum_var_type type __attribute__(unused))
1228
{}
unknown's avatar
SCRUM  
unknown committed
1229
#endif /* HAVE_REPLICATION */
1230

unknown's avatar
unknown committed
1231 1232 1233 1234

static void fix_query_cache_size(THD *thd, enum_var_type type)
{
#ifdef HAVE_QUERY_CACHE
1235
  ulong requested= query_cache_size;
unknown's avatar
unknown committed
1236
  query_cache.resize(query_cache_size);
1237 1238 1239 1240
  if (requested != query_cache_size)
    push_warning_printf(current_thd, MYSQL_ERROR::WARN_LEVEL_WARN,
			ER_WARN_QC_RESIZE, ER(ER_WARN_QC_RESIZE),
			requested, query_cache_size);
unknown's avatar
unknown committed
1241 1242 1243 1244
#endif
}


1245 1246 1247 1248 1249 1250 1251 1252 1253
#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


1254
extern void fix_delay_key_write(THD *thd, enum_var_type type)
1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269
{
  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;
  }
}

1270
static void fix_max_binlog_size(THD *thd, enum_var_type type)
1271 1272 1273 1274 1275
{
  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);
1276
#ifdef HAVE_REPLICATION
1277 1278
  if (!max_relay_log_size)
    active_mi->rli.relay_log.set_max_size(max_binlog_size);
unknown's avatar
unknown committed
1279
#endif
1280 1281 1282
  DBUG_VOID_RETURN;
}

1283
static void fix_max_relay_log_size(THD *thd, enum_var_type type)
1284 1285 1286 1287
{
  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));
1288
#ifdef HAVE_REPLICATION
1289 1290
  active_mi->rli.relay_log.set_max_size(max_relay_log_size ?
                                        max_relay_log_size: max_binlog_size);
1291
#endif
1292 1293
  DBUG_VOID_RETURN;
}
1294

1295

1296 1297
static int check_max_delayed_threads(THD *thd, set_var *var)
{
unknown's avatar
unknown committed
1298
  longlong val= var->value->val_int();
1299
  if (var->type != OPT_GLOBAL && val != 0 &&
unknown's avatar
unknown committed
1300
      val != (longlong) global_system_variables.max_insert_delayed_threads)
1301 1302
  {
    char buf[64];
1303
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), var->var->name, llstr(val, buf));
1304 1305 1306 1307 1308
    return 1;
  }
  return 0;
}

1309
static void fix_max_connections(THD *thd, enum_var_type type)
1310
{
1311
#ifndef EMBEDDED_LIBRARY
1312 1313
  resize_thr_alarm(max_connections + 
		   global_system_variables.max_insert_delayed_threads + 10);
1314
#endif
1315 1316 1317 1318 1319 1320
}


static void fix_thd_mem_root(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
unknown's avatar
unknown committed
1321
    reset_root_defaults(thd->mem_root,
1322 1323 1324 1325 1326 1327 1328
                        thd->variables.query_alloc_block_size,
                        thd->variables.query_prealloc_size);
}


static void fix_trans_mem_root(THD *thd, enum_var_type type)
{
1329
#ifdef USING_TRANSACTIONS
1330 1331 1332 1333
  if (type != OPT_GLOBAL)
    reset_root_defaults(&thd->transaction.mem_root,
                        thd->variables.trans_alloc_block_size,
                        thd->variables.trans_prealloc_size);
1334
#endif
1335 1336
}

1337

1338 1339 1340 1341
static void fix_server_id(THD *thd, enum_var_type type)
{
  server_id_supplied = 1;
}
1342

unknown's avatar
unknown committed
1343 1344 1345 1346 1347 1348
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;
}
1349

unknown's avatar
unknown committed
1350 1351
bool sys_var_long_ptr::update(THD *thd, set_var *var)
{
1352
  ulonglong tmp= var->save_result.ulonglong_value;
1353
  pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1354 1355 1356 1357
  if (option_limits)
    *value= (ulong) getopt_ull_limit_value(tmp, option_limits);
  else
    *value= (ulong) tmp;
1358
  pthread_mutex_unlock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1359 1360 1361 1362 1363 1364 1365 1366 1367 1368
  return 0;
}


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


1369 1370
bool sys_var_ulonglong_ptr::update(THD *thd, set_var *var)
{
1371
  ulonglong tmp= var->save_result.ulonglong_value;
1372
  pthread_mutex_lock(&LOCK_global_system_variables);
1373 1374 1375 1376
  if (option_limits)
    *value= (ulonglong) getopt_ull_limit_value(tmp, option_limits);
  else
    *value= (ulonglong) tmp;
1377
  pthread_mutex_unlock(&LOCK_global_system_variables);
1378 1379 1380 1381 1382 1383
  return 0;
}


void sys_var_ulonglong_ptr::set_default(THD *thd, enum_var_type type)
{
1384
  pthread_mutex_lock(&LOCK_global_system_variables);
1385
  *value= (ulonglong) option_limits->def_value;
1386
  pthread_mutex_unlock(&LOCK_global_system_variables);
1387 1388 1389
}


unknown's avatar
unknown committed
1390 1391 1392 1393 1394 1395 1396 1397 1398 1399 1400 1401 1402
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;
}


1403 1404 1405 1406 1407 1408 1409
bool sys_var_enum::update(THD *thd, set_var *var)
{
  *value= (uint) var->save_result.ulong_value;
  return 0;
}


1410
byte *sys_var_enum::value_ptr(THD *thd, enum_var_type type, LEX_STRING *base)
1411 1412 1413 1414
{
  return (byte*) enum_names->type_names[*value];
}

1415 1416 1417 1418 1419
bool sys_var_thd_ulong::check(THD *thd, set_var *var)
{
  return (sys_var_thd::check(thd, var) ||
          (check_func && (*check_func)(thd, var)));
}
1420

unknown's avatar
unknown committed
1421 1422
bool sys_var_thd_ulong::update(THD *thd, set_var *var)
{
1423
  ulonglong tmp= var->save_result.ulonglong_value;
unknown's avatar
unknown committed
1424 1425 1426 1427 1428

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

1429 1430 1431 1432 1433 1434
#if SIZEOF_LONG == 4
  /* Avoid overflows on 32 bit systems */
  if (tmp > (ulonglong) ~(ulong) 0)
    tmp= ((ulonglong) ~(ulong) 0);
#endif

unknown's avatar
unknown committed
1435 1436 1437
  if (option_limits)
    tmp= (ulong) getopt_ull_limit_value(tmp, option_limits);
  if (var->type == OPT_GLOBAL)
1438
    global_system_variables.*offset= (ulong) tmp;
unknown's avatar
unknown committed
1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456
  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;
}


1457 1458
byte *sys_var_thd_ulong::value_ptr(THD *thd, enum_var_type type,
				   LEX_STRING *base)
unknown's avatar
unknown committed
1459 1460 1461 1462 1463 1464 1465
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}


1466 1467
bool sys_var_thd_ha_rows::update(THD *thd, set_var *var)
{
1468
  ulonglong tmp= var->save_result.ulonglong_value;
1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498 1499 1500 1501 1502

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


1503 1504
byte *sys_var_thd_ha_rows::value_ptr(THD *thd, enum_var_type type,
				     LEX_STRING *base)
1505 1506 1507 1508 1509 1510
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}

unknown's avatar
unknown committed
1511 1512
bool sys_var_thd_ulonglong::update(THD *thd,  set_var *var)
{
1513
  ulonglong tmp= var->save_result.ulonglong_value;
1514

1515
  if (tmp > max_system_variables.*offset)
1516 1517 1518
    tmp= max_system_variables.*offset;

  if (option_limits)
1519
    tmp= getopt_ull_limit_value(tmp, option_limits);
unknown's avatar
unknown committed
1520
  if (var->type == OPT_GLOBAL)
1521 1522 1523
  {
    /* Lock is needed to make things safe on 32 bit systems */
    pthread_mutex_lock(&LOCK_global_system_variables);
1524
    global_system_variables.*offset= (ulonglong) tmp;
1525 1526
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
unknown's avatar
unknown committed
1527
  else
1528
    thd->variables.*offset= (ulonglong) tmp;
unknown's avatar
unknown committed
1529 1530 1531 1532 1533 1534 1535
  return 0;
}


void sys_var_thd_ulonglong::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
1536 1537
  {
    pthread_mutex_lock(&LOCK_global_system_variables);
1538
    global_system_variables.*offset= (ulonglong) option_limits->def_value;
1539 1540
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
unknown's avatar
unknown committed
1541 1542 1543 1544 1545
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1546 1547
byte *sys_var_thd_ulonglong::value_ptr(THD *thd, enum_var_type type,
				       LEX_STRING *base)
unknown's avatar
unknown committed
1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566 1567 1568 1569 1570 1571 1572 1573
{
  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;
}


1574 1575
byte *sys_var_thd_bool::value_ptr(THD *thd, enum_var_type type,
				  LEX_STRING *base)
unknown's avatar
unknown committed
1576 1577 1578 1579 1580 1581 1582 1583 1584
{
  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)
{
unknown's avatar
unknown committed
1585
  char buff[STRING_BUFFER_USUAL_SIZE];
1586
  const char *value;
1587
  String str(buff, sizeof(buff), system_charset_info), *res;
unknown's avatar
unknown committed
1588 1589 1590 1591 1592

  if (var->value->result_type() == STRING_RESULT)
  {
    if (!(res=var->value->val_str(&str)) ||
	((long) (var->save_result.ulong_value=
1593 1594
		 (ulong) find_type(enum_names, res->ptr(),
				   res->length(),1)-1)) < 0)
unknown's avatar
unknown committed
1595
    {
1596
      value= res ? res->c_ptr() : "NULL";
unknown's avatar
unknown committed
1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613
      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:
1614
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, value);
unknown's avatar
unknown committed
1615 1616 1617
  return 1;
}

1618 1619 1620

bool sys_var::check_set(THD *thd, set_var *var, TYPELIB *enum_names)
{
1621
  bool not_used;
unknown's avatar
unknown committed
1622
  char buff[STRING_BUFFER_USUAL_SIZE], *error= 0;
1623 1624 1625 1626 1627 1628
  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)))
1629
    {
unknown's avatar
unknown committed
1630
      strmov(buff, "NULL");
1631
      goto err;
1632
    }
unknown's avatar
unknown committed
1633 1634
    var->save_result.ulong_value= ((ulong)
				   find_set(enum_names, res->c_ptr(),
1635 1636 1637
					    res->length(),
                                            NULL,
                                            &error, &error_len,
unknown's avatar
unknown committed
1638
					    &not_used));
1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656 1657
    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:
1658
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, buff);
1659 1660 1661 1662
  return 1;
}


unknown's avatar
unknown committed
1663 1664 1665 1666 1667
/*
  Return an Item for a variable.  Used with @@[global.]variable_name
  If type is not given, return local value if exists, else global
*/

1668
Item *sys_var::item(THD *thd, enum_var_type var_type, LEX_STRING *base)
unknown's avatar
unknown committed
1669 1670 1671 1672 1673
{
  if (check_type(var_type))
  {
    if (var_type != OPT_DEFAULT)
    {
1674 1675
      my_error(ER_INCORRECT_GLOBAL_LOCAL_VAR, MYF(0),
               name, var_type == OPT_GLOBAL ? "SESSION" : "GLOBAL");
unknown's avatar
unknown committed
1676 1677 1678 1679 1680 1681
      return 0;
    }
    /* As there was no local variable, return the global value */
    var_type= OPT_GLOBAL;
  }
  switch (type()) {
1682 1683 1684 1685 1686 1687
  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);
1688
    return new Item_uint((ulonglong) value);
1689
  }
unknown's avatar
unknown committed
1690
  case SHOW_LONG:
1691 1692 1693 1694 1695
  {
    ulong value;
    pthread_mutex_lock(&LOCK_global_system_variables);
    value= *(ulong*) value_ptr(thd, var_type, base);
    pthread_mutex_unlock(&LOCK_global_system_variables);
1696
    return new Item_uint((ulonglong) value);
1697
  }
unknown's avatar
unknown committed
1698
  case SHOW_LONGLONG:
1699 1700 1701
  {
    longlong value;
    pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1702
    value= *(longlong*) value_ptr(thd, var_type, base);
1703 1704 1705
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return new Item_int(value);
  }
1706
  case SHOW_HA_ROWS:
1707 1708 1709
  {
    ha_rows value;
    pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1710
    value= *(ha_rows*) value_ptr(thd, var_type, base);
1711 1712 1713
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return new Item_int((longlong) value);
  }
unknown's avatar
unknown committed
1714
  case SHOW_MY_BOOL:
1715
    return new Item_int((int32) *(my_bool*) value_ptr(thd, var_type, base),1);
unknown's avatar
unknown committed
1716 1717
  case SHOW_CHAR:
  {
1718 1719
    Item_string *tmp;
    pthread_mutex_lock(&LOCK_global_system_variables);
1720
    char *str= (char*) value_ptr(thd, var_type, base);
unknown's avatar
unknown committed
1721 1722
    tmp= new Item_string(str, strlen(str),
                         system_charset_info, DERIVATION_SYSCONST);
1723 1724
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return tmp;
unknown's avatar
unknown committed
1725 1726
  }
  default:
1727
    my_error(ER_VAR_CANT_BE_READ, MYF(0), name);
unknown's avatar
unknown committed
1728 1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751
  }
  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;
}


1752 1753
byte *sys_var_thd_enum::value_ptr(THD *thd, enum_var_type type,
				  LEX_STRING *base)
unknown's avatar
unknown committed
1754 1755 1756 1757 1758 1759 1760
{
  ulong tmp= ((type == OPT_GLOBAL) ?
	      global_system_variables.*offset :
	      thd->variables.*offset);
  return (byte*) enum_names->type_names[tmp];
}

1761 1762 1763 1764 1765
bool sys_var_thd_bit::check(THD *thd, set_var *var)
{
  return (check_enum(thd, var, &bool_typelib) ||
          (check_func && (*check_func)(thd, var)));
}
unknown's avatar
unknown committed
1766 1767 1768

bool sys_var_thd_bit::update(THD *thd, set_var *var)
{
1769
  int res= (*update_func)(thd, var);
unknown's avatar
unknown committed
1770 1771 1772 1773
  return res;
}


1774 1775
byte *sys_var_thd_bit::value_ptr(THD *thd, enum_var_type type,
				 LEX_STRING *base)
unknown's avatar
unknown committed
1776 1777 1778 1779 1780 1781 1782 1783 1784 1785 1786
{
  /*
    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;
}


1787 1788 1789 1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 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
/* 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)
{
unknown's avatar
unknown committed
1829
  char buff[STRING_BUFFER_USUAL_SIZE];
1830 1831 1832 1833 1834 1835 1836 1837 1838
  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())))
  {
1839
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, res->c_ptr());
1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 1891 1892
    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;
}


1893 1894
typedef struct old_names_map_st
{
unknown's avatar
unknown committed
1895 1896 1897
  const char *old_name;
  const char *new_name;
} my_old_conv;
unknown's avatar
unknown committed
1898

unknown's avatar
unknown committed
1899 1900
static my_old_conv old_conv[]= 
{
1901 1902 1903 1904 1905 1906 1907 1908 1909 1910 1911
  {	"cp1251_koi8"		,	"cp1251"	},
  {	"cp1250_latin2"		,	"cp1250"	},
  {	"kam_latin2"		,	"keybcs2"	},
  {	"mac_latin2"		,	"MacRoman"	},
  {	"macce_latin2"		,	"MacCE"		},
  {	"pc2_latin2"		,	"pclatin2"	},
  {	"vga_latin2"		,	"pclatin1"	},
  {	"koi8_cp1251"		,	"koi8r"		},
  {	"win1251ukr_koi8_ukr"	,	"win1251ukr"	},
  {	"koi8_ukr_win1251ukr"	,	"koi8u"		},
  {	NULL			,	NULL		}
unknown's avatar
unknown committed
1912
};
unknown's avatar
unknown committed
1913

unknown's avatar
unknown committed
1914
CHARSET_INFO *get_old_charset_by_name(const char *name)
unknown's avatar
unknown committed
1915
{
unknown's avatar
unknown committed
1916
  my_old_conv *conv;
unknown's avatar
unknown committed
1917
 
unknown's avatar
unknown committed
1918
  for (conv= old_conv; conv->old_name; conv++)
1919
  {
unknown's avatar
unknown committed
1920 1921
    if (!my_strcasecmp(&my_charset_latin1, name, conv->old_name))
      return get_charset_by_csname(conv->new_name, MY_CS_PRIMARY, MYF(0));
1922
  }
unknown's avatar
unknown committed
1923
  return NULL;
unknown's avatar
unknown committed
1924 1925
}

unknown's avatar
unknown committed
1926

1927
bool sys_var_collation::check(THD *thd, set_var *var)
unknown's avatar
unknown committed
1928 1929 1930
{
  CHARSET_INFO *tmp;

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

1960

1961 1962 1963 1964
bool sys_var_character_set::check(THD *thd, set_var *var)
{
  CHARSET_INFO *tmp;

1965 1966
  if (var->value->result_type() == STRING_RESULT)
  {
unknown's avatar
unknown committed
1967
    char buff[STRING_BUFFER_USUAL_SIZE];
1968 1969
    String str(buff,sizeof(buff), system_charset_info), *res;
    if (!(res=var->value->val_str(&str)))
1970
    {
1971 1972
      if (!nullable)
      {
1973
        my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, "NULL");
1974 1975 1976 1977 1978 1979 1980
        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())))
    {
1981
      my_error(ER_UNKNOWN_CHARACTER_SET, MYF(0), res->c_ptr());
1982 1983 1984
      return 1;
    }
  }
1985
  else // INT_RESULT
unknown's avatar
unknown committed
1986
  {
1987
    if (!(tmp=get_charset((int) var->value->val_int(),MYF(0))))
1988 1989
    {
      char buf[20];
1990
      int10_to_str((int) var->value->val_int(), buf, -10);
1991 1992 1993
      my_error(ER_UNKNOWN_CHARACTER_SET, MYF(0), buf);
      return 1;
    }
unknown's avatar
unknown committed
1994 1995 1996 1997 1998
  }
  var->save_result.charset= tmp;	// Save for update
  return 0;
}

1999

2000
bool sys_var_character_set::update(THD *thd, set_var *var)
unknown's avatar
unknown committed
2001
{
2002
  ci_ptr(thd,var->type)[0]= var->save_result.charset;
unknown's avatar
unknown committed
2003
  thd->update_charset();
unknown's avatar
unknown committed
2004 2005 2006
  return 0;
}

2007 2008 2009

byte *sys_var_character_set::value_ptr(THD *thd, enum_var_type type,
				       LEX_STRING *base)
unknown's avatar
unknown committed
2010
{
2011
  CHARSET_INFO *cs= ci_ptr(thd,type)[0];
2012
  return cs ? (byte*) cs->csname : (byte*) "NULL";
unknown's avatar
unknown committed
2013 2014
}

2015

2016 2017
CHARSET_INFO ** sys_var_character_set_connection::ci_ptr(THD *thd,
							 enum_var_type type)
unknown's avatar
unknown committed
2018 2019 2020 2021 2022 2023 2024
{
  if (type == OPT_GLOBAL)
    return &global_system_variables.collation_connection;
  else
    return &thd->variables.collation_connection;
}

2025 2026 2027

void sys_var_character_set_connection::set_default(THD *thd,
						   enum_var_type type)
unknown's avatar
unknown committed
2028 2029 2030 2031
{
 if (type == OPT_GLOBAL)
   global_system_variables.collation_connection= default_charset_info;
 else
unknown's avatar
unknown committed
2032
 {
unknown's avatar
unknown committed
2033
   thd->variables.collation_connection= global_system_variables.collation_connection;
unknown's avatar
unknown committed
2034 2035
   thd->update_charset();
 }
unknown's avatar
unknown committed
2036 2037
}

2038

2039 2040
CHARSET_INFO ** sys_var_character_set_client::ci_ptr(THD *thd,
						     enum_var_type type)
2041 2042 2043 2044 2045 2046 2047
{
  if (type == OPT_GLOBAL)
    return &global_system_variables.character_set_client;
  else
    return &thd->variables.character_set_client;
}

2048

2049
void sys_var_character_set_client::set_default(THD *thd, enum_var_type type)
2050 2051
{
 if (type == OPT_GLOBAL)
2052
   global_system_variables.character_set_client= default_charset_info;
2053
 else
unknown's avatar
unknown committed
2054 2055 2056 2057 2058
 {
   thd->variables.character_set_client= (global_system_variables.
					 character_set_client);
   thd->update_charset();
 }
2059
}
unknown's avatar
unknown committed
2060

2061

unknown's avatar
unknown committed
2062 2063
CHARSET_INFO **
sys_var_character_set_results::ci_ptr(THD *thd, enum_var_type type)
2064
{
2065 2066
  if (type == OPT_GLOBAL)
    return &global_system_variables.character_set_results;
2067
  else
2068
    return &thd->variables.character_set_results;
2069 2070
}

2071

2072
void sys_var_character_set_results::set_default(THD *thd, enum_var_type type)
2073
{
2074
 if (type == OPT_GLOBAL)
2075
   global_system_variables.character_set_results= default_charset_info;
2076
 else
unknown's avatar
unknown committed
2077 2078 2079 2080 2081
 {
   thd->variables.character_set_results= (global_system_variables.
					  character_set_results);
   thd->update_charset();
 }
2082 2083
}

2084

unknown's avatar
unknown committed
2085 2086
CHARSET_INFO **
sys_var_character_set_server::ci_ptr(THD *thd, enum_var_type type)
2087 2088
{
  if (type == OPT_GLOBAL)
2089
    return &global_system_variables.collation_server;
2090
  else
2091
    return &thd->variables.collation_server;
2092 2093
}

2094

2095
void sys_var_character_set_server::set_default(THD *thd, enum_var_type type)
2096 2097
{
 if (type == OPT_GLOBAL)
2098
   global_system_variables.collation_server= default_charset_info;
2099
 else
unknown's avatar
unknown committed
2100
 {
2101
   thd->variables.collation_server= global_system_variables.collation_server;
unknown's avatar
unknown committed
2102 2103
   thd->update_charset();
 }
2104 2105
}

2106 2107
CHARSET_INFO ** sys_var_character_set_database::ci_ptr(THD *thd,
						       enum_var_type type)
2108 2109
{
  if (type == OPT_GLOBAL)
2110
    return &global_system_variables.collation_database;
2111
  else
2112
    return &thd->variables.collation_database;
2113 2114
}

2115

2116 2117 2118
void sys_var_character_set_database::set_default(THD *thd, enum_var_type type)
{
 if (type == OPT_GLOBAL)
2119
    global_system_variables.collation_database= default_charset_info;
2120
  else
unknown's avatar
unknown committed
2121
  {
2122
    thd->variables.collation_database= thd->db_charset;
unknown's avatar
unknown committed
2123 2124
    thd->update_charset();
  }
2125 2126
}

2127

2128
bool sys_var_collation_connection::update(THD *thd, set_var *var)
2129 2130
{
  if (var->type == OPT_GLOBAL)
2131
    global_system_variables.collation_connection= var->save_result.charset;
2132
  else
unknown's avatar
unknown committed
2133
  {
2134
    thd->variables.collation_connection= var->save_result.charset;
unknown's avatar
unknown committed
2135 2136
    thd->update_charset();
  }
2137 2138 2139
  return 0;
}

2140 2141 2142

byte *sys_var_collation_connection::value_ptr(THD *thd, enum_var_type type,
					      LEX_STRING *base)
2143 2144
{
  CHARSET_INFO *cs= ((type == OPT_GLOBAL) ?
2145 2146 2147
		  global_system_variables.collation_connection :
		  thd->variables.collation_connection);
  return cs ? (byte*) cs->name : (byte*) "NULL";
2148 2149
}

2150

2151
void sys_var_collation_connection::set_default(THD *thd, enum_var_type type)
2152 2153
{
 if (type == OPT_GLOBAL)
2154
   global_system_variables.collation_connection= default_charset_info;
2155
 else
unknown's avatar
unknown committed
2156 2157 2158 2159 2160
 {
   thd->variables.collation_connection= (global_system_variables.
					 collation_connection);
   thd->update_charset();
 }
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 2224 2225 2226 2227 2228 2229 2230 2231 2232 2233
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();
 }
}

2234

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

unknown's avatar
unknown committed
2237
static KEY_CACHE zero_key_cache;
unknown's avatar
unknown committed
2238

unknown's avatar
unknown committed
2239
KEY_CACHE *get_key_cache(LEX_STRING *cache_name)
unknown's avatar
unknown committed
2240
{
2241 2242
  safe_mutex_assert_owner(&LOCK_global_system_variables);
  if (!cache_name || ! cache_name->length)
unknown's avatar
unknown committed
2243
    cache_name= &default_key_cache_base;
unknown's avatar
unknown committed
2244
  return ((KEY_CACHE*) find_named(&key_caches,
2245
                                      cache_name->str, cache_name->length, 0));
unknown's avatar
unknown committed
2246 2247
}

2248

unknown's avatar
unknown committed
2249 2250
byte *sys_var_key_cache_param::value_ptr(THD *thd, enum_var_type type,
					 LEX_STRING *base)
2251
{
unknown's avatar
unknown committed
2252
  KEY_CACHE *key_cache= get_key_cache(base);
unknown's avatar
unknown committed
2253 2254 2255 2256
  if (!key_cache)
    key_cache= &zero_key_cache;
  return (byte*) key_cache + offset ;
}
2257

2258

2259 2260
bool sys_var_key_buffer_size::update(THD *thd, set_var *var)
{
2261
  ulonglong tmp= var->save_result.ulonglong_value;
unknown's avatar
unknown committed
2262
  LEX_STRING *base_name= &var->base;
unknown's avatar
unknown committed
2263
  KEY_CACHE *key_cache;
2264 2265 2266
  bool error= 0;

  /* If no basename, assume it's for the key cache named 'default' */
unknown's avatar
unknown committed
2267
  if (!base_name->length)
2268
    base_name= &default_key_cache_base;
2269 2270 2271

  pthread_mutex_lock(&LOCK_global_system_variables);
  key_cache= get_key_cache(base_name);
unknown's avatar
unknown committed
2272
                            
2273 2274
  if (!key_cache)
  {
2275
    /* Key cache didn't exists */
2276
    if (!tmp)					// Tried to delete cache
2277 2278 2279 2280 2281 2282
      goto end;					// Ok, nothing to do
    if (!(key_cache= create_key_cache(base_name->str, base_name->length)))
    {
      error= 1;
      goto end;
    }
2283
  }
2284 2285 2286 2287 2288 2289 2290 2291 2292

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

unknown's avatar
unknown committed
2293
  if (!tmp)					// Zero size means delete
2294
  {
unknown's avatar
unknown committed
2295
    if (key_cache == dflt_key_cache)
2296 2297
      goto end;					// Ignore default key cache

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

unknown's avatar
unknown committed
2320 2321
  key_cache->param_buff_size=
    (ulonglong) getopt_ull_limit_value(tmp, option_limits);
2322

2323 2324 2325 2326
  /* If key cache didn't existed initialize it, else resize it */
  key_cache->in_init= 1;
  pthread_mutex_unlock(&LOCK_global_system_variables);

unknown's avatar
unknown committed
2327
  if (!key_cache->key_cache_inited)
2328
    error= (bool) (ha_init_key_cache("", key_cache));
unknown's avatar
unknown committed
2329
  else
2330
    error= (bool)(ha_resize_key_cache(key_cache));
2331

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

2335 2336 2337
end:
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return error;
2338 2339
}

2340 2341

bool sys_var_key_cache_long::update(THD *thd, set_var *var)
2342
{
unknown's avatar
unknown committed
2343
  ulong tmp= (ulong) var->value->val_int();
2344
  LEX_STRING *base_name= &var->base;
2345 2346
  bool error= 0;

2347
  if (!base_name->length)
unknown's avatar
unknown committed
2348
    base_name= &default_key_cache_base;
2349 2350

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

unknown's avatar
unknown committed
2353 2354
  if (!key_cache && !(key_cache= create_key_cache(base_name->str,
				                  base_name->length)))
2355 2356 2357 2358
  {
    error= 1;
    goto end;
  }
2359

2360 2361 2362 2363 2364 2365 2366 2367 2368
  /*
    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))=
2369
    (ulong) getopt_ull_limit_value(tmp, option_limits);
unknown's avatar
unknown committed
2370

2371 2372 2373 2374 2375
  /*
    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;
2376

2377
  pthread_mutex_unlock(&LOCK_global_system_variables);
2378

2379 2380 2381 2382 2383 2384 2385 2386
  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;
2387 2388
}

2389

2390 2391 2392 2393
/*****************************************************************************
  Functions to handle SET NAMES and SET CHARACTER SET
*****************************************************************************/

unknown's avatar
unknown committed
2394
int set_var_collation_client::check(THD *thd)
2395 2396 2397 2398
{
  return 0;
}

unknown's avatar
unknown committed
2399
int set_var_collation_client::update(THD *thd)
2400
{
2401 2402
  thd->variables.character_set_client= character_set_client;
  thd->variables.character_set_results= character_set_results;
unknown's avatar
unknown committed
2403
  thd->variables.collation_connection= collation_connection;
unknown's avatar
unknown committed
2404
  thd->update_charset();
2405 2406 2407 2408 2409 2410 2411
  thd->protocol_simple.init(thd);
  thd->protocol_prep.init(thd);
  return 0;
}

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

unknown's avatar
unknown committed
2412 2413
bool sys_var_timestamp::update(THD *thd,  set_var *var)
{
2414
  thd->set_time((time_t) var->save_result.ulonglong_value);
unknown's avatar
unknown committed
2415 2416 2417 2418 2419 2420 2421 2422 2423 2424
  return 0;
}


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


2425 2426
byte *sys_var_timestamp::value_ptr(THD *thd, enum_var_type type,
				   LEX_STRING *base)
unknown's avatar
unknown committed
2427 2428 2429 2430 2431 2432 2433 2434
{
  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)
{
2435
  thd->insert_id(var->save_result.ulonglong_value);
unknown's avatar
unknown committed
2436 2437 2438 2439
  return 0;
}


2440 2441
byte *sys_var_last_insert_id::value_ptr(THD *thd, enum_var_type type,
					LEX_STRING *base)
unknown's avatar
unknown committed
2442 2443 2444 2445 2446 2447 2448 2449
{
  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)
{
2450
  thd->next_insert_id= var->save_result.ulonglong_value;
unknown's avatar
unknown committed
2451 2452 2453 2454
  return 0;
}


2455 2456
byte *sys_var_insert_id::value_ptr(THD *thd, enum_var_type type,
				   LEX_STRING *base)
unknown's avatar
unknown committed
2457 2458 2459 2460 2461
{
  return (byte*) &thd->current_insert_id;
}


unknown's avatar
SCRUM  
unknown committed
2462
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
2463 2464
bool sys_var_slave_skip_counter::check(THD *thd, set_var *var)
{
2465
  int result= 0;
2466
  pthread_mutex_lock(&LOCK_active_mi);
unknown's avatar
unknown committed
2467 2468 2469
  pthread_mutex_lock(&active_mi->rli.run_lock);
  if (active_mi->rli.slave_running)
  {
unknown's avatar
unknown committed
2470
    my_message(ER_SLAVE_MUST_STOP, ER(ER_SLAVE_MUST_STOP), MYF(0));
unknown's avatar
unknown committed
2471 2472 2473
    result=1;
  }
  pthread_mutex_unlock(&active_mi->rli.run_lock);
2474
  pthread_mutex_unlock(&LOCK_active_mi);
2475
  var->save_result.ulong_value= (ulong) var->value->val_int();
unknown's avatar
unknown committed
2476 2477 2478 2479 2480 2481
  return result;
}


bool sys_var_slave_skip_counter::update(THD *thd, set_var *var)
{
2482
  pthread_mutex_lock(&LOCK_active_mi);
unknown's avatar
unknown committed
2483 2484 2485 2486 2487 2488 2489 2490 2491
  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);
2492
    active_mi->rli.slave_skip_counter= var->save_result.ulong_value;
unknown's avatar
unknown committed
2493 2494 2495
    pthread_mutex_unlock(&active_mi->rli.data_lock);
  }
  pthread_mutex_unlock(&active_mi->rli.run_lock);
2496
  pthread_mutex_unlock(&LOCK_active_mi);
unknown's avatar
unknown committed
2497 2498
  return 0;
}
2499 2500 2501 2502 2503


bool sys_var_sync_binlog_period::update(THD *thd, set_var *var)
{
  pthread_mutex_t *lock_log= mysql_bin_log.get_log_lock();
2504
  sync_binlog_period= (ulong) var->save_result.ulonglong_value;
2505
  return 0;
unknown's avatar
unknown committed
2506
}
unknown's avatar
SCRUM  
unknown committed
2507
#endif /* HAVE_REPLICATION */
unknown's avatar
unknown committed
2508

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

bool sys_var_rand_seed2::update(THD *thd, set_var *var)
{
2517
  thd->rand.seed2= (ulong) var->save_result.ulonglong_value;
2518 2519 2520 2521
  return 0;
}


2522 2523
bool sys_var_thd_time_zone::check(THD *thd, set_var *var)
{
2524
  char buff[MAX_TIME_ZONE_NAME_LENGTH];
2525 2526 2527
  String str(buff, sizeof(buff), &my_charset_latin1);
  String *res= var->value->val_str(&str);

2528
  if (!(var->save_result.time_zone=
2529
        my_tz_find(res, thd->lex->time_zone_tables_used)))
2530
  {
2531
    my_error(ER_UNKNOWN_TIME_ZONE, MYF(0), res ? res->c_ptr() : "NULL");
2532 2533 2534 2535 2536 2537 2538 2539
    return 1;
  }
  return 0;
}


bool sys_var_thd_time_zone::update(THD *thd, set_var *var)
{
2540 2541 2542 2543 2544 2545 2546 2547 2548
  /* 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;
2549 2550 2551 2552 2553 2554 2555 2556 2557 2558 2559 2560
  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)
2561
    return (byte *)(global_system_variables.time_zone->get_name()->ptr());
2562
  else
2563 2564 2565 2566 2567 2568 2569 2570 2571 2572
  {
    /*
      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;
2573
    return (byte *)(thd->variables.time_zone->get_name()->ptr());
2574
  }
2575 2576 2577 2578 2579
}


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

2601 2602 2603 2604 2605 2606 2607 2608 2609 2610 2611 2612 2613 2614 2615 2616 2617 2618 2619 2620

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);
2621
  max_user_connections= (uint)var->save_result.ulonglong_value;
2622 2623 2624 2625 2626 2627 2628 2629 2630 2631 2632 2633 2634 2635 2636 2637 2638 2639 2640 2641 2642 2643 2644 2645
  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);
}


unknown's avatar
unknown committed
2646 2647 2648 2649 2650 2651
/*
  Functions to update thd->options bits
*/

static bool set_option_bit(THD *thd, set_var *var)
{
2652 2653 2654
  sys_var_thd_bit *sys_var= ((sys_var_thd_bit*) var->var);
  if ((var->save_result.ulong_value != 0) == sys_var->reverse)
    thd->options&= ~sys_var->bit_flag;
unknown's avatar
unknown committed
2655
  else
2656
    thd->options|= sys_var->bit_flag;
unknown's avatar
unknown committed
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 2686 2687 2688 2689 2690
  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;
}

2691 2692 2693 2694 2695 2696 2697 2698 2699 2700 2701
static int check_log_update(THD *thd, set_var *var)
{
#ifndef NO_EMBEDDED_ACCESS_CHECKS
  if (!(thd->master_access & SUPER_ACL))
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
#endif
  return 0;
}
unknown's avatar
unknown committed
2702 2703 2704

static bool set_log_update(THD *thd, set_var *var)
{
2705 2706 2707 2708 2709 2710
  /*
    The update log is not supported anymore since 5.0.
    See sql/mysqld.cc/, comments in function init_server_components() for an
    explaination of the different warnings we send below
  */
    
unknown's avatar
unknown committed
2711
  if (opt_sql_bin_update)
2712
  {
unknown's avatar
unknown committed
2713 2714
    ((sys_var_thd_bit*) var->var)->bit_flag|= (OPTION_BIN_LOG |
					       OPTION_UPDATE_LOG);
2715 2716 2717 2718 2719 2720 2721 2722
    push_warning(thd, MYSQL_ERROR::WARN_LEVEL_NOTE,
                 ER_UPDATE_LOG_DEPRECATED_TRANSLATED,
                 ER(ER_UPDATE_LOG_DEPRECATED_TRANSLATED));
  }
  else
    push_warning(thd, MYSQL_ERROR::WARN_LEVEL_NOTE,
                 ER_UPDATE_LOG_DEPRECATED_IGNORED,
                 ER(ER_UPDATE_LOG_DEPRECATED_IGNORED));
unknown's avatar
unknown committed
2723 2724 2725 2726
  set_option_bit(thd, var);
  return 0;
}

2727
static bool set_log_bin(THD *thd, set_var *var)
unknown's avatar
unknown committed
2728 2729 2730 2731 2732 2733 2734 2735
{
  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;
}

2736 2737 2738 2739 2740 2741 2742 2743 2744 2745 2746 2747 2748 2749 2750
static int check_pseudo_thread_id(THD *thd, set_var *var)
{
  var->save_result.ulonglong_value= var->value->val_int();
#ifndef NO_EMBEDDED_ACCESS_CHECKS
  if (thd->master_access & SUPER_ACL)
    return 0;
  else
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
#else
  return 0;
#endif
}
2751

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

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

unknown's avatar
unknown committed
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 2821 2822 2823 2824 2825

/****************************************************************************
  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()
{
2826 2827
  hash_init(&system_variable_hash, system_charset_info,
	    array_elements(sys_variables),0,0,
unknown's avatar
unknown committed
2828
	    (hash_get_key) get_sys_var_length,0,0);
unknown's avatar
unknown committed
2829 2830 2831 2832 2833 2834 2835
  sys_var **var, **end;
  for (var= sys_variables, end= sys_variables+array_elements(sys_variables) ;
       var < end;
       var++)
  {
    (*var)->name_length= strlen((*var)->name);
    (*var)->option_limits= find_option(my_long_options, (*var)->name);
unknown's avatar
SCRUM  
unknown committed
2836
    my_hash_insert(&system_variable_hash, (byte*) *var);
unknown's avatar
unknown committed
2837 2838 2839 2840 2841 2842 2843 2844 2845 2846 2847 2848 2849 2850 2851 2852 2853 2854 2855 2856 2857 2858 2859 2860 2861 2862 2863 2864 2865 2866 2867
  }
  /*
    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)
*/

2868
sys_var *find_sys_var(const char *str, uint length)
unknown's avatar
unknown committed
2869
{
unknown's avatar
unknown committed
2870 2871
  sys_var *var= (sys_var*) hash_search(&system_variable_hash,
				       (byte*) str,
unknown's avatar
unknown committed
2872 2873 2874
				       length ? length :
				       strlen(str));
  if (!var)
2875
    my_error(ER_UNKNOWN_SYSTEM_VARIABLE, MYF(0), (char*) str);
unknown's avatar
unknown committed
2876 2877 2878 2879 2880 2881 2882 2883 2884 2885 2886 2887 2888 2889 2890 2891 2892 2893 2894 2895 2896 2897
  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
2898 2899
    1	ERROR, message sent (normally no variables was updated)
    -1  ERROR, message not sent
unknown's avatar
unknown committed
2900 2901
*/

2902
int sql_set_variables(THD *thd, List<set_var_base> *var_list)
unknown's avatar
unknown committed
2903
{
unknown's avatar
unknown committed
2904
  int error;
unknown's avatar
unknown committed
2905
  List_iterator_fast<set_var_base> it(*var_list);
unknown's avatar
unknown committed
2906
  DBUG_ENTER("sql_set_variables");
unknown's avatar
unknown committed
2907 2908 2909 2910

  set_var_base *var;
  while ((var=it++))
  {
unknown's avatar
unknown committed
2911
    if ((error= var->check(thd)))
2912
      goto err;
unknown's avatar
unknown committed
2913
  }
unknown's avatar
unknown committed
2914
  if (!(error= test(thd->net.report_error)))
2915 2916 2917 2918 2919
  {
    it.rewind();
    while ((var= it++))
      error|= var->update(thd);         // Returns 0, -1 or 1
  }
unknown's avatar
unknown committed
2920

2921 2922
err:
  free_underlaid_joins(thd, &thd->lex->select_lex);
unknown's avatar
unknown committed
2923
  DBUG_RETURN(error);
unknown's avatar
unknown committed
2924 2925 2926
}


2927 2928 2929 2930 2931 2932 2933 2934 2935 2936 2937 2938 2939 2940 2941 2942 2943 2944 2945 2946 2947 2948 2949 2950 2951 2952 2953 2954 2955 2956
/*
  Say if all variables set by a SET support the ONE_SHOT keyword (currently,
  only character set and collation do; later timezones will).

  SYNOPSIS

  not_all_support_one_shot
    set_var	List of variables to update

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

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

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


unknown's avatar
unknown committed
2957 2958 2959 2960
/*****************************************************************************
  Functions to handle SET mysql_internal_variable=const_expr
*****************************************************************************/

2961
int set_var::check(THD *thd)
unknown's avatar
unknown committed
2962
{
2963 2964 2965 2966 2967
  if (var->is_readonly())
  {
    my_error(ER_INCORRECT_GLOBAL_LOCAL_VAR, MYF(0), var->name, "read only");
    return -1;
  }
unknown's avatar
unknown committed
2968 2969
  if (var->check_type(type))
  {
unknown's avatar
unknown committed
2970
    int err= type == OPT_GLOBAL ? ER_LOCAL_VARIABLE : ER_GLOBAL_VARIABLE;
2971
    my_error(err, MYF(0), var->name);
2972
    return -1;
unknown's avatar
unknown committed
2973 2974 2975 2976 2977 2978 2979 2980
  }
  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))
    {
2981
      my_error(ER_NO_DEFAULT, MYF(0), var->name);
2982
      return -1;
unknown's avatar
unknown committed
2983 2984 2985 2986
    }
    return 0;
  }

unknown's avatar
unknown committed
2987
  if ((!value->fixed &&
2988
       value->fix_fields(thd, &value)) || value->check_cols(1))
2989
    return -1;
unknown's avatar
unknown committed
2990 2991
  if (var->check_update_type(value->result_type()))
  {
2992
    my_error(ER_WRONG_TYPE_FOR_VAR, MYF(0), var->name);
2993
    return -1;
2994
  }
2995
  return var->check(thd, this) ? -1 : 0;
unknown's avatar
unknown committed
2996 2997 2998
}


unknown's avatar
unknown committed
2999 3000 3001 3002 3003 3004 3005 3006 3007 3008 3009 3010
/*
  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
*/
3011 3012 3013 3014
int set_var::light_check(THD *thd)
{
  if (var->check_type(type))
  {
unknown's avatar
unknown committed
3015
    int err= type == OPT_GLOBAL ? ER_LOCAL_VARIABLE : ER_GLOBAL_VARIABLE;
3016
    my_error(err, MYF(0), var->name);
3017 3018
    return -1;
  }
unknown's avatar
unknown committed
3019
  if (type == OPT_GLOBAL && check_global_access(thd, SUPER_ACL))
3020 3021
    return 1;

3022
  if (value && ((!value->fixed && value->fix_fields(thd, &value)) ||
unknown's avatar
unknown committed
3023
                value->check_cols(1)))
3024 3025 3026 3027 3028
    return -1;
  return 0;
}


3029
int set_var::update(THD *thd)
unknown's avatar
unknown committed
3030 3031 3032 3033
{
  if (!value)
    var->set_default(thd, type);
  else if (var->update(thd, this))
3034
    return -1;				// should never happen
unknown's avatar
unknown committed
3035 3036 3037 3038 3039 3040 3041 3042 3043 3044
  if (var->after_update)
    (*var->after_update)(thd, type);
  return 0;
}


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

3045
int set_var_user::check(THD *thd)
unknown's avatar
unknown committed
3046
{
unknown's avatar
unknown committed
3047 3048
  /*
    Item_func_set_user_var can't substitute something else on its place =>
3049
    0 can be passed as last argument (reference on item)
unknown's avatar
unknown committed
3050
  */
3051
  return (user_var_item->fix_fields(thd, (Item**) 0) ||
3052
	  user_var_item->check()) ? -1 : 0;
unknown's avatar
unknown committed
3053 3054 3055
}


unknown's avatar
unknown committed
3056 3057 3058 3059 3060 3061 3062 3063 3064 3065 3066 3067
/*
  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
*/
3068 3069 3070 3071 3072 3073
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)
  */
3074
  return (user_var_item->fix_fields(thd, (Item**) 0));
3075 3076 3077
}


3078
int set_var_user::update(THD *thd)
unknown's avatar
unknown committed
3079 3080 3081 3082
{
  if (user_var_item->update())
  {
    /* Give an error if it's not given already */
unknown's avatar
unknown committed
3083
    my_message(ER_SET_CONSTANTS_ONLY, ER(ER_SET_CONSTANTS_ONLY), MYF(0));
3084
    return -1;
unknown's avatar
unknown committed
3085 3086 3087 3088 3089 3090 3091 3092 3093
  }
  return 0;
}


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

3094
int set_var_password::check(THD *thd)
unknown's avatar
unknown committed
3095
{
unknown's avatar
unknown committed
3096
#ifndef NO_EMBEDDED_ACCESS_CHECKS
unknown's avatar
unknown committed
3097 3098
  if (!user->host.str)
    user->host.str= (char*) thd->host_or_ip;
3099
  /* Returns 1 as the function sends error to client */
3100 3101
  return check_change_password(thd, user->host.str, user->user.str,
                               password, strlen(password)) ? 1 : 0;
3102
#else
unknown's avatar
unknown committed
3103 3104
  return 0;
#endif
unknown's avatar
unknown committed
3105 3106
}

3107
int set_var_password::update(THD *thd)
unknown's avatar
unknown committed
3108
{
unknown's avatar
unknown committed
3109
#ifndef NO_EMBEDDED_ACCESS_CHECKS
3110
  /* Returns 1 as the function sends error to client */
3111 3112
  return change_password(thd, user->host.str, user->user.str, password) ?
	  1 : 0;
unknown's avatar
unknown committed
3113 3114 3115
#else
  return 0;
#endif
unknown's avatar
unknown committed
3116 3117
}

3118 3119 3120 3121
/****************************************************************************
 Functions to handle table_type
****************************************************************************/

unknown's avatar
unknown committed
3122 3123
/* Based upon sys_var::check_enum() */

unknown's avatar
unknown committed
3124
bool sys_var_thd_storage_engine::check(THD *thd, set_var *var)
3125
{
unknown's avatar
unknown committed
3126
  char buff[STRING_BUFFER_USUAL_SIZE];
3127 3128 3129 3130 3131
  const char *value;
  String str(buff, sizeof(buff), &my_charset_latin1), *res;

  if (var->value->result_type() == STRING_RESULT)
  {
3132
    enum db_type db_type;
3133 3134
    if (!(res=var->value->val_str(&str)) ||
	!(var->save_result.ulong_value=
3135
          (ulong) (db_type= ha_resolve_by_name(res->ptr(), res->length()))) ||
3136
        ha_checktype(thd, db_type, 1, 0) != db_type)
3137 3138 3139 3140 3141 3142
    {
      value= res ? res->c_ptr() : "NULL";
      goto err;
    }
    return 0;
  }
unknown's avatar
unknown committed
3143
  value= "unknown";
3144 3145

err:
3146
  my_error(ER_UNKNOWN_STORAGE_ENGINE, MYF(0), value);
unknown's avatar
unknown committed
3147
  return 1;
3148 3149
}

unknown's avatar
unknown committed
3150

unknown's avatar
unknown committed
3151 3152
byte *sys_var_thd_storage_engine::value_ptr(THD *thd, enum_var_type type,
					    LEX_STRING *base)
3153 3154 3155 3156
{
  ulong val;
  val= ((type == OPT_GLOBAL) ? global_system_variables.*offset :
        thd->variables.*offset);
unknown's avatar
unknown committed
3157
  const char *table_type= ha_get_storage_engine((enum db_type)val);
unknown's avatar
unknown committed
3158
  return (byte *) table_type;
3159 3160
}

unknown's avatar
unknown committed
3161

unknown's avatar
unknown committed
3162
void sys_var_thd_storage_engine::set_default(THD *thd, enum_var_type type)
3163 3164 3165 3166 3167 3168 3169
{
  if (type == OPT_GLOBAL)
    global_system_variables.*offset= (ulong) DB_TYPE_MYISAM;
  else
    thd->variables.*offset= (ulong) (global_system_variables.*offset);
}

unknown's avatar
unknown committed
3170

unknown's avatar
unknown committed
3171
bool sys_var_thd_storage_engine::update(THD *thd, set_var *var)
3172 3173 3174 3175 3176 3177 3178 3179
{
  if (var->type == OPT_GLOBAL)
    global_system_variables.*offset= var->save_result.ulong_value;
  else
    thd->variables.*offset= var->save_result.ulong_value;
  return 0;
}

unknown's avatar
unknown committed
3180 3181 3182 3183
void sys_var_thd_table_type::warn_deprecated(THD *thd)
{
  push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_WARN,
		      ER_WARN_DEPRECATED_SYNTAX,
3184 3185
		      ER(ER_WARN_DEPRECATED_SYNTAX), "table_type",
                      "storage_engine"); 
unknown's avatar
unknown committed
3186 3187 3188 3189 3190 3191 3192 3193 3194 3195 3196 3197 3198 3199
}

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

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

unknown's avatar
unknown committed
3200

3201 3202 3203
/****************************************************************************
 Functions to handle sql_mode
****************************************************************************/
3204

3205 3206 3207
/*
  Make string representation of mode

3208 3209 3210 3211 3212 3213 3214
  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
3215 3216 3217 3218
*/

byte *sys_var_thd_sql_mode::symbolic_mode_representation(THD *thd, ulong val,
                                                         ulong *len)
3219 3220 3221
{
  char buff[256];
  String tmp(buff, sizeof(buff), &my_charset_latin1);
unknown's avatar
unknown committed
3222
  ulong length;
3223 3224 3225 3226 3227 3228

  tmp.length(0);
  for (uint i= 0; val; val>>= 1, i++)
  {
    if (val & 1)
    {
3229 3230
      tmp.append(sql_mode_typelib.type_names[i],
                 sql_mode_typelib.type_lengths[i]);
3231 3232 3233
      tmp.append(',');
    }
  }
unknown's avatar
unknown committed
3234 3235 3236 3237 3238

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

unknown's avatar
unknown committed
3241

3242 3243 3244 3245 3246 3247 3248 3249 3250
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);
}

3251 3252 3253 3254 3255 3256 3257 3258 3259

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

unknown's avatar
unknown committed
3260

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

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

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


3335 3336 3337 3338
/****************************************************************************
  Named list handling
****************************************************************************/

unknown's avatar
unknown committed
3339 3340
gptr find_named(I_List<NAMED_LIST> *list, const char *name, uint length,
		NAMED_LIST **found)
3341 3342 3343 3344 3345 3346
{
  I_List_iterator<NAMED_LIST> it(*list);
  NAMED_LIST *element;
  while ((element= it++))
  {
    if (element->cmp(name, length))
unknown's avatar
unknown committed
3347
    {
3348 3349
      if (found)
        *found= element;
3350
      return element->data;
unknown's avatar
unknown committed
3351
    }
3352 3353 3354 3355 3356
  }
  return 0;
}


3357 3358
void delete_elements(I_List<NAMED_LIST> *list,
		     void (*free_element)(const char *name, gptr))
3359 3360
{
  NAMED_LIST *element;
unknown's avatar
unknown committed
3361
  DBUG_ENTER("delete_elements");
3362 3363
  while ((element= list->get()))
  {
3364
    (*free_element)(element->name, element->data);
3365 3366
    delete element;
  }
unknown's avatar
unknown committed
3367
  DBUG_VOID_RETURN;
3368 3369 3370 3371 3372
}


/* Key cache functions */

unknown's avatar
unknown committed
3373
static KEY_CACHE *create_key_cache(const char *name, uint length)
3374
{
unknown's avatar
unknown committed
3375
  KEY_CACHE *key_cache;
3376 3377 3378
  DBUG_ENTER("create_key_cache");
  DBUG_PRINT("enter",("name: %.*s", length, name));
  
unknown's avatar
unknown committed
3379
  if ((key_cache= (KEY_CACHE*) my_malloc(sizeof(KEY_CACHE),
3380
					     MYF(MY_ZEROFILL | MY_WME))))
unknown's avatar
unknown committed
3381 3382
  {
    if (!new NAMED_LIST(&key_caches, name, length, (gptr) key_cache))
3383 3384
    {
      my_free((char*) key_cache, MYF(0));
unknown's avatar
unknown committed
3385
      key_cache= 0;
3386 3387 3388 3389 3390 3391 3392 3393 3394
    }
    else
    {
      /*
	Set default values for a key cache
	The values in dflt_key_cache_var is set by my_getopt() at startup

	We don't set 'buff_size' as this is used to enable the key cache
      */
unknown's avatar
unknown committed
3395 3396 3397
      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;
3398
    }
unknown's avatar
unknown committed
3399
  }
3400
  DBUG_RETURN(key_cache);
3401 3402 3403
}


unknown's avatar
unknown committed
3404
KEY_CACHE *get_or_create_key_cache(const char *name, uint length)
3405
{
unknown's avatar
unknown committed
3406
  LEX_STRING key_cache_name;
unknown's avatar
unknown committed
3407
  KEY_CACHE *key_cache;
3408

unknown's avatar
unknown committed
3409 3410
  key_cache_name.str= (char *) name;
  key_cache_name.length= length;
3411 3412
  pthread_mutex_lock(&LOCK_global_system_variables);
  if (!(key_cache= get_key_cache(&key_cache_name)))
3413
    key_cache= create_key_cache(name, length);
3414
  pthread_mutex_unlock(&LOCK_global_system_variables);
3415 3416 3417 3418
  return key_cache;
}


unknown's avatar
unknown committed
3419
void free_key_cache(const char *name, KEY_CACHE *key_cache)
3420
{
3421 3422
  ha_end_key_cache(key_cache);
  my_free((char*) key_cache, MYF(0));
unknown's avatar
unknown committed
3423 3424 3425
}


unknown's avatar
unknown committed
3426
bool process_key_caches(int (* func) (const char *name, KEY_CACHE *))
3427
{
unknown's avatar
unknown committed
3428 3429
  I_List_iterator<NAMED_LIST> it(key_caches);
  NAMED_LIST *element;
3430

unknown's avatar
unknown committed
3431 3432
  while ((element= it++))
  {
unknown's avatar
unknown committed
3433
    KEY_CACHE *key_cache= (KEY_CACHE *) element->data;
3434
    func(element->name, key_cache);
unknown's avatar
unknown committed
3435 3436
  }
  return 0;
3437 3438
}

3439

unknown's avatar
unknown committed
3440 3441 3442 3443
/****************************************************************************
  Used templates
****************************************************************************/

3444
#ifdef HAVE_EXPLICIT_TEMPLATE_INSTANTIATION
unknown's avatar
unknown committed
3445
template class List<set_var_base>;
unknown's avatar
unknown committed
3446
template class List_iterator_fast<set_var_base>;
3447
template class I_List_iterator<NAMED_LIST>;
unknown's avatar
unknown committed
3448
#endif