← Back to branch summary

~vadim-tk/percona-server/flushing-algo

« back to all changes in this revision

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

  • Committer: root
  • Date: 2011-10-29 01:34:40 UTC
  • Revision ID: root@hppro1.office.percona.com-20111029013440-qhnf4jk8kdjcf4e0
Initial import

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/sys_vars/r/bulk_insert_buffer_size_basic_32.result
 
1
SET @start_global_value = @@global.bulk_insert_buffer_size;
 
2
SELECT @start_global_value;
 
3
@start_global_value
 
4
8388608
 
5
SET @start_session_value = @@session.bulk_insert_buffer_size;
 
6
SELECT @start_session_value;
 
7
@start_session_value
 
8
8388608
 
9
'#--------------------FN_DYNVARS_007_01-------------------------#'
 
10
SET @@global.bulk_insert_buffer_size = 100;
 
11
SET @@global.bulk_insert_buffer_size = DEFAULT;
 
12
SELECT @@global.bulk_insert_buffer_size;
 
13
@@global.bulk_insert_buffer_size
 
14
8388608
 
15
SET @@session.bulk_insert_buffer_size = 200;
 
16
SET @@session.bulk_insert_buffer_size = DEFAULT;
 
17
SELECT @@session.bulk_insert_buffer_size;
 
18
@@session.bulk_insert_buffer_size
 
19
8388608
 
20
'#--------------------FN_DYNVARS_007_02-------------------------#'
 
21
SET @@global.bulk_insert_buffer_size = @start_global_value;
 
22
SELECT @@global.bulk_insert_buffer_size = 8388608;
 
23
@@global.bulk_insert_buffer_size = 8388608
 
24
1
 
25
SET @@session.bulk_insert_buffer_size = @start_session_value;
 
26
SELECT @@session.bulk_insert_buffer_size = 8388608;
 
27
@@session.bulk_insert_buffer_size = 8388608
 
28
1
 
29
'#--------------------FN_DYNVARS_007_03-------------------------#'
 
30
SET @@global.bulk_insert_buffer_size = 0;
 
31
SELECT @@global.bulk_insert_buffer_size;
 
32
@@global.bulk_insert_buffer_size
 
33
0
 
34
SET @@global.bulk_insert_buffer_size = 1;
 
35
SELECT @@global.bulk_insert_buffer_size;
 
36
@@global.bulk_insert_buffer_size
 
37
1
 
38
SET @@global.bulk_insert_buffer_size = 4294967295;
 
39
SELECT @@global.bulk_insert_buffer_size;
 
40
@@global.bulk_insert_buffer_size
 
41
4294967295
 
42
SET @@global.bulk_insert_buffer_size = 429496;
 
43
SELECT @@global.bulk_insert_buffer_size;
 
44
@@global.bulk_insert_buffer_size
 
45
429496
 
46
'#--------------------FN_DYNVARS_007_04-------------------------#'
 
47
SET @@session.bulk_insert_buffer_size = 0;
 
48
SELECT @@session.bulk_insert_buffer_size;
 
49
@@session.bulk_insert_buffer_size
 
50
0
 
51
SET @@session.bulk_insert_buffer_size = 1;
 
52
SELECT @@session.bulk_insert_buffer_size;
 
53
@@session.bulk_insert_buffer_size
 
54
1
 
55
SET @@session.bulk_insert_buffer_size = 4294967295;
 
56
SELECT @@session.bulk_insert_buffer_size;
 
57
@@session.bulk_insert_buffer_size
 
58
4294967295
 
59
SET @@session.bulk_insert_buffer_size = 429496;
 
60
SELECT @@session.bulk_insert_buffer_size;
 
61
@@session.bulk_insert_buffer_size
 
62
429496
 
63
'#------------------FN_DYNVARS_007_05-----------------------#'
 
64
SET @@global.bulk_insert_buffer_size = 42949672950;
 
65
Warnings:
 
66
Warning 1292    Truncated incorrect bulk_insert_buffer_size value: '42949672950'
 
67
SELECT @@global.bulk_insert_buffer_size;
 
68
@@global.bulk_insert_buffer_size
 
69
4294967295
 
70
SET @@global.bulk_insert_buffer_size = -1024;
 
71
Warnings:
 
72
Warning 1292    Truncated incorrect bulk_insert_buffer_size value: '-1024'
 
73
SELECT @@global.bulk_insert_buffer_size;
 
74
@@global.bulk_insert_buffer_size
 
75
0
 
76
SET @@global.bulk_insert_buffer_size = test;
 
77
ERROR 42000: Incorrect argument type to variable 'bulk_insert_buffer_size'
 
78
SET @@global.bulk_insert_buffer_size = ON;
 
79
ERROR 42000: Incorrect argument type to variable 'bulk_insert_buffer_size'
 
80
SET @@global.bulk_insert_buffer_size = 429496.10;
 
81
ERROR 42000: Incorrect argument type to variable 'bulk_insert_buffer_size'
 
82
SET @@session.bulk_insert_buffer_size = 42949672950;
 
83
Warnings:
 
84
Warning 1292    Truncated incorrect bulk_insert_buffer_size value: '42949672950'
 
85
SELECT @@session.bulk_insert_buffer_size;
 
86
@@session.bulk_insert_buffer_size
 
87
4294967295
 
88
SET @@session.bulk_insert_buffer_size = -2;
 
89
Warnings:
 
90
Warning 1292    Truncated incorrect bulk_insert_buffer_size value: '-2'
 
91
SELECT @@session.bulk_insert_buffer_size;
 
92
@@session.bulk_insert_buffer_size
 
93
0
 
94
SET @@session.bulk_insert_buffer_size = test;
 
95
ERROR 42000: Incorrect argument type to variable 'bulk_insert_buffer_size'
 
96
SET @@session.bulk_insert_buffer_size = 429496.10;
 
97
ERROR 42000: Incorrect argument type to variable 'bulk_insert_buffer_size'
 
98
'#------------------FN_DYNVARS_007_06-----------------------#'
 
99
SELECT @@global.bulk_insert_buffer_size = VARIABLE_VALUE 
 
100
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 
 
101
WHERE VARIABLE_NAME='bulk_insert_buffer_size';
 
102
@@global.bulk_insert_buffer_size = VARIABLE_VALUE
 
103
1
 
104
'#------------------FN_DYNVARS_007_07-----------------------#'
 
105
SELECT @@session.bulk_insert_buffer_size = VARIABLE_VALUE 
 
106
FROM INFORMATION_SCHEMA.SESSION_VARIABLES 
 
107
WHERE VARIABLE_NAME='bulk_insert_buffer_size';
 
108
@@session.bulk_insert_buffer_size = VARIABLE_VALUE
 
109
1
 
110
'#------------------FN_DYNVARS_007_08-----------------------#'
 
111
SET @@global.bulk_insert_buffer_size = TRUE;
 
112
SELECT @@global.bulk_insert_buffer_size;
 
113
@@global.bulk_insert_buffer_size
 
114
1
 
115
SET @@global.bulk_insert_buffer_size = FALSE;
 
116
SELECT @@global.bulk_insert_buffer_size;
 
117
@@global.bulk_insert_buffer_size
 
118
0
 
119
SET @@session.bulk_insert_buffer_size = TRUE;
 
120
SELECT @@session.bulk_insert_buffer_size;
 
121
@@session.bulk_insert_buffer_size
 
122
1
 
123
SET @@session.bulk_insert_buffer_size = FALSE;
 
124
SELECT @@session.bulk_insert_buffer_size;
 
125
@@session.bulk_insert_buffer_size
 
126
0
 
127
'#---------------------FN_DYNVARS_007_09----------------------#'
 
128
SET @@bulk_insert_buffer_size = 100;
 
129
SELECT @@bulk_insert_buffer_size = @@local.bulk_insert_buffer_size;
 
130
@@bulk_insert_buffer_size = @@local.bulk_insert_buffer_size
 
131
1
 
132
SELECT @@local.bulk_insert_buffer_size = @@session.bulk_insert_buffer_size;
 
133
@@local.bulk_insert_buffer_size = @@session.bulk_insert_buffer_size
 
134
1
 
135
'#---------------------FN_DYNVARS_007_10----------------------#'
 
136
SET bulk_insert_buffer_size = 1;
 
137
SELECT @@bulk_insert_buffer_size;
 
138
@@bulk_insert_buffer_size
 
139
1
 
140
SET local.bulk_insert_buffer_size = 1;
 
141
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 'bulk_insert_buffer_size = 1' at line 1
 
142
SELECT local.bulk_insert_buffer_size;
 
143
ERROR 42S02: Unknown table 'local' in field list
 
144
SET session.bulk_insert_buffer_size = 1;
 
145
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 'bulk_insert_buffer_size = 1' at line 1
 
146
SELECT session.bulk_insert_buffer_size;
 
147
ERROR 42S02: Unknown table 'session' in field list
 
148
SELECT bulk_insert_buffer_size = @@session.bulk_insert_buffer_size;
 
149
ERROR 42S22: Unknown column 'bulk_insert_buffer_size' in 'field list'
 
150
SET @@global.bulk_insert_buffer_size = @start_global_value;
 
151
SELECT @@global.bulk_insert_buffer_size;
 
152
@@global.bulk_insert_buffer_size
 
153
8388608
 
154
SET @@session.bulk_insert_buffer_size = @start_session_value;
 
155
SELECT @@session.bulk_insert_buffer_size;
 
156
@@session.bulk_insert_buffer_size
 
157
8388608