Debian Codegraph @

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

raw
1 SET @start_value = @@global.key_cache_block_size;
2 SELECT @start_value;
3 @start_value
4 1024
5 '#--------------------FN_DYNVARS_057_01------------------------#'
6 SET @@global.key_cache_block_size = DEFAULT;
7 SELECT @@global.key_cache_block_size;
8 @@global.key_cache_block_size
9 1024
10 '#---------------------FN_DYNVARS_057_02-------------------------#'
11 SET @@global.key_cache_block_size = @start_value;
12 SELECT @@global.key_cache_block_size = 1024;
13 @@global.key_cache_block_size = 1024
14 1
15 '#--------------------FN_DYNVARS_057_03------------------------#'
16 SET @@global.key_cache_block_size = 512;
17 SELECT @@global.key_cache_block_size;
18 @@global.key_cache_block_size
19 512
20 SET @@global.key_cache_block_size = 1024;
21 SELECT @@global.key_cache_block_size;
22 @@global.key_cache_block_size
23 1024
24 SET @@global.key_cache_block_size = 16384;
25 SELECT @@global.key_cache_block_size;
26 @@global.key_cache_block_size
27 16384
28 SET @@global.key_cache_block_size = 1800;
29 Warnings:
30 Warning 1292 Truncated incorrect key_cache_block_size value: '1800'
31 SELECT @@global.key_cache_block_size;
32 @@global.key_cache_block_size
33 1536
34 SET @@global.key_cache_block_size = 16383;
35 Warnings:
36 Warning 1292 Truncated incorrect key_cache_block_size value: '16383'
37 SELECT @@global.key_cache_block_size;
38 @@global.key_cache_block_size
39 15872
40 '#--------------------FN_DYNVARS_057_04-------------------------#'
41 SET @@global.key_cache_block_size = -1;
42 Warnings:
43 Warning 1292 Truncated incorrect key_cache_block_size value: '-1'
44 SELECT @@global.key_cache_block_size;
45 @@global.key_cache_block_size
46 512
47 SET @@global.key_cache_block_size = 42949672951;
48 Warnings:
49 Warning 1292 Truncated incorrect key_cache_block_size value: '42949672951'
50 SELECT @@global.key_cache_block_size;
51 @@global.key_cache_block_size
52 16384
53 SET @@global.key_cache_block_size = 10000.01;
54 ERROR 42000: Incorrect argument type to variable 'key_cache_block_size'
55 SELECT @@global.key_cache_block_size;
56 @@global.key_cache_block_size
57 16384
58 SET @@global.key_cache_block_size = -1024;
59 Warnings:
60 Warning 1292 Truncated incorrect key_cache_block_size value: '-1024'
61 SELECT @@global.key_cache_block_size;
62 @@global.key_cache_block_size
63 512
64 SET @@global.key_cache_block_size = 256;
65 Warnings:
66 Warning 1292 Truncated incorrect key_cache_block_size value: '256'
67 SELECT @@global.key_cache_block_size;
68 @@global.key_cache_block_size
69 512
70 SET @@global.key_cache_block_size = 511;
71 Warnings:
72 Warning 1292 Truncated incorrect key_cache_block_size value: '511'
73 SELECT @@global.key_cache_block_size;
74 @@global.key_cache_block_size
75 512
76 SET @@global.key_cache_block_size = 16385;
77 Warnings:
78 Warning 1292 Truncated incorrect key_cache_block_size value: '16385'
79 SELECT @@global.key_cache_block_size;
80 @@global.key_cache_block_size
81 16384
82 SET @@global.key_cache_block_size = " ";
83 ERROR 42000: Incorrect argument type to variable 'key_cache_block_size'
84 SELECT @@global.key_cache_block_size;
85 @@global.key_cache_block_size
86 16384
87 SET @@global.key_cache_block_size = ON;
88 ERROR 42000: Incorrect argument type to variable 'key_cache_block_size'
89 SELECT @@global.key_cache_block_size;
90 @@global.key_cache_block_size
91 16384
92 SET @@global.key_cache_block_size = 'test';
93 ERROR 42000: Incorrect argument type to variable 'key_cache_block_size'
94 SELECT @@global.key_cache_block_size;
95 @@global.key_cache_block_size
96 16384
97 '#-------------------FN_DYNVARS_057_05----------------------------#'
98 SET @@session.key_cache_block_size = 0;
99 ERROR HY000: Variable 'key_cache_block_size' is a GLOBAL variable and should be set with SET GLOBAL
100 SELECT @@session.key_cache_block_size;
101 ERROR HY000: Variable 'key_cache_block_size' is a GLOBAL variable
102 '#----------------------FN_DYNVARS_057_06------------------------#'
103 SELECT @@global.key_cache_block_size = VARIABLE_VALUE
104 FROM performance_schema.global_variables
105 WHERE VARIABLE_NAME='key_cache_block_size';
106 @@global.key_cache_block_size = VARIABLE_VALUE
107 1
108 SELECT @@key_cache_block_size = VARIABLE_VALUE
109 FROM performance_schema.session_variables
110 WHERE VARIABLE_NAME='key_cache_block_size';
111 @@key_cache_block_size = VARIABLE_VALUE
112 1
113 '#---------------------FN_DYNVARS_057_07----------------------#'
114 SET @@global.key_cache_block_size = TRUE;
115 Warnings:
116 Warning 1292 Truncated incorrect key_cache_block_size value: '1'
117 SELECT @@global.key_cache_block_size;
118 @@global.key_cache_block_size
119 512
120 SET @@global.key_cache_block_size = FALSE;
121 Warnings:
122 Warning 1292 Truncated incorrect key_cache_block_size value: '0'
123 SELECT @@global.key_cache_block_size;
124 @@global.key_cache_block_size
125 512
126 '#---------------------FN_DYNVARS_057_08----------------------#'
127 SET @@global.key_cache_block_size = 1024;
128 SELECT @@key_cache_block_size = @@global.key_cache_block_size;
129 @@key_cache_block_size = @@global.key_cache_block_size
130 1
131 '#---------------------FN_DYNVARS_057_09----------------------#'
132 SET key_cache_block_size = 8000;
133 ERROR HY000: Variable 'key_cache_block_size' is a GLOBAL variable and should be set with SET GLOBAL
134 SELECT @@key_cache_block_size;
135 @@key_cache_block_size
136 1024
137 SET local.key_cache_block_size = 10;
138 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_block_size = 10' at line 1
139 SELECT local.key_cache_block_size;
140 ERROR 42S02: Unknown table 'local' in field list
141 SET global.key_cache_block_size = 10;
142 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_block_size = 10' at line 1
143 SELECT global.key_cache_block_size;
144 ERROR 42S02: Unknown table 'global' in field list
145 SELECT key_cache_block_size;
146 ERROR 42S22: Unknown column 'key_cache_block_size' in 'field list'
147 SELECT @@session.key_cache_block_size;
148 ERROR HY000: Variable 'key_cache_block_size' is a GLOBAL variable
149 SET @@global.key_cache_block_size = @start_value;
150 SELECT @@global.key_cache_block_size;
151 @@global.key_cache_block_size
152 1024