1
SET @start_global_value = @@global.max_seeks_for_key;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.max_seeks_for_key;
6
SELECT @start_session_value;
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
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
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
25
SET @@session.max_seeks_for_key = DEFAULT;
26
SELECT @@session.max_seeks_for_key = 4294967295;
27
@@session.max_seeks_for_key = 4294967295
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
34
SET @@global.max_seeks_for_key = 2;
35
SELECT @@global.max_seeks_for_key;
36
@@global.max_seeks_for_key
38
SET @@global.max_seeks_for_key = 65536;
39
SELECT @@global.max_seeks_for_key;
40
@@global.max_seeks_for_key
42
SET @@global.max_seeks_for_key = 4294967295;
43
SELECT @@global.max_seeks_for_key;
44
@@global.max_seeks_for_key
46
SET @@global.max_seeks_for_key = 4294967294;
47
SELECT @@global.max_seeks_for_key;
48
@@global.max_seeks_for_key
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
55
SET @@session.max_seeks_for_key = 2;
56
SELECT @@session.max_seeks_for_key;
57
@@session.max_seeks_for_key
59
SET @@session.max_seeks_for_key = 4294967295;
60
SELECT @@session.max_seeks_for_key;
61
@@session.max_seeks_for_key
63
SET @@session.max_seeks_for_key = 4294967294;
64
SELECT @@session.max_seeks_for_key;
65
@@session.max_seeks_for_key
67
SET @@session.max_seeks_for_key = 65535;
68
SELECT @@session.max_seeks_for_key;
69
@@session.max_seeks_for_key
71
'#------------------FN_DYNVARS_083_05-----------------------#'
72
SET @@global.max_seeks_for_key = 0;
74
Warning 1292 Truncated incorrect max_seeks_for_key value: '0'
75
SELECT @@global.max_seeks_for_key;
76
@@global.max_seeks_for_key
78
SET @@global.max_seeks_for_key = -1024;
80
Warning 1292 Truncated incorrect max_seeks_for_key value: '0'
81
SELECT @@global.max_seeks_for_key;
82
@@global.max_seeks_for_key
84
SET @@global.max_seeks_for_key = 4294967296;
85
SELECT @@global.max_seeks_for_key;
86
@@global.max_seeks_for_key
88
SET @@global.max_seeks_for_key = 65530.34.;
89
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 '.' at line 1
90
SELECT @@global.max_seeks_for_key;
91
@@global.max_seeks_for_key
93
SET @@global.max_seeks_for_key = test;
94
ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
95
SELECT @@global.max_seeks_for_key;
96
@@global.max_seeks_for_key
98
SET @@session.max_seeks_for_key = 0;
100
Warning 1292 Truncated incorrect max_seeks_for_key value: '0'
101
SELECT @@session.max_seeks_for_key;
102
@@session.max_seeks_for_key
104
SET @@session.max_seeks_for_key = -2;
106
Warning 1292 Truncated incorrect max_seeks_for_key value: '0'
107
SELECT @@session.max_seeks_for_key;
108
@@session.max_seeks_for_key
110
SET @@session.max_seeks_for_key = 65530.34.;
111
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 '.' at line 1
112
SET @@session.max_seeks_for_key = 4294967296;
113
SELECT @@session.max_seeks_for_key;
114
@@session.max_seeks_for_key
116
'Bug # 34837: Errors are not coming on assigning invalid values to variable';
117
SET @@session.max_seeks_for_key = test;
118
ERROR 42000: Incorrect argument type to variable 'max_seeks_for_key'
119
SELECT @@session.max_seeks_for_key;
120
@@session.max_seeks_for_key
122
'#------------------FN_DYNVARS_083_06-----------------------#'
123
SELECT @@global.max_seeks_for_key = VARIABLE_VALUE
124
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
125
WHERE VARIABLE_NAME='max_seeks_for_key';
126
@@global.max_seeks_for_key = VARIABLE_VALUE
128
'#------------------FN_DYNVARS_083_07-----------------------#'
129
SELECT @@session.max_seeks_for_key = VARIABLE_VALUE
130
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
131
WHERE VARIABLE_NAME='max_seeks_for_key';
132
@@session.max_seeks_for_key = VARIABLE_VALUE
134
'#------------------FN_DYNVARS_083_08-----------------------#'
135
SET @@global.max_seeks_for_key = TRUE;
136
SELECT @@global.max_seeks_for_key;
137
@@global.max_seeks_for_key
139
SET @@global.max_seeks_for_key = FALSE;
141
Warning 1292 Truncated incorrect max_seeks_for_key value: '0'
142
SELECT @@global.max_seeks_for_key;
143
@@global.max_seeks_for_key
145
'#---------------------FN_DYNVARS_083_09----------------------#'
146
SET @@global.max_seeks_for_key = 10;
147
SELECT @@max_seeks_for_key = @@global.max_seeks_for_key;
148
@@max_seeks_for_key = @@global.max_seeks_for_key
150
'#---------------------FN_DYNVARS_083_10----------------------#'
151
SET @@max_seeks_for_key = 100;
152
SELECT @@max_seeks_for_key = @@local.max_seeks_for_key;
153
@@max_seeks_for_key = @@local.max_seeks_for_key
155
SELECT @@local.max_seeks_for_key = @@session.max_seeks_for_key;
156
@@local.max_seeks_for_key = @@session.max_seeks_for_key
158
'#---------------------FN_DYNVARS_083_11----------------------#'
159
SET max_seeks_for_key = 1;
160
SELECT @@max_seeks_for_key;
163
SELECT local.max_seeks_for_key;
164
ERROR 42S02: Unknown table 'local' in field list
165
SELECT session.max_seeks_for_key;
166
ERROR 42S02: Unknown table 'session' in field list
167
SELECT max_seeks_for_key = @@session.max_seeks_for_key;
168
ERROR 42S22: Unknown column 'max_seeks_for_key' in 'field list'
169
SET @@global.max_seeks_for_key = @start_global_value;
170
SELECT @@global.max_seeks_for_key;
171
@@global.max_seeks_for_key
173
SET @@session.max_seeks_for_key = @start_session_value;
174
SELECT @@session.max_seeks_for_key;
175
@@session.max_seeks_for_key