1SET @start_global_value = @@global.optimizer_use_condition_selectivity; 2SET @start_session_value = @@session.optimizer_use_condition_selectivity; 3'#--------------------FN_DYNVARS_115_03-------------------------#' 4SET @@global.optimizer_use_condition_selectivity = 0; 5Warnings: 6Warning 1292 Truncated incorrect optimizer_use_condition_selec... value: '0' 7SELECT @@global.optimizer_use_condition_selectivity; 8@@global.optimizer_use_condition_selectivity 91 10SET @@global.optimizer_use_condition_selectivity = 1; 11SELECT @@global.optimizer_use_condition_selectivity; 12@@global.optimizer_use_condition_selectivity 131 14SET @@global.optimizer_use_condition_selectivity = 2; 15SELECT @@global.optimizer_use_condition_selectivity; 16@@global.optimizer_use_condition_selectivity 172 18SET @@global.optimizer_use_condition_selectivity = 3; 19SELECT @@global.optimizer_use_condition_selectivity; 20@@global.optimizer_use_condition_selectivity 213 22SET @@global.optimizer_use_condition_selectivity = 4; 23SELECT @@global.optimizer_use_condition_selectivity; 24@@global.optimizer_use_condition_selectivity 254 26SET @@global.optimizer_use_condition_selectivity = 5; 27SELECT @@global.optimizer_use_condition_selectivity; 28@@global.optimizer_use_condition_selectivity 295 30SET @@global.optimizer_use_condition_selectivity = 6; 31Warnings: 32Warning 1292 Truncated incorrect optimizer_use_condition_selec... value: '6' 33SELECT @@global.optimizer_use_condition_selectivity; 34@@global.optimizer_use_condition_selectivity 355 36'#--------------------FN_DYNVARS_115_04-------------------------#' 37SET @@session.optimizer_use_condition_selectivity = 0; 38Warnings: 39Warning 1292 Truncated incorrect optimizer_use_condition_selec... value: '0' 40SELECT @@session.optimizer_use_condition_selectivity; 41@@session.optimizer_use_condition_selectivity 421 43SET @@session.optimizer_use_condition_selectivity = 1; 44SELECT @@session.optimizer_use_condition_selectivity; 45@@session.optimizer_use_condition_selectivity 461 47SET @@session.optimizer_use_condition_selectivity = 2; 48SELECT @@session.optimizer_use_condition_selectivity; 49@@session.optimizer_use_condition_selectivity 502 51SET @@session.optimizer_use_condition_selectivity = 3; 52SELECT @@session.optimizer_use_condition_selectivity; 53@@session.optimizer_use_condition_selectivity 543 55SET @@session.optimizer_use_condition_selectivity = 4; 56SELECT @@session.optimizer_use_condition_selectivity; 57@@session.optimizer_use_condition_selectivity 584 59SET @@session.optimizer_use_condition_selectivity = 5; 60SELECT @@session.optimizer_use_condition_selectivity; 61@@session.optimizer_use_condition_selectivity 625 63SET @@session.optimizer_use_condition_selectivity = 6; 64Warnings: 65Warning 1292 Truncated incorrect optimizer_use_condition_selec... value: '6' 66SELECT @@session.optimizer_use_condition_selectivity; 67@@session.optimizer_use_condition_selectivity 685 69'#------------------FN_DYNVARS_115_05-----------------------#' 70SET @@global.optimizer_use_condition_selectivity = ON; 71ERROR 42000: Incorrect argument type to variable 'optimizer_use_condition_selectivity' 72SET @@global.optimizer_use_condition_selectivity = OFF; 73ERROR 42000: Incorrect argument type to variable 'optimizer_use_condition_selectivity' 74SET @@session.optimizer_use_condition_selectivity = 65530.34; 75ERROR 42000: Incorrect argument type to variable 'optimizer_use_condition_selectivity' 76SET @@session.optimizer_use_condition_selectivity = test; 77ERROR 42000: Incorrect argument type to variable 'optimizer_use_condition_selectivity' 78'#------------------FN_DYNVARS_115_06-----------------------#' 79SELECT @@global.optimizer_use_condition_selectivity = VARIABLE_VALUE 80FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 81WHERE VARIABLE_NAME='optimizer_use_condition_selectivity'; 82@@global.optimizer_use_condition_selectivity = VARIABLE_VALUE 831 84'#------------------FN_DYNVARS_115_07-----------------------#' 85SELECT @@session.optimizer_use_condition_selectivity = VARIABLE_VALUE 86FROM INFORMATION_SCHEMA.SESSION_VARIABLES 87WHERE VARIABLE_NAME='optimizer_use_condition_selectivity'; 88@@session.optimizer_use_condition_selectivity = VARIABLE_VALUE 891 90'#---------------------FN_DYNVARS_115_08----------------------#' 91SET @@optimizer_use_condition_selectivity = 1; 92SET @@global.optimizer_use_condition_selectivity = 3; 93SELECT @@optimizer_use_condition_selectivity = @@global.optimizer_use_condition_selectivity; 94@@optimizer_use_condition_selectivity = @@global.optimizer_use_condition_selectivity 950 96'#---------------------FN_DYNVARS_115_09----------------------#' 97SET @@optimizer_use_condition_selectivity = 2; 98SELECT @@optimizer_use_condition_selectivity = @@local.optimizer_use_condition_selectivity; 99@@optimizer_use_condition_selectivity = @@local.optimizer_use_condition_selectivity 1001 101SELECT @@local.optimizer_use_condition_selectivity = @@session.optimizer_use_condition_selectivity; 102@@local.optimizer_use_condition_selectivity = @@session.optimizer_use_condition_selectivity 1031 104SET @@global.optimizer_use_condition_selectivity = @start_global_value; 105