← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.5/precise-201203300109

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2011-11-08 11:31:13 UTC
  • Revision ID: package-import@ubuntu.com-20111108113113-3ulw01fvi4vn8m25
Tags: upstream-5.5.17
Import upstream version 5.5.17

Show diffs side-by-side

added added

removed removed

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