diff options
Diffstat (limited to 'mysql-test/t/variables-notembedded.test')
-rw-r--r-- | mysql-test/t/variables-notembedded.test | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/mysql-test/t/variables-notembedded.test b/mysql-test/t/variables-notembedded.test index 471212bf38f..2aa77e1e254 100644 --- a/mysql-test/t/variables-notembedded.test +++ b/mysql-test/t/variables-notembedded.test @@ -58,9 +58,33 @@ SET @@session.relay_log= 'x'; SET @@global.relay_log= 'x'; # --echo # +--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR +SHOW VARIABLES like 'relay_log_basename'; +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +SELECT @@session.relay_log_basename; +--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR +SELECT @@global.relay_log_basename; +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +SET @@session.relay_log_basename= 'x'; +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +SET @@global.relay_log_basename= 'x'; +# +--echo # +SHOW VARIABLES like 'log_bin_basename'; +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +SELECT @@session.log_bin_basename; +SELECT @@global.log_bin_basename; +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +SET @@session.log_bin_basename= 'x'; +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +SET @@global.log_bin_basename= 'x'; +# +--echo # +--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR SHOW VARIABLES like 'relay_log_index'; --error ER_INCORRECT_GLOBAL_LOCAL_VAR SELECT @@session.relay_log_index; +--replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR SELECT @@global.relay_log_index; --error ER_INCORRECT_GLOBAL_LOCAL_VAR SET @@session.relay_log_index= 'x'; @@ -68,6 +92,16 @@ SET @@session.relay_log_index= 'x'; SET @@global.relay_log_index= 'x'; # --echo # +SHOW VARIABLES like 'log_bin_index'; +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +SELECT @@session.log_bin_index; +SELECT @@global.log_bin_index; +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +SET @@session.log_bin_index= 'x'; +--error ER_INCORRECT_GLOBAL_LOCAL_VAR +SET @@global.log_bin_index= 'x'; +# +--echo # SHOW VARIABLES like 'relay_log_info_file'; --error ER_INCORRECT_GLOBAL_LOCAL_VAR SELECT @@session.relay_log_info_file; |