111
107
static void fix_max_join_size(Session *session, sql_var_t type);
112
108
static void fix_session_mem_root(Session *session, sql_var_t type);
113
109
static void fix_server_id(Session *session, sql_var_t type);
114
static bool get_unsigned32(Session *session, set_var *var);
115
static bool get_unsigned64(Session *session, set_var *var);
116
110
bool throw_bounds_warning(Session *session, bool fixed, bool unsignd,
117
111
const std::string &name, int64_t val);
118
112
static unsigned char *get_error_count(Session *session);
157
151
&drizzle_system_variables::join_buff_size);
158
152
static sys_var_session_uint32_t sys_max_allowed_packet("max_allowed_packet",
159
153
&drizzle_system_variables::max_allowed_packet);
160
static sys_var_uint64_t_ptr sys_max_connect_errors("max_connect_errors",
161
&max_connect_errors);
162
154
static sys_var_session_uint64_t sys_max_error_count("max_error_count",
163
155
&drizzle_system_variables::max_error_count);
164
156
static sys_var_session_uint64_t sys_max_heap_table_size("max_heap_table_size",
221
213
static sys_var_session_size_t sys_sort_buffer("sort_buffer_size",
222
214
&drizzle_system_variables::sortbuff_size);
224
static sys_var_session_size_t sys_transaction_message_threshold("transaction_message_threshold",
225
&drizzle_system_variables::transaction_message_threshold);
216
static sys_var_size_t_ptr_readonly sys_transaction_message_threshold("transaction_message_threshold",
217
&transaction_message_threshold);
227
219
static sys_var_session_storage_engine sys_storage_engine("storage_engine",
228
220
&drizzle_system_variables::storage_engine);
321
313
/* Global read-only variable containing hostname */
322
314
static sys_var_const_str sys_hostname("hostname", glob_hostname);
324
bool sys_var::check(Session *, set_var *var)
316
bool sys_var::check(Session *session, set_var *var)
326
var->save_result.uint64_t_value= var->value->val_int();
321
if ((res=(*check_func)(session, var)) < 0)
322
my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), getName().c_str(), var->value->str_value.ptr());
330
329
bool sys_var_str::check(Session *session, set_var *var)
336
335
if ((res=(*check_func)(session, var)) < 0)
337
336
my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), getName().c_str(), var->value->str_value.ptr());
340
bool sys_var_std_string::check(Session *session, set_var *var)
342
if (check_func == NULL)
347
int res= (*check_func)(session, var);
350
my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), getName().c_str(), var->value->str_value.ptr());
342
357
Functions to check and update variables
455
static bool get_unsigned32(Session *session, set_var *var)
457
if (var->value->unsigned_flag)
458
var->save_result.uint32_t_value=
459
static_cast<uint32_t>(var->value->val_int());
462
int64_t v= var->value->val_int();
464
throw_bounds_warning(session, true, true,var->var->getName().c_str(), v);
466
var->save_result.uint32_t_value=
467
static_cast<uint32_t>((v > UINT32_MAX) ? UINT32_MAX : (v < 0) ? 0 : v);
472
static bool get_unsigned64(Session *, set_var *var)
474
if (var->value->unsigned_flag)
475
var->save_result.uint64_t_value=(uint64_t) var->value->val_int();
478
int64_t v= var->value->val_int();
479
var->save_result.uint64_t_value= (uint64_t) ((v < 0) ? 0 : v);
484
static bool get_size_t(Session *, set_var *var)
486
if (var->value->unsigned_flag)
487
var->save_result.size_t_value= (size_t) var->value->val_int();
490
ssize_t v= (ssize_t)var->value->val_int();
491
var->save_result.size_t_value= (size_t) ((v < 0) ? 0 : v);
496
470
bool sys_var_uint32_t_ptr::check(Session *, set_var *var)
498
var->save_result.uint32_t_value= (uint32_t)var->value->val_int();
502
476
bool sys_var_uint32_t_ptr::update(Session *session, set_var *var)
504
uint32_t tmp= var->save_result.uint32_t_value;
505
LOCK_global_system_variables.lock();
478
uint64_t tmp= var->getInteger();
479
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
506
481
if (option_limits)
508
483
uint32_t newvalue= (uint32_t) fix_unsigned(session, tmp, option_limits);
484
if(static_cast<uint64_t>(newvalue) == tmp)
510
485
*value= newvalue;
513
*value= (uint32_t) tmp;
514
LOCK_global_system_variables.unlock();
489
*value= static_cast<uint32_t>(tmp);
519
void sys_var_uint32_t_ptr::set_default(Session *, sql_var_t)
496
void sys_var_uint32_t_ptr::set_default(Session *session, sql_var_t)
522
LOCK_global_system_variables.lock();
499
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
523
500
*value= (uint32_t)getopt_ull_limit_value((uint32_t) option_limits->def_value,
524
501
option_limits, ¬_used);
525
LOCK_global_system_variables.unlock();
529
505
bool sys_var_uint64_t_ptr::update(Session *session, set_var *var)
531
uint64_t tmp= var->save_result.uint64_t_value;
532
LOCK_global_system_variables.lock();
507
uint64_t tmp= var->getInteger();
508
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
533
510
if (option_limits)
535
uint64_t newvalue= (uint64_t) fix_unsigned(session, tmp, option_limits);
512
uint64_t newvalue= fix_unsigned(session, tmp, option_limits);
536
513
if(newvalue==tmp)
537
514
*value= newvalue;
540
*value= (uint64_t) tmp;
541
LOCK_global_system_variables.unlock();
546
void sys_var_uint64_t_ptr::set_default(Session *, sql_var_t)
525
void sys_var_uint64_t_ptr::set_default(Session *session, sql_var_t)
548
527
if (have_default_value)
555
LOCK_global_system_variables.lock();
534
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
556
535
*value= getopt_ull_limit_value((uint64_t) option_limits->def_value,
557
536
option_limits, ¬_used);
558
LOCK_global_system_variables.unlock();
563
541
bool sys_var_size_t_ptr::update(Session *session, set_var *var)
565
size_t tmp= var->save_result.size_t_value;
566
LOCK_global_system_variables.lock();
543
size_t tmp= size_t(var->getInteger());
545
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
567
547
if (option_limits)
568
548
*value= fix_size_t(session, tmp, option_limits);
571
LOCK_global_system_variables.unlock();
576
void sys_var_size_t_ptr::set_default(Session *, sql_var_t)
556
void sys_var_size_t_ptr::set_default(Session *session, sql_var_t)
579
LOCK_global_system_variables.lock();
559
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
580
560
*value= (size_t)getopt_ull_limit_value((size_t) option_limits->def_value,
581
561
option_limits, ¬_used);
582
LOCK_global_system_variables.unlock();
564
bool sys_var_bool_ptr::check(Session *session, set_var *var)
566
return check_enum(session, var, &bool_typelib);
585
569
bool sys_var_bool_ptr::update(Session *, set_var *var)
587
*value= (bool) var->save_result.uint32_t_value;
571
*value= bool(var->getInteger());
592
576
void sys_var_bool_ptr::set_default(Session *, sql_var_t)
594
*value= (bool) option_limits->def_value;
578
*value= default_value;
601
585
bool sys_var_session_uint32_t::check(Session *session, set_var *var)
603
return (get_unsigned32(session, var) ||
604
(check_func && (*check_func)(session, var)));
588
return (check_func && (*check_func)(session, var));
607
591
bool sys_var_session_uint32_t::update(Session *session, set_var *var)
609
uint64_t tmp= (uint64_t) var->save_result.uint32_t_value;
593
uint64_t tmp= var->getInteger();
611
595
/* Don't use bigger value than given with --maximum-variable-name=.. */
612
596
if ((uint32_t) tmp > max_system_variables.*offset)
688
674
/* We will not come here if option_limits is not set */
689
LOCK_global_system_variables.lock();
675
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
690
676
global_system_variables.*offset=
691
677
(ha_rows) getopt_ull_limit_value((ha_rows) option_limits->def_value,
692
678
option_limits, ¬_used);
693
LOCK_global_system_variables.unlock();
696
682
session->variables.*offset= global_system_variables.*offset;
709
696
bool sys_var_session_uint64_t::check(Session *session, set_var *var)
711
return (get_unsigned64(session, var) ||
712
(check_func && (*check_func)(session, var)));
699
return (check_func && (*check_func)(session, var));
715
702
bool sys_var_session_uint64_t::update(Session *session, set_var *var)
717
uint64_t tmp= var->save_result.uint64_t_value;
704
uint64_t tmp= var->getInteger();
719
706
if (tmp > max_system_variables.*offset)
765
755
bool sys_var_session_size_t::check(Session *session, set_var *var)
767
return (get_size_t(session, var) ||
768
(check_func && (*check_func)(session, var)));
758
return (check_func && (*check_func)(session, var));
771
761
bool sys_var_session_size_t::update(Session *session, set_var *var)
773
size_t tmp= var->save_result.size_t_value;
763
size_t tmp= size_t(var->getInteger());
775
765
if (tmp > max_system_variables.*offset)
776
766
tmp= max_system_variables.*offset;
815
808
return (unsigned char*) &(session->variables.*offset);
811
bool sys_var_session_bool::check(Session *session, set_var *var)
813
return check_enum(session, var, &bool_typelib);
819
816
bool sys_var_session_bool::update(Session *session, set_var *var)
821
818
if (var->type == OPT_GLOBAL)
822
global_system_variables.*offset= (bool) var->save_result.uint32_t_value;
819
global_system_variables.*offset= bool(var->getInteger());
824
session->variables.*offset= (bool) var->save_result.uint32_t_value;
821
session->variables.*offset= bool(var->getInteger());
855
853
if (var->value->result_type() == STRING_RESULT)
857
if (!(res=var->value->val_str(&str)) ||
858
(var->save_result.uint32_t_value= find_type(enum_names, res->ptr(),
859
res->length(),1)) == 0)
855
res= var->value->val_str(&str);
861
value= res ? res->c_ptr() : "NULL";
865
var->save_result.uint32_t_value--;
862
uint64_t tmp_val= find_type(enum_names, res->ptr(), res->length(),1);
868
var->setValue(tmp_val-1);
869
uint64_t tmp=var->value->val_int();
872
uint64_t tmp= var->value->val_int();
870
873
if (tmp >= enum_names->count)
872
875
internal::llstr(tmp,buff);
873
876
value=buff; // Wrong value is here
876
var->save_result.uint32_t_value= (uint32_t) tmp; // Save for update
879
var->setValue(tmp); // Save for update
912
LOCK_global_system_variables.lock();
915
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
913
916
value= *(uint*) value_ptr(session, var_type, base);
914
LOCK_global_system_variables.unlock();
915
918
return new Item_uint((uint64_t) value);
917
920
case SHOW_LONGLONG:
920
LOCK_global_system_variables.lock();
923
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
921
924
value= *(int64_t*) value_ptr(session, var_type, base);
922
LOCK_global_system_variables.unlock();
923
926
return new Item_int(value);
925
928
case SHOW_DOUBLE:
928
LOCK_global_system_variables.lock();
929
value= *(double*) value_ptr(session, var_type, base);
930
LOCK_global_system_variables.unlock();
932
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
933
value= *(double*) value_ptr(session, var_type, base);
931
936
/* 6, as this is for now only used with microseconds */
932
937
return new Item_float(value, 6);
934
939
case SHOW_HA_ROWS:
937
LOCK_global_system_variables.lock();
942
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
938
943
value= *(ha_rows*) value_ptr(session, var_type, base);
939
LOCK_global_system_variables.unlock();
940
945
return new Item_int((uint64_t) value);
945
LOCK_global_system_variables.lock();
950
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
946
951
value= *(size_t*) value_ptr(session, var_type, base);
947
LOCK_global_system_variables.unlock();
948
953
return new Item_int((uint64_t) value);
950
955
case SHOW_MY_BOOL:
953
LOCK_global_system_variables.lock();
958
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
954
959
value= *(bool*) value_ptr(session, var_type, base);
955
LOCK_global_system_variables.unlock();
956
960
return new Item_int(value,1);
958
962
case SHOW_CHAR_PTR:
961
LOCK_global_system_variables.lock();
965
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
962
966
char *str= *(char**) value_ptr(session, var_type, base);
971
975
tmp= new Item_null();
972
976
tmp->collation.set(system_charset_info, DERIVATION_SYSCONST);
974
LOCK_global_system_variables.unlock();
980
LOCK_global_system_variables.lock();
984
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
981
985
char *str= (char*) value_ptr(session, var_type, base);
983
987
tmp= new Item_string(str, strlen(str),
1068
1066
String str(buff,sizeof(buff), system_charset_info), *res;
1069
1067
if (!(res=var->value->val_str(&str)))
1071
my_error(ER_WRONG_VALUE_FOR_VAR, MYF(0), name.c_str(), "NULL");
1069
boost::throw_exception(invalid_option_value(var->var->getName()) << invalid_value(std::string("NULL")));
1074
1072
if (!(tmp=get_charset_by_name(res->c_ptr())))
1076
1074
my_error(ER_UNKNOWN_COLLATION, MYF(0), res->c_ptr());
1075
boost::throw_exception(invalid_option_value(var->var->getName()) << invalid_value(std::string(res->c_ptr())));
1085
1084
internal::int10_to_str((int) var->value->val_int(), buf, -10);
1086
1085
my_error(ER_UNKNOWN_COLLATION, MYF(0), buf);
1086
boost::throw_exception(invalid_option_value(var->var->getName()) << invalid_value(boost::lexical_cast<std::string>(var->value->val_int())));
1090
var->save_result.charset= tmp; // Save for update
1095
bool sys_var_collation_sv::update(Session *session, set_var *var)
1097
1090
if (var->type == OPT_GLOBAL)
1098
global_system_variables.*offset= var->save_result.charset;
1091
global_system_variables.*offset= tmp;
1101
session->variables.*offset= var->save_result.charset;
1094
session->variables.*offset= tmp;
1130
1123
bool sys_var_timestamp::update(Session *session, set_var *var)
1132
session->set_time((time_t) var->save_result.uint64_t_value);
1125
session->set_time(time_t(var->getInteger()));
1137
1130
void sys_var_timestamp::set_default(Session *session, sql_var_t)
1139
session->user_time=0;
1132
session->resetUserTime();
1143
1136
unsigned char *sys_var_timestamp::value_ptr(Session *session, sql_var_t,
1144
1137
const LEX_STRING *)
1146
session->sys_var_tmp.int32_t_value= (int32_t) session->start_time;
1139
session->sys_var_tmp.int32_t_value= (int32_t) session->getCurrentTimestampEpoch();
1147
1140
return (unsigned char*) &session->sys_var_tmp.int32_t_value;
1151
1144
bool sys_var_last_insert_id::update(Session *session, set_var *var)
1153
session->first_successful_insert_id_in_prev_stmt=
1154
var->save_result.uint64_t_value;
1146
session->first_successful_insert_id_in_prev_stmt= var->getInteger();
1173
bool sys_var_session_time_zone::check(Session *session, set_var *var)
1165
bool sys_var_session_time_zone::update(Session *session, set_var *var)
1175
1167
char buff[MAX_TIME_ZONE_NAME_LENGTH];
1176
1168
String str(buff, sizeof(buff), &my_charset_utf8_general_ci);
1177
1169
String *res= var->value->val_str(&str);
1179
if (!(var->save_result.time_zone= my_tz_find(session, res)))
1171
Time_zone *tmp= my_tz_find(session, res);
1181
my_error(ER_UNKNOWN_TIME_ZONE, MYF(0), res ? res->c_ptr() : "NULL");
1174
boost::throw_exception(invalid_option_value(var->var->getName()) << invalid_value(std::string(res ? res->c_ptr() : "NULL")));
1188
bool sys_var_session_time_zone::update(Session *session, set_var *var)
1190
1177
/* We are using Time_zone object found during check() phase. */
1191
1178
if (var->type == OPT_GLOBAL)
1193
LOCK_global_system_variables.lock();
1194
global_system_variables.time_zone= var->save_result.time_zone;
1195
LOCK_global_system_variables.unlock();
1180
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
1181
global_system_variables.time_zone= tmp;
1198
session->variables.time_zone= var->save_result.time_zone;
1185
session->variables.time_zone= tmp;
1228
1217
void sys_var_session_time_zone::set_default(Session *session, sql_var_t type)
1230
LOCK_global_system_variables.lock();
1231
if (type == OPT_GLOBAL)
1233
if (default_tz_name)
1235
String str(default_tz_name, &my_charset_utf8_general_ci);
1237
We are guaranteed to find this time zone since its existence
1238
is checked during start-up.
1240
global_system_variables.time_zone= my_tz_find(session, &str);
1243
global_system_variables.time_zone= my_tz_SYSTEM;
1246
session->variables.time_zone= global_system_variables.time_zone;
1247
LOCK_global_system_variables.unlock();
1219
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
1220
if (type == OPT_GLOBAL)
1222
if (default_tz_name)
1224
String str(default_tz_name, &my_charset_utf8_general_ci);
1226
We are guaranteed to find this time zone since its existence
1227
is checked during start-up.
1229
global_system_variables.time_zone= my_tz_find(session, &str);
1232
global_system_variables.time_zone= my_tz_SYSTEM;
1235
session->variables.time_zone= global_system_variables.time_zone;
1251
bool sys_var_session_lc_time_names::check(Session *, set_var *var)
1240
bool sys_var_session_lc_time_names::update(Session *session, set_var *var)
1253
1242
MY_LOCALE *locale_match;
1374
1354
static bool set_option_autocommit(Session *session, set_var *var)
1376
1357
/* The test is negative as the flag we use is NOT autocommit */
1378
1359
uint64_t org_options= session->options;
1360
uint64_t new_options= session->options;
1380
if (var->save_result.uint32_t_value != 0)
1381
session->options&= ~((sys_var_session_bit*) var->var)->bit_flag;
1362
if (var->getInteger() != 0)
1363
new_options&= ~((sys_var_session_bit*) var->var)->bit_flag;
1383
session->options|= ((sys_var_session_bit*) var->var)->bit_flag;
1365
new_options|= ((sys_var_session_bit*) var->var)->bit_flag;
1385
if ((org_options ^ session->options) & OPTION_NOT_AUTOCOMMIT)
1367
if ((org_options ^ new_options) & OPTION_NOT_AUTOCOMMIT)
1387
1369
if ((org_options & OPTION_NOT_AUTOCOMMIT))
1371
success= session->endActiveTransaction();
1389
1372
/* We changed to auto_commit mode */
1390
1373
session->options&= ~(uint64_t) (OPTION_BEGIN);
1391
1374
session->server_status|= SERVER_STATUS_AUTOCOMMIT;
1392
TransactionServices &transaction_services= TransactionServices::singleton();
1393
if (transaction_services.commitTransaction(session, true))
1398
1378
session->server_status&= ~SERVER_STATUS_AUTOCOMMIT;
1382
if (var->getInteger() != 0)
1383
session->options&= ~((sys_var_session_bit*) var->var)->bit_flag;
1385
session->options|= ((sys_var_session_bit*) var->var)->bit_flag;
1404
1393
static int check_pseudo_thread_id(Session *, set_var *var)
1406
var->save_result.uint64_t_value= var->value->val_int();
1592
1581
add_sys_var_to_list(&sys_last_insert_id, my_long_options);
1593
1582
add_sys_var_to_list(&sys_lc_time_names, my_long_options);
1594
1583
add_sys_var_to_list(&sys_max_allowed_packet, my_long_options);
1595
add_sys_var_to_list(&sys_max_connect_errors, my_long_options);
1596
1584
add_sys_var_to_list(&sys_max_error_count, my_long_options);
1597
1585
add_sys_var_to_list(&sys_max_heap_table_size, my_long_options);
1598
1586
add_sys_var_to_list(&sys_max_join_size, my_long_options);
1703
1677
Functions to handle table_type
1704
1678
****************************************************************************/
1706
/* Based upon sys_var::check_enum() */
1708
bool sys_var_session_storage_engine::check(Session *session, set_var *var)
1710
char buff[STRING_BUFFER_USUAL_SIZE];
1712
String str(buff, sizeof(buff), &my_charset_utf8_general_ci), *res;
1714
var->save_result.storage_engine= NULL;
1715
if (var->value->result_type() == STRING_RESULT)
1717
res= var->value->val_str(&str);
1718
if (res == NULL || res->ptr() == NULL)
1725
const std::string engine_name(res->ptr());
1726
plugin::StorageEngine *engine;
1727
var->save_result.storage_engine= plugin::StorageEngine::findByName(*session, engine_name);
1728
if (var->save_result.storage_engine == NULL)
1730
value= res->c_ptr();
1733
engine= var->save_result.storage_engine;
1740
my_error(ER_UNKNOWN_STORAGE_ENGINE, MYF(0), value);
1745
1680
unsigned char *sys_var_session_storage_engine::value_ptr(Session *session,
1746
1681
sql_var_t type,
1747
1682
const LEX_STRING *)
1780
1715
bool sys_var_session_storage_engine::update(Session *session, set_var *var)
1782
plugin::StorageEngine **value= &(global_system_variables.*offset), *old_value;
1717
char buff[STRING_BUFFER_USUAL_SIZE];
1718
const char *name_value;
1719
String str(buff, sizeof(buff), &my_charset_utf8_general_ci), *res;
1721
plugin::StorageEngine *tmp= NULL;
1722
plugin::StorageEngine **value= NULL;
1724
if (var->value->result_type() == STRING_RESULT)
1726
res= var->value->val_str(&str);
1727
if (res == NULL || res->ptr() == NULL)
1734
const std::string engine_name(res->ptr());
1735
tmp= plugin::StorageEngine::findByName(*session, engine_name);
1738
name_value= res->c_ptr();
1745
name_value= "unknown";
1748
value= &(global_system_variables.*offset);
1783
1749
if (var->type != OPT_GLOBAL)
1784
1750
value= &(session->variables.*offset);
1786
if (old_value != var->save_result.storage_engine)
1788
*value= var->save_result.storage_engine;
1757
my_error(ER_UNKNOWN_STORAGE_ENGINE, MYF(0), name_value);
1793
1761
} /* namespace drizzled */