Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.max_seeks_for_key;
2 SELECT @start_global_value;
3 @start_global_value
4 4294967295
5 SET @start_session_value = @@session.max_seeks_for_key;
6 SELECT @start_session_value;
7 @start_session_value
8 4294967295
9 '#--------------------FN_DYNVARS_083_01-------------------------#'
10 SET @@global.max_seeks_for_key = 100;
11 SET @@global.max_seeks_for_key = DEFAULT;
12 SELECT @@global.max_seeks_for_key;
13 @@global.max_seeks_for_key
14 4294967295
15 SET @@session.max_seeks_for_key = 200;
16 SET @@session.max_seeks_for_key = DEFAULT;
17 SELECT @@session.max_seeks_for_key;
18 @@session.max_seeks_for_key
19 4294967295
20 '#--------------------FN_DYNVARS_083_02-------------------------#'
21 SET @@global.max_seeks_for_key = DEFAULT;
22 SELECT @@global.max_seeks_for_key = 4294967295;
23 @@global.max_seeks_for_key = 4294967295
24 1
25 SET @@session.max_seeks_for_key = DEFAULT;
26 SELECT @@session.max_seeks_for_key = 4294967295;
27 @@session.max_seeks_for_key = 4294967295
28 1
29 '#--------------------FN_DYNVARS_083_03-------------------------#'
30 SET @@global.max_seeks_for_key = 1;
31 SELECT @@global.max_seeks_for_key;
32 @@global.max_seeks_for_key
33 1
34 SET @@global.max_seeks_for_key = 2;
35 SELECT @@global.max_seeks_for_key;
36 @@global.max_seeks_for_key
37 2
38 SET @@global.max_seeks_for_key = 65536;
39 SELECT @@global.max_seeks_for_key;
40 @@global.max_seeks_for_key
41 65536
42 SET @@global.max_seeks_for_key = 4294967295;
43 SELECT @@global.max_seeks_for_key;
44 @@global.max_seeks_for_key
45 4294967295
46 SET @@global.max_seeks_for_key = 4294967294;
47 SELECT @@global.max_seeks_for_key;
48 @@global.max_seeks_for_key
49 4294967294
50 '#--------------------FN_DYNVARS_083_04-------------------------#'
51 SET @@session.max_seeks_for_key = 1;
52 SELECT @@session.max_seeks_for_key;
53 @@session.max_seeks_for_key
54 1
55 SET @@session.max_seeks_for_key = 2;
56 SELECT @@session.max_seeks_for_key;
57 @@session.max_seeks_for_key
58 2
59 SET @@session.max_seeks_for_key = 4294967295;
60 SELECT @@session.max_seeks_for_key;
61 @@session.max_seeks_for_key
62 4294967295
63 SET @@session.max_seeks_for_key = 4294967294;
64 SELECT @@session.max_seeks_for_key;
65 @@session.max_seeks_for_key
66 4294967294
67 SET @@session.max_seeks_for_key = 65535;
68 SELECT @@session.max_seeks_for_key;
69 @@session.max_seeks_for_key
70 65535
71 '#------------------FN_DYNVARS_083_05-----------------------#'
72 SET @@global.max_seeks_for_key = 0;
73 Warnings:
74 Warning 1292 Truncated incorrect max_seeks_for_key value: '0'
75 SELECT @@global.max_seeks_for_key;
76 @@global.max_seeks_for_key
77 1
78 SET @@global.max_seeks_for_key = -1024;
79 Warnings:
80 Warning 1292 Truncated incorrect max_seeks_for_key value: '-1024'
81 SELECT @@global.max_seeks_for_key;
82 @@global.max_seeks_for_key
83 1
84 SET @@global.max_seeks_for_key = 65530.34;
85 ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
86 SELECT @@global.max_seeks_for_key;
87 @@global.max_seeks_for_key
88 1
89 SET @@global.max_seeks_for_key = test;
90 ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
91 SELECT @@global.max_seeks_for_key;
92 @@global.max_seeks_for_key
93 1
94 SET @@global.max_seeks_for_key = 4294967296;
95 Warnings:
96 Warning 1292 Truncated incorrect max_seeks_for_key value: '4294967296'
97 SELECT @@global.max_seeks_for_key;
98 @@global.max_seeks_for_key
99 4294967295
100 SET @@global.max_seeks_for_key = 42949672950;
101 Warnings:
102 Warning 1292 Truncated incorrect max_seeks_for_key value: '42949672950'
103 SELECT @@global.max_seeks_for_key;
104 @@global.max_seeks_for_key
105 4294967295
106 SET @@session.max_seeks_for_key = 0;
107 Warnings:
108 Warning 1292 Truncated incorrect max_seeks_for_key value: '0'
109 SELECT @@session.max_seeks_for_key;
110 @@session.max_seeks_for_key
111 1
112 SET @@session.max_seeks_for_key = -2;
113 Warnings:
114 Warning 1292 Truncated incorrect max_seeks_for_key value: '-2'
115 SELECT @@session.max_seeks_for_key;
116 @@session.max_seeks_for_key
117 1
118 SET @@session.max_seeks_for_key = 65530.34;
119 ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
120 SET @@session.max_seeks_for_key = test;
121 ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
122 SELECT @@session.max_seeks_for_key;
123 @@session.max_seeks_for_key
124 1
125 SET @@session.max_seeks_for_key = 4294967296;
126 Warnings:
127 Warning 1292 Truncated incorrect max_seeks_for_key value: '4294967296'
128 SELECT @@session.max_seeks_for_key;
129 @@session.max_seeks_for_key
130 4294967295
131 SET @@session.max_seeks_for_key = 42949672950;
132 Warnings:
133 Warning 1292 Truncated incorrect max_seeks_for_key value: '42949672950'
134 SELECT @@session.max_seeks_for_key;
135 @@session.max_seeks_for_key
136 4294967295
137 '#------------------FN_DYNVARS_083_06-----------------------#'
138 SELECT @@global.max_seeks_for_key = VARIABLE_VALUE
139 FROM performance_schema.global_variables
140 WHERE VARIABLE_NAME='max_seeks_for_key';
141 @@global.max_seeks_for_key = VARIABLE_VALUE
142 1
143 '#------------------FN_DYNVARS_083_07-----------------------#'
144 SELECT @@session.max_seeks_for_key = VARIABLE_VALUE
145 FROM performance_schema.session_variables
146 WHERE VARIABLE_NAME='max_seeks_for_key';
147 @@session.max_seeks_for_key = VARIABLE_VALUE
148 1
149 '#------------------FN_DYNVARS_083_08-----------------------#'
150 SET @@global.max_seeks_for_key = TRUE;
151 SELECT @@global.max_seeks_for_key;
152 @@global.max_seeks_for_key
153 1
154 SET @@global.max_seeks_for_key = FALSE;
155 Warnings:
156 Warning 1292 Truncated incorrect max_seeks_for_key value: '0'
157 SELECT @@global.max_seeks_for_key;
158 @@global.max_seeks_for_key
159 1
160 '#---------------------FN_DYNVARS_083_09----------------------#'
161 SET @@global.max_seeks_for_key = 10;
162 SELECT @@max_seeks_for_key = @@global.max_seeks_for_key;
163 @@max_seeks_for_key = @@global.max_seeks_for_key
164 0
165 '#---------------------FN_DYNVARS_083_10----------------------#'
166 SET @@max_seeks_for_key = 100;
167 SELECT @@max_seeks_for_key = @@local.max_seeks_for_key;
168 @@max_seeks_for_key = @@local.max_seeks_for_key
169 1
170 SELECT @@local.max_seeks_for_key = @@session.max_seeks_for_key;
171 @@local.max_seeks_for_key = @@session.max_seeks_for_key
172 1
173 '#---------------------FN_DYNVARS_083_11----------------------#'
174 SET max_seeks_for_key = 1;
175 SELECT @@max_seeks_for_key;
176 @@max_seeks_for_key
177 1
178 SELECT local.max_seeks_for_key;
179 ERROR 42S02: Unknown table 'local' in field list
180 SELECT session.max_seeks_for_key;
181 ERROR 42S02: Unknown table 'session' in field list
182 SELECT max_seeks_for_key = @@session.max_seeks_for_key;
183 ERROR 42S22: Unknown column 'max_seeks_for_key' in 'field list'
184 SET @@global.max_seeks_for_key = @start_global_value;
185 SELECT @@global.max_seeks_for_key;
186 @@global.max_seeks_for_key
187 4294967295
188 SET @@session.max_seeks_for_key = @start_session_value;
189 SELECT @@session.max_seeks_for_key;
190 @@session.max_seeks_for_key
191 4294967295