Debian Codegraph @

mysql-test/suite/sys_vars/r/flush_basic.result

raw
1 SET @start_value = @@global.flush;
2 SELECT @start_value;
3 @start_value
4 0
5 '#--------------------FN_DYNVARS_030_01------------------------#'
6 SET @@global.flush = ON;
7 SET @@global.flush = DEFAULT;
8 SELECT @@global.flush;
9 @@global.flush
10 0
11 '#---------------------FN_DYNVARS_030_02-------------------------#'
12 SET @@global.flush = @start_value;
13 SELECT @@global.flush;
14 @@global.flush
15 0
16 '#--------------------FN_DYNVARS_030_03------------------------#'
17 SET @@global.flush = ON;
18 SELECT @@global.flush;
19 @@global.flush
20 1
21 SET @@global.flush = OFF;
22 SELECT @@global.flush;
23 @@global.flush
24 0
25 SET @@global.flush = 0;
26 SELECT @@global.flush;
27 @@global.flush
28 0
29 SET @@global.flush = 1;
30 SELECT @@global.flush;
31 @@global.flush
32 1
33 '#--------------------FN_DYNVARS_030_04-------------------------#'
34 SET @@global.flush = 2;
35 ERROR 42000: Variable 'flush' can't be set to the value of '2'
36 SET @@global.flush = -1;
37 ERROR 42000: Variable 'flush' can't be set to the value of '-1'
38 SET @@global.flush = TRUEF;
39 ERROR 42000: Variable 'flush' can't be set to the value of 'TRUEF'
40 SET @@global.flush = TRUE_F;
41 ERROR 42000: Variable 'flush' can't be set to the value of 'TRUE_F'
42 SET @@global.flush = FALSE0;
43 ERROR 42000: Variable 'flush' can't be set to the value of 'FALSE0'
44 SET @@global.flush = OON;
45 ERROR 42000: Variable 'flush' can't be set to the value of 'OON'
46 SET @@global.flush = ONN;
47 ERROR 42000: Variable 'flush' can't be set to the value of 'ONN'
48 SET @@global.flush = OOFF;
49 ERROR 42000: Variable 'flush' can't be set to the value of 'OOFF'
50 SET @@global.flush = 0FF;
51 ERROR 42000: Variable 'flush' can't be set to the value of '0FF'
52 SET @@global.flush = ' ';
53 ERROR 42000: Variable 'flush' can't be set to the value of ' '
54 SET @@global.flush = " ";
55 ERROR 42000: Variable 'flush' can't be set to the value of ' '
56 SET @@global.flush = '';
57 ERROR 42000: Variable 'flush' can't be set to the value of ''
58 '#-------------------FN_DYNVARS_030_05----------------------------#'
59 SET @@session.flush = 1;
60 ERROR HY000: Variable 'flush' is a GLOBAL variable and should be set with SET GLOBAL
61 SELECT @@session.flush;
62 ERROR HY000: Variable 'flush' is a GLOBAL variable
63 '#----------------------FN_DYNVARS_030_06------------------------#'
64 SELECT IF(@@global.flush, "ON", "OFF") = VARIABLE_VALUE
65 FROM performance_schema.global_variables
66 WHERE VARIABLE_NAME='flush';
67 IF(@@global.flush, "ON", "OFF") = VARIABLE_VALUE
68 1
69 '#---------------------FN_DYNVARS_030_07----------------------#'
70 SET @@global.flush = TRUE;
71 SELECT @@global.flush;
72 @@global.flush
73 1
74 SET @@global.flush = FALSE;
75 SELECT @@global.flush;
76 @@global.flush
77 0
78 '#---------------------FN_DYNVARS_030_08----------------------#'
79 SET @@global.flush = 1;
80 SELECT @@flush = @@global.flush;
81 @@flush = @@global.flush
82 1
83 '#---------------------FN_DYNVARS_030_09----------------------#'
84 SET flush = 1;
85 ERROR HY000: Variable 'flush' is a GLOBAL variable and should be set with SET GLOBAL
86 SET global.flush = 1;
87 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 'global.flush = 1' at line 1
88 SELECT global.flush;
89 ERROR 42S02: Unknown table 'global' in field list
90 SELECT flush;
91 ERROR 42S22: Unknown column 'flush' in 'field list'
92 SELECT @@session.flush;
93 ERROR HY000: Variable 'flush' is a GLOBAL variable
94 SET @@global.flush = @start_value;
95 SELECT @@global.flush;
96 @@global.flush
97 0