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

   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
unknown's avatar
unknown committed
5
   the Free Software Foundation; version 2 of the License.
unknown's avatar
unknown committed
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

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

36 37 38 39 40 41
  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
42 43 44 45 46 47 48 49
  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.
*/

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

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

unknown's avatar
unknown committed
61 62 63 64 65 66
#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 86 87
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
88 89 90 91
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
92 93
static bool set_option_bit(THD *thd, set_var *var);
static bool set_option_autocommit(THD *thd, set_var *var);
94
static int  check_log_update(THD *thd, set_var *var);
unknown's avatar
unknown committed
95
static bool set_log_update(THD *thd, set_var *var);
96
static int  check_pseudo_thread_id(THD *thd, set_var *var);
97
static bool set_log_bin(THD *thd, set_var *var);
unknown's avatar
unknown committed
98 99
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
100 101
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
102 103
static void fix_net_read_timeout(THD *thd, enum_var_type type);
static void fix_net_write_timeout(THD *thd, enum_var_type type);
104
static void fix_net_retry_count(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
105 106
static void fix_max_join_size(THD *thd, enum_var_type type);
static void fix_query_cache_size(THD *thd, enum_var_type type);
107
static void fix_query_cache_min_res_unit(THD *thd, enum_var_type type);
108
static void fix_myisam_max_sort_file_size(THD *thd, enum_var_type type);
109 110
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);
111
static void fix_max_connections(THD *thd, enum_var_type type);
112
static int check_max_delayed_threads(THD *thd, set_var *var);
113 114
static void fix_thd_mem_root(THD *thd, enum_var_type type);
static void fix_trans_mem_root(THD *thd, enum_var_type type);
115
static void fix_server_id(THD *thd, enum_var_type type);
unknown's avatar
unknown committed
116
static KEY_CACHE *create_key_cache(const char *name, uint length);
117
void fix_sql_mode_var(THD *thd, enum_var_type type);
118 119
static byte *get_error_count(THD *thd);
static byte *get_warning_count(THD *thd);
120
static byte *get_have_innodb(THD *thd);
121
static byte *get_tmpdir(THD *thd);
unknown's avatar
unknown committed
122 123 124 125 126 127 128 129

/*
  Variable definition list

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

130 131 132 133 134
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);

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

138
sys_var_const_str       sys_basedir("basedir", mysql_home);
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
sys_var_character_set_server	sys_character_set_server("character_set_server");
144 145
sys_var_const_str       sys_charset_system("character_set_system",
                                           (char *)my_charset_utf8_general_ci.name);
146
sys_var_character_set_database	sys_character_set_database("character_set_database");
147
sys_var_character_set_client  sys_character_set_client("character_set_client");
unknown's avatar
unknown committed
148
sys_var_character_set_connection  sys_character_set_connection("character_set_connection");
149
sys_var_character_set_results sys_character_set_results("character_set_results");
unknown's avatar
unknown committed
150
sys_var_character_set_filesystem  sys_character_set_filesystem("character_set_filesystem");
unknown's avatar
unknown committed
151 152 153 154
sys_var_thd_ulong	sys_completion_type("completion_type",
					 &SV::completion_type,
					 check_completion_type,
					 fix_completion_type);
unknown's avatar
unknown committed
155
sys_var_collation_connection sys_collation_connection("collation_connection");
156 157
sys_var_collation_database sys_collation_database("collation_database");
sys_var_collation_server sys_collation_server("collation_server");
158 159
sys_var_long_ptr	sys_concurrent_insert("concurrent_insert",
                                              &myisam_concurrent_insert);
unknown's avatar
unknown committed
160 161
sys_var_long_ptr	sys_connect_timeout("connect_timeout",
					    &connect_timeout);
162
sys_var_const_str       sys_datadir("datadir", mysql_real_data_home);
163 164 165 166
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
167 168 169 170 171 172
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
173 174
sys_var_long_ptr	sys_expire_logs_days("expire_logs_days",
					     &expire_logs_days);
unknown's avatar
unknown committed
175 176
sys_var_bool_ptr	sys_flush("flush", &myisam_flush);
sys_var_long_ptr	sys_flush_time("flush_time", &flush_time);
177 178 179 180 181 182 183 184 185 186 187
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
188 189 190 191
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);
192
sys_var_key_buffer_size	sys_key_buffer_size("key_buffer_size");
193
sys_var_key_cache_long  sys_key_cache_block_size("key_cache_block_size",
unknown's avatar
unknown committed
194 195
						 offsetof(KEY_CACHE,
							  param_block_size));
196
sys_var_key_cache_long	sys_key_cache_division_limit("key_cache_division_limit",
unknown's avatar
unknown committed
197 198
						     offsetof(KEY_CACHE,
							      param_division_limit));
199
sys_var_key_cache_long  sys_key_cache_age_threshold("key_cache_age_threshold",
unknown's avatar
unknown committed
200 201
						     offsetof(KEY_CACHE,
							      param_age_threshold));
unknown's avatar
unknown committed
202 203
sys_var_bool_ptr	sys_local_infile("local_infile",
					 &opt_local_infile);
204
sys_var_trust_routine_creators
205
sys_trust_routine_creators("log_bin_trust_routine_creators",
206
                           &trust_function_creators);
unknown's avatar
foo1  
unknown committed
207
sys_var_bool_ptr
208 209
sys_trust_function_creators("log_bin_trust_function_creators",
                            &trust_function_creators);
210 211 212
sys_var_bool_ptr
  sys_log_queries_not_using_indexes("log_queries_not_using_indexes",
                                    &opt_log_queries_not_using_indexes);
213
sys_var_thd_ulong	sys_log_warnings("log_warnings", &SV::log_warnings);
unknown's avatar
unknown committed
214 215 216 217 218 219 220 221 222 223 224 225 226 227 228
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",
229 230
					    &max_binlog_size,
                                            fix_max_binlog_size);
unknown's avatar
unknown committed
231
sys_var_long_ptr	sys_max_connections("max_connections",
232 233
					    &max_connections,
                                            fix_max_connections);
unknown's avatar
unknown committed
234 235
sys_var_long_ptr	sys_max_connect_errors("max_connect_errors",
					       &max_connect_errors);
236
sys_var_thd_ulong       sys_max_insert_delayed_threads("max_insert_delayed_threads",
237 238 239
						       &SV::max_insert_delayed_threads,
                                                       check_max_delayed_threads,
                                                       fix_max_connections);
240 241
sys_var_thd_ulong	sys_max_delayed_threads("max_delayed_threads",
						&SV::max_insert_delayed_threads,
242 243
                                                check_max_delayed_threads,
                                                fix_max_connections);
244 245
sys_var_thd_ulong	sys_max_error_count("max_error_count",
					    &SV::max_error_count);
246
sys_var_thd_ulonglong	sys_max_heap_table_size("max_heap_table_size",
unknown's avatar
unknown committed
247
						&SV::max_heap_table_size);
248 249 250
sys_var_thd_ulong       sys_pseudo_thread_id("pseudo_thread_id",
					     &SV::pseudo_thread_id,
                                             check_pseudo_thread_id, 0);
251
sys_var_thd_ha_rows	sys_max_join_size("max_join_size",
unknown's avatar
unknown committed
252 253
					  &SV::max_join_size,
					  fix_max_join_size);
254 255
sys_var_thd_ulong	sys_max_seeks_for_key("max_seeks_for_key",
					      &SV::max_seeks_for_key);
unknown's avatar
unknown committed
256
sys_var_thd_ulong   sys_max_length_for_sort_data("max_length_for_sort_data",
257
                                                 &SV::max_length_for_sort_data);
unknown's avatar
unknown committed
258
#ifndef TO_BE_DELETED	/* Alias for max_join_size */
259
sys_var_thd_ha_rows	sys_sql_max_join_size("sql_max_join_size",
unknown's avatar
unknown committed
260 261 262
					      &SV::max_join_size,
					      fix_max_join_size);
#endif
263 264 265 266
static sys_var_long_ptr_global
sys_max_prepared_stmt_count("max_prepared_stmt_count",
                            &max_prepared_stmt_count,
                            &LOCK_prepared_stmt_count);
267 268 269
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
270 271
sys_var_thd_ulong	sys_max_sort_length("max_sort_length",
					    &SV::max_sort_length);
272 273
sys_var_thd_ulong	sys_max_sp_recursion_depth("max_sp_recursion_depth",
                                                   &SV::max_sp_recursion_depth);
274
sys_var_max_user_conn   sys_max_user_connections("max_user_connections");
unknown's avatar
unknown committed
275 276 277 278
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
279 280
sys_var_thd_ulong       sys_multi_range_count("multi_range_count",
                                              &SV::multi_range_count);
unknown's avatar
unknown committed
281 282
sys_var_long_ptr	sys_myisam_data_pointer_size("myisam_data_pointer_size",
                                                    &myisam_data_pointer_size);
283
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);
284
sys_var_thd_ulong       sys_myisam_repair_threads("myisam_repair_threads", &SV::myisam_repair_threads);
unknown's avatar
unknown committed
285
sys_var_thd_ulong	sys_myisam_sort_buffer_size("myisam_sort_buffer_size", &SV::myisam_sort_buff_size);
286 287 288 289 290 291

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

unknown's avatar
unknown committed
292 293 294 295
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,
296
					     0, fix_net_read_timeout);
unknown's avatar
unknown committed
297 298
sys_var_thd_ulong	sys_net_write_timeout("net_write_timeout",
					      &SV::net_write_timeout,
299
					      0, fix_net_write_timeout);
300 301
sys_var_thd_ulong	sys_net_retry_count("net_retry_count",
					    &SV::net_retry_count,
302
					    0, fix_net_retry_count);
303
sys_var_thd_bool	sys_new_mode("new", &SV::new_mode);
304
sys_var_thd_bool	sys_old_passwords("old_passwords", &SV::old_passwords);
305 306 307 308
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
309 310
sys_var_thd_ulong       sys_preload_buff_size("preload_buffer_size",
                                              &SV::preload_buff_size);
unknown's avatar
unknown committed
311 312
sys_var_thd_ulong	sys_read_buff_size("read_buffer_size",
					   &SV::read_buff_size);
313
sys_var_bool_ptr	sys_readonly("read_only", &opt_readonly);
unknown's avatar
unknown committed
314 315
sys_var_thd_ulong	sys_read_rnd_buff_size("read_rnd_buffer_size",
					       &SV::read_rnd_buff_size);
unknown's avatar
unknown committed
316 317
sys_var_thd_ulong	sys_div_precincrement("div_precision_increment",
                                              &SV::div_precincrement);
318 319 320 321
#ifdef HAVE_REPLICATION
sys_var_bool_ptr	sys_relay_log_purge("relay_log_purge",
                                            &relay_log_purge);
#endif
unknown's avatar
unknown committed
322 323 324 325 326
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);
327 328 329 330

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",
331 332
						   &SV::query_alloc_block_size,
						   0, fix_thd_mem_root);
333
sys_var_thd_ulong	sys_query_prealloc_size("query_prealloc_size",
334 335
						&SV::query_prealloc_size,
						0, fix_thd_mem_root);
336
sys_var_readonly        sys_tmpdir("tmpdir", OPT_GLOBAL, SHOW_CHAR, get_tmpdir);
337
sys_var_thd_ulong	sys_trans_alloc_block_size("transaction_alloc_block_size",
338 339
						   &SV::trans_alloc_block_size,
						   0, fix_trans_mem_root);
340
sys_var_thd_ulong	sys_trans_prealloc_size("transaction_prealloc_size",
341 342
						&SV::trans_prealloc_size,
						0, fix_trans_mem_root);
343

unknown's avatar
unknown committed
344 345 346
#ifdef HAVE_QUERY_CACHE
sys_var_long_ptr	sys_query_cache_limit("query_cache_limit",
					      &query_cache.query_cache_limit);
347 348 349
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
350 351 352
sys_var_thd_enum	sys_query_cache_type("query_cache_type",
					     &SV::query_cache_type,
					     &query_cache_type_typelib);
353 354 355
sys_var_thd_bool
sys_query_cache_wlock_invalidate("query_cache_wlock_invalidate",
				 &SV::query_cache_wlock_invalidate);
unknown's avatar
unknown committed
356
#endif /* HAVE_QUERY_CACHE */
357
sys_var_bool_ptr	sys_secure_auth("secure_auth", &opt_secure_auth);
358 359
sys_var_const_str_ptr   sys_secure_file_priv("secure_file_priv",
                                             &opt_secure_file_priv);
360
sys_var_long_ptr	sys_server_id("server_id", &server_id, fix_server_id);
361 362
sys_var_bool_ptr	sys_slave_compressed_protocol("slave_compressed_protocol",
						      &opt_slave_compressed_protocol);
unknown's avatar
SCRUM  
unknown committed
363
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
364 365
sys_var_long_ptr	sys_slave_net_timeout("slave_net_timeout",
					      &slave_net_timeout);
366 367
sys_var_long_ptr	sys_slave_trans_retries("slave_transaction_retries",
                                                &slave_trans_retries);
368
#endif
unknown's avatar
unknown committed
369 370 371 372
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);
373 374
sys_var_thd_sql_mode    sys_sql_mode("sql_mode",
                                     &SV::sql_mode);
375 376 377 378 379 380 381 382 383 384 385 386 387 388 389
#ifdef HAVE_OPENSSL
extern char *opt_ssl_ca, *opt_ssl_capath, *opt_ssl_cert, *opt_ssl_cipher,
            *opt_ssl_key;
sys_var_const_str_ptr	sys_ssl_ca("ssl_ca", &opt_ssl_ca);
sys_var_const_str_ptr	sys_ssl_capath("ssl_capath", &opt_ssl_capath);
sys_var_const_str_ptr	sys_ssl_cert("ssl_cert", &opt_ssl_cert);
sys_var_const_str_ptr	sys_ssl_cipher("ssl_cipher", &opt_ssl_cipher);
sys_var_const_str_ptr	sys_ssl_key("ssl_key", &opt_ssl_key);
#else
sys_var_const_str	sys_ssl_ca("ssl_ca", NULL);
sys_var_const_str	sys_ssl_capath("ssl_capath", NULL);
sys_var_const_str	sys_ssl_cert("ssl_cert", NULL);
sys_var_const_str	sys_ssl_cipher("ssl_cipher", NULL);
sys_var_const_str	sys_ssl_key("ssl_key", NULL);
#endif
390 391 392 393
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
394

395 396
sys_var_thd_table_type  sys_table_type("table_type",
				       &SV::table_type);
unknown's avatar
unknown committed
397 398
sys_var_thd_storage_engine sys_storage_engine("storage_engine",
				       &SV::table_type);
399 400 401
#ifdef HAVE_REPLICATION
sys_var_sync_binlog_period sys_sync_binlog_period("sync_binlog", &sync_binlog_period);
#endif
402
sys_var_bool_ptr	sys_sync_frm("sync_frm", &opt_sync_frm);
403 404
sys_var_const_str	sys_system_time_zone("system_time_zone",
                                             system_time_zone);
unknown's avatar
unknown committed
405 406
sys_var_long_ptr	sys_table_cache_size("table_cache",
					     &table_cache_size);
407 408
sys_var_long_ptr	sys_table_lock_wait_timeout("table_lock_wait_timeout",
                                                    &table_lock_wait_timeout);
unknown's avatar
unknown committed
409 410 411 412 413 414
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);
415
sys_var_thd_ulonglong	sys_tmp_table_size("tmp_table_size",
unknown's avatar
unknown committed
416
					   &SV::tmp_table_size);
unknown's avatar
unknown committed
417 418
sys_var_bool_ptr  sys_timed_mutexes("timed_mutexes",
                                    &timed_mutexes);
419 420 421 422 423 424 425 426 427 428
sys_var_const_str	sys_version("version", server_version);
#ifdef HAVE_BERKELEY_DB
sys_var_const_str	sys_version_bdb("version_bdb", DB_VERSION_STRING);
#endif
sys_var_const_str	sys_version_comment("version_comment",
                                            MYSQL_COMPILATION_COMMENT);
sys_var_const_str	sys_version_compile_machine("version_compile_machine",
                                                    MACHINE_TYPE);
sys_var_const_str	sys_version_compile_os("version_compile_os",
                                               SYSTEM_TYPE);
unknown's avatar
unknown committed
429 430
sys_var_thd_ulong	sys_net_wait_timeout("wait_timeout",
					     &SV::net_wait_timeout);
431

432
#ifdef HAVE_INNOBASE_DB
433 434
sys_var_long_ptr	sys_innodb_fast_shutdown("innodb_fast_shutdown",
						 &innobase_fast_shutdown);
435 436
sys_var_long_ptr        sys_innodb_max_dirty_pages_pct("innodb_max_dirty_pages_pct",
                                                        &srv_max_buf_pool_modified_pct);
437 438
sys_var_long_ptr	sys_innodb_max_purge_lag("innodb_max_purge_lag",
							&srv_max_purge_lag);
439 440
sys_var_thd_bool	sys_innodb_table_locks("innodb_table_locks",
                                               &SV::innodb_table_locks);
441 442
sys_var_thd_bool	sys_innodb_support_xa("innodb_support_xa",
                                               &SV::innodb_support_xa);
443 444
sys_var_long_ptr	sys_innodb_autoextend_increment("innodb_autoextend_increment",
							&srv_auto_extend_increment);
445 446
sys_var_long_ptr	sys_innodb_sync_spin_loops("innodb_sync_spin_loops",
                                             &srv_n_spin_wait_rounds);
unknown's avatar
unknown committed
447
sys_var_long_ptr  sys_innodb_concurrency_tickets("innodb_concurrency_tickets",
unknown's avatar
unknown committed
448 449 450 451 452
                                             &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);
453 454
sys_var_long_ptr  sys_innodb_commit_concurrency("innodb_commit_concurrency",
                                                &srv_commit_concurrency);
unknown's avatar
unknown committed
455 456 457
sys_var_long_ptr  sys_innodb_flush_log_at_trx_commit(
                                        "innodb_flush_log_at_trx_commit",
                                        &srv_flush_log_at_trx_commit);
458
#endif
459

unknown's avatar
unknown committed
460 461 462 463 464
/* Condition pushdown to storage engine */
sys_var_thd_bool
sys_engine_condition_pushdown("engine_condition_pushdown",
			      &SV::engine_condition_pushdown);

465
#ifdef HAVE_NDBCLUSTER_DB
466
/* ndb thread specific variable settings */
467
sys_var_thd_ulong
468 469 470
sys_ndb_autoincrement_prefetch_sz("ndb_autoincrement_prefetch_sz",
				  &SV::ndb_autoincrement_prefetch_sz);
sys_var_thd_bool
471
sys_ndb_force_send("ndb_force_send", &SV::ndb_force_send);
472
sys_var_thd_bool
473
sys_ndb_use_exact_count("ndb_use_exact_count", &SV::ndb_use_exact_count);
474
sys_var_thd_bool
475
sys_ndb_use_transactions("ndb_use_transactions", &SV::ndb_use_transactions);
476 477
sys_var_long_ptr
sys_ndb_cache_check_time("ndb_cache_check_time", &ndb_cache_check_time);
478 479
sys_var_const_str
sys_ndb_connectstring("ndb_connectstring", opt_ndb_constrbuf);
480
#endif
481 482 483 484 485

/* Time/date/datetime formats */

sys_var_thd_date_time_format sys_time_format("time_format",
					     &SV::time_format,
486
					     MYSQL_TIMESTAMP_TIME);
487 488
sys_var_thd_date_time_format sys_date_format("date_format",
					     &SV::date_format,
489
					     MYSQL_TIMESTAMP_DATE);
490 491
sys_var_thd_date_time_format sys_datetime_format("datetime_format",
						 &SV::datetime_format,
492
						 MYSQL_TIMESTAMP_DATETIME);
493 494

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

496 497 498 499
sys_var_thd_bit sys_autocommit("autocommit", 0,
                               set_option_autocommit,
                               OPTION_NOT_AUTOCOMMIT,
                               1);
500
static sys_var_thd_bit	sys_big_tables("big_tables", 0,
unknown's avatar
unknown committed
501 502 503
				       set_option_bit,
				       OPTION_BIG_TABLES);
#ifndef TO_BE_DELETED	/* Alias for big_tables */
504
static sys_var_thd_bit	sys_sql_big_tables("sql_big_tables", 0,
unknown's avatar
unknown committed
505 506 507
					   set_option_bit,
					   OPTION_BIG_TABLES);
#endif
508
static sys_var_thd_bit	sys_big_selects("sql_big_selects", 0,
unknown's avatar
unknown committed
509
					set_option_bit,
510
					OPTION_BIG_SELECTS);
511 512
static sys_var_thd_bit	sys_log_off("sql_log_off",
				    check_log_update,
unknown's avatar
unknown committed
513 514 515
				    set_option_bit,
				    OPTION_LOG_OFF);
static sys_var_thd_bit	sys_log_update("sql_log_update",
516
                                       check_log_update,
unknown's avatar
unknown committed
517 518 519
				       set_log_update,
				       OPTION_UPDATE_LOG);
static sys_var_thd_bit	sys_log_binlog("sql_log_bin",
520 521 522 523
                                       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
524 525
					 set_option_bit,
					 OPTION_WARNINGS);
526 527
static sys_var_thd_bit	sys_sql_notes("sql_notes", 0,
					 set_option_bit,
528
					 OPTION_SQL_NOTES);
529
static sys_var_thd_bit	sys_auto_is_null("sql_auto_is_null", 0,
unknown's avatar
unknown committed
530 531
					 set_option_bit,
					 OPTION_AUTO_IS_NULL);
532
static sys_var_thd_bit	sys_safe_updates("sql_safe_updates", 0,
unknown's avatar
unknown committed
533 534
					 set_option_bit,
					 OPTION_SAFE_UPDATES);
535
static sys_var_thd_bit	sys_buffer_results("sql_buffer_result", 0,
unknown's avatar
unknown committed
536 537
					   set_option_bit,
					   OPTION_BUFFER_RESULT);
538
static sys_var_thd_bit	sys_quote_show_create("sql_quote_show_create", 0,
unknown's avatar
unknown committed
539 540
					      set_option_bit,
					      OPTION_QUOTE_SHOW_CREATE);
541
static sys_var_thd_bit	sys_foreign_key_checks("foreign_key_checks", 0,
542 543 544
					       set_option_bit,
					       OPTION_NO_FOREIGN_KEY_CHECKS,
					       1);
545
static sys_var_thd_bit	sys_unique_checks("unique_checks", 0,
546 547 548 549
					  set_option_bit,
					  OPTION_RELAXED_UNIQUE_CHECKS,
					  1);

unknown's avatar
unknown committed
550 551
/* Local state variables */

552
static sys_var_thd_ha_rows	sys_select_limit("sql_select_limit",
unknown's avatar
unknown committed
553 554 555 556
						 &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");
unknown's avatar
unknown committed
557 558 559

static sys_var_thd_lc_time_names       sys_lc_time_names("lc_time_names");

unknown's avatar
unknown committed
560
static sys_var_insert_id	sys_insert_id("insert_id");
561 562 563 564 565 566 567 568 569
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
570
/* alias for last_insert_id() to be compatible with Sybase */
unknown's avatar
SCRUM  
unknown committed
571
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
572
static sys_var_slave_skip_counter sys_slave_skip_counter("sql_slave_skip_counter");
573
#endif
574 575
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
576

577 578
static sys_var_thd_ulong        sys_default_week_format("default_week_format",
					                &SV::default_week_format);
unknown's avatar
unknown committed
579

unknown's avatar
unknown committed
580 581 582
sys_var_thd_ulong               sys_group_concat_max_len("group_concat_max_len",
                                                         &SV::group_concat_max_len);

583
sys_var_thd_time_zone            sys_time_zone("time_zone");
584 585 586

/* Read only variables */

587 588
sys_var_readonly                sys_have_innodb("have_innodb", OPT_GLOBAL,
                                                SHOW_CHAR, get_have_innodb);
589
/* Global read-only variable describing server license */
590
sys_var_const_str		sys_license("license", STRINGIFY_ARG(LICENSE));
591

592 593 594
/* Global read-only variable containing hostname */
sys_var_const_str		sys_hostname("hostname", glob_hostname);

unknown's avatar
unknown committed
595 596 597 598
sys_var_thd_bool  sys_keep_files_on_create("keep_files_on_create", 
                                           &SV::keep_files_on_create);
							    

599

600

unknown's avatar
unknown committed
601 602 603 604 605 606 607 608 609 610 611
/*
  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,
612 613
  &sys_auto_increment_increment,
  &sys_auto_increment_offset,
unknown's avatar
unknown committed
614
  &sys_autocommit,
615
  &sys_automatic_sp_privileges,
616
  &sys_basedir,
unknown's avatar
unknown committed
617 618 619 620 621
  &sys_big_tables,
  &sys_big_selects,
  &sys_binlog_cache_size,
  &sys_buffer_results,
  &sys_bulk_insert_buff_size,
622 623
  &sys_character_set_server,
  &sys_character_set_database,
624
  &sys_character_set_client,
unknown's avatar
unknown committed
625
  &sys_character_set_connection,
626
  &sys_character_set_results,
unknown's avatar
unknown committed
627
  &sys_character_set_filesystem,
628
  &sys_charset_system,
unknown's avatar
unknown committed
629
  &sys_collation_connection,
630 631
  &sys_collation_database,
  &sys_collation_server,
unknown's avatar
unknown committed
632
  &sys_completion_type,
unknown's avatar
unknown committed
633 634
  &sys_concurrent_insert,
  &sys_connect_timeout,
635
  &sys_datadir,
636 637
  &sys_date_format,
  &sys_datetime_format,
unknown's avatar
unknown committed
638
  &sys_div_precincrement,
639
  &sys_default_week_format,
unknown's avatar
unknown committed
640 641 642 643
  &sys_delay_key_write,
  &sys_delayed_insert_limit,
  &sys_delayed_insert_timeout,
  &sys_delayed_queue_size,
unknown's avatar
unknown committed
644
  &sys_keep_files_on_create,
645
  &sys_error_count,
unknown's avatar
unknown committed
646
  &sys_expire_logs_days,
unknown's avatar
unknown committed
647 648
  &sys_flush,
  &sys_flush_time,
649
  &sys_ft_boolean_syntax,
650
  &sys_foreign_key_checks,
unknown's avatar
unknown committed
651
  &sys_group_concat_max_len,
652
  &sys_have_innodb,
653
  &sys_hostname,
unknown's avatar
unknown committed
654
  &sys_identity,
unknown's avatar
unknown committed
655 656
  &sys_init_connect,
  &sys_init_slave,
unknown's avatar
unknown committed
657 658 659 660
  &sys_insert_id,
  &sys_interactive_timeout,
  &sys_join_buffer_size,
  &sys_key_buffer_size,
unknown's avatar
unknown committed
661
  &sys_key_cache_block_size,
662 663
  &sys_key_cache_division_limit,
  &sys_key_cache_age_threshold,
unknown's avatar
unknown committed
664
  &sys_last_insert_id,
unknown's avatar
unknown committed
665
  &sys_lc_time_names,
666
  &sys_license,
unknown's avatar
unknown committed
667 668 669
  &sys_local_infile,
  &sys_log_binlog,
  &sys_log_off,
670
  &sys_log_queries_not_using_indexes,
unknown's avatar
unknown committed
671 672 673 674 675 676 677 678 679 680
  &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,
681
  &sys_max_error_count,
682
  &sys_max_insert_delayed_threads,
unknown's avatar
unknown committed
683 684
  &sys_max_heap_table_size,
  &sys_max_join_size,
unknown's avatar
unknown committed
685
  &sys_max_length_for_sort_data,
686
  &sys_max_prepared_stmt_count,
687
  &sys_max_relay_log_size,
688
  &sys_max_seeks_for_key,
unknown's avatar
unknown committed
689
  &sys_max_sort_length,
690
  &sys_max_sp_recursion_depth,
unknown's avatar
unknown committed
691 692 693
  &sys_max_tmp_tables,
  &sys_max_user_connections,
  &sys_max_write_lock_count,
unknown's avatar
unknown committed
694
  &sys_multi_range_count,
unknown's avatar
unknown committed
695
  &sys_myisam_data_pointer_size,
unknown's avatar
unknown committed
696
  &sys_myisam_max_sort_file_size,
697
  &sys_myisam_repair_threads,
unknown's avatar
unknown committed
698
  &sys_myisam_sort_buffer_size,
699
  &sys_myisam_stats_method,
unknown's avatar
unknown committed
700 701
  &sys_net_buffer_length,
  &sys_net_read_timeout,
702
  &sys_net_retry_count,
unknown's avatar
unknown committed
703 704
  &sys_net_wait_timeout,
  &sys_net_write_timeout,
705
  &sys_new_mode,
706
  &sys_old_passwords,
707 708
  &sys_optimizer_prune_level,
  &sys_optimizer_search_depth,
unknown's avatar
unknown committed
709
  &sys_preload_buff_size,
unknown's avatar
unknown committed
710
  &sys_pseudo_thread_id,
711
  &sys_query_alloc_block_size,
unknown's avatar
unknown committed
712
  &sys_query_cache_size,
713
  &sys_query_prealloc_size,
unknown's avatar
unknown committed
714 715
#ifdef HAVE_QUERY_CACHE
  &sys_query_cache_limit,
716
  &sys_query_cache_min_res_unit,
unknown's avatar
unknown committed
717
  &sys_query_cache_type,
718
  &sys_query_cache_wlock_invalidate,
719
#endif /* HAVE_QUERY_CACHE */
unknown's avatar
unknown committed
720
  &sys_quote_show_create,
721 722
  &sys_rand_seed1,
  &sys_rand_seed2,
723
  &sys_range_alloc_block_size,
724
  &sys_readonly,
unknown's avatar
unknown committed
725 726
  &sys_read_buff_size,
  &sys_read_rnd_buff_size,
727 728 729
#ifdef HAVE_REPLICATION
  &sys_relay_log_purge,
#endif
unknown's avatar
unknown committed
730 731
  &sys_rpl_recovery_rank,
  &sys_safe_updates,
732
  &sys_secure_auth,
733
  &sys_secure_file_priv,
unknown's avatar
unknown committed
734 735
  &sys_select_limit,
  &sys_server_id,
unknown's avatar
SCRUM  
unknown committed
736
#ifdef HAVE_REPLICATION
737
  &sys_slave_compressed_protocol,
unknown's avatar
unknown committed
738
  &sys_slave_net_timeout,
739
  &sys_slave_trans_retries,
unknown's avatar
unknown committed
740
  &sys_slave_skip_counter,
741
#endif
unknown's avatar
unknown committed
742 743 744 745 746
  &sys_slow_launch_time,
  &sys_sort_buffer,
  &sys_sql_big_tables,
  &sys_sql_low_priority_updates,
  &sys_sql_max_join_size,
747
  &sys_sql_mode,
unknown's avatar
unknown committed
748
  &sys_sql_warnings,
749
  &sys_sql_notes,
750 751 752 753 754
  &sys_ssl_ca,
  &sys_ssl_capath,
  &sys_ssl_cert,
  &sys_ssl_cipher,
  &sys_ssl_key,
unknown's avatar
unknown committed
755
  &sys_storage_engine,
756 757 758
#ifdef HAVE_REPLICATION
  &sys_sync_binlog_period,
#endif
759
  &sys_sync_frm,
760
  &sys_system_time_zone,
unknown's avatar
unknown committed
761
  &sys_table_cache_size,
762
  &sys_table_lock_wait_timeout,
unknown's avatar
unknown committed
763 764
  &sys_table_type,
  &sys_thread_cache_size,
765
  &sys_time_format,
unknown's avatar
unknown committed
766
  &sys_timed_mutexes,
unknown's avatar
unknown committed
767
  &sys_timestamp,
768
  &sys_time_zone,
769
  &sys_tmpdir,
unknown's avatar
unknown committed
770
  &sys_tmp_table_size,
771 772
  &sys_trans_alloc_block_size,
  &sys_trans_prealloc_size,
unknown's avatar
unknown committed
773
  &sys_tx_isolation,
774 775 776 777 778 779 780
  &sys_version,
#ifdef HAVE_BERKELEY_DB
  &sys_version_bdb,
#endif
  &sys_version_comment,
  &sys_version_compile_machine,
  &sys_version_compile_os,
781
#ifdef HAVE_INNOBASE_DB
782
  &sys_innodb_fast_shutdown,
783
  &sys_innodb_max_dirty_pages_pct,
784
  &sys_innodb_max_purge_lag,
785
  &sys_innodb_table_locks,
786
  &sys_innodb_support_xa,
787
  &sys_innodb_autoextend_increment,
788
  &sys_innodb_sync_spin_loops,
unknown's avatar
unknown committed
789
  &sys_innodb_concurrency_tickets,
unknown's avatar
unknown committed
790 791
  &sys_innodb_thread_sleep_delay,
  &sys_innodb_thread_concurrency,
792
  &sys_innodb_commit_concurrency,
unknown's avatar
unknown committed
793
  &sys_innodb_flush_log_at_trx_commit,
unknown's avatar
foo1  
unknown committed
794
#endif
795
  &sys_trust_routine_creators,
796
  &sys_trust_function_creators,
unknown's avatar
unknown committed
797
  &sys_engine_condition_pushdown,
798 799
#ifdef HAVE_NDBCLUSTER_DB
  &sys_ndb_autoincrement_prefetch_sz,
800
  &sys_ndb_cache_check_time,
801
  &sys_ndb_connectstring,
802 803 804
  &sys_ndb_force_send,
  &sys_ndb_use_exact_count,
  &sys_ndb_use_transactions,
805
#endif
806
  &sys_unique_checks,
807
  &sys_updatable_views_with_limit,
808
  &sys_warning_count
unknown's avatar
unknown committed
809 810 811 812
};


/*
813
  Variables shown by SHOW VARIABLES in alphabetical order
unknown's avatar
unknown committed
814 815 816
*/

struct show_var_st init_vars[]= {
817
  {"auto_increment_increment", (char*) &sys_auto_increment_increment, SHOW_SYS},
818
  {"auto_increment_offset",   (char*) &sys_auto_increment_offset, SHOW_SYS},
819
  {sys_automatic_sp_privileges.name,(char*) &sys_automatic_sp_privileges,       SHOW_SYS},
unknown's avatar
unknown committed
820
  {"back_log",                (char*) &back_log,                    SHOW_LONG},
821
  {sys_basedir.name,          (char*) &sys_basedir,                 SHOW_SYS},
unknown's avatar
unknown committed
822 823 824
#ifdef HAVE_BERKELEY_DB
  {"bdb_cache_size",          (char*) &berkeley_cache_size,         SHOW_LONG},
  {"bdb_home",                (char*) &berkeley_home,               SHOW_CHAR_PTR},
825
  {"bdb_log_buffer_size",     (char*) &berkeley_log_buffer_size,    SHOW_LONG},
unknown's avatar
unknown committed
826
  {"bdb_logdir",              (char*) &berkeley_logdir,             SHOW_CHAR_PTR},
827
  {"bdb_max_lock",            (char*) &berkeley_max_lock,	    SHOW_LONG},
unknown's avatar
unknown committed
828 829 830 831 832
  {"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},
833
  {sys_character_set_client.name,(char*) &sys_character_set_client, SHOW_SYS},
unknown's avatar
unknown committed
834
  {sys_character_set_connection.name,(char*) &sys_character_set_connection,SHOW_SYS},
835
  {sys_character_set_database.name, (char*) &sys_character_set_database,SHOW_SYS},
unknown's avatar
unknown committed
836
  {sys_character_set_filesystem.name,(char*) &sys_character_set_filesystem, SHOW_SYS},
837
  {sys_character_set_results.name,(char*) &sys_character_set_results, SHOW_SYS},
838 839 840
  {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
841
  {sys_collation_connection.name,(char*) &sys_collation_connection, SHOW_SYS},
842 843
  {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
844
  {sys_completion_type.name,  (char*) &sys_completion_type,	    SHOW_SYS},
unknown's avatar
unknown committed
845 846
  {sys_concurrent_insert.name,(char*) &sys_concurrent_insert,       SHOW_SYS},
  {sys_connect_timeout.name,  (char*) &sys_connect_timeout,         SHOW_SYS},
847
  {sys_datadir.name,          (char*) &sys_datadir,                 SHOW_SYS},
848 849 850
  {sys_date_format.name,      (char*) &sys_date_format,		    SHOW_SYS},
  {sys_datetime_format.name,  (char*) &sys_datetime_format,	    SHOW_SYS},
  {sys_default_week_format.name, (char*) &sys_default_week_format,  SHOW_SYS},
unknown's avatar
unknown committed
851 852 853 854
  {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
855
  {sys_div_precincrement.name,(char*) &sys_div_precincrement,SHOW_SYS},
unknown's avatar
unknown committed
856
  {sys_keep_files_on_create.name,(char*) &sys_keep_files_on_create, SHOW_SYS},
unknown's avatar
foo1  
unknown committed
857
  {sys_engine_condition_pushdown.name,
unknown's avatar
unknown committed
858
   (char*) &sys_engine_condition_pushdown,                          SHOW_SYS},
unknown's avatar
unknown committed
859
  {sys_expire_logs_days.name, (char*) &sys_expire_logs_days,        SHOW_SYS},
unknown's avatar
unknown committed
860 861
  {sys_flush.name,             (char*) &sys_flush,                  SHOW_SYS},
  {sys_flush_time.name,        (char*) &sys_flush_time,             SHOW_SYS},
862
  {sys_ft_boolean_syntax.name,(char*) &ft_boolean_syntax,	    SHOW_CHAR},
unknown's avatar
unknown committed
863
  {"ft_max_word_len",         (char*) &ft_max_word_len,             SHOW_LONG},
864
  {"ft_min_word_len",         (char*) &ft_min_word_len,             SHOW_LONG},
865
  {"ft_query_expansion_limit",(char*) &ft_query_expansion_limit,    SHOW_LONG},
866
  {"ft_stopword_file",        (char*) &ft_stopword_file,            SHOW_CHAR_PTR},
867
  {sys_group_concat_max_len.name, (char*) &sys_group_concat_max_len,  SHOW_SYS},
868
  {"have_archive",	      (char*) &have_archive_db,	            SHOW_HAVE},
unknown's avatar
unknown committed
869
  {"have_bdb",		      (char*) &have_berkeley_db,	    SHOW_HAVE},
870
  {"have_blackhole_engine",   (char*) &have_blackhole_db,	    SHOW_HAVE},
unknown's avatar
unknown committed
871
  {"have_compress",	      (char*) &have_compress,		    SHOW_HAVE},
872
  {"have_crypt",	      (char*) &have_crypt,		    SHOW_HAVE},
873
  {"have_csv",	              (char*) &have_csv_db,	            SHOW_HAVE},
874
  {"have_dynamic_loading",    (char*) &have_dlopen,	            SHOW_HAVE},
875
  {"have_example_engine",     (char*) &have_example_db,	            SHOW_HAVE},
876
  {"have_federated_engine",   (char*) &have_federated_db,           SHOW_HAVE},
unknown's avatar
unknown committed
877
  {"have_geometry",           (char*) &have_geometry,               SHOW_HAVE},
unknown's avatar
unknown committed
878
  {"have_innodb",	      (char*) &have_innodb,		    SHOW_HAVE},
879
  {"have_isam",		      (char*) &have_isam,		    SHOW_HAVE},
880
  {"have_merge_engine",       (char*) &have_merge_db,               SHOW_HAVE},
881
  {"have_ndbcluster",         (char*) &have_ndbcluster,             SHOW_HAVE},
882 883 884
  /* have_openssl is just and alias for have_ssl */
  {"have_openssl",	      (char*) &have_ssl,		    SHOW_HAVE},
  {"have_ssl",	              (char*) &have_ssl,		    SHOW_HAVE},
unknown's avatar
unknown committed
885
  {"have_query_cache",        (char*) &have_query_cache,            SHOW_HAVE},
886
  {"have_raid",		      (char*) &have_raid,		    SHOW_HAVE},
887
  {"have_rtree_keys",         (char*) &have_rtree_keys,             SHOW_HAVE},
888
  {"have_symlink",            (char*) &have_symlink,                SHOW_HAVE},
889
  {sys_hostname.name,         (char*) &sys_hostname,                SHOW_SYS},
unknown's avatar
unknown committed
890
  {"init_connect",            (char*) &sys_init_connect,            SHOW_SYS},
891
  {"init_file",               (char*) &opt_init_file,               SHOW_CHAR_PTR},
unknown's avatar
unknown committed
892
  {"init_slave",              (char*) &sys_init_slave,              SHOW_SYS},
unknown's avatar
unknown committed
893 894
#ifdef HAVE_INNOBASE_DB
  {"innodb_additional_mem_pool_size", (char*) &innobase_additional_mem_pool_size, SHOW_LONG },
895
  {sys_innodb_autoextend_increment.name, (char*) &sys_innodb_autoextend_increment, SHOW_SYS},
unknown's avatar
unknown committed
896
  {"innodb_buffer_pool_awe_mem_mb", (char*) &innobase_buffer_pool_awe_mem_mb, SHOW_LONG },
897
  {"innodb_buffer_pool_size", (char*) &innobase_buffer_pool_size, SHOW_LONGLONG },
unknown's avatar
unknown committed
898
  {"innodb_checksums", (char*) &innobase_use_checksums, SHOW_MY_BOOL},
unknown's avatar
unknown committed
899
  {sys_innodb_commit_concurrency.name, (char*) &sys_innodb_commit_concurrency, SHOW_SYS},
unknown's avatar
unknown committed
900
  {sys_innodb_concurrency_tickets.name, (char*) &sys_innodb_concurrency_tickets, SHOW_SYS},
unknown's avatar
unknown committed
901 902
  {"innodb_data_file_path", (char*) &innobase_data_file_path,	    SHOW_CHAR_PTR},
  {"innodb_data_home_dir",  (char*) &innobase_data_home_dir,	    SHOW_CHAR_PTR},
903
  {"innodb_doublewrite", (char*) &innobase_use_doublewrite, SHOW_MY_BOOL},
904
  {sys_innodb_fast_shutdown.name,(char*) &sys_innodb_fast_shutdown, SHOW_SYS},
905
  {"innodb_file_io_threads", (char*) &innobase_file_io_threads, SHOW_LONG },
unknown's avatar
unknown committed
906
  {"innodb_file_per_table", (char*) &innobase_file_per_table, SHOW_MY_BOOL},
unknown's avatar
unknown committed
907
  {sys_innodb_flush_log_at_trx_commit.name, (char*) &sys_innodb_flush_log_at_trx_commit, SHOW_SYS},
unknown's avatar
unknown committed
908
  {"innodb_flush_method",    (char*) &innobase_unix_file_flush_method, SHOW_CHAR_PTR},
909
  {"innodb_force_recovery", (char*) &innobase_force_recovery, SHOW_LONG },
unknown's avatar
unknown committed
910
  {"innodb_lock_wait_timeout", (char*) &innobase_lock_wait_timeout, SHOW_LONG },
unknown's avatar
unknown committed
911
  {"innodb_locks_unsafe_for_binlog", (char*) &innobase_locks_unsafe_for_binlog, SHOW_MY_BOOL},
unknown's avatar
unknown committed
912 913 914
  {"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 },
915
  {"innodb_log_file_size", (char*) &innobase_log_file_size, SHOW_LONGLONG},
unknown's avatar
unknown committed
916 917
  {"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},
918
  {sys_innodb_max_dirty_pages_pct.name, (char*) &sys_innodb_max_dirty_pages_pct, SHOW_SYS},
919
  {sys_innodb_max_purge_lag.name, (char*) &sys_innodb_max_purge_lag, SHOW_SYS},
920 921
  {"innodb_mirrored_log_groups", (char*) &innobase_mirrored_log_groups, SHOW_LONG},
  {"innodb_open_files", (char*) &innobase_open_files, SHOW_LONG },
922
  {"innodb_rollback_on_timeout", (char*) &innobase_rollback_on_timeout, SHOW_MY_BOOL},
unknown's avatar
unknown committed
923
  {sys_innodb_support_xa.name, (char*) &sys_innodb_support_xa, SHOW_SYS},
924
  {sys_innodb_sync_spin_loops.name, (char*) &sys_innodb_sync_spin_loops, SHOW_SYS},
unknown's avatar
unknown committed
925
  {sys_innodb_table_locks.name, (char*) &sys_innodb_table_locks, SHOW_SYS},
unknown's avatar
unknown committed
926 927
  {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
928 929 930 931
#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},
932 933
  {sys_key_cache_age_threshold.name,   (char*) &sys_key_cache_age_threshold,
                                                                    SHOW_SYS},
unknown's avatar
unknown committed
934
  {sys_key_cache_block_size.name,   (char*) &sys_key_cache_block_size,
935
                                                                    SHOW_SYS},
936
  {sys_key_cache_division_limit.name,   (char*) &sys_key_cache_division_limit,
937
                                                                    SHOW_SYS},
unknown's avatar
unknown committed
938
  {"language",                language,                             SHOW_CHAR},
939
  {"large_files_support",     (char*) &opt_large_files,             SHOW_BOOL},
940
  {"large_page_size",         (char*) &opt_large_page_size,         SHOW_INT},
unknown's avatar
unknown committed
941
  {"large_pages",             (char*) &opt_large_pages,             SHOW_MY_BOOL},
unknown's avatar
unknown committed
942
  {sys_lc_time_names.name,    (char*) &sys_lc_time_names,           SHOW_SYS},
943
  {sys_license.name,	      (char*) &sys_license,                 SHOW_SYS},
unknown's avatar
unknown committed
944 945 946 947 948 949
  {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},
950
  {sys_trust_function_creators.name,(char*) &sys_trust_function_creators, SHOW_SYS},
951
  {"log_error",               (char*) log_error_file,               SHOW_CHAR},
952 953
  {sys_log_queries_not_using_indexes.name,
    (char*) &sys_log_queries_not_using_indexes, SHOW_SYS},
unknown's avatar
SCRUM  
unknown committed
954
#ifdef HAVE_REPLICATION
955
  {"log_slave_updates",       (char*) &opt_log_slave_updates,       SHOW_MY_BOOL},
956
#endif
unknown's avatar
unknown committed
957 958 959 960
  {"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},
961
  {"lower_case_file_system",  (char*) &lower_case_file_system,      SHOW_MY_BOOL},
962
  {"lower_case_table_names",  (char*) &lower_case_table_names,      SHOW_INT},
unknown's avatar
unknown committed
963 964 965 966
  {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},
967
  {sys_max_connections.name,    (char*) &sys_max_connections,	    SHOW_SYS},
unknown's avatar
unknown committed
968
  {sys_max_delayed_threads.name,(char*) &sys_max_delayed_threads,   SHOW_SYS},
969
  {sys_max_error_count.name,	(char*) &sys_max_error_count,	    SHOW_SYS},
unknown's avatar
unknown committed
970
  {sys_max_heap_table_size.name,(char*) &sys_max_heap_table_size,   SHOW_SYS},
971 972
  {sys_max_insert_delayed_threads.name,
   (char*) &sys_max_insert_delayed_threads,   SHOW_SYS},
unknown's avatar
unknown committed
973
  {sys_max_join_size.name,	(char*) &sys_max_join_size,	    SHOW_SYS},
unknown's avatar
unknown committed
974
  {sys_max_length_for_sort_data.name, (char*) &sys_max_length_for_sort_data,
unknown's avatar
unknown committed
975
   SHOW_SYS},
976 977
  {sys_max_prepared_stmt_count.name, (char*) &sys_max_prepared_stmt_count,
    SHOW_SYS},
978 979
  {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
980
  {sys_max_sort_length.name,	(char*) &sys_max_sort_length,	    SHOW_SYS},
981 982
  {sys_max_sp_recursion_depth.name,
    (char*) &sys_max_sp_recursion_depth, SHOW_SYS},
983
  {sys_max_tmp_tables.name,	(char*) &sys_max_tmp_tables,	    SHOW_SYS},
984
  {sys_max_user_connections.name,(char*) &sys_max_user_connections, SHOW_SYS},
unknown's avatar
unknown committed
985
  {sys_max_write_lock_count.name, (char*) &sys_max_write_lock_count,SHOW_SYS},
unknown's avatar
unknown committed
986
  {sys_multi_range_count.name,  (char*) &sys_multi_range_count,     SHOW_SYS},
unknown's avatar
unknown committed
987
  {sys_myisam_data_pointer_size.name, (char*) &sys_myisam_data_pointer_size, SHOW_SYS},
988 989
  {sys_myisam_max_sort_file_size.name, (char*) &sys_myisam_max_sort_file_size,
   SHOW_SYS},
990
  {"myisam_recover_options",  (char*) &myisam_recover_options_str,  SHOW_CHAR_PTR},
991
  {sys_myisam_repair_threads.name, (char*) &sys_myisam_repair_threads,
unknown's avatar
unknown committed
992 993
   SHOW_SYS},
  {sys_myisam_sort_buffer_size.name, (char*) &sys_myisam_sort_buffer_size, SHOW_SYS},
unknown's avatar
foo1  
unknown committed
994

995
  {sys_myisam_stats_method.name, (char*) &sys_myisam_stats_method, SHOW_SYS},
unknown's avatar
foo1  
unknown committed
996

unknown's avatar
unknown committed
997
#ifdef __NT__
998
  {"named_pipe",	      (char*) &opt_enable_named_pipe,       SHOW_MY_BOOL},
999 1000 1001 1002 1003 1004 1005
#endif
#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
1006
  {sys_ndb_cache_check_time.name,(char*) &sys_ndb_cache_check_time, SHOW_SYS},
1007
  {sys_ndb_connectstring.name,(char*) &sys_ndb_connectstring,       SHOW_SYS},
unknown's avatar
unknown committed
1008 1009 1010
#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},
1011
  {sys_net_retry_count.name,  (char*) &sys_net_retry_count,	    SHOW_SYS},
unknown's avatar
unknown committed
1012
  {sys_net_write_timeout.name,(char*) &sys_net_write_timeout,       SHOW_SYS},
1013
  {sys_new_mode.name,         (char*) &sys_new_mode,                SHOW_SYS},
1014
  {sys_old_passwords.name,    (char*) &sys_old_passwords,           SHOW_SYS},
unknown's avatar
unknown committed
1015
  {"open_files_limit",	      (char*) &open_files_limit,	    SHOW_LONG},
1016 1017 1018 1019
  {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
1020
  {"pid_file",                (char*) pidfile_name,                 SHOW_CHAR},
1021
  {"port",                    (char*) &mysqld_port,                  SHOW_INT},
unknown's avatar
unknown committed
1022
  {sys_preload_buff_size.name, (char*) &sys_preload_buff_size,      SHOW_SYS},
1023
  {"protocol_version",        (char*) &protocol_version,            SHOW_INT},
1024 1025
  {sys_query_alloc_block_size.name, (char*) &sys_query_alloc_block_size,
   SHOW_SYS},
unknown's avatar
unknown committed
1026
#ifdef HAVE_QUERY_CACHE
unknown's avatar
unknown committed
1027
  {sys_query_cache_limit.name,(char*) &sys_query_cache_limit,	    SHOW_SYS},
1028 1029
  {sys_query_cache_min_res_unit.name, (char*) &sys_query_cache_min_res_unit,
   SHOW_SYS},
unknown's avatar
unknown committed
1030 1031
  {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
1032 1033
  {sys_query_cache_wlock_invalidate.name,
   (char *) &sys_query_cache_wlock_invalidate, SHOW_SYS},
unknown's avatar
unknown committed
1034
#endif /* HAVE_QUERY_CACHE */
1035
  {sys_query_prealloc_size.name, (char*) &sys_query_prealloc_size,  SHOW_SYS},
1036 1037
  {sys_range_alloc_block_size.name, (char*) &sys_range_alloc_block_size,
   SHOW_SYS},
unknown's avatar
unknown committed
1038 1039 1040
  {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
1041 1042
#ifdef HAVE_REPLICATION
  {sys_relay_log_purge.name,  (char*) &sys_relay_log_purge,         SHOW_SYS},
1043
  {"relay_log_space_limit",  (char*) &relay_log_space_limit,        SHOW_LONGLONG},
unknown's avatar
unknown committed
1044
#endif
unknown's avatar
unknown committed
1045
  {sys_rpl_recovery_rank.name,(char*) &sys_rpl_recovery_rank,       SHOW_SYS},
1046
  {"secure_auth",             (char*) &sys_secure_auth,             SHOW_SYS},
1047
  {"secure_file_priv",        (char*) &sys_secure_file_priv,        SHOW_SYS},
1048 1049 1050 1051
#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
1052
  {sys_server_id.name,	      (char*) &sys_server_id,		    SHOW_SYS},
1053
  {"skip_external_locking",   (char*) &my_disable_locking,          SHOW_MY_BOOL},
unknown's avatar
unknown committed
1054 1055
  {"skip_networking",         (char*) &opt_disable_networking,      SHOW_BOOL},
  {"skip_show_database",      (char*) &opt_skip_show_db,            SHOW_BOOL},
1056
#ifdef HAVE_REPLICATION
1057 1058 1059
  {sys_slave_compressed_protocol.name,
    (char*) &sys_slave_compressed_protocol,           SHOW_SYS},
  {"slave_load_tmpdir",       (char*) &slave_load_tmpdir,           SHOW_CHAR_PTR},
1060
  {sys_slave_net_timeout.name,(char*) &sys_slave_net_timeout,	    SHOW_SYS},
1061
  {"slave_skip_errors",       (char*) &slave_error_mask,            SHOW_SLAVE_SKIP_ERRORS},
1062
  {sys_slave_trans_retries.name,(char*) &sys_slave_trans_retries,   SHOW_SYS},
1063
#endif
unknown's avatar
unknown committed
1064
  {sys_slow_launch_time.name, (char*) &sys_slow_launch_time,        SHOW_SYS},
1065
#ifdef HAVE_SYS_UN_H
1066
  {"socket",                  (char*) &mysqld_unix_port,             SHOW_CHAR_PTR},
1067
#endif
1068 1069
  {sys_sort_buffer.name,      (char*) &sys_sort_buffer,             SHOW_SYS},
  {sys_big_selects.name,      (char*) &sys_big_selects,             SHOW_SYS},
1070
  {sys_sql_mode.name,         (char*) &sys_sql_mode,                SHOW_SYS},
1071 1072
  {"sql_notes",               (char*) &sys_sql_notes,               SHOW_SYS},
  {"sql_warnings",            (char*) &sys_sql_warnings,            SHOW_SYS},
1073 1074 1075 1076 1077
  {sys_ssl_ca.name,           (char*) &sys_ssl_ca,                  SHOW_SYS},
  {sys_ssl_capath.name,       (char*) &sys_ssl_capath,              SHOW_SYS},
  {sys_ssl_cert.name,         (char*) &sys_ssl_cert,                SHOW_SYS},
  {sys_ssl_cipher.name,       (char*) &sys_ssl_cipher,              SHOW_SYS},
  {sys_ssl_key.name,          (char*) &sys_ssl_key,                 SHOW_SYS},
unknown's avatar
unknown committed
1078
  {sys_storage_engine.name,   (char*) &sys_storage_engine,          SHOW_SYS},
1079 1080 1081
#ifdef HAVE_REPLICATION
  {sys_sync_binlog_period.name,(char*) &sys_sync_binlog_period,     SHOW_SYS},
#endif
unknown's avatar
unknown committed
1082
  {sys_sync_frm.name,         (char*) &sys_sync_frm,               SHOW_SYS},
1083 1084 1085
#ifdef HAVE_TZNAME
  {"system_time_zone",        system_time_zone,                     SHOW_CHAR},
#endif
unknown's avatar
unknown committed
1086
  {"table_cache",             (char*) &table_cache_size,            SHOW_LONG},
1087
  {"table_lock_wait_timeout", (char*) &table_lock_wait_timeout,     SHOW_LONG },
unknown's avatar
unknown committed
1088 1089 1090 1091 1092 1093
  {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},
1094
  {sys_time_format.name,      (char*) &sys_time_format,		    SHOW_SYS},
1095
  {"time_zone",               (char*) &sys_time_zone,               SHOW_SYS},
unknown's avatar
unknown committed
1096
  {sys_timed_mutexes.name,    (char*) &sys_timed_mutexes,       SHOW_SYS},
unknown's avatar
unknown committed
1097
  {sys_tmp_table_size.name,   (char*) &sys_tmp_table_size,	    SHOW_SYS},
1098
  {sys_tmpdir.name,           (char*) &sys_tmpdir,	            SHOW_SYS},
1099 1100 1101
  {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},
1102
  {sys_tx_isolation.name,     (char*) &sys_tx_isolation,	    SHOW_SYS},
1103 1104
  {sys_updatable_views_with_limit.name,
                              (char*) &sys_updatable_views_with_limit,SHOW_SYS},
1105
  {sys_version.name,          (char*) &sys_version,                 SHOW_SYS},
1106
#ifdef HAVE_BERKELEY_DB
1107
  {sys_version_bdb.name,      (char*) &sys_version_bdb,             SHOW_SYS},
1108
#endif
1109 1110 1111 1112
  {sys_version_comment.name,  (char*) &sys_version_comment,         SHOW_SYS},
  {sys_version_compile_machine.name, (char*) &sys_version_compile_machine,
   SHOW_SYS},
  {sys_version_compile_os.name,	(char*) &sys_version_compile_os,    SHOW_SYS},
unknown's avatar
unknown committed
1113 1114 1115 1116
  {sys_net_wait_timeout.name, (char*) &sys_net_wait_timeout,	    SHOW_SYS},
  {NullS, NullS, SHOW_LONG}
};

1117

1118 1119 1120 1121 1122 1123
bool sys_var::check(THD *thd, set_var *var)
{
  var->save_result.ulonglong_value= var->value->val_int();
  return 0;
}

1124 1125 1126 1127 1128 1129 1130
bool sys_var_str::check(THD *thd, set_var *var)
{
  int res;
  if (!check_func)
    return 0;

  if ((res=(*check_func)(thd, var)) < 0)
1131 1132
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0),
             name, var->value->str_value.ptr());
1133 1134 1135
  return res;
}

unknown's avatar
unknown committed
1136 1137 1138 1139
/*
  Functions to check and update variables
*/

unknown's avatar
unknown committed
1140

1141 1142 1143 1144 1145 1146 1147 1148 1149 1150
/*
  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
1151
{
1152 1153 1154 1155
  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*) "";
1156
  if (!(res= my_strdup_with_length(old_value, new_length, MYF(0))))
1157
    return 1;
unknown's avatar
unknown committed
1158 1159 1160 1161
  /*
    Replace the old value in such a way that the any thread using
    the value will work.
  */
1162 1163 1164 1165 1166
  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
1167 1168 1169 1170 1171
  my_free(old_value, MYF(MY_ALLOW_ZERO_PTR));
  return 0;
}


1172 1173 1174 1175 1176 1177
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
1178 1179
static void sys_default_init_connect(THD* thd, enum_var_type type)
{
1180
  update_sys_var_str(&sys_init_connect, &LOCK_sys_init_connect, 0);
unknown's avatar
unknown committed
1181 1182 1183 1184 1185
}


static bool sys_update_init_slave(THD *thd, set_var *var)
{
1186
  return update_sys_var_str(&sys_init_slave, &LOCK_sys_init_slave, var);
unknown's avatar
unknown committed
1187 1188 1189 1190 1191
}


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

1195 1196
static int sys_check_ftb_syntax(THD *thd,  set_var *var)
{
1197 1198 1199 1200
  if (thd->security_ctx->master_access & SUPER_ACL)
    return (ft_boolean_check_syntax_string((byte*)
                                           var->value->str_value.c_ptr()) ?
            -1 : 0);
1201 1202 1203 1204 1205 1206 1207 1208 1209 1210 1211
  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);
1212 1213 1214 1215 1216

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

1217 1218 1219 1220 1221
  return 0;
}

static void sys_default_ftb_syntax(THD *thd, enum_var_type type)
{
1222
  strmake(ft_boolean_syntax, def_ft_boolean_syntax,
1223 1224
	  sizeof(ft_boolean_syntax)-1);
}
unknown's avatar
unknown committed
1225

unknown's avatar
unknown committed
1226 1227 1228 1229 1230 1231 1232 1233

/*
  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)
{
1234 1235 1236 1237 1238
  if (type == OPT_GLOBAL)
    thr_upgraded_concurrent_insert_lock= 
      (global_system_variables.low_priority_updates ?
       TL_WRITE_LOW_PRIORITY : TL_WRITE);
  else
unknown's avatar
unknown committed
1239 1240 1241 1242 1243
    thd->update_lock_default= (thd->variables.low_priority_updates ?
			       TL_WRITE_LOW_PRIORITY : TL_WRITE);
}


1244 1245 1246 1247 1248 1249 1250
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
1251 1252 1253 1254 1255 1256 1257 1258
/*
  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)
  {
1259
    if (thd->variables.max_join_size == HA_POS_ERROR)
unknown's avatar
unknown committed
1260 1261 1262 1263 1264
      thd->options|= OPTION_BIG_SELECTS;
    else
      thd->options&= ~OPTION_BIG_SELECTS;
  }
}
1265

unknown's avatar
unknown committed
1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278

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

1279 1280
static void fix_completion_type(THD *thd __attribute__((unused)),
				enum_var_type type __attribute__((unused))) {}
unknown's avatar
unknown committed
1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293

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
1294 1295 1296 1297 1298

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

unknown's avatar
SCRUM  
unknown committed
1299
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
1300 1301 1302
static void fix_net_read_timeout(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
1303
    my_net_set_read_timeout(&thd->net, thd->variables.net_read_timeout);
unknown's avatar
unknown committed
1304 1305 1306 1307 1308 1309
}


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

1313 1314 1315 1316 1317
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
1318
#else /* HAVE_REPLICATION */
1319 1320
static void fix_net_read_timeout(THD *thd __attribute__((unused)),
				 enum_var_type type __attribute__((unused)))
1321
{}
1322 1323
static void fix_net_write_timeout(THD *thd __attribute__((unused)),
				  enum_var_type type __attribute__((unused)))
1324
{}
1325 1326
static void fix_net_retry_count(THD *thd __attribute__((unused)),
				enum_var_type type __attribute__((unused)))
1327
{}
unknown's avatar
SCRUM  
unknown committed
1328
#endif /* HAVE_REPLICATION */
1329

unknown's avatar
unknown committed
1330 1331 1332 1333

static void fix_query_cache_size(THD *thd, enum_var_type type)
{
#ifdef HAVE_QUERY_CACHE
1334
  ulong requested= query_cache_size;
unknown's avatar
unknown committed
1335
  query_cache.resize(query_cache_size);
1336 1337 1338 1339
  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
1340 1341 1342 1343
#endif
}


1344 1345 1346
#ifdef HAVE_QUERY_CACHE
static void fix_query_cache_min_res_unit(THD *thd, enum_var_type type)
{
unknown's avatar
foo1  
unknown committed
1347
  query_cache_min_res_unit=
1348 1349 1350 1351 1352
    query_cache.set_min_res_unit(query_cache_min_res_unit);
}
#endif


1353
extern void fix_delay_key_write(THD *thd, enum_var_type type)
1354 1355 1356 1357 1358 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368
{
  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;
  }
}

1369
static void fix_max_binlog_size(THD *thd, enum_var_type type)
1370 1371 1372 1373 1374
{
  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);
1375
#ifdef HAVE_REPLICATION
1376 1377
  if (!max_relay_log_size)
    active_mi->rli.relay_log.set_max_size(max_binlog_size);
unknown's avatar
unknown committed
1378
#endif
1379 1380 1381
  DBUG_VOID_RETURN;
}

1382
static void fix_max_relay_log_size(THD *thd, enum_var_type type)
1383 1384 1385 1386
{
  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));
1387
#ifdef HAVE_REPLICATION
1388 1389
  active_mi->rli.relay_log.set_max_size(max_relay_log_size ?
                                        max_relay_log_size: max_binlog_size);
1390
#endif
1391 1392
  DBUG_VOID_RETURN;
}
1393

1394

1395 1396
static int check_max_delayed_threads(THD *thd, set_var *var)
{
unknown's avatar
unknown committed
1397
  longlong val= var->value->val_int();
1398
  if (var->type != OPT_GLOBAL && val != 0 &&
unknown's avatar
unknown committed
1399
      val != (longlong) global_system_variables.max_insert_delayed_threads)
1400 1401
  {
    char buf[64];
1402
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), var->var->name, llstr(val, buf));
1403 1404 1405 1406 1407
    return 1;
  }
  return 0;
}

1408
static void fix_max_connections(THD *thd, enum_var_type type)
1409
{
1410
#ifndef EMBEDDED_LIBRARY
unknown's avatar
foo1  
unknown committed
1411
  resize_thr_alarm(max_connections +
1412
		   global_system_variables.max_insert_delayed_threads + 10);
1413
#endif
1414 1415 1416 1417 1418 1419
}


static void fix_thd_mem_root(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
unknown's avatar
unknown committed
1420
    reset_root_defaults(thd->mem_root,
1421 1422 1423 1424 1425 1426 1427
                        thd->variables.query_alloc_block_size,
                        thd->variables.query_prealloc_size);
}


static void fix_trans_mem_root(THD *thd, enum_var_type type)
{
1428
#ifdef USING_TRANSACTIONS
1429 1430 1431 1432
  if (type != OPT_GLOBAL)
    reset_root_defaults(&thd->transaction.mem_root,
                        thd->variables.trans_alloc_block_size,
                        thd->variables.trans_prealloc_size);
1433
#endif
1434 1435
}

1436

1437 1438 1439 1440
static void fix_server_id(THD *thd, enum_var_type type)
{
  server_id_supplied = 1;
}
1441

1442 1443

sys_var_long_ptr::
1444
sys_var_long_ptr(const char *name_arg, ulong *value_ptr_arg,
1445
                 sys_after_update_func after_update_arg)
1446
  :sys_var_long_ptr_global(name_arg, value_ptr_arg,
1447 1448 1449 1450 1451
                           &LOCK_global_system_variables, after_update_arg)
{}


bool sys_var_long_ptr_global::check(THD *thd, set_var *var)
unknown's avatar
unknown committed
1452 1453 1454 1455 1456
{
  longlong v= var->value->val_int();
  var->save_result.ulonglong_value= v < 0 ? 0 : v;
  return 0;
}
1457

1458
bool sys_var_long_ptr_global::update(THD *thd, set_var *var)
unknown's avatar
unknown committed
1459
{
1460
  ulonglong tmp= var->save_result.ulonglong_value;
1461
  pthread_mutex_lock(guard);
unknown's avatar
unknown committed
1462 1463 1464 1465
  if (option_limits)
    *value= (ulong) getopt_ull_limit_value(tmp, option_limits);
  else
    *value= (ulong) tmp;
1466
  pthread_mutex_unlock(guard);
unknown's avatar
unknown committed
1467 1468 1469 1470
  return 0;
}


1471
void sys_var_long_ptr_global::set_default(THD *thd, enum_var_type type)
unknown's avatar
unknown committed
1472
{
1473
  pthread_mutex_lock(guard);
unknown's avatar
unknown committed
1474
  *value= (ulong) option_limits->def_value;
1475
  pthread_mutex_unlock(guard);
unknown's avatar
unknown committed
1476 1477 1478
}


1479 1480
bool sys_var_ulonglong_ptr::update(THD *thd, set_var *var)
{
1481
  ulonglong tmp= var->save_result.ulonglong_value;
1482
  pthread_mutex_lock(&LOCK_global_system_variables);
1483 1484 1485 1486
  if (option_limits)
    *value= (ulonglong) getopt_ull_limit_value(tmp, option_limits);
  else
    *value= (ulonglong) tmp;
1487
  pthread_mutex_unlock(&LOCK_global_system_variables);
1488 1489 1490 1491 1492 1493
  return 0;
}


void sys_var_ulonglong_ptr::set_default(THD *thd, enum_var_type type)
{
1494
  pthread_mutex_lock(&LOCK_global_system_variables);
1495
  *value= (ulonglong) option_limits->def_value;
1496
  pthread_mutex_unlock(&LOCK_global_system_variables);
1497 1498 1499
}


unknown's avatar
unknown committed
1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512
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;
}


1513 1514 1515 1516 1517 1518 1519
bool sys_var_enum::update(THD *thd, set_var *var)
{
  *value= (uint) var->save_result.ulong_value;
  return 0;
}


1520
byte *sys_var_enum::value_ptr(THD *thd, enum_var_type type, LEX_STRING *base)
1521 1522 1523 1524
{
  return (byte*) enum_names->type_names[*value];
}

1525 1526 1527 1528 1529
bool sys_var_thd_ulong::check(THD *thd, set_var *var)
{
  return (sys_var_thd::check(thd, var) ||
          (check_func && (*check_func)(thd, var)));
}
1530

unknown's avatar
unknown committed
1531 1532
bool sys_var_thd_ulong::update(THD *thd, set_var *var)
{
1533
  ulonglong tmp= var->save_result.ulonglong_value;
unknown's avatar
unknown committed
1534 1535 1536 1537 1538

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

1539 1540 1541 1542 1543 1544
#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
1545 1546 1547
  if (option_limits)
    tmp= (ulong) getopt_ull_limit_value(tmp, option_limits);
  if (var->type == OPT_GLOBAL)
1548
    global_system_variables.*offset= (ulong) tmp;
unknown's avatar
unknown committed
1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561 1562 1563 1564 1565 1566
  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;
}


1567 1568
byte *sys_var_thd_ulong::value_ptr(THD *thd, enum_var_type type,
				   LEX_STRING *base)
unknown's avatar
unknown committed
1569 1570 1571 1572 1573 1574 1575
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}


1576 1577
bool sys_var_thd_ha_rows::update(THD *thd, set_var *var)
{
1578
  ulonglong tmp= var->save_result.ulonglong_value;
1579 1580 1581 1582 1583 1584 1585 1586 1587 1588

  /* 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 */
unknown's avatar
foo1  
unknown committed
1589
    pthread_mutex_lock(&LOCK_global_system_variables);
1590 1591 1592 1593 1594 1595 1596 1597 1598 1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612
    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;
}


1613 1614
byte *sys_var_thd_ha_rows::value_ptr(THD *thd, enum_var_type type,
				     LEX_STRING *base)
1615 1616 1617 1618 1619 1620
{
  if (type == OPT_GLOBAL)
    return (byte*) &(global_system_variables.*offset);
  return (byte*) &(thd->variables.*offset);
}

unknown's avatar
unknown committed
1621 1622
bool sys_var_thd_ulonglong::update(THD *thd,  set_var *var)
{
1623
  ulonglong tmp= var->save_result.ulonglong_value;
1624

1625
  if (tmp > max_system_variables.*offset)
1626 1627 1628
    tmp= max_system_variables.*offset;

  if (option_limits)
1629
    tmp= getopt_ull_limit_value(tmp, option_limits);
unknown's avatar
unknown committed
1630
  if (var->type == OPT_GLOBAL)
1631 1632 1633
  {
    /* Lock is needed to make things safe on 32 bit systems */
    pthread_mutex_lock(&LOCK_global_system_variables);
1634
    global_system_variables.*offset= (ulonglong) tmp;
1635 1636
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
unknown's avatar
unknown committed
1637
  else
1638
    thd->variables.*offset= (ulonglong) tmp;
unknown's avatar
unknown committed
1639 1640 1641 1642 1643 1644 1645
  return 0;
}


void sys_var_thd_ulonglong::set_default(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
1646 1647
  {
    pthread_mutex_lock(&LOCK_global_system_variables);
1648
    global_system_variables.*offset= (ulonglong) option_limits->def_value;
1649 1650
    pthread_mutex_unlock(&LOCK_global_system_variables);
  }
unknown's avatar
unknown committed
1651 1652 1653 1654 1655
  else
    thd->variables.*offset= global_system_variables.*offset;
}


1656 1657
byte *sys_var_thd_ulonglong::value_ptr(THD *thd, enum_var_type type,
				       LEX_STRING *base)
unknown's avatar
unknown committed
1658 1659 1660 1661 1662 1663 1664 1665 1666 1667 1668 1669 1670 1671 1672 1673 1674 1675 1676 1677 1678 1679 1680 1681 1682 1683
{
  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;
}


1684 1685
byte *sys_var_thd_bool::value_ptr(THD *thd, enum_var_type type,
				  LEX_STRING *base)
unknown's avatar
unknown committed
1686 1687 1688 1689 1690 1691 1692 1693 1694
{
  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
1695
  char buff[STRING_BUFFER_USUAL_SIZE];
1696
  const char *value;
1697
  String str(buff, sizeof(buff), system_charset_info), *res;
unknown's avatar
unknown committed
1698 1699 1700 1701 1702

  if (var->value->result_type() == STRING_RESULT)
  {
    if (!(res=var->value->val_str(&str)) ||
	((long) (var->save_result.ulong_value=
1703 1704
		 (ulong) find_type(enum_names, res->ptr(),
				   res->length(),1)-1)) < 0)
unknown's avatar
unknown committed
1705
    {
1706
      value= res ? res->c_ptr() : "NULL";
unknown's avatar
unknown committed
1707 1708 1709 1710 1711 1712 1713 1714 1715 1716 1717 1718 1719 1720 1721 1722 1723
      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:
1724
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, value);
unknown's avatar
unknown committed
1725 1726 1727
  return 1;
}

1728 1729 1730

bool sys_var::check_set(THD *thd, set_var *var, TYPELIB *enum_names)
{
1731
  bool not_used;
unknown's avatar
unknown committed
1732
  char buff[STRING_BUFFER_USUAL_SIZE], *error= 0;
1733 1734 1735 1736 1737 1738
  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)))
1739
    {
unknown's avatar
unknown committed
1740
      strmov(buff, "NULL");
1741
      goto err;
1742
    }
unknown's avatar
unknown committed
1743 1744
    var->save_result.ulong_value= ((ulong)
				   find_set(enum_names, res->c_ptr(),
1745 1746 1747
					    res->length(),
                                            NULL,
                                            &error, &error_len,
unknown's avatar
unknown committed
1748
					    &not_used));
1749 1750 1751 1752 1753 1754 1755 1756 1757
    if (error_len)
    {
      strmake(buff, error, min(sizeof(buff), error_len));
      goto err;
    }
  }
  else
  {
    ulonglong tmp= var->value->val_int();
1758 1759 1760 1761 1762 1763
   /*
     For when the enum is made to contain 64 elements, as 1ULL<<64 is
     undefined, we guard with a "count<64" test.
   */
    if (unlikely((tmp >= ((ULL(1)) << enum_names->count)) &&
                 (enum_names->count < 64)))
1764 1765 1766 1767 1768 1769 1770 1771 1772
    {
      llstr(tmp, buff);
      goto err;
    }
    var->save_result.ulong_value= (ulong) tmp;  // Save for update
  }
  return 0;

err:
1773
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, buff);
1774 1775 1776 1777
  return 1;
}


unknown's avatar
unknown committed
1778 1779 1780 1781 1782
/*
  Return an Item for a variable.  Used with @@[global.]variable_name
  If type is not given, return local value if exists, else global
*/

1783
Item *sys_var::item(THD *thd, enum_var_type var_type, LEX_STRING *base)
unknown's avatar
unknown committed
1784 1785 1786 1787 1788
{
  if (check_type(var_type))
  {
    if (var_type != OPT_DEFAULT)
    {
1789 1790
      my_error(ER_INCORRECT_GLOBAL_LOCAL_VAR, MYF(0),
               name, var_type == OPT_GLOBAL ? "SESSION" : "GLOBAL");
unknown's avatar
unknown committed
1791 1792 1793 1794 1795
      return 0;
    }
    /* As there was no local variable, return the global value */
    var_type= OPT_GLOBAL;
  }
1796
  switch (show_type()) {
1797 1798 1799 1800 1801 1802
  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);
1803
    return new Item_uint((ulonglong) value);
1804
  }
unknown's avatar
unknown committed
1805
  case SHOW_LONG:
1806 1807 1808 1809 1810
  {
    ulong value;
    pthread_mutex_lock(&LOCK_global_system_variables);
    value= *(ulong*) value_ptr(thd, var_type, base);
    pthread_mutex_unlock(&LOCK_global_system_variables);
1811
    return new Item_uint((ulonglong) value);
1812
  }
unknown's avatar
unknown committed
1813
  case SHOW_LONGLONG:
1814 1815 1816
  {
    longlong value;
    pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1817
    value= *(longlong*) value_ptr(thd, var_type, base);
1818 1819 1820
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return new Item_int(value);
  }
1821
  case SHOW_HA_ROWS:
1822 1823 1824
  {
    ha_rows value;
    pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
unknown committed
1825
    value= *(ha_rows*) value_ptr(thd, var_type, base);
1826 1827 1828
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return new Item_int((longlong) value);
  }
unknown's avatar
unknown committed
1829
  case SHOW_MY_BOOL:
1830
    return new Item_int((int32) *(my_bool*) value_ptr(thd, var_type, base),1);
unknown's avatar
unknown committed
1831 1832
  case SHOW_CHAR:
  {
unknown's avatar
unknown committed
1833
    Item *tmp;
1834
    pthread_mutex_lock(&LOCK_global_system_variables);
1835
    char *str= (char*) value_ptr(thd, var_type, base);
unknown's avatar
unknown committed
1836 1837 1838 1839 1840 1841 1842 1843
    if (str)
      tmp= new Item_string(str, strlen(str),
                           system_charset_info, DERIVATION_SYSCONST);
    else
    {
      tmp= new Item_null();
      tmp->collation.set(system_charset_info, DERIVATION_SYSCONST);
    }
1844 1845
    pthread_mutex_unlock(&LOCK_global_system_variables);
    return tmp;
unknown's avatar
unknown committed
1846 1847
  }
  default:
1848
    my_error(ER_VAR_CANT_BE_READ, MYF(0), name);
unknown's avatar
unknown committed
1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872
  }
  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;
}


1873 1874
byte *sys_var_thd_enum::value_ptr(THD *thd, enum_var_type type,
				  LEX_STRING *base)
unknown's avatar
unknown committed
1875 1876 1877 1878 1879 1880 1881
{
  ulong tmp= ((type == OPT_GLOBAL) ?
	      global_system_variables.*offset :
	      thd->variables.*offset);
  return (byte*) enum_names->type_names[tmp];
}

1882 1883 1884 1885 1886
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
1887 1888 1889

bool sys_var_thd_bit::update(THD *thd, set_var *var)
{
1890
  int res= (*update_func)(thd, var);
unknown's avatar
unknown committed
1891 1892 1893 1894
  return res;
}


1895 1896
byte *sys_var_thd_bit::value_ptr(THD *thd, enum_var_type type,
				 LEX_STRING *base)
unknown's avatar
unknown committed
1897 1898 1899 1900 1901 1902 1903 1904 1905 1906 1907
{
  /*
    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;
}


1908 1909 1910 1911 1912 1913 1914 1915 1916 1917 1918 1919 1920 1921 1922 1923 1924 1925 1926 1927 1928 1929 1930 1931 1932 1933 1934 1935 1936 1937 1938 1939 1940 1941 1942 1943 1944 1945 1946 1947 1948 1949
/* 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
1950
  char buff[STRING_BUFFER_USUAL_SIZE];
1951 1952 1953 1954 1955 1956 1957 1958 1959
  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())))
  {
1960
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, res->c_ptr());
1961 1962
    return 1;
  }
unknown's avatar
foo1  
unknown committed
1963

1964 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013
  /*
    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;
}


2014 2015
typedef struct old_names_map_st
{
unknown's avatar
unknown committed
2016 2017 2018
  const char *old_name;
  const char *new_name;
} my_old_conv;
unknown's avatar
unknown committed
2019

unknown's avatar
foo1  
unknown committed
2020
static my_old_conv old_conv[]=
unknown's avatar
unknown committed
2021
{
2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032
  {	"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
2033
};
unknown's avatar
unknown committed
2034

unknown's avatar
unknown committed
2035
CHARSET_INFO *get_old_charset_by_name(const char *name)
unknown's avatar
unknown committed
2036
{
unknown's avatar
unknown committed
2037
  my_old_conv *conv;
unknown's avatar
foo1  
unknown committed
2038

unknown's avatar
unknown committed
2039
  for (conv= old_conv; conv->old_name; conv++)
2040
  {
unknown's avatar
unknown committed
2041 2042
    if (!my_strcasecmp(&my_charset_latin1, name, conv->old_name))
      return get_charset_by_csname(conv->new_name, MY_CS_PRIMARY, MYF(0));
2043
  }
unknown's avatar
unknown committed
2044
  return NULL;
unknown's avatar
unknown committed
2045 2046
}

unknown's avatar
unknown committed
2047

2048
bool sys_var_collation::check(THD *thd, set_var *var)
unknown's avatar
unknown committed
2049 2050 2051
{
  CHARSET_INFO *tmp;

2052
  if (var->value->result_type() == STRING_RESULT)
2053
  {
unknown's avatar
unknown committed
2054
    char buff[STRING_BUFFER_USUAL_SIZE];
2055 2056 2057
    String str(buff,sizeof(buff), system_charset_info), *res;
    if (!(res=var->value->val_str(&str)))
    {
2058
      my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, "NULL");
2059 2060 2061 2062
      return 1;
    }
    if (!(tmp=get_charset_by_name(res->c_ptr(),MYF(0))))
    {
2063
      my_error(ER_UNKNOWN_COLLATION, MYF(0), res->c_ptr());
2064 2065
      return 1;
    }
2066
  }
2067
  else // INT_RESULT
2068
  {
2069
    if (!(tmp=get_charset((int) var->value->val_int(),MYF(0))))
2070 2071
    {
      char buf[20];
2072
      int10_to_str((int) var->value->val_int(), buf, -10);
2073
      my_error(ER_UNKNOWN_COLLATION, MYF(0), buf);
2074 2075
      return 1;
    }
2076 2077 2078 2079 2080
  }
  var->save_result.charset= tmp;	// Save for update
  return 0;
}

2081

2082 2083 2084 2085
bool sys_var_character_set::check(THD *thd, set_var *var)
{
  CHARSET_INFO *tmp;

2086 2087
  if (var->value->result_type() == STRING_RESULT)
  {
unknown's avatar
unknown committed
2088
    char buff[STRING_BUFFER_USUAL_SIZE];
2089 2090
    String str(buff,sizeof(buff), system_charset_info), *res;
    if (!(res=var->value->val_str(&str)))
2091
    {
2092 2093
      if (!nullable)
      {
2094
        my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, "NULL");
2095 2096 2097 2098 2099 2100 2101
        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())))
    {
2102
      my_error(ER_UNKNOWN_CHARACTER_SET, MYF(0), res->c_ptr());
2103 2104 2105
      return 1;
    }
  }
2106
  else // INT_RESULT
unknown's avatar
unknown committed
2107
  {
2108
    if (!(tmp=get_charset((int) var->value->val_int(),MYF(0))))
2109 2110
    {
      char buf[20];
2111
      int10_to_str((int) var->value->val_int(), buf, -10);
2112 2113 2114
      my_error(ER_UNKNOWN_CHARACTER_SET, MYF(0), buf);
      return 1;
    }
unknown's avatar
unknown committed
2115 2116 2117 2118 2119
  }
  var->save_result.charset= tmp;	// Save for update
  return 0;
}

2120

2121
bool sys_var_character_set::update(THD *thd, set_var *var)
unknown's avatar
unknown committed
2122
{
2123
  ci_ptr(thd,var->type)[0]= var->save_result.charset;
unknown's avatar
unknown committed
2124
  thd->update_charset();
unknown's avatar
unknown committed
2125 2126 2127
  return 0;
}

2128 2129 2130

byte *sys_var_character_set::value_ptr(THD *thd, enum_var_type type,
				       LEX_STRING *base)
unknown's avatar
unknown committed
2131
{
2132
  CHARSET_INFO *cs= ci_ptr(thd,type)[0];
unknown's avatar
unknown committed
2133
  return cs ? (byte*) cs->csname : (byte*) NULL;
unknown's avatar
unknown committed
2134 2135
}

2136

2137 2138
CHARSET_INFO ** sys_var_character_set_connection::ci_ptr(THD *thd,
							 enum_var_type type)
unknown's avatar
unknown committed
2139 2140 2141 2142 2143 2144 2145
{
  if (type == OPT_GLOBAL)
    return &global_system_variables.collation_connection;
  else
    return &thd->variables.collation_connection;
}

2146 2147 2148

void sys_var_character_set_connection::set_default(THD *thd,
						   enum_var_type type)
unknown's avatar
unknown committed
2149 2150 2151 2152
{
 if (type == OPT_GLOBAL)
   global_system_variables.collation_connection= default_charset_info;
 else
unknown's avatar
unknown committed
2153
 {
unknown's avatar
unknown committed
2154
   thd->variables.collation_connection= global_system_variables.collation_connection;
unknown's avatar
unknown committed
2155 2156
   thd->update_charset();
 }
unknown's avatar
unknown committed
2157 2158
}

2159

2160 2161
CHARSET_INFO ** sys_var_character_set_client::ci_ptr(THD *thd,
						     enum_var_type type)
2162 2163 2164 2165 2166 2167 2168
{
  if (type == OPT_GLOBAL)
    return &global_system_variables.character_set_client;
  else
    return &thd->variables.character_set_client;
}

2169

2170
void sys_var_character_set_client::set_default(THD *thd, enum_var_type type)
2171 2172
{
 if (type == OPT_GLOBAL)
2173
   global_system_variables.character_set_client= default_charset_info;
2174
 else
unknown's avatar
unknown committed
2175 2176 2177 2178 2179
 {
   thd->variables.character_set_client= (global_system_variables.
					 character_set_client);
   thd->update_charset();
 }
2180
}
unknown's avatar
unknown committed
2181

2182

unknown's avatar
unknown committed
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
CHARSET_INFO **
sys_var_character_set_filesystem::ci_ptr(THD *thd, enum_var_type type)
{
  if (type == OPT_GLOBAL)
    return &global_system_variables.character_set_filesystem;
  else
    return &thd->variables.character_set_filesystem;
}


extern CHARSET_INFO *character_set_filesystem;

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


unknown's avatar
unknown committed
2209 2210
CHARSET_INFO **
sys_var_character_set_results::ci_ptr(THD *thd, enum_var_type type)
2211
{
2212 2213
  if (type == OPT_GLOBAL)
    return &global_system_variables.character_set_results;
2214
  else
2215
    return &thd->variables.character_set_results;
2216 2217
}

2218

2219
void sys_var_character_set_results::set_default(THD *thd, enum_var_type type)
2220
{
2221
 if (type == OPT_GLOBAL)
2222
   global_system_variables.character_set_results= default_charset_info;
2223
 else
unknown's avatar
unknown committed
2224 2225 2226 2227 2228
 {
   thd->variables.character_set_results= (global_system_variables.
					  character_set_results);
   thd->update_charset();
 }
2229 2230
}

2231

unknown's avatar
unknown committed
2232 2233
CHARSET_INFO **
sys_var_character_set_server::ci_ptr(THD *thd, enum_var_type type)
2234 2235
{
  if (type == OPT_GLOBAL)
2236
    return &global_system_variables.collation_server;
2237
  else
2238
    return &thd->variables.collation_server;
2239 2240
}

2241

2242
void sys_var_character_set_server::set_default(THD *thd, enum_var_type type)
2243 2244
{
 if (type == OPT_GLOBAL)
2245
   global_system_variables.collation_server= default_charset_info;
2246
 else
unknown's avatar
unknown committed
2247
 {
2248
   thd->variables.collation_server= global_system_variables.collation_server;
unknown's avatar
unknown committed
2249 2250
   thd->update_charset();
 }
2251 2252
}

2253 2254
CHARSET_INFO ** sys_var_character_set_database::ci_ptr(THD *thd,
						       enum_var_type type)
2255 2256
{
  if (type == OPT_GLOBAL)
2257
    return &global_system_variables.collation_database;
2258
  else
2259
    return &thd->variables.collation_database;
2260 2261
}

2262

2263 2264 2265
void sys_var_character_set_database::set_default(THD *thd, enum_var_type type)
{
 if (type == OPT_GLOBAL)
2266
    global_system_variables.collation_database= default_charset_info;
2267
  else
unknown's avatar
unknown committed
2268
  {
2269
    thd->variables.collation_database= thd->db_charset;
unknown's avatar
unknown committed
2270 2271
    thd->update_charset();
  }
2272 2273
}

2274

2275
bool sys_var_collation_connection::update(THD *thd, set_var *var)
2276 2277
{
  if (var->type == OPT_GLOBAL)
2278
    global_system_variables.collation_connection= var->save_result.charset;
2279
  else
unknown's avatar
unknown committed
2280
  {
2281
    thd->variables.collation_connection= var->save_result.charset;
unknown's avatar
unknown committed
2282 2283
    thd->update_charset();
  }
2284 2285 2286
  return 0;
}

2287 2288 2289

byte *sys_var_collation_connection::value_ptr(THD *thd, enum_var_type type,
					      LEX_STRING *base)
2290 2291
{
  CHARSET_INFO *cs= ((type == OPT_GLOBAL) ?
2292 2293 2294
		  global_system_variables.collation_connection :
		  thd->variables.collation_connection);
  return cs ? (byte*) cs->name : (byte*) "NULL";
2295 2296
}

2297

2298
void sys_var_collation_connection::set_default(THD *thd, enum_var_type type)
2299 2300
{
 if (type == OPT_GLOBAL)
2301
   global_system_variables.collation_connection= default_charset_info;
2302
 else
unknown's avatar
unknown committed
2303 2304 2305 2306 2307
 {
   thd->variables.collation_connection= (global_system_variables.
					 collation_connection);
   thd->update_charset();
 }
2308 2309
}

2310 2311 2312 2313 2314 2315 2316 2317 2318 2319 2320 2321 2322 2323 2324 2325 2326 2327 2328 2329 2330 2331 2332 2333 2334 2335 2336 2337 2338 2339 2340 2341 2342 2343 2344 2345 2346 2347 2348 2349 2350 2351 2352 2353 2354 2355 2356 2357 2358 2359 2360 2361 2362 2363 2364 2365 2366 2367 2368 2369 2370 2371 2372 2373 2374 2375 2376 2377 2378 2379 2380
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();
 }
}

2381

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

unknown's avatar
unknown committed
2384
static KEY_CACHE zero_key_cache;
unknown's avatar
unknown committed
2385

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

2395

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

2405

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

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

  pthread_mutex_lock(&LOCK_global_system_variables);
  key_cache= get_key_cache(base_name);
unknown's avatar
foo1  
unknown committed
2419

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

  /*
    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
2440
  if (!tmp)					// Zero size means delete
2441
  {
unknown's avatar
unknown committed
2442
    if (key_cache == dflt_key_cache)
2443 2444 2445 2446
    {
      push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_WARN,
                          ER_WARN_CANT_DROP_DEFAULT_KEYCACHE,
                          ER(ER_WARN_CANT_DROP_DEFAULT_KEYCACHE));
2447
      goto end;					// Ignore default key cache
2448
    }
2449

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

unknown's avatar
unknown committed
2472 2473
  key_cache->param_buff_size=
    (ulonglong) getopt_ull_limit_value(tmp, option_limits);
2474

2475 2476 2477 2478
  /* 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
2479
  if (!key_cache->key_cache_inited)
2480
    error= (bool) (ha_init_key_cache("", key_cache));
unknown's avatar
unknown committed
2481
  else
2482
    error= (bool)(ha_resize_key_cache(key_cache));
2483

2484
  pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
foo1  
unknown committed
2485
  key_cache->in_init= 0;
2486

2487 2488 2489
end:
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return error;
2490 2491
}

2492 2493

bool sys_var_key_cache_long::update(THD *thd, set_var *var)
2494
{
unknown's avatar
unknown committed
2495
  ulong tmp= (ulong) var->value->val_int();
2496
  LEX_STRING *base_name= &var->base;
2497 2498
  bool error= 0;

2499
  if (!base_name->length)
unknown's avatar
unknown committed
2500
    base_name= &default_key_cache_base;
2501 2502

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

unknown's avatar
unknown committed
2505 2506
  if (!key_cache && !(key_cache= create_key_cache(base_name->str,
				                  base_name->length)))
2507 2508 2509 2510
  {
    error= 1;
    goto end;
  }
2511

2512 2513 2514 2515 2516 2517 2518 2519 2520
  /*
    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))=
2521
    (ulong) getopt_ull_limit_value(tmp, option_limits);
unknown's avatar
unknown committed
2522

2523 2524 2525 2526 2527
  /*
    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;
2528

2529
  pthread_mutex_unlock(&LOCK_global_system_variables);
2530

2531 2532 2533
  error= (bool) (ha_resize_key_cache(key_cache));

  pthread_mutex_lock(&LOCK_global_system_variables);
unknown's avatar
foo1  
unknown committed
2534
  key_cache->in_init= 0;
2535 2536 2537 2538

end:
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return error;
2539 2540
}

2541

2542 2543 2544 2545
/*****************************************************************************
  Functions to handle SET NAMES and SET CHARACTER SET
*****************************************************************************/

unknown's avatar
unknown committed
2546
int set_var_collation_client::check(THD *thd)
2547 2548 2549 2550
{
  return 0;
}

unknown's avatar
unknown committed
2551
int set_var_collation_client::update(THD *thd)
2552
{
2553 2554
  thd->variables.character_set_client= character_set_client;
  thd->variables.character_set_results= character_set_results;
unknown's avatar
unknown committed
2555
  thd->variables.collation_connection= collation_connection;
unknown's avatar
unknown committed
2556
  thd->update_charset();
2557 2558 2559 2560 2561 2562 2563
  thd->protocol_simple.init(thd);
  thd->protocol_prep.init(thd);
  return 0;
}

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

unknown's avatar
unknown committed
2564 2565
bool sys_var_timestamp::update(THD *thd,  set_var *var)
{
2566
  thd->set_time((time_t) var->save_result.ulonglong_value);
unknown's avatar
unknown committed
2567 2568 2569 2570 2571 2572 2573 2574 2575 2576
  return 0;
}


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


2577 2578
byte *sys_var_timestamp::value_ptr(THD *thd, enum_var_type type,
				   LEX_STRING *base)
unknown's avatar
unknown committed
2579 2580 2581 2582 2583 2584 2585 2586
{
  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)
{
2587
  thd->insert_id(var->save_result.ulonglong_value);
unknown's avatar
unknown committed
2588 2589 2590 2591
  return 0;
}


2592 2593
byte *sys_var_last_insert_id::value_ptr(THD *thd, enum_var_type type,
					LEX_STRING *base)
unknown's avatar
unknown committed
2594
{
2595 2596 2597 2598 2599 2600 2601 2602
  if (!thd->last_insert_id_used)
  {
    /*
      As this statement reads @@LAST_INSERT_ID, set
      THD::last_insert_id_used and remember first generated insert id
      of the previous statement in THD::current_insert_id.
    */
    thd->last_insert_id_used= TRUE;
2603
    thd->last_insert_id_used_bin_log= TRUE;
2604 2605 2606
    thd->current_insert_id= thd->last_insert_id;
  }
  return (byte*) &thd->current_insert_id;
unknown's avatar
unknown committed
2607 2608 2609 2610 2611
}


bool sys_var_insert_id::update(THD *thd, set_var *var)
{
2612
  thd->next_insert_id= var->save_result.ulonglong_value;
unknown's avatar
unknown committed
2613 2614 2615 2616
  return 0;
}


2617 2618
byte *sys_var_insert_id::value_ptr(THD *thd, enum_var_type type,
				   LEX_STRING *base)
unknown's avatar
unknown committed
2619
{
2620
  return (byte*) &thd->next_insert_id;
unknown's avatar
unknown committed
2621 2622 2623
}


unknown's avatar
SCRUM  
unknown committed
2624
#ifdef HAVE_REPLICATION
unknown's avatar
unknown committed
2625 2626
bool sys_var_slave_skip_counter::check(THD *thd, set_var *var)
{
2627
  int result= 0;
2628
  pthread_mutex_lock(&LOCK_active_mi);
unknown's avatar
unknown committed
2629 2630 2631
  pthread_mutex_lock(&active_mi->rli.run_lock);
  if (active_mi->rli.slave_running)
  {
unknown's avatar
unknown committed
2632
    my_message(ER_SLAVE_MUST_STOP, ER(ER_SLAVE_MUST_STOP), MYF(0));
unknown's avatar
unknown committed
2633 2634 2635
    result=1;
  }
  pthread_mutex_unlock(&active_mi->rli.run_lock);
2636
  pthread_mutex_unlock(&LOCK_active_mi);
2637
  var->save_result.ulong_value= (ulong) var->value->val_int();
unknown's avatar
unknown committed
2638 2639 2640 2641 2642 2643
  return result;
}


bool sys_var_slave_skip_counter::update(THD *thd, set_var *var)
{
2644
  pthread_mutex_lock(&LOCK_active_mi);
unknown's avatar
unknown committed
2645 2646 2647 2648 2649 2650 2651 2652 2653
  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);
2654
    active_mi->rli.slave_skip_counter= var->save_result.ulong_value;
unknown's avatar
unknown committed
2655 2656 2657
    pthread_mutex_unlock(&active_mi->rli.data_lock);
  }
  pthread_mutex_unlock(&active_mi->rli.run_lock);
2658
  pthread_mutex_unlock(&LOCK_active_mi);
unknown's avatar
unknown committed
2659 2660
  return 0;
}
2661 2662 2663 2664


bool sys_var_sync_binlog_period::update(THD *thd, set_var *var)
{
2665
  sync_binlog_period= (ulong) var->save_result.ulonglong_value;
2666
  return 0;
unknown's avatar
unknown committed
2667
}
unknown's avatar
SCRUM  
unknown committed
2668
#endif /* HAVE_REPLICATION */
unknown's avatar
unknown committed
2669

2670 2671
bool sys_var_rand_seed1::update(THD *thd, set_var *var)
{
2672
  thd->rand.seed1= (ulong) var->save_result.ulonglong_value;
2673 2674 2675 2676 2677
  return 0;
}

bool sys_var_rand_seed2::update(THD *thd, set_var *var)
{
2678
  thd->rand.seed2= (ulong) var->save_result.ulonglong_value;
2679 2680 2681 2682
  return 0;
}


2683 2684
bool sys_var_thd_time_zone::check(THD *thd, set_var *var)
{
2685
  char buff[MAX_TIME_ZONE_NAME_LENGTH];
2686 2687 2688
  String str(buff, sizeof(buff), &my_charset_latin1);
  String *res= var->value->val_str(&str);

2689
  if (!(var->save_result.time_zone=
2690
        my_tz_find(res, thd->lex->time_zone_tables_used)))
2691
  {
2692
    my_error(ER_UNKNOWN_TIME_ZONE, MYF(0), res ? res->c_ptr() : "NULL");
2693 2694 2695 2696 2697 2698 2699 2700
    return 1;
  }
  return 0;
}


bool sys_var_thd_time_zone::update(THD *thd, set_var *var)
{
2701 2702 2703 2704 2705 2706 2707 2708 2709
  /* 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;
2710 2711 2712 2713 2714 2715 2716
  return 0;
}


byte *sys_var_thd_time_zone::value_ptr(THD *thd, enum_var_type type,
				       LEX_STRING *base)
{
unknown's avatar
foo1  
unknown committed
2717
  /*
2718 2719 2720 2721
    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)
2722
    return (byte *)(global_system_variables.time_zone->get_name()->ptr());
2723
  else
2724 2725 2726 2727 2728 2729 2730 2731 2732 2733
  {
    /*
      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;
2734
    return (byte *)(thd->variables.time_zone->get_name()->ptr());
2735
  }
2736 2737 2738 2739 2740
}


void sys_var_thd_time_zone::set_default(THD *thd, enum_var_type type)
{
2741
 pthread_mutex_lock(&LOCK_global_system_variables);
2742 2743 2744 2745 2746
 if (type == OPT_GLOBAL)
 {
   if (default_tz_name)
   {
     String str(default_tz_name, &my_charset_latin1);
2747 2748 2749 2750
     /*
       We are guaranteed to find this time zone since its existence
       is checked during start-up.
     */
2751 2752
     global_system_variables.time_zone=
       my_tz_find(&str, thd->lex->time_zone_tables_used);
2753 2754 2755 2756 2757 2758
   }
   else
     global_system_variables.time_zone= my_tz_SYSTEM;
 }
 else
   thd->variables.time_zone= global_system_variables.time_zone;
2759
 pthread_mutex_unlock(&LOCK_global_system_variables);
2760 2761
}

2762 2763 2764 2765 2766 2767 2768 2769 2770 2771 2772 2773 2774 2775 2776 2777 2778 2779 2780 2781

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);
2782
  max_user_connections= (uint)var->save_result.ulonglong_value;
2783 2784 2785 2786 2787 2788 2789 2790 2791 2792 2793 2794 2795 2796 2797 2798 2799 2800 2801 2802 2803 2804 2805
  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);
}

2806

unknown's avatar
unknown committed
2807 2808
bool sys_var_thd_lc_time_names::check(THD *thd, set_var *var)
{
2809
  MY_LOCALE *locale_match;
unknown's avatar
unknown committed
2810

2811
  if (var->value->result_type() == INT_RESULT)
unknown's avatar
unknown committed
2812
  {
2813 2814 2815 2816 2817 2818 2819
    if (!(locale_match= my_locale_by_number((uint) var->value->val_int())))
    {
      char buf[20];
      int10_to_str((int) var->value->val_int(), buf, -10);
      my_printf_error(ER_UNKNOWN_ERROR, "Unknown locale: '%s'", MYF(0), buf);
      return 1;
    }
unknown's avatar
unknown committed
2820
  }
2821
  else // STRING_RESULT
unknown's avatar
unknown committed
2822
  {
2823 2824 2825 2826 2827 2828 2829 2830 2831 2832 2833 2834 2835 2836
    char buff[6]; 
    String str(buff, sizeof(buff), &my_charset_latin1), *res;
    if (!(res=var->value->val_str(&str)))
    {
      my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, "NULL");
      return 1;
    }
    const char *locale_str= res->c_ptr();
    if (!(locale_match= my_locale_by_name(locale_str)))
    {
      my_printf_error(ER_UNKNOWN_ERROR,
                      "Unknown locale: '%s'", MYF(0), locale_str);
      return 1;
    }
unknown's avatar
unknown committed
2837
  }
2838

2839 2840
  var->save_result.locale_value= locale_match;
  return 0;
unknown's avatar
unknown committed
2841 2842 2843 2844 2845
}


bool sys_var_thd_lc_time_names::update(THD *thd, set_var *var)
{
2846 2847 2848 2849
  if (var->type == OPT_GLOBAL)
    global_system_variables.lc_time_names= var->save_result.locale_value;
  else
    thd->variables.lc_time_names= var->save_result.locale_value;
unknown's avatar
unknown committed
2850 2851 2852 2853 2854 2855 2856
  return 0;
}


byte *sys_var_thd_lc_time_names::value_ptr(THD *thd, enum_var_type type,
					  LEX_STRING *base)
{
2857 2858 2859
  return type == OPT_GLOBAL ?
                 (byte *) global_system_variables.lc_time_names->name :
                 (byte *) thd->variables.lc_time_names->name;
unknown's avatar
unknown committed
2860 2861 2862 2863 2864
}


void sys_var_thd_lc_time_names::set_default(THD *thd, enum_var_type type)
{
2865 2866 2867 2868
  if (type == OPT_GLOBAL)
    global_system_variables.lc_time_names= my_default_lc_time_names;
  else
    thd->variables.lc_time_names= global_system_variables.lc_time_names;
unknown's avatar
unknown committed
2869
}
2870

unknown's avatar
unknown committed
2871 2872 2873 2874 2875 2876
/*
  Functions to update thd->options bits
*/

static bool set_option_bit(THD *thd, set_var *var)
{
2877 2878 2879
  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
2880
  else
2881
    thd->options|= sys_var->bit_flag;
unknown's avatar
unknown committed
2882 2883 2884 2885 2886 2887 2888 2889
  return 0;
}


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

2890
  ulonglong org_options= thd->options;
unknown's avatar
unknown committed
2891 2892 2893 2894 2895 2896 2897 2898 2899 2900 2901

  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 */
2902
      thd->options&= ~(ulong) OPTION_BEGIN;
unknown's avatar
unknown committed
2903
      thd->transaction.all.modified_non_trans_table= FALSE;
unknown's avatar
unknown committed
2904 2905 2906 2907 2908 2909
      thd->server_status|= SERVER_STATUS_AUTOCOMMIT;
      if (ha_commit(thd))
	return 1;
    }
    else
    {
unknown's avatar
unknown committed
2910
      thd->transaction.all.modified_non_trans_table= FALSE;
unknown's avatar
unknown committed
2911 2912 2913 2914 2915 2916
      thd->server_status&= ~SERVER_STATUS_AUTOCOMMIT;
    }
  }
  return 0;
}

2917 2918 2919
static int check_log_update(THD *thd, set_var *var)
{
#ifndef NO_EMBEDDED_ACCESS_CHECKS
2920
  if (!(thd->security_ctx->master_access & SUPER_ACL))
2921 2922 2923 2924 2925 2926 2927
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
#endif
  return 0;
}
unknown's avatar
unknown committed
2928 2929 2930

static bool set_log_update(THD *thd, set_var *var)
{
2931 2932 2933 2934 2935
  /*
    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
foo1  
unknown committed
2936

unknown's avatar
unknown committed
2937
  if (opt_sql_bin_update)
2938
  {
unknown's avatar
unknown committed
2939 2940
    ((sys_var_thd_bit*) var->var)->bit_flag|= (OPTION_BIN_LOG |
					       OPTION_UPDATE_LOG);
2941 2942 2943 2944 2945 2946 2947 2948
    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
2949 2950 2951 2952
  set_option_bit(thd, var);
  return 0;
}

2953
static bool set_log_bin(THD *thd, set_var *var)
unknown's avatar
unknown committed
2954 2955 2956 2957 2958 2959 2960 2961
{
  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;
}

2962 2963 2964 2965
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
2966
  if (thd->security_ctx->master_access & SUPER_ACL)
2967 2968 2969 2970 2971 2972 2973 2974 2975 2976
    return 0;
  else
  {
    my_error(ER_SPECIFIC_ACCESS_DENIED_ERROR, MYF(0), "SUPER");
    return 1;
  }
#else
  return 0;
#endif
}
2977

2978 2979 2980 2981
static byte *get_warning_count(THD *thd)
{
  thd->sys_var_tmp.long_value=
    (thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_NOTE] +
2982
     thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_ERROR] +
2983 2984 2985 2986 2987 2988
     thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_WARN]);
  return (byte*) &thd->sys_var_tmp.long_value;
}

static byte *get_error_count(THD *thd)
{
unknown's avatar
foo1  
unknown committed
2989
  thd->sys_var_tmp.long_value=
2990 2991 2992 2993
    thd->warn_count[(uint) MYSQL_ERROR::WARN_LEVEL_ERROR];
  return (byte*) &thd->sys_var_tmp.long_value;
}

unknown's avatar
unknown committed
2994

2995 2996 2997 2998 2999 3000
static byte *get_have_innodb(THD *thd)
{
  return (byte*) show_comp_option_name[have_innodb];
}


3001 3002 3003 3004 3005 3006 3007 3008 3009 3010 3011 3012 3013 3014 3015 3016 3017 3018 3019 3020 3021 3022 3023 3024
/*
  Get the tmpdir that was specified or chosen by default

  SYNOPSIS
    get_tmpdir()
    thd		thread handle

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

  RETURN VALUES
    ptr		pointer to NUL-terminated string
 */
static byte *get_tmpdir(THD *thd)
{
  if (opt_mysql_tmpdir)
    return (byte *)opt_mysql_tmpdir;
  return (byte*)mysql_tmpdir;
}

unknown's avatar
unknown committed
3025 3026 3027 3028 3029 3030 3031 3032 3033 3034 3035 3036 3037 3038 3039 3040 3041 3042 3043 3044
/****************************************************************************
  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
*/

unknown's avatar
foo1  
unknown committed
3045
static struct my_option *find_option(struct my_option *opt, const char *name)
unknown's avatar
unknown committed
3046 3047 3048 3049 3050 3051 3052 3053 3054 3055 3056 3057 3058 3059 3060 3061 3062 3063 3064 3065 3066 3067 3068 3069 3070 3071 3072 3073 3074 3075 3076 3077 3078 3079 3080 3081 3082
{
  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()
{
3083 3084
  hash_init(&system_variable_hash, system_charset_info,
	    array_elements(sys_variables),0,0,
unknown's avatar
unknown committed
3085
	    (hash_get_key) get_sys_var_length,0,0);
unknown's avatar
unknown committed
3086 3087 3088 3089 3090 3091 3092
  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
3093
    my_hash_insert(&system_variable_hash, (byte*) *var);
unknown's avatar
unknown committed
3094 3095 3096 3097 3098 3099 3100 3101 3102 3103 3104 3105 3106 3107 3108 3109 3110 3111 3112 3113 3114 3115 3116 3117 3118 3119 3120 3121 3122 3123 3124
  }
  /*
    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)
*/

3125
sys_var *find_sys_var(const char *str, uint length)
unknown's avatar
unknown committed
3126
{
unknown's avatar
unknown committed
3127 3128
  sys_var *var= (sys_var*) hash_search(&system_variable_hash,
				       (byte*) str,
unknown's avatar
unknown committed
3129 3130 3131
				       length ? length :
				       strlen(str));
  if (!var)
3132
    my_error(ER_UNKNOWN_SYSTEM_VARIABLE, MYF(0), (char*) str);
unknown's avatar
unknown committed
3133 3134 3135 3136 3137 3138 3139 3140 3141 3142 3143 3144 3145 3146 3147 3148 3149 3150 3151 3152 3153 3154
  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
3155 3156
    1	ERROR, message sent (normally no variables was updated)
    -1  ERROR, message not sent
unknown's avatar
unknown committed
3157 3158
*/

3159
int sql_set_variables(THD *thd, List<set_var_base> *var_list)
unknown's avatar
unknown committed
3160
{
unknown's avatar
unknown committed
3161
  int error;
unknown's avatar
unknown committed
3162
  List_iterator_fast<set_var_base> it(*var_list);
unknown's avatar
unknown committed
3163
  DBUG_ENTER("sql_set_variables");
unknown's avatar
unknown committed
3164 3165 3166 3167

  set_var_base *var;
  while ((var=it++))
  {
unknown's avatar
unknown committed
3168
    if ((error= var->check(thd)))
3169
      goto err;
unknown's avatar
unknown committed
3170
  }
unknown's avatar
unknown committed
3171
  if (!(error= test(thd->net.report_error)))
3172 3173 3174 3175 3176
  {
    it.rewind();
    while ((var= it++))
      error|= var->update(thd);         // Returns 0, -1 or 1
  }
unknown's avatar
unknown committed
3177

3178 3179
err:
  free_underlaid_joins(thd, &thd->lex->select_lex);
unknown's avatar
unknown committed
3180
  DBUG_RETURN(error);
unknown's avatar
unknown committed
3181 3182 3183
}


3184 3185 3186 3187 3188 3189 3190 3191 3192 3193 3194 3195 3196 3197 3198 3199 3200 3201 3202 3203 3204 3205 3206 3207 3208 3209 3210 3211 3212 3213
/*
  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
3214 3215 3216 3217
/*****************************************************************************
  Functions to handle SET mysql_internal_variable=const_expr
*****************************************************************************/

3218
int set_var::check(THD *thd)
unknown's avatar
unknown committed
3219
{
3220 3221 3222 3223 3224
  if (var->is_readonly())
  {
    my_error(ER_INCORRECT_GLOBAL_LOCAL_VAR, MYF(0), var->name, "read only");
    return -1;
  }
unknown's avatar
unknown committed
3225 3226
  if (var->check_type(type))
  {
unknown's avatar
unknown committed
3227
    int err= type == OPT_GLOBAL ? ER_LOCAL_VARIABLE : ER_GLOBAL_VARIABLE;
3228
    my_error(err, MYF(0), var->name);
3229
    return -1;
unknown's avatar
unknown committed
3230 3231 3232 3233 3234 3235 3236 3237
  }
  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))
    {
3238
      my_error(ER_NO_DEFAULT, MYF(0), var->name);
3239
      return -1;
unknown's avatar
unknown committed
3240 3241 3242 3243
    }
    return 0;
  }

unknown's avatar
unknown committed
3244
  if ((!value->fixed &&
3245
       value->fix_fields(thd, &value)) || value->check_cols(1))
3246
    return -1;
unknown's avatar
unknown committed
3247 3248
  if (var->check_update_type(value->result_type()))
  {
3249
    my_error(ER_WRONG_TYPE_FOR_VAR, MYF(0), var->name);
3250
    return -1;
3251
  }
3252
  return var->check(thd, this) ? -1 : 0;
unknown's avatar
unknown committed
3253 3254 3255
}


unknown's avatar
unknown committed
3256 3257 3258 3259 3260 3261 3262 3263 3264 3265 3266 3267
/*
  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
*/
3268 3269 3270 3271
int set_var::light_check(THD *thd)
{
  if (var->check_type(type))
  {
unknown's avatar
unknown committed
3272
    int err= type == OPT_GLOBAL ? ER_LOCAL_VARIABLE : ER_GLOBAL_VARIABLE;
3273
    my_error(err, MYF(0), var->name);
3274 3275
    return -1;
  }
unknown's avatar
unknown committed
3276
  if (type == OPT_GLOBAL && check_global_access(thd, SUPER_ACL))
3277 3278
    return 1;

3279
  if (value && ((!value->fixed && value->fix_fields(thd, &value)) ||
unknown's avatar
unknown committed
3280
                value->check_cols(1)))
3281 3282 3283 3284 3285
    return -1;
  return 0;
}


3286
int set_var::update(THD *thd)
unknown's avatar
unknown committed
3287 3288 3289 3290
{
  if (!value)
    var->set_default(thd, type);
  else if (var->update(thd, this))
3291
    return -1;				// should never happen
unknown's avatar
unknown committed
3292 3293 3294 3295 3296 3297 3298 3299 3300 3301
  if (var->after_update)
    (*var->after_update)(thd, type);
  return 0;
}


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

3302
int set_var_user::check(THD *thd)
unknown's avatar
unknown committed
3303
{
unknown's avatar
unknown committed
3304 3305
  /*
    Item_func_set_user_var can't substitute something else on its place =>
3306
    0 can be passed as last argument (reference on item)
unknown's avatar
unknown committed
3307
  */
3308
  return (user_var_item->fix_fields(thd, (Item**) 0) ||
3309
	  user_var_item->check(0)) ? -1 : 0;
unknown's avatar
unknown committed
3310 3311 3312
}


unknown's avatar
unknown committed
3313 3314 3315 3316 3317 3318 3319 3320 3321 3322 3323 3324
/*
  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
*/
3325 3326 3327 3328 3329 3330
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)
  */
3331
  return (user_var_item->fix_fields(thd, (Item**) 0));
3332 3333 3334
}


3335
int set_var_user::update(THD *thd)
unknown's avatar
unknown committed
3336 3337 3338 3339
{
  if (user_var_item->update())
  {
    /* Give an error if it's not given already */
unknown's avatar
unknown committed
3340
    my_message(ER_SET_CONSTANTS_ONLY, ER(ER_SET_CONSTANTS_ONLY), MYF(0));
3341
    return -1;
unknown's avatar
unknown committed
3342 3343 3344 3345 3346 3347 3348 3349 3350
  }
  return 0;
}


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

3351
int set_var_password::check(THD *thd)
unknown's avatar
unknown committed
3352
{
unknown's avatar
unknown committed
3353
#ifndef NO_EMBEDDED_ACCESS_CHECKS
unknown's avatar
unknown committed
3354
  if (!user->host.str)
3355
  {
3356
    if (*thd->security_ctx->priv_host != 0)
3357
    {
3358 3359
      user->host.str= (char *) thd->security_ctx->priv_host;
      user->host.length= strlen(thd->security_ctx->priv_host);
3360 3361 3362 3363 3364 3365 3366
    }
    else
    {
      user->host.str= (char *)"%";
      user->host.length= 1;
    }
  }
3367
  /* Returns 1 as the function sends error to client */
3368 3369
  return check_change_password(thd, user->host.str, user->user.str,
                               password, strlen(password)) ? 1 : 0;
3370
#else
unknown's avatar
unknown committed
3371 3372
  return 0;
#endif
unknown's avatar
unknown committed
3373 3374
}

3375
int set_var_password::update(THD *thd)
unknown's avatar
unknown committed
3376
{
unknown's avatar
unknown committed
3377
#ifndef NO_EMBEDDED_ACCESS_CHECKS
3378
  /* Returns 1 as the function sends error to client */
3379 3380
  return change_password(thd, user->host.str, user->user.str, password) ?
	  1 : 0;
unknown's avatar
unknown committed
3381 3382 3383
#else
  return 0;
#endif
unknown's avatar
unknown committed
3384 3385
}

3386 3387 3388 3389
/****************************************************************************
 Functions to handle table_type
****************************************************************************/

unknown's avatar
unknown committed
3390 3391
/* Based upon sys_var::check_enum() */

unknown's avatar
unknown committed
3392
bool sys_var_thd_storage_engine::check(THD *thd, set_var *var)
3393
{
unknown's avatar
unknown committed
3394
  char buff[STRING_BUFFER_USUAL_SIZE];
3395 3396 3397 3398 3399
  const char *value;
  String str(buff, sizeof(buff), &my_charset_latin1), *res;

  if (var->value->result_type() == STRING_RESULT)
  {
3400
    enum db_type db_type;
3401 3402
    if (!(res=var->value->val_str(&str)) ||
	!(var->save_result.ulong_value=
3403
          (ulong) (db_type= ha_resolve_by_name(res->ptr(), res->length()))) ||
3404
        ha_checktype(thd, db_type, 1, 0) != db_type)
3405 3406 3407 3408 3409 3410
    {
      value= res ? res->c_ptr() : "NULL";
      goto err;
    }
    return 0;
  }
unknown's avatar
unknown committed
3411
  value= "unknown";
3412 3413

err:
3414
  my_error(ER_UNKNOWN_STORAGE_ENGINE, MYF(0), value);
unknown's avatar
unknown committed
3415
  return 1;
3416 3417
}

unknown's avatar
unknown committed
3418

unknown's avatar
unknown committed
3419 3420
byte *sys_var_thd_storage_engine::value_ptr(THD *thd, enum_var_type type,
					    LEX_STRING *base)
3421 3422 3423 3424
{
  ulong val;
  val= ((type == OPT_GLOBAL) ? global_system_variables.*offset :
        thd->variables.*offset);
unknown's avatar
unknown committed
3425
  const char *table_type= ha_get_storage_engine((enum db_type)val);
unknown's avatar
unknown committed
3426
  return (byte *) table_type;
3427 3428
}

unknown's avatar
unknown committed
3429

unknown's avatar
unknown committed
3430
void sys_var_thd_storage_engine::set_default(THD *thd, enum_var_type type)
3431 3432 3433 3434 3435 3436 3437
{
  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
3438

unknown's avatar
unknown committed
3439
bool sys_var_thd_storage_engine::update(THD *thd, set_var *var)
3440 3441 3442 3443 3444 3445 3446 3447
{
  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
3448 3449 3450 3451
void sys_var_thd_table_type::warn_deprecated(THD *thd)
{
  push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_WARN,
		      ER_WARN_DEPRECATED_SYNTAX,
3452
		      ER(ER_WARN_DEPRECATED_SYNTAX), "table_type",
unknown's avatar
foo1  
unknown committed
3453
                      "storage_engine");
unknown's avatar
unknown committed
3454 3455 3456 3457 3458 3459 3460 3461 3462 3463 3464 3465 3466 3467
}

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
3468

3469 3470 3471
/****************************************************************************
 Functions to handle sql_mode
****************************************************************************/
3472

3473 3474 3475
/*
  Make string representation of mode

3476 3477 3478 3479 3480 3481 3482
  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
3483 3484 3485 3486
*/

byte *sys_var_thd_sql_mode::symbolic_mode_representation(THD *thd, ulong val,
                                                         ulong *len)
3487 3488 3489
{
  char buff[256];
  String tmp(buff, sizeof(buff), &my_charset_latin1);
unknown's avatar
unknown committed
3490
  ulong length;
3491 3492 3493 3494 3495 3496

  tmp.length(0);
  for (uint i= 0; val; val>>= 1, i++)
  {
    if (val & 1)
    {
3497 3498
      tmp.append(sql_mode_typelib.type_names[i],
                 sql_mode_typelib.type_lengths[i]);
3499 3500 3501
      tmp.append(',');
    }
  }
unknown's avatar
unknown committed
3502 3503 3504 3505 3506

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

unknown's avatar
unknown committed
3509

3510 3511 3512 3513 3514 3515 3516 3517 3518
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);
}

3519 3520 3521 3522 3523 3524 3525 3526 3527

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
3528

3529 3530 3531 3532 3533 3534
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
3535
  {
3536
    thd->variables.sql_mode= fix_sql_mode(thd->variables.sql_mode);
3537 3538 3539 3540 3541 3542 3543 3544
    /*
      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;
  }
3545 3546 3547
}

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

3549 3550 3551
ulong fix_sql_mode(ulong sql_mode)
{
  /*
unknown's avatar
foo1  
unknown committed
3552
    Note that we dont set
3553 3554 3555 3556 3557
    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)
3558
  {
3559
    sql_mode|= (MODE_REAL_AS_FLOAT | MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
3560
		MODE_IGNORE_SPACE);
unknown's avatar
foo1  
unknown committed
3561
    /*
3562 3563 3564 3565
      MODE_ONLY_FULL_GROUP_BY removed from ANSI mode because it is currently
      overly restrictive (see BUG#8510).
    */
  }
3566 3567 3568 3569
  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 |
3570
		MODE_NO_FIELD_OPTIONS | MODE_NO_AUTO_CREATE_USER);
3571 3572 3573 3574 3575 3576 3577 3578 3579 3580 3581 3582 3583 3584 3585
  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);
3586
  if (sql_mode & MODE_MAXDB)
3587 3588 3589
    sql_mode|= (MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE |
		MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS |
3590
		MODE_NO_FIELD_OPTIONS | MODE_NO_AUTO_CREATE_USER);
3591
  if (sql_mode & MODE_MYSQL40)
3592
    sql_mode|= MODE_HIGH_NOT_PRECEDENCE;
3593
  if (sql_mode & MODE_MYSQL323)
3594
    sql_mode|= MODE_HIGH_NOT_PRECEDENCE;
unknown's avatar
unknown committed
3595 3596 3597
  if (sql_mode & MODE_TRADITIONAL)
    sql_mode|= (MODE_STRICT_TRANS_TABLES | MODE_STRICT_ALL_TABLES |
                MODE_NO_ZERO_IN_DATE | MODE_NO_ZERO_DATE |
3598
                MODE_ERROR_FOR_DIVISION_BY_ZERO | MODE_NO_AUTO_CREATE_USER);
3599 3600
  return sql_mode;
}
3601 3602


3603 3604 3605 3606
/****************************************************************************
  Named list handling
****************************************************************************/

unknown's avatar
unknown committed
3607 3608
gptr find_named(I_List<NAMED_LIST> *list, const char *name, uint length,
		NAMED_LIST **found)
3609 3610 3611 3612 3613 3614
{
  I_List_iterator<NAMED_LIST> it(*list);
  NAMED_LIST *element;
  while ((element= it++))
  {
    if (element->cmp(name, length))
unknown's avatar
unknown committed
3615
    {
3616 3617
      if (found)
        *found= element;
3618
      return element->data;
unknown's avatar
unknown committed
3619
    }
3620 3621 3622 3623 3624
  }
  return 0;
}


3625 3626
void delete_elements(I_List<NAMED_LIST> *list,
		     void (*free_element)(const char *name, gptr))
3627 3628
{
  NAMED_LIST *element;
unknown's avatar
unknown committed
3629
  DBUG_ENTER("delete_elements");
3630 3631
  while ((element= list->get()))
  {
3632
    (*free_element)(element->name, element->data);
3633 3634
    delete element;
  }
unknown's avatar
unknown committed
3635
  DBUG_VOID_RETURN;
3636 3637 3638 3639 3640
}


/* Key cache functions */

unknown's avatar
unknown committed
3641
static KEY_CACHE *create_key_cache(const char *name, uint length)
3642
{
unknown's avatar
unknown committed
3643
  KEY_CACHE *key_cache;
3644 3645
  DBUG_ENTER("create_key_cache");
  DBUG_PRINT("enter",("name: %.*s", length, name));
unknown's avatar
foo1  
unknown committed
3646

unknown's avatar
unknown committed
3647
  if ((key_cache= (KEY_CACHE*) my_malloc(sizeof(KEY_CACHE),
3648
					     MYF(MY_ZEROFILL | MY_WME))))
unknown's avatar
unknown committed
3649 3650
  {
    if (!new NAMED_LIST(&key_caches, name, length, (gptr) key_cache))
3651 3652
    {
      my_free((char*) key_cache, MYF(0));
unknown's avatar
unknown committed
3653
      key_cache= 0;
3654 3655 3656 3657 3658 3659 3660 3661 3662
    }
    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
3663 3664 3665
      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;
3666
    }
unknown's avatar
unknown committed
3667
  }
3668
  DBUG_RETURN(key_cache);
3669 3670 3671
}


unknown's avatar
unknown committed
3672
KEY_CACHE *get_or_create_key_cache(const char *name, uint length)
3673
{
unknown's avatar
unknown committed
3674
  LEX_STRING key_cache_name;
unknown's avatar
unknown committed
3675
  KEY_CACHE *key_cache;
3676

unknown's avatar
unknown committed
3677 3678
  key_cache_name.str= (char *) name;
  key_cache_name.length= length;
3679 3680
  pthread_mutex_lock(&LOCK_global_system_variables);
  if (!(key_cache= get_key_cache(&key_cache_name)))
3681
    key_cache= create_key_cache(name, length);
3682
  pthread_mutex_unlock(&LOCK_global_system_variables);
3683 3684 3685 3686
  return key_cache;
}


unknown's avatar
unknown committed
3687
void free_key_cache(const char *name, KEY_CACHE *key_cache)
3688
{
3689 3690
  ha_end_key_cache(key_cache);
  my_free((char*) key_cache, MYF(0));
unknown's avatar
unknown committed
3691 3692 3693
}


unknown's avatar
unknown committed
3694
bool process_key_caches(int (* func) (const char *name, KEY_CACHE *))
3695
{
unknown's avatar
unknown committed
3696 3697
  I_List_iterator<NAMED_LIST> it(key_caches);
  NAMED_LIST *element;
3698

unknown's avatar
unknown committed
3699 3700
  while ((element= it++))
  {
unknown's avatar
unknown committed
3701
    KEY_CACHE *key_cache= (KEY_CACHE *) element->data;
3702
    func(element->name, key_cache);
unknown's avatar
unknown committed
3703 3704
  }
  return 0;
3705 3706
}

3707

3708 3709 3710 3711 3712
void sys_var_trust_routine_creators::warn_deprecated(THD *thd)
{
  push_warning_printf(thd, MYSQL_ERROR::WARN_LEVEL_WARN,
		      ER_WARN_DEPRECATED_SYNTAX,
		      ER(ER_WARN_DEPRECATED_SYNTAX), "log_bin_trust_routine_creators",
unknown's avatar
foo1  
unknown committed
3713
                      "log_bin_trust_function_creators");
3714 3715 3716 3717 3718 3719 3720 3721 3722 3723 3724 3725 3726 3727
}

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

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

unknown's avatar
unknown committed
3728 3729 3730 3731
/****************************************************************************
  Used templates
****************************************************************************/

3732
#ifdef HAVE_EXPLICIT_TEMPLATE_INSTANTIATION
unknown's avatar
unknown committed
3733
template class List<set_var_base>;
unknown's avatar
unknown committed
3734
template class List_iterator_fast<set_var_base>;
3735
template class I_List_iterator<NAMED_LIST>;
unknown's avatar
unknown committed
3736
#endif