summaryrefslogtreecommitdiff
path: root/mysql-test/r/flush_basic.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/flush_basic.result')
-rw-r--r--mysql-test/r/flush_basic.result97
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