1SET @start_global_value = @@global.max_seeks_for_key;
2SELECT @start_global_value;
3@start_global_value
44294967295
5SET @start_session_value = @@session.max_seeks_for_key;
6SELECT @start_session_value;
7@start_session_value
84294967295
9'#--------------------FN_DYNVARS_083_01-------------------------#'
10SET @@global.max_seeks_for_key = 100;
11SET @@global.max_seeks_for_key = DEFAULT;
12SELECT @@global.max_seeks_for_key;
13@@global.max_seeks_for_key
144294967295
15SET @@session.max_seeks_for_key = 200;
16SET @@session.max_seeks_for_key = DEFAULT;
17SELECT @@session.max_seeks_for_key;
18@@session.max_seeks_for_key
194294967295
20'#--------------------FN_DYNVARS_083_02-------------------------#'
21SET @@global.max_seeks_for_key = DEFAULT;
22SELECT @@global.max_seeks_for_key = 4294967295;
23@@global.max_seeks_for_key = 4294967295
241
25SET @@session.max_seeks_for_key = DEFAULT;
26SELECT @@session.max_seeks_for_key = 4294967295;
27@@session.max_seeks_for_key = 4294967295
281
29'#--------------------FN_DYNVARS_083_03-------------------------#'
30SET @@global.max_seeks_for_key = 1;
31SELECT @@global.max_seeks_for_key;
32@@global.max_seeks_for_key
331
34SET @@global.max_seeks_for_key = 2;
35SELECT @@global.max_seeks_for_key;
36@@global.max_seeks_for_key
372
38SET @@global.max_seeks_for_key = 65536;
39SELECT @@global.max_seeks_for_key;
40@@global.max_seeks_for_key
4165536
42SET @@global.max_seeks_for_key = 4294967295;
43SELECT @@global.max_seeks_for_key;
44@@global.max_seeks_for_key
454294967295
46SET @@global.max_seeks_for_key = 4294967294;
47SELECT @@global.max_seeks_for_key;
48@@global.max_seeks_for_key
494294967294
50'#--------------------FN_DYNVARS_083_04-------------------------#'
51SET @@session.max_seeks_for_key = 1;
52SELECT @@session.max_seeks_for_key;
53@@session.max_seeks_for_key
541
55SET @@session.max_seeks_for_key = 2;
56SELECT @@session.max_seeks_for_key;
57@@session.max_seeks_for_key
582
59SET @@session.max_seeks_for_key = 4294967295;
60SELECT @@session.max_seeks_for_key;
61@@session.max_seeks_for_key
624294967295
63SET @@session.max_seeks_for_key = 4294967294;
64SELECT @@session.max_seeks_for_key;
65@@session.max_seeks_for_key
664294967294
67SET @@session.max_seeks_for_key = 65535;
68SELECT @@session.max_seeks_for_key;
69@@session.max_seeks_for_key
7065535
71'#------------------FN_DYNVARS_083_05-----------------------#'
72SET @@global.max_seeks_for_key = 0;
73Warnings:
74Warning	1292	Truncated incorrect max_seeks_for_key value: '0'
75SELECT @@global.max_seeks_for_key;
76@@global.max_seeks_for_key
771
78SET @@global.max_seeks_for_key = -1024;
79Warnings:
80Warning	1292	Truncated incorrect max_seeks_for_key value: '-1024'
81SELECT @@global.max_seeks_for_key;
82@@global.max_seeks_for_key
831
84SET @@global.max_seeks_for_key = 4294967296;
85Warnings:
86Warning	1292	Truncated incorrect max_seeks_for_key value: '4294967296'
87SELECT @@global.max_seeks_for_key;
88@@global.max_seeks_for_key
894294967295
90SET @@global.max_seeks_for_key = 65530.34;
91ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
92SELECT @@global.max_seeks_for_key;
93@@global.max_seeks_for_key
944294967295
95SET @@global.max_seeks_for_key = test;
96ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
97SELECT @@global.max_seeks_for_key;
98@@global.max_seeks_for_key
994294967295
100SET @@session.max_seeks_for_key = 0;
101Warnings:
102Warning	1292	Truncated incorrect max_seeks_for_key value: '0'
103SELECT @@session.max_seeks_for_key;
104@@session.max_seeks_for_key
1051
106SET @@session.max_seeks_for_key = -2;
107Warnings:
108Warning	1292	Truncated incorrect max_seeks_for_key value: '-2'
109SELECT @@session.max_seeks_for_key;
110@@session.max_seeks_for_key
1111
112SET @@session.max_seeks_for_key = 65530.34;
113ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
114SET @@session.max_seeks_for_key = 4294967296;
115Warnings:
116Warning	1292	Truncated incorrect max_seeks_for_key value: '4294967296'
117SELECT @@session.max_seeks_for_key;
118@@session.max_seeks_for_key
1194294967295
120SET @@session.max_seeks_for_key = test;
121ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
122SELECT @@session.max_seeks_for_key;
123@@session.max_seeks_for_key
1244294967295
125'#------------------FN_DYNVARS_083_06-----------------------#'
126SELECT @@global.max_seeks_for_key = VARIABLE_VALUE
127FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
128WHERE VARIABLE_NAME='max_seeks_for_key';
129@@global.max_seeks_for_key = VARIABLE_VALUE
1301
131'#------------------FN_DYNVARS_083_07-----------------------#'
132SELECT @@session.max_seeks_for_key = VARIABLE_VALUE
133FROM INFORMATION_SCHEMA.SESSION_VARIABLES
134WHERE VARIABLE_NAME='max_seeks_for_key';
135@@session.max_seeks_for_key = VARIABLE_VALUE
1361
137'#------------------FN_DYNVARS_083_08-----------------------#'
138SET @@global.max_seeks_for_key = TRUE;
139SELECT @@global.max_seeks_for_key;
140@@global.max_seeks_for_key
1411
142SET @@global.max_seeks_for_key = FALSE;
143Warnings:
144Warning	1292	Truncated incorrect max_seeks_for_key value: '0'
145SELECT @@global.max_seeks_for_key;
146@@global.max_seeks_for_key
1471
148'#---------------------FN_DYNVARS_083_09----------------------#'
149SET @@global.max_seeks_for_key = 10;
150SELECT @@max_seeks_for_key = @@global.max_seeks_for_key;
151@@max_seeks_for_key = @@global.max_seeks_for_key
1520
153'#---------------------FN_DYNVARS_083_10----------------------#'
154SET @@max_seeks_for_key = 100;
155SELECT @@max_seeks_for_key = @@local.max_seeks_for_key;
156@@max_seeks_for_key = @@local.max_seeks_for_key
1571
158SELECT @@local.max_seeks_for_key = @@session.max_seeks_for_key;
159@@local.max_seeks_for_key = @@session.max_seeks_for_key
1601
161'#---------------------FN_DYNVARS_083_11----------------------#'
162SET max_seeks_for_key = 1;
163SELECT @@max_seeks_for_key;
164@@max_seeks_for_key
1651
166SELECT local.max_seeks_for_key;
167ERROR 42S02: Unknown table 'local' in field list
168SELECT session.max_seeks_for_key;
169ERROR 42S02: Unknown table 'session' in field list
170SELECT max_seeks_for_key = @@session.max_seeks_for_key;
171ERROR 42S22: Unknown column 'max_seeks_for_key' in 'field list'
172SET @@global.max_seeks_for_key = @start_global_value;
173SELECT @@global.max_seeks_for_key;
174@@global.max_seeks_for_key
1754294967295
176SET @@session.max_seeks_for_key = @start_session_value;
177SELECT @@session.max_seeks_for_key;
178@@session.max_seeks_for_key
1794294967295
180