← Back to branch summary

~ubuntu-branches/ubuntu/wily/mysql-5.6/wily

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2015-04-16 20:07:10 UTC
  • mto: (1.3.9 vivid-proposed)
  • mto: This revision was merged to the branch mainline in revision 11.
  • Revision ID: package-import@ubuntu.com-20150416200710-pcrsa022082zj46k
Tags: upstream-5.6.24
Import upstream version 5.6.24

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/sys_vars/r/transaction_alloc_block_size_basic_64.result
1
 
SET @start_global_value = @@global.transaction_alloc_block_size;
2
 
SELECT @start_global_value;
3
 
@start_global_value
4
 
8192
5
 
SET @start_session_value = @@session.transaction_alloc_block_size;
6
 
SELECT @start_session_value;
7
 
@start_session_value
8
 
8192
9
 
'#--------------------FN_DYNVARS_005_01-------------------------#'
10
 
SET @@global.transaction_alloc_block_size = 100;
11
 
Warnings:
12
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '100'
13
 
SET @@global.transaction_alloc_block_size = DEFAULT;
14
 
SELECT @@global.transaction_alloc_block_size;
15
 
@@global.transaction_alloc_block_size
16
 
8192
17
 
SET @@session.transaction_alloc_block_size = 200;
18
 
Warnings:
19
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '200'
20
 
SET @@session.transaction_alloc_block_size = DEFAULT;
21
 
SELECT @@session.transaction_alloc_block_size;
22
 
@@session.transaction_alloc_block_size
23
 
8192
24
 
'#--------------------FN_DYNVARS_005_02-------------------------#'
25
 
SET @@global.transaction_alloc_block_size = DEFAULT;
26
 
SELECT @@global.transaction_alloc_block_size = 8192;
27
 
@@global.transaction_alloc_block_size = 8192
28
 
1
29
 
SET @@session.transaction_alloc_block_size = DEFAULT;
30
 
SELECT @@session.transaction_alloc_block_size = 8192;
31
 
@@session.transaction_alloc_block_size = 8192
32
 
1
33
 
'#--------------------FN_DYNVARS_005_03-------------------------#'
34
 
SET @@global.transaction_alloc_block_size = 1024;
35
 
SELECT @@global.transaction_alloc_block_size;
36
 
@@global.transaction_alloc_block_size
37
 
1024
38
 
SET @@global.transaction_alloc_block_size = 60020;
39
 
Warnings:
40
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '60020'
41
 
SELECT @@global.transaction_alloc_block_size;
42
 
@@global.transaction_alloc_block_size
43
 
59392
44
 
SET @@global.transaction_alloc_block_size = 4294967295;
45
 
Warnings:
46
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '4294967295'
47
 
SELECT @@global.transaction_alloc_block_size;
48
 
@@global.transaction_alloc_block_size
49
 
4294966272
50
 
'#--------------------FN_DYNVARS_005_04-------------------------#'
51
 
SET @@session.transaction_alloc_block_size = 1024;
52
 
SELECT @@session.transaction_alloc_block_size;
53
 
@@session.transaction_alloc_block_size
54
 
1024
55
 
SET @@session.transaction_alloc_block_size =4294967295;
56
 
Warnings:
57
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '4294967295'
58
 
SELECT @@session.transaction_alloc_block_size;
59
 
@@session.transaction_alloc_block_size
60
 
4294966272
61
 
SET @@session.transaction_alloc_block_size = 65535;
62
 
Warnings:
63
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '65535'
64
 
SELECT @@session.transaction_alloc_block_size;
65
 
@@session.transaction_alloc_block_size
66
 
64512
67
 
'#------------------FN_DYNVARS_005_05-----------------------#'
68
 
SET @@global.transaction_alloc_block_size = 0;
69
 
Warnings:
70
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '0'
71
 
SELECT @@global.transaction_alloc_block_size;
72
 
@@global.transaction_alloc_block_size
73
 
1024
74
 
SET @@global.transaction_alloc_block_size = -1024;
75
 
Warnings:
76
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '-1024'
77
 
SELECT @@global.transaction_alloc_block_size;
78
 
@@global.transaction_alloc_block_size
79
 
1024
80
 
SET @@global.transaction_alloc_block_size = 123456789201;
81
 
Warnings:
82
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '123456789201'
83
 
SELECT @@global.transaction_alloc_block_size;
84
 
@@global.transaction_alloc_block_size
85
 
123456788480
86
 
SET @@global.transaction_alloc_block_size = ON;
87
 
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
88
 
SET @@global.transaction_alloc_block_size = OFF;
89
 
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
90
 
SET @@global.transaction_alloc_block_size = True;
91
 
Warnings:
92
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '1'
93
 
SELECT @@global.transaction_alloc_block_size;
94
 
@@global.transaction_alloc_block_size
95
 
1024
96
 
SET @@global.transaction_alloc_block_size = False;
97
 
Warnings:
98
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '0'
99
 
SELECT @@global.transaction_alloc_block_size;
100
 
@@global.transaction_alloc_block_size
101
 
1024
102
 
SET @@global.transaction_alloc_block_size = 65530.34;
103
 
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
104
 
SET @@global.transaction_alloc_block_size ="Test";
105
 
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
106
 
SET @@global.transaction_alloc_block_size = 1000;
107
 
Warnings:
108
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '1000'
109
 
SELECT @@global.transaction_alloc_block_size;
110
 
@@global.transaction_alloc_block_size
111
 
1024
112
 
SET @@session.transaction_alloc_block_size = 12345678901;
113
 
Warnings:
114
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '12345678901'
115
 
SELECT @@session.transaction_alloc_block_size;
116
 
@@session.transaction_alloc_block_size
117
 
12345678848
118
 
SET @@session.transaction_alloc_block_size = ON;
119
 
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
120
 
SET @@session.transaction_alloc_block_size = OFF;
121
 
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
122
 
SET @@session.transaction_alloc_block_size = True;
123
 
Warnings:
124
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '1'
125
 
SELECT @@session.transaction_alloc_block_size;
126
 
@@session.transaction_alloc_block_size
127
 
1024
128
 
SET @@session.transaction_alloc_block_size = False;
129
 
Warnings:
130
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '0'
131
 
SELECT @@session.transaction_alloc_block_size;
132
 
@@session.transaction_alloc_block_size
133
 
1024
134
 
SET @@session.transaction_alloc_block_size = "Test";
135
 
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
136
 
SET @@session.transaction_alloc_block_size = 'test';
137
 
ERROR 42000: Incorrect argument type to variable 'transaction_alloc_block_size'
138
 
'#------------------FN_DYNVARS_005_06-----------------------#'
139
 
SELECT @@global.transaction_alloc_block_size = VARIABLE_VALUE 
140
 
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
141
 
WHERE VARIABLE_NAME='transaction_alloc_block_size';
142
 
@@global.transaction_alloc_block_size = VARIABLE_VALUE
143
 
1
144
 
'#------------------FN_DYNVARS_005_07-----------------------#'
145
 
SELECT @@session.transaction_alloc_block_size = VARIABLE_VALUE 
146
 
FROM INFORMATION_SCHEMA.SESSION_VARIABLES 
147
 
WHERE VARIABLE_NAME='transaction_alloc_block_size';
148
 
@@session.transaction_alloc_block_size = VARIABLE_VALUE
149
 
1
150
 
'#---------------------FN_DYNVARS_001_08----------------------#'
151
 
SET @@transaction_alloc_block_size = 1024;
152
 
SET @@global.transaction_alloc_block_size = 4294967295;
153
 
Warnings:
154
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '4294967295'
155
 
SELECT @@transaction_alloc_block_size = @@global.transaction_alloc_block_size;
156
 
@@transaction_alloc_block_size = @@global.transaction_alloc_block_size
157
 
0
158
 
'#---------------------FN_DYNVARS_001_09----------------------#'
159
 
SET @@transaction_alloc_block_size = 100;
160
 
Warnings:
161
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '100'
162
 
SELECT @@transaction_alloc_block_size = @@local.transaction_alloc_block_size;
163
 
@@transaction_alloc_block_size = @@local.transaction_alloc_block_size
164
 
1
165
 
SELECT @@local.transaction_alloc_block_size = @@session.transaction_alloc_block_size;
166
 
@@local.transaction_alloc_block_size = @@session.transaction_alloc_block_size
167
 
1
168
 
'#---------------------FN_DYNVARS_001_10----------------------#'
169
 
SET transaction_alloc_block_size = 1027;
170
 
Warnings:
171
 
Warning 1292    Truncated incorrect transaction_alloc_block_size value: '1027'
172
 
SELECT @@transaction_alloc_block_size;
173
 
@@transaction_alloc_block_size
174
 
1024
175
 
SELECT local.transaction_alloc_block_size;
176
 
ERROR 42S02: Unknown table 'local' in field list
177
 
SELECT session.transaction_alloc_block_size;
178
 
ERROR 42S02: Unknown table 'session' in field list
179
 
SELECT transaction_alloc_block_size = @@session.transaction_alloc_block_size;
180
 
ERROR 42S22: Unknown column 'transaction_alloc_block_size' in 'field list'
181
 
SET @@global.transaction_alloc_block_size = @start_global_value;
182
 
SELECT @@global.transaction_alloc_block_size;
183
 
@@global.transaction_alloc_block_size
184
 
8192
185
 
SET @@session.tmp_table_size = @start_session_value;
186
 
SELECT @@session.transaction_alloc_block_size;
187
 
@@session.transaction_alloc_block_size
188
 
1024