diff options
Diffstat (limited to 'mysql-test/r/flush_basic.result')
-rw-r--r-- | mysql-test/r/flush_basic.result | 97 |
1 files changed, 0 insertions, 97 deletions
diff --git a/mysql-test/r/flush_basic.result b/mysql-test/r/flush_basic.result deleted file mode 100644 index 259f8f929a1..00000000000 --- a/mysql-test/r/flush_basic.result +++ /dev/null @@ -1,97 +0,0 @@ -SET @start_value = @@global.flush; -SELECT @start_value; -@start_value -0 -'#--------------------FN_DYNVARS_030_01------------------------#' -SET @@global.flush = ON; -SET @@global.flush = DEFAULT; -ERROR 42000: Variable 'flush' doesn't have a default value -'Bug# 34878: FN_DYNVARS_002_01 - Default value is off according to Documentation of MySQL'; -SELECT @@global.flush; -@@global.flush -1 -'#---------------------FN_DYNVARS_030_02-------------------------#' -SET @@global.flush = @start_value; -SELECT @@global.flush; -@@global.flush -0 -'#--------------------FN_DYNVARS_030_03------------------------#' -SET @@global.flush = ON; -SELECT @@global.flush; -@@global.flush -1 -SET @@global.flush = OFF; -SELECT @@global.flush; -@@global.flush -0 -SET @@global.flush = 0; -SELECT @@global.flush; -@@global.flush -0 -SET @@global.flush = 1; -SELECT @@global.flush; -@@global.flush -1 -'#--------------------FN_DYNVARS_030_04-------------------------#' -SET @@global.flush = 2; -ERROR 42000: Variable 'flush' can't be set to the value of '2' -SET @@global.flush = -1; -ERROR 42000: Variable 'flush' can't be set to the value of '-1' -SET @@global.flush = TRUEF; -ERROR 42000: Variable 'flush' can't be set to the value of 'TRUEF' -SET @@global.flush = TRUE_F; -ERROR 42000: Variable 'flush' can't be set to the value of 'TRUE_F' -SET @@global.flush = FALSE0; -ERROR 42000: Variable 'flush' can't be set to the value of 'FALSE0' -SET @@global.flush = OON; -ERROR 42000: Variable 'flush' can't be set to the value of 'OON' -SET @@global.flush = ONN; -ERROR 42000: Variable 'flush' can't be set to the value of 'ONN' -SET @@global.flush = OOFF; -ERROR 42000: Variable 'flush' can't be set to the value of 'OOFF' -SET @@global.flush = 0FF; -ERROR 42000: Variable 'flush' can't be set to the value of '0FF' -SET @@global.flush = ' '; -ERROR 42000: Variable 'flush' can't be set to the value of ' ' -SET @@global.flush = " "; -ERROR 42000: Variable 'flush' can't be set to the value of ' ' -SET @@global.flush = ''; -ERROR 42000: Variable 'flush' can't be set to the value of '' -'#-------------------FN_DYNVARS_030_05----------------------------#' -SET @@session.flush = 1; -ERROR HY000: Variable 'flush' is a GLOBAL variable and should be set with SET GLOBAL -SELECT @@session.flush; -ERROR HY000: Variable 'flush' is a GLOBAL variable -'#----------------------FN_DYNVARS_030_06------------------------#' -SELECT @@global.flush = VARIABLE_VALUE -FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES -WHERE VARIABLE_NAME='flush'; -@@global.flush = VARIABLE_VALUE -0 -'#---------------------FN_DYNVARS_030_07----------------------#' -SET @@global.flush = TRUE; -SELECT @@global.flush; -@@global.flush -1 -SET @@global.flush = FALSE; -SELECT @@global.flush; -@@global.flush -0 -'#---------------------FN_DYNVARS_030_08----------------------#' -SET @@global.flush = 1; -SELECT @@flush = @@global.flush; -@@flush = @@global.flush -1 -'#---------------------FN_DYNVARS_030_09----------------------#' -SET flush = 1; -ERROR HY000: Variable 'flush' is a GLOBAL variable and should be set with SET GLOBAL -SET global.flush = 1; -ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'flush = 1' at line 1 -SELECT global.flush; -ERROR 42S02: Unknown table 'global' in field list -SELECT flush = @@session.flush; -ERROR 42S22: Unknown column 'flush' in 'field list' -SET @@global.flush = @start_value; -SELECT @@global.flush; -@@global.flush -0 |