diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/t/optimizer_prune_level_basic.test')
-rw-r--r-- | mysql-test/suite/sys_vars/t/optimizer_prune_level_basic.test | 14 |
1 files changed, 10 insertions, 4 deletions
diff --git a/mysql-test/suite/sys_vars/t/optimizer_prune_level_basic.test b/mysql-test/suite/sys_vars/t/optimizer_prune_level_basic.test index 1e3a8bc3d7f..c857653bc31 100644 --- a/mysql-test/suite/sys_vars/t/optimizer_prune_level_basic.test +++ b/mysql-test/suite/sys_vars/t/optimizer_prune_level_basic.test @@ -60,10 +60,10 @@ SELECT @@session.optimizer_prune_level; ########################################################### SET @@global.optimizer_prune_level = DEFAULT; -SELECT @@global.optimizer_prune_level = 1; +SELECT @@global.optimizer_prune_level = 2; SET @@session.optimizer_prune_level = DEFAULT; -SELECT @@session.optimizer_prune_level = 1; +SELECT @@session.optimizer_prune_level = 2; --echo '#--------------------FN_DYNVARS_115_03-------------------------#' @@ -77,6 +77,8 @@ SET @@global.optimizer_prune_level = 0; SELECT @@global.optimizer_prune_level; SET @@global.optimizer_prune_level = 1; SELECT @@global.optimizer_prune_level; +SET @@global.optimizer_prune_level = 2; +SELECT @@global.optimizer_prune_level; SET @@global.optimizer_prune_level = TRUE; SELECT @@global.optimizer_prune_level; SET @@global.optimizer_prune_level = FALSE; @@ -94,6 +96,8 @@ SET @@session.optimizer_prune_level = 0; SELECT @@session.optimizer_prune_level; SET @@session.optimizer_prune_level = 1; SELECT @@session.optimizer_prune_level; +SET @@session.optimizer_prune_level = 2; +SELECT @@session.optimizer_prune_level; SET @@session.optimizer_prune_level = TRUE; SELECT @@session.optimizer_prune_level; SET @@session.optimizer_prune_level = FALSE; @@ -107,7 +111,7 @@ SELECT @@session.optimizer_prune_level; --Error ER_WRONG_TYPE_FOR_VAR SET @@global.optimizer_prune_level = ON; ---echo 'Bug# 34840: Since it is a boolean variable, it should not give errors on 'ON' & 'OFF' values'; +--echo 'Bug# 34840: Since it is not a boolean variable, it should give errors on 'ON' & 'OFF' values'; --Error ER_WRONG_TYPE_FOR_VAR SET @@global.optimizer_prune_level = OFF; --Error ER_WRONG_TYPE_FOR_VAR @@ -122,9 +126,11 @@ SET @@global.optimizer_prune_level = FELSE; SET @@global.optimizer_prune_level = -1024; SELECT @@global.optimizer_prune_level; ---echo 'Bug# 34840: Since it is a boolean variable, it should give errors on numeric values'; +--echo 'Bug# 34840: Since it is not a boolean variable, it should no give errors on numeric values'; SET @@global.optimizer_prune_level = 65536; +SET @@global.optimizer_prune_level = 3; +select @@global.optimizer_prune_level; --Error ER_WRONG_TYPE_FOR_VAR SET @@global.optimizer_prune_level = 65530.34; --Error ER_WRONG_TYPE_FOR_VAR |