Debian Codegraph @

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

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