Debian Codegraph @

mysql-test/suite/sys_vars/r/max_seeks_for_key_basic.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 = 4294967296;
85 Warnings:
86 Warning 1292 Truncated incorrect max_seeks_for_key value: '4294967296'
87 SELECT @@global.max_seeks_for_key;
88 @@global.max_seeks_for_key
89 4294967295
90 SET @@global.max_seeks_for_key = 65530.34;
91 ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
92 SELECT @@global.max_seeks_for_key;
93 @@global.max_seeks_for_key
94 4294967295
95 SET @@global.max_seeks_for_key = test;
96 ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
97 SELECT @@global.max_seeks_for_key;
98 @@global.max_seeks_for_key
99 4294967295
100 SET @@session.max_seeks_for_key = 0;
101 Warnings:
102 Warning 1292 Truncated incorrect max_seeks_for_key value: '0'
103 SELECT @@session.max_seeks_for_key;
104 @@session.max_seeks_for_key
105 1
106 SET @@session.max_seeks_for_key = -2;
107 Warnings:
108 Warning 1292 Truncated incorrect max_seeks_for_key value: '-2'
109 SELECT @@session.max_seeks_for_key;
110 @@session.max_seeks_for_key
111 1
112 SET @@session.max_seeks_for_key = 65530.34;
113 ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
114 SET @@session.max_seeks_for_key = 4294967296;
115 Warnings:
116 Warning 1292 Truncated incorrect max_seeks_for_key value: '4294967296'
117 SELECT @@session.max_seeks_for_key;
118 @@session.max_seeks_for_key
119 4294967295
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 4294967295
125 '#------------------FN_DYNVARS_083_06-----------------------#'
126 SELECT @@global.max_seeks_for_key = VARIABLE_VALUE
127 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
128 WHERE VARIABLE_NAME='max_seeks_for_key';
129 @@global.max_seeks_for_key = VARIABLE_VALUE
130 1
131 '#------------------FN_DYNVARS_083_07-----------------------#'
132 SELECT @@session.max_seeks_for_key = VARIABLE_VALUE
133 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
134 WHERE VARIABLE_NAME='max_seeks_for_key';
135 @@session.max_seeks_for_key = VARIABLE_VALUE
136 1
137 '#------------------FN_DYNVARS_083_08-----------------------#'
138 SET @@global.max_seeks_for_key = TRUE;
139 SELECT @@global.max_seeks_for_key;
140 @@global.max_seeks_for_key
141 1
142 SET @@global.max_seeks_for_key = FALSE;
143 Warnings:
144 Warning 1292 Truncated incorrect max_seeks_for_key value: '0'
145 SELECT @@global.max_seeks_for_key;
146 @@global.max_seeks_for_key
147 1
148 '#---------------------FN_DYNVARS_083_09----------------------#'
149 SET @@global.max_seeks_for_key = 10;
150 SELECT @@max_seeks_for_key = @@global.max_seeks_for_key;
151 @@max_seeks_for_key = @@global.max_seeks_for_key
152 0
153 '#---------------------FN_DYNVARS_083_10----------------------#'
154 SET @@max_seeks_for_key = 100;
155 SELECT @@max_seeks_for_key = @@local.max_seeks_for_key;
156 @@max_seeks_for_key = @@local.max_seeks_for_key
157 1
158 SELECT @@local.max_seeks_for_key = @@session.max_seeks_for_key;
159 @@local.max_seeks_for_key = @@session.max_seeks_for_key
160 1
161 '#---------------------FN_DYNVARS_083_11----------------------#'
162 SET max_seeks_for_key = 1;
163 SELECT @@max_seeks_for_key;
164 @@max_seeks_for_key
165 1
166 SELECT local.max_seeks_for_key;
167 ERROR 42S02: Unknown table 'local' in SELECT
168 SELECT session.max_seeks_for_key;
169 ERROR 42S02: Unknown table 'session' in SELECT
170 SELECT max_seeks_for_key = @@session.max_seeks_for_key;
171 ERROR 42S22: Unknown column 'max_seeks_for_key' in 'SELECT'
172 SET @@global.max_seeks_for_key = @start_global_value;
173 SELECT @@global.max_seeks_for_key;
174 @@global.max_seeks_for_key
175 4294967295
176 SET @@session.max_seeks_for_key = @start_session_value;
177 SELECT @@session.max_seeks_for_key;
178 @@session.max_seeks_for_key
179 4294967295