Debian Codegraph @

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

raw
1 SET @start_value = @@global.key_cache_age_threshold;
2 SELECT @start_value;
3 @start_value
4 300
5 '#--------------------FN_DYNVARS_056_01------------------------#'
6 SET @@global.key_cache_age_threshold = DEFAULT;
7 SELECT @@global.key_cache_age_threshold;
8 @@global.key_cache_age_threshold
9 300
10 '#---------------------FN_DYNVARS_056_02-------------------------#'
11 SET @@global.key_cache_age_threshold = @start_value;
12 SELECT @@global.key_cache_age_threshold = 300;
13 @@global.key_cache_age_threshold = 300
14 1
15 '#--------------------FN_DYNVARS_056_03------------------------#'
16 SET @@global.key_cache_age_threshold = 100;
17 SELECT @@global.key_cache_age_threshold;
18 @@global.key_cache_age_threshold
19 100
20 SET @@global.key_cache_age_threshold = 4294967295;
21 Warnings:
22 Warning 1292 Truncated incorrect key_cache_age_threshold value: '4294967295'
23 SELECT @@global.key_cache_age_threshold;
24 @@global.key_cache_age_threshold
25 4294967200
26 SET @@global.key_cache_age_threshold = 1800;
27 SELECT @@global.key_cache_age_threshold;
28 @@global.key_cache_age_threshold
29 1800
30 SET @@global.key_cache_age_threshold = 65535;
31 Warnings:
32 Warning 1292 Truncated incorrect key_cache_age_threshold value: '65535'
33 SELECT @@global.key_cache_age_threshold;
34 @@global.key_cache_age_threshold
35 65500
36 SET @@global.key_cache_age_threshold = 18446744073709551615;
37 Warnings:
38 Warning 1292 Truncated incorrect key_cache_age_threshold value: '18446744073709551615'
39 SELECT @@global.key_cache_age_threshold;
40 @@global.key_cache_age_threshold
41 18446744073709551600
42 '#--------------------FN_DYNVARS_056_04-------------------------#'
43 SET @@global.key_cache_age_threshold = -1;
44 Warnings:
45 Warning 1292 Truncated incorrect key_cache_age_threshold value: '-1'
46 SELECT @@global.key_cache_age_threshold;
47 @@global.key_cache_age_threshold
48 100
49 SET @@global.key_cache_age_threshold = 10000.01;
50 ERROR 42000: Incorrect argument type to variable 'key_cache_age_threshold'
51 SELECT @@global.key_cache_age_threshold;
52 @@global.key_cache_age_threshold
53 100
54 SET @@global.key_cache_age_threshold = -1024;
55 Warnings:
56 Warning 1292 Truncated incorrect key_cache_age_threshold value: '-1024'
57 SELECT @@global.key_cache_age_threshold;
58 @@global.key_cache_age_threshold
59 100
60 SET @@global.key_cache_age_threshold = 99;
61 Warnings:
62 Warning 1292 Truncated incorrect key_cache_age_threshold value: '99'
63 SELECT @@global.key_cache_age_threshold;
64 @@global.key_cache_age_threshold
65 100
66 SET @@global.key_cache_age_threshold = ON;
67 ERROR 42000: Incorrect argument type to variable 'key_cache_age_threshold'
68 SELECT @@global.key_cache_age_threshold;
69 @@global.key_cache_age_threshold
70 100
71 SET @@global.key_cache_age_threshold = 'test';
72 ERROR 42000: Incorrect argument type to variable 'key_cache_age_threshold'
73 SELECT @@global.key_cache_age_threshold;
74 @@global.key_cache_age_threshold
75 100
76 SET @@global.key_cache_age_threshold = 18446744073709551616;
77 ERROR 42000: Incorrect argument type to variable 'key_cache_age_threshold'
78 SELECT @@global.key_cache_age_threshold;
79 @@global.key_cache_age_threshold
80 100
81 '#-------------------FN_DYNVARS_056_05----------------------------#'
82 SET @@session.key_cache_age_threshold = 0;
83 ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable and should be set with SET GLOBAL
84 SELECT @@session.key_cache_age_threshold;
85 ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable
86 '#----------------------FN_DYNVARS_056_06------------------------#'
87 SELECT @@global.key_cache_age_threshold = VARIABLE_VALUE
88 FROM performance_schema.global_variables
89 WHERE VARIABLE_NAME='key_cache_age_threshold';
90 @@global.key_cache_age_threshold = VARIABLE_VALUE
91 1
92 SELECT @@key_cache_age_threshold = VARIABLE_VALUE
93 FROM performance_schema.session_variables
94 WHERE VARIABLE_NAME='key_cache_age_threshold';
95 @@key_cache_age_threshold = VARIABLE_VALUE
96 1
97 '#---------------------FN_DYNVARS_056_07----------------------#'
98 SET @@global.key_cache_age_threshold = TRUE;
99 Warnings:
100 Warning 1292 Truncated incorrect key_cache_age_threshold value: '1'
101 SELECT @@global.key_cache_age_threshold;
102 @@global.key_cache_age_threshold
103 100
104 SET @@global.key_cache_age_threshold = FALSE;
105 Warnings:
106 Warning 1292 Truncated incorrect key_cache_age_threshold value: '0'
107 SELECT @@global.key_cache_age_threshold;
108 @@global.key_cache_age_threshold
109 100
110 '#---------------------FN_DYNVARS_056_08----------------------#'
111 SET @@global.key_cache_age_threshold = 101;
112 Warnings:
113 Warning 1292 Truncated incorrect key_cache_age_threshold value: '101'
114 SELECT @@key_cache_age_threshold = @@global.key_cache_age_threshold;
115 @@key_cache_age_threshold = @@global.key_cache_age_threshold
116 1
117 '#---------------------FN_DYNVARS_056_09----------------------#'
118 SET key_cache_age_threshold = 8000;
119 ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable and should be set with SET GLOBAL
120 SELECT @@key_cache_age_threshold;
121 @@key_cache_age_threshold
122 100
123 SET local.key_cache_age_threshold = 10;
124 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 'local.key_cache_age_threshold = 10' at line 1
125 SELECT local.key_cache_age_threshold;
126 ERROR 42S02: Unknown table 'local' in field list
127 SET global.key_cache_age_threshold = 10;
128 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.key_cache_age_threshold = 10' at line 1
129 SELECT global.key_cache_age_threshold;
130 ERROR 42S02: Unknown table 'global' in field list
131 SELECT key_cache_age_threshold;
132 ERROR 42S22: Unknown column 'key_cache_age_threshold' in 'field list'
133 SELECT @@session.key_cache_age_threshold;
134 ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable
135 SET @@global.key_cache_age_threshold = @start_value;
136 SELECT @@global.key_cache_age_threshold;
137 @@global.key_cache_age_threshold
138 300