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