diff options
Diffstat (limited to 'mysql-test/r/log_output_basic.result')
| -rw-r--r-- | mysql-test/r/log_output_basic.result | 172 |
1 files changed, 172 insertions, 0 deletions
diff --git a/mysql-test/r/log_output_basic.result b/mysql-test/r/log_output_basic.result new file mode 100644 index 00000000000..2b0c2409c41 --- /dev/null +++ b/mysql-test/r/log_output_basic.result @@ -0,0 +1,172 @@ +SET @start_value = @@global.log_output; +SELECT @start_value; +@start_value +FILE,TABLE +'#--------------------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 = ""; +SELECT @@global.log_output; +@@global.log_output + +'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; +@@global.log_output +TABLE +SET @@global.log_output = 'FILE'; +SELECT @@global.log_output; +@@global.log_output +FILE +SET @@global.log_output = 'NONE'; +SELECT @@global.log_output; +@@global.log_output +NONE +SET @@global.log_output = 'FILE,TABLE'; +SELECT @@global.log_output; +@@global.log_output +FILE,TABLE +SET @@global.log_output = 'TABLE,FILE'; +SELECT @@global.log_output; +@@global.log_output +FILE,TABLE +SET @@global.log_output = 'NONE,TABLE'; +SELECT @@global.log_output; +@@global.log_output +NONE,TABLE +SET @@global.log_output = 'NONE,FILE'; +SELECT @@global.log_output; +@@global.log_output +NONE,FILE +SET @@global.log_output = 'FILE,TABLE,NONE'; +SELECT @@global.log_output; +@@global.log_output +NONE,FILE,TABLE +SET @@global.log_output = 'TABLE,NONE'; +SELECT @@global.log_output; +@@global.log_output +NONE,TABLE +SET @@global.log_output = 'TABLE,TABLE'; +SELECT @@global.log_output; +@@global.log_output +TABLE +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 +FILE,TABLE +'#--------------------FN_DYNVARS_065_04-------------------------#' +SET @@global.log_output = -1; +ERROR 42000: Variable 'log_output' can't be set to the value of '-1' +SET @@global.log_output = TAB; +ERROR 42000: Variable 'log_output' can't be set to the value of 'TAB' +SET @@global.log_output = NIL; +ERROR 42000: Variable 'log_output' can't be set to the value of 'NIL' +SET @@global.log_output = 'FIL'; +ERROR 42000: Variable 'log_output' can't be set to the value of 'FIL' +SET @@global.log_output = 'T'; +ERROR 42000: Variable 'log_output' can't be set to the value of 'T' +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 +SELECT @@session.log_output; +ERROR HY000: Variable 'log_output' is a GLOBAL variable +'#----------------------FN_DYNVARS_065_06------------------------#' +SELECT @@log_output = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='log_output'; +@@log_output = VARIABLE_VALUE +1 +'#---------------------FN_DYNVARS_065_07-------------------------#' +SET @@global.log_output = 0; +SELECT @@global.log_output; +@@global.log_output + +SET @@global.log_output = 1; +SELECT @@global.log_output; +@@global.log_output +NONE +SET @@global.log_output = 2; +SELECT @@global.log_output; +@@global.log_output +FILE +SET @@global.log_output = 3; +SELECT @@global.log_output; +@@global.log_output +NONE,FILE +SET @@global.log_output = 4; +SELECT @@global.log_output; +@@global.log_output +TABLE +SET @@global.log_output = 5; +SELECT @@global.log_output; +@@global.log_output +NONE,TABLE +SET @@global.log_output = 6; +SELECT @@global.log_output; +@@global.log_output +FILE,TABLE +SET @@global.log_output = 7; +SELECT @@global.log_output; +@@global.log_output +NONE,FILE,TABLE +SET @@global.log_output = 8; +ERROR 42000: Variable 'log_output' can't be set to the value of '8' +'#---------------------FN_DYNVARS_065_08----------------------#' +SET @@global.log_output = TRUE; +SELECT @@global.log_output; +@@global.log_output +NONE +SET @@global.log_output = FALSE; +SELECT @@global.log_output; +@@global.log_output + +'#---------------------FN_DYNVARS_065_09----------------------#' +SET log_output = ON; +ERROR HY000: Variable 'log_output' is a GLOBAL variable and should be set with SET GLOBAL +SET global log_output = 'TABLE'; +SELECT @@global.log_output; +@@global.log_output +TABLE +SET @@global.log_output = @start_value; +SELECT @@global.log_output; +@@global.log_output +FILE,TABLE |