1SET @global_start_value = @@global.query_cache_type;
2SELECT @global_start_value;
3@global_start_value
4OFF
5SET @session_start_value = @@session.query_cache_type;
6SELECT @session_start_value;
7@session_start_value
8OFF
9'#--------------------FN_DYNVARS_134_01------------------------#'
10SET @@global.query_cache_type = 0;
11SET @@global.query_cache_type = DEFAULT;
12SELECT @@global.query_cache_type;
13@@global.query_cache_type
14OFF
15SET @@session.query_cache_type = 0;
16SET @@session.query_cache_type = DEFAULT;
17SELECT @@session.query_cache_type;
18@@session.query_cache_type
19OFF
20'#---------------------FN_DYNVARS_134_02-------------------------#'
21SET @@global.query_cache_type = NULL;
22ERROR 42000: Variable 'query_cache_type' can't be set to the value of 'NULL'
23SET @@global.query_cache_type = '';
24ERROR 42000: Variable 'query_cache_type' can't be set to the value of ''
25SET @@session.query_cache_type = NULL;
26ERROR 42000: Variable 'query_cache_type' can't be set to the value of 'NULL'
27SET @@session.query_cache_type = '';
28ERROR 42000: Variable 'query_cache_type' can't be set to the value of ''
29'#--------------------FN_DYNVARS_134_03------------------------#'
30SET @@global.query_cache_type = OFF;
31SELECT @@global.query_cache_type;
32@@global.query_cache_type
33OFF
34SET @@global.query_cache_type = ON;
35SELECT @@global.query_cache_type;
36@@global.query_cache_type
37ON
38SET @@global.query_cache_type = DEMAND;
39SELECT @@global.query_cache_type;
40@@global.query_cache_type
41DEMAND
42SET @@session.query_cache_type = OFF;
43SELECT @@session.query_cache_type;
44@@session.query_cache_type
45OFF
46SET @@session.query_cache_type = ON;
47SELECT @@session.query_cache_type;
48@@session.query_cache_type
49ON
50SET @@session.query_cache_type = DEMAND;
51SELECT @@session.query_cache_type;
52@@session.query_cache_type
53DEMAND
54'#--------------------FN_DYNVARS_134_04-------------------------#'
55SET @@global.query_cache_type = -1;
56ERROR 42000: Variable 'query_cache_type' can't be set to the value of '-1'
57SET @@global.query_cache_type = ONDEMAND;
58ERROR 42000: Variable 'query_cache_type' can't be set to the value of 'ONDEMAND'
59SET @@global.query_cache_type = 'ON,OFF';
60ERROR 42000: Variable 'query_cache_type' can't be set to the value of 'ON,OFF'
61SET @@global.query_cache_type = 'OF';
62ERROR 42000: Variable 'query_cache_type' can't be set to the value of 'OF'
63SET @@global.query_cache_type = YES;
64ERROR 42000: Variable 'query_cache_type' can't be set to the value of 'YES'
65SET @@global.query_cache_type = ' ';
66ERROR 42000: Variable 'query_cache_type' can't be set to the value of ' '
67'#-------------------FN_DYNVARS_134_05----------------------------#'
68SELECT @@session.query_cache_type = VARIABLE_VALUE
69FROM INFORMATION_SCHEMA.SESSION_VARIABLES
70WHERE VARIABLE_NAME='query_cache_type';
71@@session.query_cache_type = VARIABLE_VALUE
721
73'#----------------------FN_DYNVARS_134_06------------------------#'
74SELECT @@global.query_cache_type = VARIABLE_VALUE
75FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
76WHERE VARIABLE_NAME='query_cache_type';
77@@global.query_cache_type = VARIABLE_VALUE
781
79'#---------------------FN_DYNVARS_134_07-------------------------#'
80SET @@global.query_cache_type = 0;
81SELECT @@global.query_cache_type;
82@@global.query_cache_type
83OFF
84SET @@global.query_cache_type = 1;
85SELECT @@global.query_cache_type;
86@@global.query_cache_type
87ON
88SET @@global.query_cache_type = 2;
89SELECT @@global.query_cache_type;
90@@global.query_cache_type
91DEMAND
92SET @@global.query_cache_type = 0.4;
93ERROR 42000: Incorrect argument type to variable 'query_cache_type'
94SET @@global.query_cache_type = 3;
95ERROR 42000: Variable 'query_cache_type' can't be set to the value of '3'
96'#---------------------FN_DYNVARS_134_08----------------------#'
97SET @@global.query_cache_type = TRUE;
98SELECT @@global.query_cache_type;
99@@global.query_cache_type
100ON
101SET @@global.query_cache_type = FALSE;
102SELECT @@global.query_cache_type;
103@@global.query_cache_type
104OFF
105'#---------------------FN_DYNVARS_134_09----------------------#'
106SET global query_cache_type = 'ON';
107SET session query_cache_type = 1;
108SELECT @@query_cache_type;
109@@query_cache_type
110ON
111SET global query_cache_type = 0;
112SELECT @@global.query_cache_type;
113@@global.query_cache_type
114OFF
115SET @@global.query_cache_type = @global_start_value;
116SELECT @@global.query_cache_type;
117@@global.query_cache_type
118OFF
119SET @@session.query_cache_type = @session_start_value;
120SELECT @@session.query_cache_type;
121@@session.query_cache_type
122OFF
123