1
SET @start_value = @@global.key_cache_age_threshold;
5
'#--------------------FN_DYNVARS_056_01------------------------#'
6
SET @@global.key_cache_age_threshold = 99;
8
Warning 1292 Truncated incorrect key_cache_age_threshold value: '99'
9
SET @@global.key_cache_age_threshold = DEFAULT;
10
ERROR 42000: Variable 'key_cache_age_threshold' doesn't have a default value
11
'Bug# 34878: This variable has default value according to documentation';
12
SELECT @@global.key_cache_age_threshold;
13
@@global.key_cache_age_threshold
15
'#---------------------FN_DYNVARS_056_02-------------------------#'
16
SET @@global.key_cache_age_threshold = @start_value;
17
SELECT @@global.key_cache_age_threshold = 300;
18
@@global.key_cache_age_threshold = 300
20
'#--------------------FN_DYNVARS_056_03------------------------#'
21
SET @@global.key_cache_age_threshold = 100;
22
SELECT @@global.key_cache_age_threshold;
23
@@global.key_cache_age_threshold
25
SET @@global.key_cache_age_threshold = 4294967295;
26
SELECT @@global.key_cache_age_threshold;
27
@@global.key_cache_age_threshold
29
SET @@global.key_cache_age_threshold = 1800;
30
SELECT @@global.key_cache_age_threshold;
31
@@global.key_cache_age_threshold
33
SET @@global.key_cache_age_threshold = 65535;
34
SELECT @@global.key_cache_age_threshold;
35
@@global.key_cache_age_threshold
37
'Bug# 34877 : Invalid Values are coming in variable on assigning valid values and Out Of Memory Warnings are coming';
38
'#--------------------FN_DYNVARS_056_04-------------------------#'
39
SET @@global.key_cache_age_threshold = -1;
40
SELECT @@global.key_cache_age_threshold;
41
@@global.key_cache_age_threshold
43
SET @@global.key_cache_age_threshold = 42949672951;
44
SELECT @@global.key_cache_age_threshold;
45
@@global.key_cache_age_threshold
47
SET @@global.key_cache_age_threshold = 10000.01;
48
ERROR 42000: Incorrect argument type to variable 'key_cache_age_threshold'
49
SELECT @@global.key_cache_age_threshold;
50
@@global.key_cache_age_threshold
52
SET @@global.key_cache_age_threshold = -1024;
53
SELECT @@global.key_cache_age_threshold;
54
@@global.key_cache_age_threshold
56
SET @@global.key_cache_age_threshold = 99;
58
Warning 1292 Truncated incorrect key_cache_age_threshold value: '99'
59
SELECT @@global.key_cache_age_threshold;
60
@@global.key_cache_age_threshold
62
'Bug # 34837: Errors are not coming on assigning invalid values to variable'
63
SET @@global.key_cache_age_threshold = ON;
64
ERROR 42000: Incorrect argument type to variable 'key_cache_age_threshold'
65
SELECT @@global.key_cache_age_threshold;
66
@@global.key_cache_age_threshold
68
SET @@global.key_cache_age_threshold = 'test';
69
ERROR 42000: Incorrect argument type to variable 'key_cache_age_threshold'
70
SELECT @@global.key_cache_age_threshold;
71
@@global.key_cache_age_threshold
73
'#-------------------FN_DYNVARS_056_05----------------------------#'
74
SET @@session.key_cache_age_threshold = 0;
75
ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable and should be set with SET GLOBAL
76
SELECT @@session.key_cache_age_threshold;
77
ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable
78
'#----------------------FN_DYNVARS_056_06------------------------#'
79
SELECT @@global.key_cache_age_threshold = VARIABLE_VALUE
80
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
81
WHERE VARIABLE_NAME='key_cache_age_threshold';
82
@@global.key_cache_age_threshold = VARIABLE_VALUE
84
SELECT @@key_cache_age_threshold = VARIABLE_VALUE
85
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
86
WHERE VARIABLE_NAME='key_cache_age_threshold';
87
@@key_cache_age_threshold = VARIABLE_VALUE
89
'#---------------------FN_DYNVARS_056_07----------------------#'
90
SET @@global.key_cache_age_threshold = TRUE;
92
Warning 1292 Truncated incorrect key_cache_age_threshold value: '1'
93
SELECT @@global.key_cache_age_threshold;
94
@@global.key_cache_age_threshold
96
SET @@global.key_cache_age_threshold = FALSE;
98
Warning 1292 Truncated incorrect key_cache_age_threshold value: '0'
99
SELECT @@global.key_cache_age_threshold;
100
@@global.key_cache_age_threshold
102
'#---------------------FN_DYNVARS_056_08----------------------#'
103
SET @@global.key_cache_age_threshold = 101;
104
SELECT @@key_cache_age_threshold = @@global.key_cache_age_threshold;
105
@@key_cache_age_threshold = @@global.key_cache_age_threshold
107
'#---------------------FN_DYNVARS_056_09----------------------#'
108
SET key_cache_age_threshold = 8000;
109
ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable and should be set with SET GLOBAL
110
SELECT @@key_cache_age_threshold;
111
@@key_cache_age_threshold
113
SET local.key_cache_age_threshold = 10;
114
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 'key_cache_age_threshold = 10' at line 1
115
SELECT local.key_cache_age_threshold;
116
ERROR 42S02: Unknown table 'local' in field list
117
SET global.key_cache_age_threshold = 10;
118
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 'key_cache_age_threshold = 10' at line 1
119
SELECT global.key_cache_age_threshold;
120
ERROR 42S02: Unknown table 'global' in field list
121
SELECT key_cache_age_threshold = @@session.key_cache_age_threshold;
122
ERROR 42S22: Unknown column 'key_cache_age_threshold' in 'field list'
123
SET @@global.key_cache_age_threshold = @start_value;
124
SELECT @@global.key_cache_age_threshold;
125
@@global.key_cache_age_threshold