Debian Codegraph @

mysql-test/suite/sys_vars/r/key_cache_age_threshold_basic_32.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 '#--------------------FN_DYNVARS_056_04-------------------------#'
37 SET @@global.key_cache_age_threshold = -1;
38 Warnings:
39 Warning 1292 Truncated incorrect key_cache_age_threshold value: '-1'
40 SELECT @@global.key_cache_age_threshold;
41 @@global.key_cache_age_threshold
42 100
43 SET @@global.key_cache_age_threshold = 10000.01;
44 ERROR 42000: Incorrect argument type to variable 'key_cache_age_threshold'
45 SELECT @@global.key_cache_age_threshold;
46 @@global.key_cache_age_threshold
47 100
48 SET @@global.key_cache_age_threshold = -1024;
49 Warnings:
50 Warning 1292 Truncated incorrect key_cache_age_threshold value: '-1024'
51 SELECT @@global.key_cache_age_threshold;
52 @@global.key_cache_age_threshold
53 100
54 SET @@global.key_cache_age_threshold = 99;
55 Warnings:
56 Warning 1292 Truncated incorrect key_cache_age_threshold value: '99'
57 SELECT @@global.key_cache_age_threshold;
58 @@global.key_cache_age_threshold
59 100
60 SET @@global.key_cache_age_threshold = ON;
61 ERROR 42000: Incorrect argument type to variable 'key_cache_age_threshold'
62 SELECT @@global.key_cache_age_threshold;
63 @@global.key_cache_age_threshold
64 100
65 SET @@global.key_cache_age_threshold = 'test';
66 ERROR 42000: Incorrect argument type to variable 'key_cache_age_threshold'
67 SELECT @@global.key_cache_age_threshold;
68 @@global.key_cache_age_threshold
69 100
70 SET @@global.key_cache_age_threshold = 4294967296;
71 Warnings:
72 Warning 1292 Truncated incorrect key_cache_age_threshold value: '4294967296'
73 SELECT @@global.key_cache_age_threshold;
74 @@global.key_cache_age_threshold
75 4294967200
76 SET @@global.key_cache_age_threshold = 42949672950;
77 Warnings:
78 Warning 1292 Truncated incorrect key_cache_age_threshold value: '42949672950'
79 SELECT @@global.key_cache_age_threshold;
80 @@global.key_cache_age_threshold
81 4294967200
82 '#-------------------FN_DYNVARS_056_05----------------------------#'
83 SET @@session.key_cache_age_threshold = 0;
84 ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable and should be set with SET GLOBAL
85 SELECT @@session.key_cache_age_threshold;
86 ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable
87 '#----------------------FN_DYNVARS_056_06------------------------#'
88 SELECT @@global.key_cache_age_threshold = VARIABLE_VALUE
89 FROM performance_schema.global_variables
90 WHERE VARIABLE_NAME='key_cache_age_threshold';
91 @@global.key_cache_age_threshold = VARIABLE_VALUE
92 1
93 SELECT @@key_cache_age_threshold = VARIABLE_VALUE
94 FROM performance_schema.session_variables
95 WHERE VARIABLE_NAME='key_cache_age_threshold';
96 @@key_cache_age_threshold = VARIABLE_VALUE
97 1
98 '#---------------------FN_DYNVARS_056_07----------------------#'
99 SET @@global.key_cache_age_threshold = TRUE;
100 Warnings:
101 Warning 1292 Truncated incorrect key_cache_age_threshold value: '1'
102 SELECT @@global.key_cache_age_threshold;
103 @@global.key_cache_age_threshold
104 100
105 SET @@global.key_cache_age_threshold = FALSE;
106 Warnings:
107 Warning 1292 Truncated incorrect key_cache_age_threshold value: '0'
108 SELECT @@global.key_cache_age_threshold;
109 @@global.key_cache_age_threshold
110 100
111 '#---------------------FN_DYNVARS_056_08----------------------#'
112 SET @@global.key_cache_age_threshold = 101;
113 Warnings:
114 Warning 1292 Truncated incorrect key_cache_age_threshold value: '101'
115 SELECT @@key_cache_age_threshold = @@global.key_cache_age_threshold;
116 @@key_cache_age_threshold = @@global.key_cache_age_threshold
117 1
118 '#---------------------FN_DYNVARS_056_09----------------------#'
119 SET key_cache_age_threshold = 8000;
120 ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable and should be set with SET GLOBAL
121 SELECT @@key_cache_age_threshold;
122 @@key_cache_age_threshold
123 100
124 SET local.key_cache_age_threshold = 10;
125 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
126 SELECT local.key_cache_age_threshold;
127 ERROR 42S02: Unknown table 'local' in field list
128 SET global.key_cache_age_threshold = 10;
129 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
130 SELECT global.key_cache_age_threshold;
131 ERROR 42S02: Unknown table 'global' in field list
132 SELECT key_cache_age_threshold;
133 ERROR 42S22: Unknown column 'key_cache_age_threshold' in 'field list'
134 SELECT @@session.key_cache_age_threshold;
135 ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable
136 SET @@global.key_cache_age_threshold = @start_value;
137 SELECT @@global.key_cache_age_threshold;
138 @@global.key_cache_age_threshold
139 300