← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/r/max_insert_delayed_threads_basic.result

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/max_insert_delayed_threads_basic.result
 
1
SET @start_global_value = @@global.max_insert_delayed_threads;
 
2
SELECT @start_global_value;
 
3
@start_global_value
 
4
20
 
5
SET @start_session_value = @@session.max_insert_delayed_threads;
 
6
SELECT @start_session_value;
 
7
@start_session_value
 
8
20
 
9
'#--------------------FN_DYNVARS_078_01-------------------------#'
 
10
SET @@global.max_insert_delayed_threads = 1000;
 
11
SET @@global.max_insert_delayed_threads = DEFAULT;
 
12
ERROR 42000: Variable 'max_insert_delayed_threads' doesn't have a default value
 
13
SELECT @@global.max_insert_delayed_threads;
 
14
@@global.max_insert_delayed_threads
 
15
1000
 
16
SET @@session.max_insert_delayed_threads = 1000;
 
17
SET @@session.max_insert_delayed_threads = DEFAULT;
 
18
SELECT @@session.max_insert_delayed_threads;
 
19
@@session.max_insert_delayed_threads
 
20
1000
 
21
'#--------------------FN_DYNVARS_078_02-------------------------#'
 
22
SET @@global.max_insert_delayed_threads = DEFAULT;
 
23
ERROR 42000: Variable 'max_insert_delayed_threads' doesn't have a default value
 
24
SELECT @@global.max_insert_delayed_threads = 20;
 
25
@@global.max_insert_delayed_threads = 20
 
26
0
 
27
SET @@session.max_insert_delayed_threads = DEFAULT;
 
28
SELECT @@session.max_insert_delayed_threads = 20;
 
29
@@session.max_insert_delayed_threads = 20
 
30
0
 
31
'Bug# 34876: This variable has invalid default value as compared to documentation';
 
32
'#--------------------FN_DYNVARS_078_03-------------------------#'
 
33
SET @@global.max_insert_delayed_threads = 1;
 
34
SELECT @@global.max_insert_delayed_threads;
 
35
@@global.max_insert_delayed_threads
 
36
1
 
37
SET @@global.max_insert_delayed_threads = 1025;
 
38
SELECT @@global.max_insert_delayed_threads;
 
39
@@global.max_insert_delayed_threads
 
40
1025
 
41
'Bug# 34877: Invalid Values are coming in variable on assigning valid values';
 
42
SET @@global.max_insert_delayed_threads = 0;
 
43
SELECT @@global.max_insert_delayed_threads;
 
44
@@global.max_insert_delayed_threads
 
45
0
 
46
SET @@global.max_insert_delayed_threads = 16384;
 
47
SELECT @@global.max_insert_delayed_threads;
 
48
@@global.max_insert_delayed_threads
 
49
16384
 
50
SET @@global.max_insert_delayed_threads = 16383;
 
51
SELECT @@global.max_insert_delayed_threads;
 
52
@@global.max_insert_delayed_threads
 
53
16383
 
54
'#--------------------FN_DYNVARS_078_04-------------------------#'
 
55
SET @@session.max_insert_delayed_threads = 1;
 
56
ERROR 42000: Variable 'max_insert_delayed_threads' can't be set to the value of '1'
 
57
SELECT @@session.max_insert_delayed_threads;
 
58
@@session.max_insert_delayed_threads
 
59
1000
 
60
SET @@session.max_insert_delayed_threads = 1025;
 
61
ERROR 42000: Variable 'max_insert_delayed_threads' can't be set to the value of '1025'
 
62
SELECT @@session.max_insert_delayed_threads;
 
63
@@session.max_insert_delayed_threads
 
64
1000
 
65
SET @@session.max_insert_delayed_threads = 0;
 
66
SELECT @@session.max_insert_delayed_threads;
 
67
@@session.max_insert_delayed_threads
 
68
0
 
69
SET @@session.max_insert_delayed_threads = 16384;
 
70
ERROR 42000: Variable 'max_insert_delayed_threads' can't be set to the value of '16384'
 
71
SELECT @@session.max_insert_delayed_threads;
 
72
@@session.max_insert_delayed_threads
 
73
0
 
74
SET @@session.max_insert_delayed_threads = 16383;
 
75
SELECT @@session.max_insert_delayed_threads;
 
76
@@session.max_insert_delayed_threads
 
77
16383
 
78
'#------------------FN_DYNVARS_078_05-----------------------#'
 
79
SET @@global.max_insert_delayed_threads = -1024;
 
80
SELECT @@global.max_insert_delayed_threads;
 
81
@@global.max_insert_delayed_threads
 
82
0
 
83
SET @@global.max_insert_delayed_threads = -1;
 
84
SELECT @@global.max_insert_delayed_threads;
 
85
@@global.max_insert_delayed_threads
 
86
0
 
87
SET @@global.max_insert_delayed_threads = 16385;
 
88
Warnings:
 
89
Warning 1292    Truncated incorrect max_insert_delayed_threads value: '16385'
 
90
SELECT @@global.max_insert_delayed_threads;
 
91
@@global.max_insert_delayed_threads
 
92
16384
 
93
SET @@global.max_insert_delayed_threads = 65530.34.;
 
94
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
 
95
SELECT @@global.max_insert_delayed_threads;
 
96
@@global.max_insert_delayed_threads
 
97
16384
 
98
SET @@global.max_insert_delayed_threads = test;
 
99
ERROR 42000: Incorrect argument type to variable 'max_insert_delayed_threads'
 
100
SELECT @@global.max_insert_delayed_threads;
 
101
@@global.max_insert_delayed_threads
 
102
16384
 
103
SET @@session.max_insert_delayed_threads = 16385;
 
104
ERROR 42000: Variable 'max_insert_delayed_threads' can't be set to the value of '16385'
 
105
SELECT @@session.max_insert_delayed_threads;
 
106
@@session.max_insert_delayed_threads
 
107
16383
 
108
SET @@session.max_insert_delayed_threads = -1;
 
109
ERROR 42000: Variable 'max_insert_delayed_threads' can't be set to the value of '-1'
 
110
SELECT @@session.max_insert_delayed_threads;
 
111
@@session.max_insert_delayed_threads
 
112
16383
 
113
SET @@session.max_insert_delayed_threads = -2;
 
114
ERROR 42000: Variable 'max_insert_delayed_threads' can't be set to the value of '-2'
 
115
SELECT @@session.max_insert_delayed_threads;
 
116
@@session.max_insert_delayed_threads
 
117
16383
 
118
SET @@session.max_insert_delayed_threads = 65530.34.;
 
119
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
 
120
SET @@session.max_insert_delayed_threads = 10737418241;
 
121
ERROR 42000: Variable 'max_insert_delayed_threads' can't be set to the value of '10737418241'
 
122
SELECT @@session.max_insert_delayed_threads;
 
123
@@session.max_insert_delayed_threads
 
124
16383
 
125
SET @@session.max_insert_delayed_threads = test;
 
126
ERROR 42000: Incorrect argument type to variable 'max_insert_delayed_threads'
 
127
SELECT @@session.max_insert_delayed_threads;
 
128
@@session.max_insert_delayed_threads
 
129
16383
 
130
'#------------------FN_DYNVARS_078_06-----------------------#'
 
131
SELECT @@global.max_insert_delayed_threads = VARIABLE_VALUE 
 
132
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
 
133
WHERE VARIABLE_NAME='max_insert_delayed_threads';
 
134
@@global.max_insert_delayed_threads = VARIABLE_VALUE
 
135
1
 
136
'#------------------FN_DYNVARS_078_07-----------------------#'
 
137
SELECT @@session.max_insert_delayed_threads = VARIABLE_VALUE 
 
138
FROM INFORMATION_SCHEMA.SESSION_VARIABLES 
 
139
WHERE VARIABLE_NAME='max_insert_delayed_threads';
 
140
@@session.max_insert_delayed_threads = VARIABLE_VALUE
 
141
1
 
142
'#------------------FN_DYNVARS_078_08-----------------------#'
 
143
SET @@global.max_insert_delayed_threads = TRUE;
 
144
SELECT @@global.max_insert_delayed_threads;
 
145
@@global.max_insert_delayed_threads
 
146
1
 
147
SET @@global.max_insert_delayed_threads = FALSE;
 
148
SELECT @@global.max_insert_delayed_threads;
 
149
@@global.max_insert_delayed_threads
 
150
0
 
151
'#---------------------FN_DYNVARS_078_09----------------------#'
 
152
SET @@global.max_insert_delayed_threads = 2048;
 
153
SELECT @@max_insert_delayed_threads = @@global.max_insert_delayed_threads;
 
154
@@max_insert_delayed_threads = @@global.max_insert_delayed_threads
 
155
0
 
156
'#---------------------FN_DYNVARS_078_10----------------------#'
 
157
SET @@max_insert_delayed_threads = 100000;
 
158
ERROR 42000: Variable 'max_insert_delayed_threads' can't be set to the value of '100000'
 
159
SELECT @@max_insert_delayed_threads = @@local.max_insert_delayed_threads;
 
160
@@max_insert_delayed_threads = @@local.max_insert_delayed_threads
 
161
1
 
162
SELECT @@local.max_insert_delayed_threads = @@session.max_insert_delayed_threads;
 
163
@@local.max_insert_delayed_threads = @@session.max_insert_delayed_threads
 
164
1
 
165
'#---------------------FN_DYNVARS_078_11----------------------#'
 
166
SET max_insert_delayed_threads = 1024;
 
167
ERROR 42000: Variable 'max_insert_delayed_threads' can't be set to the value of '1024'
 
168
SELECT @@max_insert_delayed_threads;
 
169
@@max_insert_delayed_threads
 
170
16383
 
171
SELECT local.max_insert_delayed_threads;
 
172
ERROR 42S02: Unknown table 'local' in field list
 
173
SELECT session.max_insert_delayed_threads;
 
174
ERROR 42S02: Unknown table 'session' in field list
 
175
SELECT max_insert_delayed_threads = @@session.max_insert_delayed_threads;
 
176
ERROR 42S22: Unknown column 'max_insert_delayed_threads' in 'field list'
 
177
SET @@global.max_insert_delayed_threads = @start_global_value;
 
178
SELECT @@global.max_insert_delayed_threads;
 
179
@@global.max_insert_delayed_threads
 
180
20
 
181
SET @@session.max_insert_delayed_threads = @start_session_value;
 
182
SELECT @@session.max_insert_delayed_threads;
 
183
@@session.max_insert_delayed_threads
 
184
20