diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/log_output_basic.result')
| -rw-r--r-- | mysql-test/suite/sys_vars/r/log_output_basic.result | 34 |
1 files changed, 3 insertions, 31 deletions
diff --git a/mysql-test/suite/sys_vars/r/log_output_basic.result b/mysql-test/suite/sys_vars/r/log_output_basic.result index 481d5862074..ab9e5837e63 100644 --- a/mysql-test/suite/sys_vars/r/log_output_basic.result +++ b/mysql-test/suite/sys_vars/r/log_output_basic.result @@ -1,26 +1,18 @@ SET @start_value = @@global.log_output; SELECT @start_value; @start_value -FILE,TABLE +FILE '#--------------------FN_DYNVARS_065_01------------------------#' SET @@global.log_output = FILE; SET @@global.log_output = DEFAULT; SELECT @@global.log_output; @@global.log_output FILE -'Bug# 34876: Documentation specifies a DEFAULT value of TABLE whereas'; -'DEFAULT value is FILE. Also note that initial value is different'; -'from DEFAULT'; '#---------------------FN_DYNVARS_065_02-------------------------#' SET @@global.log_output = NULL; ERROR 42000: Variable 'log_output' can't be set to the value of 'NULL' SET @@global.log_output = ""; ERROR 42000: Variable 'log_output' can't be set to the value of '' -SELECT @@global.log_output; -@@global.log_output -FILE -'Bug# 34838: Empty value is allowed where as it is not specified in'; -'documentation'; '#--------------------FN_DYNVARS_065_03------------------------#' SET @@global.log_output = 'TABLE'; SELECT @@global.log_output; @@ -66,10 +58,6 @@ SET @@global.log_output = ',TABLE'; SELECT @@global.log_output; @@global.log_output TABLE -SET @@global.log_output = ','; -SELECT @@global.log_output; -@@global.log_output - SET @@global.log_output = 'TABLE,,FILE,,,'; SELECT @@global.log_output; @@global.log_output @@ -89,22 +77,6 @@ SET @@global.log_output = 'TABLE, FILE'; ERROR 42000: Variable 'log_output' can't be set to the value of ' FILE' SET @@global.log_output = ' TABLE,FILE'; ERROR 42000: Variable 'log_output' can't be set to the value of ' TABLE' -SET @@global.log_output = ', '; -SELECT @@global.log_output; -@@global.log_output - -SET @@global.log_output = ' '; -SELECT @@global.log_output; -@@global.log_output - -SET @@global.log_output = ' '; -SELECT @@global.log_output; -@@global.log_output - -'Bug: The behavior of space in value is not consistent.'; -'Some times it is trimmed and some times not.'; -'The space before and after value is not accepted where as space'; -'between comma is accepted.'; '#-------------------FN_DYNVARS_065_05----------------------------#' SET @@log_output = 0; ERROR HY000: Variable 'log_output' is a GLOBAL variable and should be set with SET GLOBAL @@ -121,7 +93,7 @@ SET @@global.log_output = 0; ERROR 42000: Variable 'log_output' can't be set to the value of '0' SELECT @@global.log_output; @@global.log_output - +FILE,TABLE SET @@global.log_output = 1; SELECT @@global.log_output; @@global.log_output @@ -172,4 +144,4 @@ TABLE SET @@global.log_output = @start_value; SELECT @@global.log_output; @@global.log_output -FILE,TABLE +FILE |