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

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

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

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

/*
  Handling of MySQL SQL variables

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

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

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

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

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

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

#include "mysql_priv.h"
56
#include <mysql.h>
57 58
#include "slave.h"
#include <my_getopt.h>
59
#include <thr_alarm.h>
60 61 62 63 64 65 66
#include <myisam.h>
#ifdef HAVE_BERKELEY_DB
#include "ha_berkeley.h"
#endif
#ifdef HAVE_INNOBASE_DB
#include "ha_innodb.h"
#endif
67 68 69
#ifdef HAVE_NDBCLUSTER_DB
#include "ha_ndbcluster.h"
#endif
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
76 77
};

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

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

/*
  Variable definition list

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

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

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

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

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

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

362 363
sys_var_thd_table_type  sys_table_type("table_type",
				       &SV::table_type);
364 365
sys_var_thd_storage_engine sys_storage_engine("storage_engine",
				       &SV::table_type);
366 367
#ifdef HAVE_REPLICATION
sys_var_sync_binlog_period sys_sync_binlog_period("sync_binlog", &sync_binlog_period);
368 369 370 371 372 373 374 375
sys_var_thd_ulong	sys_sync_replication("sync_replication",
                                               &SV::sync_replication);
sys_var_thd_ulong	sys_sync_replication_slave_id(
						"sync_replication_slave_id",
                                               &SV::sync_replication_slave_id);
sys_var_thd_ulong	sys_sync_replication_timeout(
						"sync_replication_timeout",
                                               &SV::sync_replication_timeout);
376 377
#endif
sys_var_bool_ptr	sys_sync_frm("sync_frm", &opt_sync_frm);
378 379
sys_var_long_ptr	sys_table_cache_size("table_cache",
					     &table_cache_size);
380 381
sys_var_long_ptr	sys_table_lock_wait_timeout("table_lock_wait_timeout",
                                                    &table_lock_wait_timeout);
382 383 384 385 386 387 388 389
sys_var_long_ptr	sys_thread_cache_size("thread_cache_size",
					      &thread_cache_size);
sys_var_thd_enum	sys_tx_isolation("tx_isolation",
					 &SV::tx_isolation,
					 &tx_isolation_typelib,
					 fix_tx_isolation);
sys_var_thd_ulong	sys_tmp_table_size("tmp_table_size",
					   &SV::tmp_table_size);
vtkachenko@intelp4d.mysql.com's avatar
vtkachenko@intelp4d.mysql.com committed
390 391
sys_var_bool_ptr  sys_timed_mutexes("timed_mutexes",
                                    &timed_mutexes);
392 393
sys_var_thd_ulong	sys_net_wait_timeout("wait_timeout",
					     &SV::net_wait_timeout);
394

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

mskold@mysql.com's avatar
mskold@mysql.com committed
418 419 420 421 422
/* Condition pushdown to storage engine */
sys_var_thd_bool
sys_engine_condition_pushdown("engine_condition_pushdown",
			      &SV::engine_condition_pushdown);

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

/* Time/date/datetime formats */

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

/* Variables that are bits in THD */
451

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

505 506
/* Local state variables */

507
static sys_var_thd_ha_rows	sys_select_limit("sql_select_limit",
508 509 510 511 512
						 &SV::select_limit);
static sys_var_timestamp	sys_timestamp("timestamp");
static sys_var_last_insert_id	sys_last_insert_id("last_insert_id");
static sys_var_last_insert_id	sys_identity("identity");
static sys_var_insert_id	sys_insert_id("insert_id");
513 514 515 516 517 518 519 520 521
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);

522
/* alias for last_insert_id() to be compatible with Sybase */
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
523
#ifdef HAVE_REPLICATION
524
static sys_var_slave_skip_counter sys_slave_skip_counter("sql_slave_skip_counter");
525
#endif
526 527
static sys_var_rand_seed1	sys_rand_seed1("rand_seed1");
static sys_var_rand_seed2	sys_rand_seed2("rand_seed2");
528

529 530
static sys_var_thd_ulong        sys_default_week_format("default_week_format",
					                &SV::default_week_format);
531

532 533 534
sys_var_thd_ulong               sys_group_concat_max_len("group_concat_max_len",
                                                         &SV::group_concat_max_len);

535
sys_var_thd_time_zone            sys_time_zone("time_zone");
536 537 538 539 540

/* Read only variables */

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


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


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

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

1012

1013 1014 1015 1016 1017 1018
bool sys_var::check(THD *thd, set_var *var)
{
  var->save_result.ulonglong_value= var->value->val_int();
  return 0;
}

1019 1020 1021 1022 1023 1024 1025
bool sys_var_str::check(THD *thd, set_var *var)
{
  int res;
  if (!check_func)
    return 0;

  if ((res=(*check_func)(thd, var)) < 0)
1026 1027
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0),
             name, var->value->str_value.ptr());
1028 1029 1030
  return res;
}

1031 1032 1033 1034
/*
  Functions to check and update variables
*/

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

1036 1037 1038 1039 1040 1041 1042 1043 1044 1045
/*
  Update variables 'init_connect, init_slave'.

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

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


1067 1068 1069 1070 1071 1072
static bool sys_update_init_connect(THD *thd, set_var *var)
{
  return update_sys_var_str(&sys_init_connect, &LOCK_sys_init_connect, var);
}


gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
1073 1074
static void sys_default_init_connect(THD* thd, enum_var_type type)
{
1075
  update_sys_var_str(&sys_init_connect, &LOCK_sys_init_connect, 0);
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
1076 1077 1078 1079 1080
}


static bool sys_update_init_slave(THD *thd, set_var *var)
{
1081
  return update_sys_var_str(&sys_init_slave, &LOCK_sys_init_slave, var);
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
1082 1083 1084 1085 1086
}


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

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

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

static void sys_default_ftb_syntax(THD *thd, enum_var_type type)
{
1111
  strmake(ft_boolean_syntax, def_ft_boolean_syntax,
1112 1113
	  sizeof(ft_boolean_syntax)-1);
}
gluh@gluh.mysql.r18.ru's avatar
gluh@gluh.mysql.r18.ru committed
1114

1115 1116 1117 1118 1119
/*
  The following 3 functions need to be changed in 4.1 when we allow
  one to change character sets
*/

1120
static int sys_check_charset(THD *thd, set_var *var)
1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141 1142 1143 1144 1145 1146 1147 1148 1149
{
  return 0;
}


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


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


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

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


1150 1151 1152 1153 1154 1155 1156
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;
}

1157 1158 1159 1160 1161 1162 1163 1164
/*
  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)
  {
1165
    if (thd->variables.max_join_size == HA_POS_ERROR)
1166 1167 1168 1169 1170
      thd->options|= OPTION_BIG_SELECTS;
    else
      thd->options&= ~OPTION_BIG_SELECTS;
  }
}
1171

1172 1173 1174 1175 1176 1177 1178 1179 1180 1181 1182 1183 1184

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

1185 1186 1187 1188 1189 1190 1191 1192 1193 1194 1195 1196 1197 1198 1199
static void fix_completion_type(THD *thd __attribute__(unused), 
				enum_var_type type __attribute__(unused)) {}

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

1200 1201 1202 1203 1204

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

hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1205
#ifdef HAVE_REPLICATION
1206 1207 1208 1209 1210 1211 1212 1213 1214 1215 1216 1217 1218
static void fix_net_read_timeout(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
    thd->net.read_timeout=thd->variables.net_read_timeout;
}


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

1219 1220 1221 1222 1223
static void fix_net_retry_count(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
    thd->net.retry_count=thd->variables.net_retry_count;
}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1224 1225 1226
#else /* HAVE_REPLICATION */
static void fix_net_read_timeout(THD *thd __attribute__(unused),
				 enum_var_type type __attribute__(unused))
1227
{}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1228 1229
static void fix_net_write_timeout(THD *thd __attribute__(unused),
				  enum_var_type type __attribute__(unused))
1230
{}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1231 1232
static void fix_net_retry_count(THD *thd __attribute__(unused),
				enum_var_type type __attribute__(unused))
1233
{}
hf@deer.mysql.r18.ru's avatar
SCRUM  
hf@deer.mysql.r18.ru committed
1234
#endif /* HAVE_REPLICATION */
1235

1236 1237 1238 1239

static void fix_query_cache_size(THD *thd, enum_var_type type)
{
#ifdef HAVE_QUERY_CACHE
1240
  ulong requested= query_cache_size;
1241
  query_cache.resize(query_cache_size);
1242 1243 1244 1245
  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);
1246 1247 1248 1249
#endif
}


1250 1251 1252 1253 1254 1255 1256 1257 1258
#ifdef HAVE_QUERY_CACHE
static void fix_query_cache_min_res_unit(THD *thd, enum_var_type type)
{
  query_cache_min_res_unit= 
    query_cache.set_min_res_unit(query_cache_min_res_unit);
}
#endif


1259
extern void fix_delay_key_write(THD *thd, enum_var_type type)
1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274
{
  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;
  }
}

1275
static void fix_max_binlog_size(THD *thd, enum_var_type type)
1276 1277 1278 1279 1280
{
  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);
1281
#ifdef HAVE_REPLICATION
1282 1283
  if (!max_relay_log_size)
    active_mi->rli.relay_log.set_max_size(max_binlog_size);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1284
#endif
1285 1286 1287
  DBUG_VOID_RETURN;
}

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

1300

1301 1302
static int check_max_delayed_threads(THD *thd, set_var *var)
{
monty@mishka.local's avatar
monty@mishka.local committed
1303
  longlong val= var->value->val_int();
1304
  if (var->type != OPT_GLOBAL && val != 0 &&
monty@mishka.local's avatar
monty@mishka.local committed
1305
      val != (longlong) global_system_variables.max_insert_delayed_threads)
1306 1307
  {
    char buf[64];
1308
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), var->var->name, llstr(val, buf));
1309 1310 1311 1312 1313
    return 1;
  }
  return 0;
}

1314
static void fix_max_connections(THD *thd, enum_var_type type)
1315
{
1316
#ifndef EMBEDDED_LIBRARY
1317 1318
  resize_thr_alarm(max_connections + 
		   global_system_variables.max_insert_delayed_threads + 10);
1319
#endif
1320 1321 1322 1323 1324 1325
}


static void fix_thd_mem_root(THD *thd, enum_var_type type)
{
  if (type != OPT_GLOBAL)
1326
    reset_root_defaults(thd->mem_root,
1327 1328 1329 1330 1331 1332 1333
                        thd->variables.query_alloc_block_size,
                        thd->variables.query_prealloc_size);
}


static void fix_trans_mem_root(THD *thd, enum_var_type type)
{
1334
#ifdef USING_TRANSACTIONS
1335 1336 1337 1338
  if (type != OPT_GLOBAL)
    reset_root_defaults(&thd->transaction.mem_root,
                        thd->variables.trans_alloc_block_size,
                        thd->variables.trans_prealloc_size);
1339
#endif
1340 1341
}

1342

1343 1344 1345 1346
static void fix_server_id(THD *thd, enum_var_type type)
{
  server_id_supplied = 1;
}
1347

svoj@mysql.com's avatar
svoj@mysql.com committed
1348 1349 1350 1351 1352 1353
bool sys_var_long_ptr::check(THD *thd, set_var *var)
{
  longlong v= var->value->val_int();
  var->save_result.ulonglong_value= v < 0 ? 0 : v;
  return 0;
}
1354

1355 1356
bool sys_var_long_ptr::update(THD *thd, set_var *var)
{
1357
  ulonglong tmp= var->save_result.ulonglong_value;
1358
  pthread_mutex_lock(&LOCK_global_system_variables);
1359 1360 1361 1362
  if (option_limits)
    *value= (ulong) getopt_ull_limit_value(tmp, option_limits);
  else
    *value= (ulong) tmp;
1363
  pthread_mutex_unlock(&LOCK_global_system_variables);
1364 1365 1366 1367 1368 1369 1370 1371 1372 1373
  return 0;
}


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


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


void sys_var_ulonglong_ptr::set_default(THD *thd, enum_var_type type)
{
1389
  pthread_mutex_lock(&LOCK_global_system_variables);
1390
  *value= (ulonglong) option_limits->def_value;
1391
  pthread_mutex_unlock(&LOCK_global_system_variables);
1392 1393 1394
}


1395 1396 1397 1398 1399 1400 1401 1402 1403 1404 1405 1406 1407
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;
}


1408 1409 1410 1411 1412 1413 1414
bool sys_var_enum::update(THD *thd, set_var *var)
{
  *value= (uint) var->save_result.ulong_value;
  return 0;
}


1415
byte *sys_var_enum::value_ptr(THD *thd, enum_var_type type, LEX_STRING *base)
1416 1417 1418 1419
{
  return (byte*) enum_names->type_names[*value];
}

1420 1421 1422 1423 1424
bool sys_var_thd_ulong::check(THD *thd, set_var *var)
{
  return (sys_var_thd::check(thd, var) ||
          (check_func && (*check_func)(thd, var)));
}
1425

1426 1427
bool sys_var_thd_ulong::update(THD *thd, set_var *var)
{
1428
  ulonglong tmp= var->save_result.ulonglong_value;
1429 1430 1431 1432 1433 1434 1435 1436

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

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


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


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

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

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


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


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

1510 1511
bool sys_var_thd_ulonglong::update(THD *thd,  set_var *var)
{
1512
  ulonglong tmp= var->save_result.ulonglong_value;
1513

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

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


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


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


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

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

1617 1618 1619

bool sys_var::check_set(THD *thd, set_var *var, TYPELIB *enum_names)
{
1620
  bool not_used;
1621
  char buff[STRING_BUFFER_USUAL_SIZE], *error= 0;
1622 1623 1624 1625 1626 1627
  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)))
1628
    {
1629
      strmov(buff, "NULL");
1630
      goto err;
1631
    }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1632 1633
    var->save_result.ulong_value= ((ulong)
				   find_set(enum_names, res->c_ptr(),
1634 1635 1636
					    res->length(),
                                            NULL,
                                            &error, &error_len,
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
1637
					    &not_used));
1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651 1652 1653 1654 1655 1656
    if (error_len)
    {
      strmake(buff, error, min(sizeof(buff), error_len));
      goto err;
    }
  }
  else
  {
    ulonglong tmp= var->value->val_int();
    if (tmp >= enum_names->count)
    {
      llstr(tmp, buff);
      goto err;
    }
    var->save_result.ulong_value= (ulong) tmp;  // Save for update
  }
  return 0;

err:
1657
  my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, buff);
1658 1659 1660 1661
  return 1;
}


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

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


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

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

bool sys_var_thd_bit::update(THD *thd, set_var *var)
{
1768
  int res= (*update_func)(thd, var);
1769 1770 1771 1772
  return res;
}


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


1786 1787 1788 1789 1790 1791 1792 1793 1794 1795 1796 1797 1798 1799 1800 1801 1802 1803 1804 1805 1806 1807 1808 1809 1810 1811 1812 1813 1814 1815 1816 1817 1818 1819 1820 1821 1822 1823 1824 1825 1826 1827
/* 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)
{
1828
  char buff[STRING_BUFFER_USUAL_SIZE];
1829 1830 1831 1832 1833 1834 1835 1836 1837
  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())))
  {
1838
    my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name, res->c_ptr());
1839 1840 1841 1842 1843 1844 1845 1846 1847 1848 1849 1850 1851 1852 1853 1854 1855 1856 1857 1858 1859 1860 1861 1862 1863 1864 1865 1866 1867 1868 1869 1870 1871 1872 1873 1874 1875 1876 1877 1878 1879 1880 1881 1882 1883 1884 1885 1886 1887 1888 1889 1890 1891
    return 1;
  }
  
  /*
    We must copy result to thread space to not get a memory leak if
    update is aborted
  */
  var->save_result.date_time_format= date_time_format_copy(thd, format);
  my_free((char*) format, MYF(0));
  return var->save_result.date_time_format == 0;
}


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

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

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


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


1892 1893
typedef struct old_names_map_st
{
1894 1895 1896
  const char *old_name;
  const char *new_name;
} my_old_conv;
1897

1898 1899
static my_old_conv old_conv[]= 
{
1900 1901 1902 1903 1904 1905 1906 1907 1908 1909 1910
  {	"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		}
1911
};
1912

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

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

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

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

1959

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

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

1998

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

2006 2007 2008

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

2014

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

2024 2025 2026

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

2037

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

2047

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

2060

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

2070

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

2083

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

2093

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

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

2114

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

2126

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

2139 2140 2141

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

2149

2150
void sys_var_collation_connection::set_default(THD *thd, enum_var_type type)
2151 2152
{
 if (type == OPT_GLOBAL)
2153
   global_system_variables.collation_connection= default_charset_info;
2154
 else
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2155 2156 2157 2158 2159
 {
   thd->variables.collation_connection= (global_system_variables.
					 collation_connection);
   thd->update_charset();
 }
2160 2161
}

2162 2163 2164 2165 2166 2167 2168 2169 2170 2171 2172 2173 2174 2175 2176 2177 2178 2179 2180 2181 2182 2183 2184 2185 2186 2187 2188 2189 2190 2191 2192 2193 2194 2195 2196 2197 2198 2199 2200 2201 2202 2203 2204 2205 2206 2207 2208 2209 2210 2211 2212 2213 2214 2215 2216 2217 2218 2219 2220 2221 2222 2223 2224 2225 2226 2227 2228 2229 2230 2231 2232
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();
 }
}

2233

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

2236
static KEY_CACHE zero_key_cache;
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2237

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

2247

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

2257

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

  /* If no basename, assume it's for the key cache named 'default' */
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2266
  if (!base_name->length)
2267
    base_name= &default_key_cache_base;
2268 2269 2270

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

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

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2292
  if (!tmp)					// Zero size means delete
2293
  {
timour@mysql.com's avatar
timour@mysql.com committed
2294
    if (key_cache == dflt_key_cache)
2295 2296
      goto end;					// Ignore default key cache

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

2319 2320
  key_cache->param_buff_size=
    (ulonglong) getopt_ull_limit_value(tmp, option_limits);
2321

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

2326
  if (!key_cache->key_cache_inited)
2327
    error= (bool) (ha_init_key_cache("", key_cache));
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2328
  else
2329
    error= (bool)(ha_resize_key_cache(key_cache));
2330

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

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

2339 2340

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

2346
  if (!base_name->length)
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
2347
    base_name= &default_key_cache_base;
2348 2349

  pthread_mutex_lock(&LOCK_global_system_variables);
2350
  KEY_CACHE *key_cache= get_key_cache(base_name);
2351

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

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

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

2376
  pthread_mutex_unlock(&LOCK_global_system_variables);
2377

2378 2379 2380 2381 2382 2383 2384 2385
  error= (bool) (ha_resize_key_cache(key_cache));

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

end:
  pthread_mutex_unlock(&LOCK_global_system_variables);
  return error;
2386 2387
}

2388

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

2393
int set_var_collation_client::check(THD *thd)
2394 2395 2396 2397
{
  return 0;
}

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

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

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


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


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


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


bool sys_var_insert_id::update(THD *thd, set_var *var)
{
2449
  thd->next_insert_id= var->save_result.ulonglong_value;
2450 2451 2452 2453
  return 0;
}


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


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


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


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

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

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


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

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


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


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


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

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

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


2645 2646 2647 2648 2649 2650
/*
  Functions to update thd->options bits
*/

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


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

  ulong org_options=thd->options;

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

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

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

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

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

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

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

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

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

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

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

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

  RETURN VALUES
    0		Error
    ptr		pointer to option structure
*/

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


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

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


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


void set_var_init()
{
2825 2826
  hash_init(&system_variable_hash, system_charset_info,
	    array_elements(sys_variables),0,0,
2827
	    (hash_get_key) get_sys_var_length,0,0);
2828 2829 2830 2831 2832 2833 2834
  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);
hf@deer.(none)'s avatar
SCRUM  
hf@deer.(none) committed
2835
    my_hash_insert(&system_variable_hash, (byte*) *var);
2836 2837 2838 2839 2840 2841 2842 2843 2844 2845 2846 2847 2848 2849 2850 2851 2852 2853 2854 2855 2856 2857 2858 2859 2860 2861 2862 2863 2864 2865 2866
  }
  /*
    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)
*/

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

2901
int sql_set_variables(THD *thd, List<set_var_base> *var_list)
2902
{
2903
  int error;
2904
  List_iterator_fast<set_var_base> it(*var_list);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2905
  DBUG_ENTER("sql_set_variables");
2906 2907 2908 2909

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

2920 2921
err:
  free_underlaid_joins(thd, &thd->lex->select_lex);
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
2922
  DBUG_RETURN(error);
2923 2924 2925
}


2926 2927 2928 2929 2930 2931 2932 2933 2934 2935 2936 2937 2938 2939 2940 2941 2942 2943 2944 2945 2946 2947 2948 2949 2950 2951 2952 2953 2954 2955
/*
  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;
}


2956 2957 2958 2959
/*****************************************************************************
  Functions to handle SET mysql_internal_variable=const_expr
*****************************************************************************/

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

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


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

3021
  if (value && ((!value->fixed && value->fix_fields(thd, &value)) ||
3022
                value->check_cols(1)))
3023 3024 3025 3026 3027
    return -1;
  return 0;
}


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


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

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


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


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


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

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

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

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

3121 3122
/* Based upon sys_var::check_enum() */

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

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

err:
3145
  my_error(ER_UNKNOWN_STORAGE_ENGINE, MYF(0), value);
bell@sanja.is.com.ua's avatar
bell@sanja.is.com.ua committed
3146
  return 1;
3147 3148
}

3149

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

3160

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

3169

3170
bool sys_var_thd_storage_engine::update(THD *thd, set_var *var)
3171 3172 3173 3174 3175 3176 3177 3178
{
  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;
}

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

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

3199

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

3204 3205
byte *sys_var_thd_sql_mode::value_ptr(THD *thd, enum_var_type type,
				      LEX_STRING *base)
3206 3207 3208 3209 3210 3211 3212 3213 3214 3215 3216 3217 3218 3219 3220 3221 3222 3223 3224 3225 3226 3227 3228 3229 3230 3231 3232 3233 3234 3235 3236 3237 3238 3239 3240 3241
{
  ulong val;
  char buff[256];
  String tmp(buff, sizeof(buff), &my_charset_latin1);

  tmp.length(0);
  val= ((type == OPT_GLOBAL) ? global_system_variables.*offset :
        thd->variables.*offset);
  for (uint i= 0; val; val>>= 1, i++)
  {
    if (val & 1)
    {
      tmp.append(enum_names->type_names[i]);
      tmp.append(',');
    }
  }
  if (tmp.length())
    tmp.length(tmp.length() - 1);
  return (byte*) thd->strmake(tmp.ptr(), tmp.length());
}


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

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
3242
  {
3243
    thd->variables.sql_mode= fix_sql_mode(thd->variables.sql_mode);
3244 3245 3246 3247 3248 3249 3250 3251
    /*
      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;
  }
3252 3253 3254
}

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

3256 3257 3258 3259 3260 3261 3262 3263 3264
ulong fix_sql_mode(ulong sql_mode)
{
  /*
    Note that we dont set 
    MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS | MODE_NO_FIELD_OPTIONS
    to allow one to get full use of MySQL in this mode.
  */

  if (sql_mode & MODE_ANSI)
3265
  {
3266
    sql_mode|= (MODE_REAL_AS_FLOAT | MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
3267 3268 3269 3270 3271 3272
		MODE_IGNORE_SPACE);
    /* 
      MODE_ONLY_FULL_GROUP_BY removed from ANSI mode because it is currently
      overly restrictive (see BUG#8510).
    */
  }
3273 3274 3275 3276
  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 |
3277
		MODE_NO_FIELD_OPTIONS | MODE_NO_AUTO_CREATE_USER);
3278 3279 3280 3281 3282 3283 3284 3285 3286 3287 3288 3289 3290 3291 3292
  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);
3293
  if (sql_mode & MODE_MAXDB)
3294 3295 3296
    sql_mode|= (MODE_PIPES_AS_CONCAT | MODE_ANSI_QUOTES |
		MODE_IGNORE_SPACE |
		MODE_NO_KEY_OPTIONS | MODE_NO_TABLE_OPTIONS |
3297
		MODE_NO_FIELD_OPTIONS | MODE_NO_AUTO_CREATE_USER);
3298
  if (sql_mode & MODE_MYSQL40)
3299
    sql_mode|= MODE_NO_FIELD_OPTIONS | MODE_HIGH_NOT_PRECEDENCE;
3300
  if (sql_mode & MODE_MYSQL323)
3301
    sql_mode|= MODE_NO_FIELD_OPTIONS | MODE_HIGH_NOT_PRECEDENCE;
3302 3303 3304
  if (sql_mode & MODE_TRADITIONAL)
    sql_mode|= (MODE_STRICT_TRANS_TABLES | MODE_STRICT_ALL_TABLES |
                MODE_NO_ZERO_IN_DATE | MODE_NO_ZERO_DATE |
3305
                MODE_ERROR_FOR_DIVISION_BY_ZERO | MODE_NO_AUTO_CREATE_USER);
3306 3307
  return sql_mode;
}
3308 3309


3310 3311 3312 3313
/****************************************************************************
  Named list handling
****************************************************************************/

monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3314 3315
gptr find_named(I_List<NAMED_LIST> *list, const char *name, uint length,
		NAMED_LIST **found)
3316 3317 3318 3319 3320 3321
{
  I_List_iterator<NAMED_LIST> it(*list);
  NAMED_LIST *element;
  while ((element= it++))
  {
    if (element->cmp(name, length))
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3322
    {
3323 3324
      if (found)
        *found= element;
3325
      return element->data;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3326
    }
3327 3328 3329 3330 3331
  }
  return 0;
}


3332 3333
void delete_elements(I_List<NAMED_LIST> *list,
		     void (*free_element)(const char *name, gptr))
3334 3335
{
  NAMED_LIST *element;
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3336
  DBUG_ENTER("delete_elements");
3337 3338
  while ((element= list->get()))
  {
3339
    (*free_element)(element->name, element->data);
3340 3341
    delete element;
  }
monty@mashka.mysql.fi's avatar
monty@mashka.mysql.fi committed
3342
  DBUG_VOID_RETURN;
3343 3344 3345 3346 3347
}


/* Key cache functions */

3348
static KEY_CACHE *create_key_cache(const char *name, uint length)
3349
{
3350
  KEY_CACHE *key_cache;
3351 3352 3353
  DBUG_ENTER("create_key_cache");
  DBUG_PRINT("enter",("name: %.*s", length, name));
  
3354
  if ((key_cache= (KEY_CACHE*) my_malloc(sizeof(KEY_CACHE),
3355
					     MYF(MY_ZEROFILL | MY_WME))))
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3356 3357
  {
    if (!new NAMED_LIST(&key_caches, name, length, (gptr) key_cache))
3358 3359
    {
      my_free((char*) key_cache, MYF(0));
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3360
      key_cache= 0;
3361 3362 3363 3364 3365 3366 3367 3368 3369
    }
    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
      */
3370 3371 3372
      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;
3373
    }
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3374
  }
3375
  DBUG_RETURN(key_cache);
3376 3377 3378
}


3379
KEY_CACHE *get_or_create_key_cache(const char *name, uint length)
3380
{
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3381
  LEX_STRING key_cache_name;
3382
  KEY_CACHE *key_cache;
3383

igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3384 3385
  key_cache_name.str= (char *) name;
  key_cache_name.length= length;
3386 3387
  pthread_mutex_lock(&LOCK_global_system_variables);
  if (!(key_cache= get_key_cache(&key_cache_name)))
3388
    key_cache= create_key_cache(name, length);
3389
  pthread_mutex_unlock(&LOCK_global_system_variables);
3390 3391 3392 3393
  return key_cache;
}


3394
void free_key_cache(const char *name, KEY_CACHE *key_cache)
3395
{
3396 3397
  ha_end_key_cache(key_cache);
  my_free((char*) key_cache, MYF(0));
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3398 3399 3400
}


3401
bool process_key_caches(int (* func) (const char *name, KEY_CACHE *))
3402
{
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3403 3404
  I_List_iterator<NAMED_LIST> it(key_caches);
  NAMED_LIST *element;
3405

igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3406 3407
  while ((element= it++))
  {
3408
    KEY_CACHE *key_cache= (KEY_CACHE *) element->data;
3409
    func(element->name, key_cache);
igor@rurik.mysql.com's avatar
igor@rurik.mysql.com committed
3410 3411
  }
  return 0;
3412 3413
}

3414

3415 3416 3417 3418
/****************************************************************************
  Used templates
****************************************************************************/

3419
#ifdef HAVE_EXPLICIT_TEMPLATE_INSTANTIATION
3420
template class List<set_var_base>;
3421
template class List_iterator_fast<set_var_base>;
3422
template class I_List_iterator<NAMED_LIST>;
3423
#endif