diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/t/optimizer_use_condition_selectivity_basic.test')
-rw-r--r-- | mysql-test/suite/sys_vars/t/optimizer_use_condition_selectivity_basic.test | 32 |
1 files changed, 0 insertions, 32 deletions
diff --git a/mysql-test/suite/sys_vars/t/optimizer_use_condition_selectivity_basic.test b/mysql-test/suite/sys_vars/t/optimizer_use_condition_selectivity_basic.test index c409abd0d1b..1529db1a145 100644 --- a/mysql-test/suite/sys_vars/t/optimizer_use_condition_selectivity_basic.test +++ b/mysql-test/suite/sys_vars/t/optimizer_use_condition_selectivity_basic.test @@ -11,41 +11,13 @@ ############################################################# SET @start_global_value = @@global.optimizer_use_condition_selectivity; -SELECT @start_global_value; SET @start_session_value = @@session.optimizer_use_condition_selectivity; -SELECT @start_session_value; - - ---echo '#--------------------FN_DYNVARS_115_01-------------------------#' -######################################################################### -# Display the DEFAULT value of optimizer_use_condition_selectivity # -######################################################################### - -SET @@global.optimizer_use_condition_selectivity = DEFAULT; -SELECT @@global.optimizer_use_condition_selectivity; - -SET @@session.optimizer_use_condition_selectivity = DEFAULT; -SELECT @@session.optimizer_use_condition_selectivity; - - ---echo '#--------------------FN_DYNVARS_115_02-------------------------#' -######################################################################### -# Check the DEFAULT value of optimizer_use_condition_selectivity # -######################################################################### - -SET @@global.optimizer_use_condition_selectivity = DEFAULT; -SELECT @@global.optimizer_use_condition_selectivity = 1; - -SET @@session.optimizer_use_condition_selectivity = DEFAULT; -SELECT @@session.optimizer_use_condition_selectivity = 1; - --echo '#--------------------FN_DYNVARS_115_03-------------------------#' ############################################################################################# # Change the value of optimizer_use_condition_selectivity to a valid value for GLOBAL Scope # ############################################################################################# -SELECT @@global.optimizer_use_condition_selectivity; SET @@global.optimizer_use_condition_selectivity = 0; SELECT @@global.optimizer_use_condition_selectivity; SET @@global.optimizer_use_condition_selectivity = 1; @@ -67,7 +39,6 @@ SELECT @@global.optimizer_use_condition_selectivity; # Change the value of optimizer_use_condition_selectivity to a valid value for SESSION Scope# ############################################################################################# -SELECT @@session.optimizer_use_condition_selectivity; SET @@session.optimizer_use_condition_selectivity = 0; SELECT @@session.optimizer_use_condition_selectivity; SET @@session.optimizer_use_condition_selectivity = 1; @@ -144,9 +115,6 @@ SELECT @@local.optimizer_use_condition_selectivity = @@session.optimizer_use_con #################################### SET @@global.optimizer_use_condition_selectivity = @start_global_value; -SELECT @@global.optimizer_use_condition_selectivity; -SET @@session.optimizer_use_condition_selectivity = @start_session_value; -SELECT @@session.optimizer_use_condition_selectivity; ######################################################################## # END OF optimizer_use_condition_selectivity TESTS # |