Debian Codegraph @

mysql-test/suite/sys_vars/r/key_cache_age_threshold_basic.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 = 42949672951;
44 Warnings:
45 Warning 1292 Truncated incorrect key_cache_age_threshold value: '42949672951'
46 SELECT @@global.key_cache_age_threshold;
47 @@global.key_cache_age_threshold
48 4294967200
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 4294967200
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 '#-------------------FN_DYNVARS_056_05----------------------------#'
77 SET @@session.key_cache_age_threshold = 0;
78 ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable and should be set with SET GLOBAL
79 SELECT @@session.key_cache_age_threshold;
80 ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable
81 '#----------------------FN_DYNVARS_056_06------------------------#'
82 SELECT @@global.key_cache_age_threshold = VARIABLE_VALUE
83 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
84 WHERE VARIABLE_NAME='key_cache_age_threshold';
85 @@global.key_cache_age_threshold = VARIABLE_VALUE
86 1
87 SELECT @@key_cache_age_threshold = VARIABLE_VALUE
88 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
89 WHERE VARIABLE_NAME='key_cache_age_threshold';
90 @@key_cache_age_threshold = VARIABLE_VALUE
91 1
92 '#---------------------FN_DYNVARS_056_07----------------------#'
93 SET @@global.key_cache_age_threshold = TRUE;
94 Warnings:
95 Warning 1292 Truncated incorrect key_cache_age_threshold value: '1'
96 SELECT @@global.key_cache_age_threshold;
97 @@global.key_cache_age_threshold
98 100
99 SET @@global.key_cache_age_threshold = FALSE;
100 Warnings:
101 Warning 1292 Truncated incorrect key_cache_age_threshold value: '0'
102 SELECT @@global.key_cache_age_threshold;
103 @@global.key_cache_age_threshold
104 100
105 '#---------------------FN_DYNVARS_056_08----------------------#'
106 SET @@global.key_cache_age_threshold = 101;
107 Warnings:
108 Warning 1292 Truncated incorrect key_cache_age_threshold value: '101'
109 SELECT @@key_cache_age_threshold = @@global.key_cache_age_threshold;
110 @@key_cache_age_threshold = @@global.key_cache_age_threshold
111 1
112 '#---------------------FN_DYNVARS_056_09----------------------#'
113 SET key_cache_age_threshold = 8000;
114 ERROR HY000: Variable 'key_cache_age_threshold' is a GLOBAL variable and should be set with SET GLOBAL
115 SELECT @@key_cache_age_threshold;
116 @@key_cache_age_threshold
117 100
118 SELECT local.key_cache_age_threshold;
119 ERROR 42S02: Unknown table 'local' in SELECT
120 SELECT global.key_cache_age_threshold;
121 ERROR 42S02: Unknown table 'global' in SELECT
122 SELECT key_cache_age_threshold = @@session.key_cache_age_threshold;
123 ERROR 42S22: Unknown column 'key_cache_age_threshold' in 'SELECT'
124 SET @@global.key_cache_age_threshold = @start_value;
125 SELECT @@global.key_cache_age_threshold;
126 @@global.key_cache_age_threshold
127 300