Debian Codegraph @

mysql-test/suite/sys_vars/r/bulk_insert_buffer_size_basic.result

raw
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 SELECT @@global.bulk_insert_buffer_size;
66 @@global.bulk_insert_buffer_size
67 max_bulk_insert_buffer_size
68 SET @@global.bulk_insert_buffer_size = -1024;
69 Warnings:
70 Warning 1292 Truncated incorrect bulk_insert_buffer_size value: '-1024'
71 SELECT @@global.bulk_insert_buffer_size;
72 @@global.bulk_insert_buffer_size
73 0
74 SET @@global.bulk_insert_buffer_size = test;
75 ERROR 42000: Incorrect argument type to variable 'bulk_insert_buffer_size'
76 SET @@global.bulk_insert_buffer_size = ON;
77 ERROR 42000: Incorrect argument type to variable 'bulk_insert_buffer_size'
78 SET @@global.bulk_insert_buffer_size = 429496.10;
79 ERROR 42000: Incorrect argument type to variable 'bulk_insert_buffer_size'
80 SET @@session.bulk_insert_buffer_size = 42949672950;
81 SELECT @@session.bulk_insert_buffer_size;
82 @@session.bulk_insert_buffer_size
83 max_bulk_insert_buffer_size
84 SET @@session.bulk_insert_buffer_size = -2;
85 Warnings:
86 Warning 1292 Truncated incorrect bulk_insert_buffer_size value: '-2'
87 SELECT @@session.bulk_insert_buffer_size;
88 @@session.bulk_insert_buffer_size
89 0
90 SET @@session.bulk_insert_buffer_size = test;
91 ERROR 42000: Incorrect argument type to variable 'bulk_insert_buffer_size'
92 SET @@session.bulk_insert_buffer_size = 429496.10;
93 ERROR 42000: Incorrect argument type to variable 'bulk_insert_buffer_size'
94 '#------------------FN_DYNVARS_007_06-----------------------#'
95 SELECT @@global.bulk_insert_buffer_size = VARIABLE_VALUE
96 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
97 WHERE VARIABLE_NAME='bulk_insert_buffer_size';
98 @@global.bulk_insert_buffer_size = VARIABLE_VALUE
99 1
100 '#------------------FN_DYNVARS_007_07-----------------------#'
101 SELECT @@session.bulk_insert_buffer_size = VARIABLE_VALUE
102 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
103 WHERE VARIABLE_NAME='bulk_insert_buffer_size';
104 @@session.bulk_insert_buffer_size = VARIABLE_VALUE
105 1
106 '#------------------FN_DYNVARS_007_08-----------------------#'
107 SET @@global.bulk_insert_buffer_size = TRUE;
108 SELECT @@global.bulk_insert_buffer_size;
109 @@global.bulk_insert_buffer_size
110 1
111 SET @@global.bulk_insert_buffer_size = FALSE;
112 SELECT @@global.bulk_insert_buffer_size;
113 @@global.bulk_insert_buffer_size
114 0
115 SET @@session.bulk_insert_buffer_size = TRUE;
116 SELECT @@session.bulk_insert_buffer_size;
117 @@session.bulk_insert_buffer_size
118 1
119 SET @@session.bulk_insert_buffer_size = FALSE;
120 SELECT @@session.bulk_insert_buffer_size;
121 @@session.bulk_insert_buffer_size
122 0
123 '#---------------------FN_DYNVARS_007_09----------------------#'
124 SET @@bulk_insert_buffer_size = 100;
125 SELECT @@bulk_insert_buffer_size = @@local.bulk_insert_buffer_size;
126 @@bulk_insert_buffer_size = @@local.bulk_insert_buffer_size
127 1
128 SELECT @@local.bulk_insert_buffer_size = @@session.bulk_insert_buffer_size;
129 @@local.bulk_insert_buffer_size = @@session.bulk_insert_buffer_size
130 1
131 '#---------------------FN_DYNVARS_007_10----------------------#'
132 SET bulk_insert_buffer_size = 1;
133 SELECT @@bulk_insert_buffer_size;
134 @@bulk_insert_buffer_size
135 1
136 SELECT local.bulk_insert_buffer_size;
137 ERROR 42S02: Unknown table 'local' in SELECT
138 SELECT session.bulk_insert_buffer_size;
139 ERROR 42S02: Unknown table 'session' in SELECT
140 SELECT bulk_insert_buffer_size = @@session.bulk_insert_buffer_size;
141 ERROR 42S22: Unknown column 'bulk_insert_buffer_size' in 'SELECT'
142 SET @@global.bulk_insert_buffer_size = @start_global_value;
143 SELECT @@global.bulk_insert_buffer_size;
144 @@global.bulk_insert_buffer_size
145 8388608
146 SET @@session.bulk_insert_buffer_size = @start_session_value;
147 SELECT @@session.bulk_insert_buffer_size;
148 @@session.bulk_insert_buffer_size
149 8388608