313
317
/* Global read-only variable containing hostname */
314
318
static sys_var_const_str sys_hostname("hostname", glob_hostname);
316
bool sys_var::check(Session *session, set_var *var)
320
bool sys_var::check(Session *, set_var *var)
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());
322
var->save_result.uint64_t_value= var->value->val_int();
329
326
bool sys_var_str::check(Session *session, set_var *var)
335
332
if ((res=(*check_func)(session, var)) < 0)
336
333
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());
357
338
Functions to check and update variables
451
static bool get_unsigned32(Session *session, set_var *var)
453
if (var->value->unsigned_flag)
454
var->save_result.uint32_t_value=
455
static_cast<uint32_t>(var->value->val_int());
458
int64_t v= var->value->val_int();
460
throw_bounds_warning(session, true, true,var->var->getName().c_str(), v);
462
var->save_result.uint32_t_value=
463
static_cast<uint32_t>((v > UINT32_MAX) ? UINT32_MAX : (v < 0) ? 0 : v);
468
static bool get_unsigned64(Session *, set_var *var)
470
if (var->value->unsigned_flag)
471
var->save_result.uint64_t_value=(uint64_t) var->value->val_int();
474
int64_t v= var->value->val_int();
475
var->save_result.uint64_t_value= (uint64_t) ((v < 0) ? 0 : v);
480
static bool get_size_t(Session *, set_var *var)
482
if (var->value->unsigned_flag)
483
var->save_result.size_t_value= (size_t) var->value->val_int();
486
ssize_t v= (ssize_t)var->value->val_int();
487
var->save_result.size_t_value= (size_t) ((v < 0) ? 0 : v);
470
492
bool sys_var_uint32_t_ptr::check(Session *, set_var *var)
494
var->save_result.uint32_t_value= (uint32_t)var->value->val_int();
476
498
bool sys_var_uint32_t_ptr::update(Session *session, set_var *var)
478
uint64_t tmp= var->getInteger();
479
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
500
uint32_t tmp= var->save_result.uint32_t_value;
501
LOCK_global_system_variables.lock();
481
502
if (option_limits)
483
504
uint32_t newvalue= (uint32_t) fix_unsigned(session, tmp, option_limits);
484
if(static_cast<uint64_t>(newvalue) == tmp)
485
506
*value= newvalue;
489
*value= static_cast<uint32_t>(tmp);
509
*value= (uint32_t) tmp;
510
LOCK_global_system_variables.unlock();
496
void sys_var_uint32_t_ptr::set_default(Session *session, sql_var_t)
515
void sys_var_uint32_t_ptr::set_default(Session *, sql_var_t)
499
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
518
LOCK_global_system_variables.lock();
500
519
*value= (uint32_t)getopt_ull_limit_value((uint32_t) option_limits->def_value,
501
520
option_limits, ¬_used);
521
LOCK_global_system_variables.unlock();
505
525
bool sys_var_uint64_t_ptr::update(Session *session, set_var *var)
507
uint64_t tmp= var->getInteger();
508
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
527
uint64_t tmp= var->save_result.uint64_t_value;
528
LOCK_global_system_variables.lock();
510
529
if (option_limits)
512
uint64_t newvalue= fix_unsigned(session, tmp, option_limits);
531
uint64_t newvalue= (uint64_t) fix_unsigned(session, tmp, option_limits);
513
532
if(newvalue==tmp)
514
533
*value= newvalue;
536
*value= (uint64_t) tmp;
537
LOCK_global_system_variables.unlock();
525
void sys_var_uint64_t_ptr::set_default(Session *session, sql_var_t)
542
void sys_var_uint64_t_ptr::set_default(Session *, sql_var_t)
527
if (have_default_value)
529
*value= default_value;
534
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
535
*value= getopt_ull_limit_value((uint64_t) option_limits->def_value,
536
option_limits, ¬_used);
545
LOCK_global_system_variables.lock();
546
*value= getopt_ull_limit_value((uint64_t) option_limits->def_value,
547
option_limits, ¬_used);
548
LOCK_global_system_variables.unlock();
541
552
bool sys_var_size_t_ptr::update(Session *session, set_var *var)
543
size_t tmp= size_t(var->getInteger());
545
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
554
size_t tmp= var->save_result.size_t_value;
555
LOCK_global_system_variables.lock();
547
556
if (option_limits)
548
557
*value= fix_size_t(session, tmp, option_limits);
560
LOCK_global_system_variables.unlock();
556
void sys_var_size_t_ptr::set_default(Session *session, sql_var_t)
565
void sys_var_size_t_ptr::set_default(Session *, sql_var_t)
559
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
568
LOCK_global_system_variables.lock();
560
569
*value= (size_t)getopt_ull_limit_value((size_t) option_limits->def_value,
561
570
option_limits, ¬_used);
564
bool sys_var_bool_ptr::check(Session *session, set_var *var)
566
return check_enum(session, var, &bool_typelib);
571
LOCK_global_system_variables.unlock();
569
574
bool sys_var_bool_ptr::update(Session *, set_var *var)
571
*value= bool(var->getInteger());
576
*value= (bool) var->save_result.uint32_t_value;
576
581
void sys_var_bool_ptr::set_default(Session *, sql_var_t)
578
*value= default_value;
583
*value= (bool) option_limits->def_value;
853
844
if (var->value->result_type() == STRING_RESULT)
855
res= var->value->val_str(&str);
846
if (!(res=var->value->val_str(&str)) ||
847
(var->save_result.uint32_t_value= find_type(enum_names, res->ptr(),
848
res->length(),1)) == 0)
850
value= res ? res->c_ptr() : "NULL";
862
uint64_t tmp_val= find_type(enum_names, res->ptr(), res->length(),1);
868
var->setValue(tmp_val-1);
854
var->save_result.uint32_t_value--;
872
uint64_t tmp= var->value->val_int();
858
uint64_t tmp=var->value->val_int();
873
859
if (tmp >= enum_names->count)
875
861
internal::llstr(tmp,buff);
876
862
value=buff; // Wrong value is here
879
var->setValue(tmp); // Save for update
865
var->save_result.uint32_t_value= (uint32_t) tmp; // Save for update
915
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
901
LOCK_global_system_variables.lock();
916
902
value= *(uint*) value_ptr(session, var_type, base);
903
LOCK_global_system_variables.unlock();
918
904
return new Item_uint((uint64_t) value);
920
906
case SHOW_LONGLONG:
923
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
909
LOCK_global_system_variables.lock();
924
910
value= *(int64_t*) value_ptr(session, var_type, base);
911
LOCK_global_system_variables.unlock();
926
912
return new Item_int(value);
928
914
case SHOW_DOUBLE:
932
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
933
value= *(double*) value_ptr(session, var_type, base);
917
LOCK_global_system_variables.lock();
918
value= *(double*) value_ptr(session, var_type, base);
919
LOCK_global_system_variables.unlock();
936
920
/* 6, as this is for now only used with microseconds */
937
921
return new Item_float(value, 6);
939
923
case SHOW_HA_ROWS:
942
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
926
LOCK_global_system_variables.lock();
943
927
value= *(ha_rows*) value_ptr(session, var_type, base);
928
LOCK_global_system_variables.unlock();
945
929
return new Item_int((uint64_t) value);
950
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
934
LOCK_global_system_variables.lock();
951
935
value= *(size_t*) value_ptr(session, var_type, base);
936
LOCK_global_system_variables.unlock();
953
937
return new Item_int((uint64_t) value);
955
939
case SHOW_MY_BOOL:
958
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
942
LOCK_global_system_variables.lock();
959
943
value= *(bool*) value_ptr(session, var_type, base);
944
LOCK_global_system_variables.unlock();
960
945
return new Item_int(value,1);
962
947
case SHOW_CHAR_PTR:
965
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
950
LOCK_global_system_variables.lock();
966
951
char *str= *(char**) value_ptr(session, var_type, base);
1123
1119
bool sys_var_timestamp::update(Session *session, set_var *var)
1125
session->set_time(time_t(var->getInteger()));
1121
session->set_time((time_t) var->save_result.uint64_t_value);
1130
1126
void sys_var_timestamp::set_default(Session *session, sql_var_t)
1132
session->resetUserTime();
1128
session->user_time=0;
1136
1132
unsigned char *sys_var_timestamp::value_ptr(Session *session, sql_var_t,
1137
1133
const LEX_STRING *)
1139
session->sys_var_tmp.int32_t_value= (int32_t) session->getCurrentTimestampEpoch();
1135
session->sys_var_tmp.int32_t_value= (int32_t) session->start_time;
1140
1136
return (unsigned char*) &session->sys_var_tmp.int32_t_value;
1144
1140
bool sys_var_last_insert_id::update(Session *session, set_var *var)
1146
session->first_successful_insert_id_in_prev_stmt= var->getInteger();
1142
session->first_successful_insert_id_in_prev_stmt=
1143
var->save_result.uint64_t_value;
1165
bool sys_var_session_time_zone::update(Session *session, set_var *var)
1162
bool sys_var_session_time_zone::check(Session *session, set_var *var)
1167
1164
char buff[MAX_TIME_ZONE_NAME_LENGTH];
1168
1165
String str(buff, sizeof(buff), &my_charset_utf8_general_ci);
1169
1166
String *res= var->value->val_str(&str);
1171
Time_zone *tmp= my_tz_find(session, res);
1168
if (!(var->save_result.time_zone= my_tz_find(session, res)))
1174
boost::throw_exception(invalid_option_value(var->var->getName()) << invalid_value(std::string(res ? res->c_ptr() : "NULL")));
1170
my_error(ER_UNKNOWN_TIME_ZONE, MYF(0), res ? res->c_ptr() : "NULL");
1177
bool sys_var_session_time_zone::update(Session *session, set_var *var)
1177
1179
/* We are using Time_zone object found during check() phase. */
1178
1180
if (var->type == OPT_GLOBAL)
1180
boost::mutex::scoped_lock scopedLock(session->catalog().systemVariableLock());
1181
global_system_variables.time_zone= tmp;
1182
LOCK_global_system_variables.lock();
1183
global_system_variables.time_zone= var->save_result.time_zone;
1184
LOCK_global_system_variables.unlock();
1185
session->variables.time_zone= tmp;
1187
session->variables.time_zone= var->save_result.time_zone;
1217
1217
void sys_var_session_time_zone::set_default(Session *session, sql_var_t type)
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;
1219
LOCK_global_system_variables.lock();
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;
1236
LOCK_global_system_variables.unlock();
1240
bool sys_var_session_lc_time_names::update(Session *session, set_var *var)
1240
bool sys_var_session_lc_time_names::check(Session *, set_var *var)
1242
1242
MY_LOCALE *locale_match;
1354
1363
static bool set_option_autocommit(Session *session, set_var *var)
1357
1365
/* The test is negative as the flag we use is NOT autocommit */
1359
1367
uint64_t org_options= session->options;
1360
uint64_t new_options= session->options;
1362
if (var->getInteger() != 0)
1363
new_options&= ~((sys_var_session_bit*) var->var)->bit_flag;
1369
if (var->save_result.uint32_t_value != 0)
1370
session->options&= ~((sys_var_session_bit*) var->var)->bit_flag;
1365
new_options|= ((sys_var_session_bit*) var->var)->bit_flag;
1372
session->options|= ((sys_var_session_bit*) var->var)->bit_flag;
1367
if ((org_options ^ new_options) & OPTION_NOT_AUTOCOMMIT)
1374
if ((org_options ^ session->options) & OPTION_NOT_AUTOCOMMIT)
1369
1376
if ((org_options & OPTION_NOT_AUTOCOMMIT))
1371
success= session->endActiveTransaction();
1372
1378
/* We changed to auto_commit mode */
1373
1379
session->options&= ~(uint64_t) (OPTION_BEGIN);
1374
1380
session->server_status|= SERVER_STATUS_AUTOCOMMIT;
1381
TransactionServices &transaction_services= TransactionServices::singleton();
1382
if (transaction_services.commitTransaction(session, true))
1378
1387
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;
1393
1393
static int check_pseudo_thread_id(Session *, set_var *var)
1395
var->save_result.uint64_t_value= var->value->val_int();
1677
1691
Functions to handle table_type
1678
1692
****************************************************************************/
1694
/* Based upon sys_var::check_enum() */
1696
bool sys_var_session_storage_engine::check(Session *session, set_var *var)
1698
char buff[STRING_BUFFER_USUAL_SIZE];
1700
String str(buff, sizeof(buff), &my_charset_utf8_general_ci), *res;
1702
var->save_result.storage_engine= NULL;
1703
if (var->value->result_type() == STRING_RESULT)
1705
res= var->value->val_str(&str);
1706
if (res == NULL || res->ptr() == NULL)
1713
const std::string engine_name(res->ptr());
1714
plugin::StorageEngine *engine;
1715
var->save_result.storage_engine= plugin::StorageEngine::findByName(*session, engine_name);
1716
if (var->save_result.storage_engine == NULL)
1718
value= res->c_ptr();
1721
engine= var->save_result.storage_engine;
1728
my_error(ER_UNKNOWN_STORAGE_ENGINE, MYF(0), value);
1680
1733
unsigned char *sys_var_session_storage_engine::value_ptr(Session *session,
1681
1734
sql_var_t type,
1682
1735
const LEX_STRING *)
1715
1768
bool sys_var_session_storage_engine::update(Session *session, set_var *var)
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);
1770
plugin::StorageEngine **value= &(global_system_variables.*offset), *old_value;
1749
1771
if (var->type != OPT_GLOBAL)
1750
1772
value= &(session->variables.*offset);
1774
if (old_value != var->save_result.storage_engine)
1776
*value= var->save_result.storage_engine;
1757
my_error(ER_UNKNOWN_STORAGE_ENGINE, MYF(0), name_value);
1761
1781
} /* namespace drizzled */