diff options
Diffstat (limited to 'mysql-test/r/variables-notembedded.result')
| -rw-r--r-- | mysql-test/r/variables-notembedded.result | 43 |
1 files changed, 41 insertions, 2 deletions
diff --git a/mysql-test/r/variables-notembedded.result b/mysql-test/r/variables-notembedded.result index 75fd2430e4b..f8191345219 100644 --- a/mysql-test/r/variables-notembedded.result +++ b/mysql-test/r/variables-notembedded.result @@ -44,19 +44,58 @@ ERROR HY000: Variable 'relay_log' is a read only variable SET @@global.relay_log= 'x'; ERROR HY000: Variable 'relay_log' is a read only variable # +SHOW VARIABLES like 'relay_log_basename'; +Variable_name Value +relay_log_basename MYSQLTEST_VARDIR/mysqld.1/data/mysqld-relay-bin +SELECT @@session.relay_log_basename; +ERROR HY000: Variable 'relay_log_basename' is a GLOBAL variable +SELECT @@global.relay_log_basename; +@@global.relay_log_basename +MYSQLTEST_VARDIR/mysqld.1/data/mysqld-relay-bin +SET @@session.relay_log_basename= 'x'; +ERROR HY000: Variable 'relay_log_basename' is a read only variable +SET @@global.relay_log_basename= 'x'; +ERROR HY000: Variable 'relay_log_basename' is a read only variable +# +SHOW VARIABLES like 'log_bin_basename'; +Variable_name Value +log_bin_basename +SELECT @@session.log_bin_basename; +ERROR HY000: Variable 'log_bin_basename' is a GLOBAL variable +SELECT @@global.log_bin_basename; +@@global.log_bin_basename +NULL +SET @@session.log_bin_basename= 'x'; +ERROR HY000: Variable 'log_bin_basename' is a read only variable +SET @@global.log_bin_basename= 'x'; +ERROR HY000: Variable 'log_bin_basename' is a read only variable +# SHOW VARIABLES like 'relay_log_index'; Variable_name Value -relay_log_index mysqld-relay-bin.index +relay_log_index MYSQLTEST_VARDIR/mysqld.1/data/mysqld-relay-bin.index SELECT @@session.relay_log_index; ERROR HY000: Variable 'relay_log_index' is a GLOBAL variable SELECT @@global.relay_log_index; @@global.relay_log_index -mysqld-relay-bin.index +MYSQLTEST_VARDIR/mysqld.1/data/mysqld-relay-bin.index SET @@session.relay_log_index= 'x'; ERROR HY000: Variable 'relay_log_index' is a read only variable SET @@global.relay_log_index= 'x'; ERROR HY000: Variable 'relay_log_index' is a read only variable # +SHOW VARIABLES like 'log_bin_index'; +Variable_name Value +log_bin_index +SELECT @@session.log_bin_index; +ERROR HY000: Variable 'log_bin_index' is a GLOBAL variable +SELECT @@global.log_bin_index; +@@global.log_bin_index +NULL +SET @@session.log_bin_index= 'x'; +ERROR HY000: Variable 'log_bin_index' is a read only variable +SET @@global.log_bin_index= 'x'; +ERROR HY000: Variable 'log_bin_index' is a read only variable +# SHOW VARIABLES like 'relay_log_info_file'; Variable_name Value relay_log_info_file relay-log.info |