1
SET @start_global_value = @@global.max_delayed_threads;
2
SELECT @start_global_value;
5
SET @start_session_value = @@session.max_delayed_threads;
6
SELECT @start_session_value;
9
'#--------------------FN_DYNVARS_075_01-------------------------#'
10
SET @@global.max_delayed_threads = 1000;
11
SET @@global.max_delayed_threads = DEFAULT;
12
SELECT @@global.max_delayed_threads;
13
@@global.max_delayed_threads
15
SET @@session.max_delayed_threads = 1000;
16
ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1000'
17
'Bug# 34882: Valid values are not allowed to assign in this variable';
18
SET @@session.max_delayed_threads = DEFAULT;
19
SELECT @@session.max_delayed_threads;
20
@@session.max_delayed_threads
22
'#--------------------FN_DYNVARS_075_02-------------------------#'
23
SET @@global.max_delayed_threads = DEFAULT;
24
SELECT @@global.max_delayed_threads = 20;
25
@@global.max_delayed_threads = 20
27
SET @@session.max_delayed_threads = DEFAULT;
28
SELECT @@session.max_delayed_threads = 20;
29
@@session.max_delayed_threads = 20
31
'#--------------------FN_DYNVARS_075_03-------------------------#'
32
SET @@global.max_delayed_threads = 1;
33
SELECT @@global.max_delayed_threads;
34
@@global.max_delayed_threads
36
SET @@global.max_delayed_threads = 1025;
37
SELECT @@global.max_delayed_threads;
38
@@global.max_delayed_threads
40
'Bug# 34877: Invalid Values are coming in variable on assigning valid values';
41
SET @@global.max_delayed_threads = 0;
42
SELECT @@global.max_delayed_threads;
43
@@global.max_delayed_threads
45
SET @@global.max_delayed_threads = 16384;
46
SELECT @@global.max_delayed_threads;
47
@@global.max_delayed_threads
49
SET @@global.max_delayed_threads = 16383;
50
SELECT @@global.max_delayed_threads;
51
@@global.max_delayed_threads
53
'#--------------------FN_DYNVARS_075_04-------------------------#'
54
SET @@session.max_delayed_threads = 1;
55
ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1'
56
SELECT @@session.max_delayed_threads;
57
@@session.max_delayed_threads
59
SET @@session.max_delayed_threads = 1025;
60
ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1025'
61
SELECT @@session.max_delayed_threads;
62
@@session.max_delayed_threads
64
SET @@session.max_delayed_threads = 0;
65
SELECT @@session.max_delayed_threads;
66
@@session.max_delayed_threads
68
SET @@session.max_delayed_threads = 16384;
69
ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '16384'
70
SELECT @@session.max_delayed_threads;
71
@@session.max_delayed_threads
73
SET @@session.max_delayed_threads = 16383;
74
SELECT @@session.max_delayed_threads;
75
@@session.max_delayed_threads
77
'#------------------FN_DYNVARS_075_05-----------------------#'
78
SET @@global.max_delayed_threads = -1024;
79
SELECT @@global.max_delayed_threads;
80
@@global.max_delayed_threads
82
SET @@global.max_delayed_threads = -1;
83
SELECT @@global.max_delayed_threads;
84
@@global.max_delayed_threads
86
SET @@global.max_delayed_threads = 16385;
88
Warning 1292 Truncated incorrect max_delayed_threads value: '16385'
89
SELECT @@global.max_delayed_threads;
90
@@global.max_delayed_threads
92
SET @@global.max_delayed_threads = 65530.34.;
93
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
94
SELECT @@global.max_delayed_threads;
95
@@global.max_delayed_threads
97
SET @@global.max_delayed_threads = test;
98
ERROR 42000: Incorrect argument type to variable 'max_delayed_threads'
99
SELECT @@global.max_delayed_threads;
100
@@global.max_delayed_threads
102
SET @@session.max_delayed_threads = 16385;
103
ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '16385'
104
SELECT @@session.max_delayed_threads;
105
@@session.max_delayed_threads
107
SET @@session.max_delayed_threads = -1;
108
ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '-1'
109
SELECT @@session.max_delayed_threads;
110
@@session.max_delayed_threads
112
SET @@session.max_delayed_threads = -2;
113
ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '-2'
114
SELECT @@session.max_delayed_threads;
115
@@session.max_delayed_threads
117
SET @@session.max_delayed_threads = 65530.34.;
118
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
119
SET @@session.max_delayed_threads = 10737418241;
120
ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '10737418241'
121
SELECT @@session.max_delayed_threads;
122
@@session.max_delayed_threads
124
SET @@session.max_delayed_threads = test;
125
ERROR 42000: Incorrect argument type to variable 'max_delayed_threads'
126
SELECT @@session.max_delayed_threads;
127
@@session.max_delayed_threads
129
'#------------------FN_DYNVARS_075_06-----------------------#'
130
SELECT @@global.max_delayed_threads = VARIABLE_VALUE
131
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
132
WHERE VARIABLE_NAME='max_delayed_threads';
133
@@global.max_delayed_threads = VARIABLE_VALUE
135
'#------------------FN_DYNVARS_075_07-----------------------#'
136
SELECT @@session.max_delayed_threads = VARIABLE_VALUE
137
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
138
WHERE VARIABLE_NAME='max_delayed_threads';
139
@@session.max_delayed_threads = VARIABLE_VALUE
141
'#------------------FN_DYNVARS_075_08-----------------------#'
142
SET @@global.max_delayed_threads = TRUE;
143
SELECT @@global.max_delayed_threads;
144
@@global.max_delayed_threads
146
SET @@global.max_delayed_threads = FALSE;
147
SELECT @@global.max_delayed_threads;
148
@@global.max_delayed_threads
150
'#---------------------FN_DYNVARS_001_09----------------------#'
151
SET @@global.max_delayed_threads = 2048;
152
SELECT @@max_delayed_threads = @@global.max_delayed_threads;
153
@@max_delayed_threads = @@global.max_delayed_threads
155
'#---------------------FN_DYNVARS_001_10----------------------#'
156
SET @@max_delayed_threads = 100000;
157
ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '100000'
158
SELECT @@max_delayed_threads = @@local.max_delayed_threads;
159
@@max_delayed_threads = @@local.max_delayed_threads
161
SELECT @@local.max_delayed_threads = @@session.max_delayed_threads;
162
@@local.max_delayed_threads = @@session.max_delayed_threads
164
'#---------------------FN_DYNVARS_001_11----------------------#'
165
SET max_delayed_threads = 1024;
166
ERROR 42000: Variable 'max_delayed_threads' can't be set to the value of '1024'
167
SELECT @@max_delayed_threads;
168
@@max_delayed_threads
170
SELECT local.max_delayed_threads;
171
ERROR 42S02: Unknown table 'local' in field list
172
SELECT session.max_delayed_threads;
173
ERROR 42S02: Unknown table 'session' in field list
174
SELECT max_delayed_threads = @@session.max_delayed_threads;
175
ERROR 42S22: Unknown column 'max_delayed_threads' in 'field list'
176
SET @@global.max_delayed_threads = @start_global_value;
177
SELECT @@global.max_delayed_threads;
178
@@global.max_delayed_threads
180
SET @@session.max_delayed_threads = @start_session_value;
181
SELECT @@session.max_delayed_threads;
182
@@session.max_delayed_threads