Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.max_seeks_for_key;
2 SELECT @start_global_value;
3 @start_global_value
4 18446744073709551615
5 SET @start_session_value = @@session.max_seeks_for_key;
6 SELECT @start_session_value;
7 @start_session_value
8 18446744073709551615
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 18446744073709551615
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 18446744073709551615
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 0
25 SET @@session.max_seeks_for_key = DEFAULT;
26 SELECT @@session.max_seeks_for_key = 4294967295;
27 @@session.max_seeks_for_key = 4294967295
28 0
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 SET @@global.max_seeks_for_key = 18446744073709551615;
51 SELECT @@global.max_seeks_for_key;
52 @@global.max_seeks_for_key
53 18446744073709551615
54 '#--------------------FN_DYNVARS_083_04-------------------------#'
55 SET @@session.max_seeks_for_key = 1;
56 SELECT @@session.max_seeks_for_key;
57 @@session.max_seeks_for_key
58 1
59 SET @@session.max_seeks_for_key = 2;
60 SELECT @@session.max_seeks_for_key;
61 @@session.max_seeks_for_key
62 2
63 SET @@session.max_seeks_for_key = 4294967295;
64 SELECT @@session.max_seeks_for_key;
65 @@session.max_seeks_for_key
66 4294967295
67 SET @@session.max_seeks_for_key = 4294967294;
68 SELECT @@session.max_seeks_for_key;
69 @@session.max_seeks_for_key
70 4294967294
71 SET @@session.max_seeks_for_key = 65535;
72 SELECT @@session.max_seeks_for_key;
73 @@session.max_seeks_for_key
74 65535
75 SET @@session.max_seeks_for_key = 18446744073709551615;
76 SELECT @@session.max_seeks_for_key;
77 @@session.max_seeks_for_key
78 18446744073709551615
79 '#------------------FN_DYNVARS_083_05-----------------------#'
80 SET @@global.max_seeks_for_key = 0;
81 Warnings:
82 Warning 1292 Truncated incorrect max_seeks_for_key value: '0'
83 SELECT @@global.max_seeks_for_key;
84 @@global.max_seeks_for_key
85 1
86 SET @@global.max_seeks_for_key = -1024;
87 Warnings:
88 Warning 1292 Truncated incorrect max_seeks_for_key value: '-1024'
89 SELECT @@global.max_seeks_for_key;
90 @@global.max_seeks_for_key
91 1
92 SET @@global.max_seeks_for_key = 65530.34;
93 ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
94 SELECT @@global.max_seeks_for_key;
95 @@global.max_seeks_for_key
96 1
97 SET @@global.max_seeks_for_key = test;
98 ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
99 SELECT @@global.max_seeks_for_key;
100 @@global.max_seeks_for_key
101 1
102 SET @@global.max_seeks_for_key = 18446744073709551616;
103 ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
104 SELECT @@global.max_seeks_for_key;
105 @@global.max_seeks_for_key
106 1
107 SET @@session.max_seeks_for_key = 0;
108 Warnings:
109 Warning 1292 Truncated incorrect max_seeks_for_key value: '0'
110 SELECT @@session.max_seeks_for_key;
111 @@session.max_seeks_for_key
112 1
113 SET @@session.max_seeks_for_key = -2;
114 Warnings:
115 Warning 1292 Truncated incorrect max_seeks_for_key value: '-2'
116 SELECT @@session.max_seeks_for_key;
117 @@session.max_seeks_for_key
118 1
119 SET @@session.max_seeks_for_key = 65530.34;
120 ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
121 SET @@session.max_seeks_for_key = test;
122 ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
123 SELECT @@session.max_seeks_for_key;
124 @@session.max_seeks_for_key
125 1
126 SET @@session.max_seeks_for_key = 18446744073709551616;
127 ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
128 SELECT @@session.max_seeks_for_key;
129 @@session.max_seeks_for_key
130 1
131 '#------------------FN_DYNVARS_083_06-----------------------#'
132 SELECT @@global.max_seeks_for_key = VARIABLE_VALUE
133 FROM performance_schema.global_variables
134 WHERE VARIABLE_NAME='max_seeks_for_key';
135 @@global.max_seeks_for_key = VARIABLE_VALUE
136 1
137 '#------------------FN_DYNVARS_083_07-----------------------#'
138 SELECT @@session.max_seeks_for_key = VARIABLE_VALUE
139 FROM performance_schema.session_variables
140 WHERE VARIABLE_NAME='max_seeks_for_key';
141 @@session.max_seeks_for_key = VARIABLE_VALUE
142 1
143 '#------------------FN_DYNVARS_083_08-----------------------#'
144 SET @@global.max_seeks_for_key = TRUE;
145 SELECT @@global.max_seeks_for_key;
146 @@global.max_seeks_for_key
147 1
148 SET @@global.max_seeks_for_key = FALSE;
149 Warnings:
150 Warning 1292 Truncated incorrect max_seeks_for_key value: '0'
151 SELECT @@global.max_seeks_for_key;
152 @@global.max_seeks_for_key
153 1
154 '#---------------------FN_DYNVARS_083_09----------------------#'
155 SET @@global.max_seeks_for_key = 10;
156 SELECT @@max_seeks_for_key = @@global.max_seeks_for_key;
157 @@max_seeks_for_key = @@global.max_seeks_for_key
158 0
159 '#---------------------FN_DYNVARS_083_10----------------------#'
160 SET @@max_seeks_for_key = 100;
161 SELECT @@max_seeks_for_key = @@local.max_seeks_for_key;
162 @@max_seeks_for_key = @@local.max_seeks_for_key
163 1
164 SELECT @@local.max_seeks_for_key = @@session.max_seeks_for_key;
165 @@local.max_seeks_for_key = @@session.max_seeks_for_key
166 1
167 '#---------------------FN_DYNVARS_083_11----------------------#'
168 SET max_seeks_for_key = 1;
169 SELECT @@max_seeks_for_key;
170 @@max_seeks_for_key
171 1
172 SELECT local.max_seeks_for_key;
173 ERROR 42S02: Unknown table 'local' in field list
174 SELECT session.max_seeks_for_key;
175 ERROR 42S02: Unknown table 'session' in field list
176 SELECT max_seeks_for_key = @@session.max_seeks_for_key;
177 ERROR 42S22: Unknown column 'max_seeks_for_key' in 'field list'
178 SET @@global.max_seeks_for_key = @start_global_value;
179 SELECT @@global.max_seeks_for_key;
180 @@global.max_seeks_for_key
181 18446744073709551615
182 SET @@session.max_seeks_for_key = @start_session_value;
183 SELECT @@session.max_seeks_for_key;
184 @@session.max_seeks_for_key
185 18446744073709551615