Debian Codegraph @

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

raw
1 SET @start_value = @@global.delayed_insert_limit;
2 Warnings:
3 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
4 SELECT @start_value;
5 @start_value
6 100
7 '#--------------------FN_DYNVARS_024_01------------------------#'
8 SET @@global.delayed_insert_limit = 100;
9 Warnings:
10 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
11 SET @@global.delayed_insert_limit = DEFAULT;
12 Warnings:
13 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
14 SELECT @@global.delayed_insert_limit;
15 @@global.delayed_insert_limit
16 100
17 Warnings:
18 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
19 '#---------------------FN_DYNVARS_024_02-------------------------#'
20 SET @@global.delayed_insert_limit = @start_value;
21 Warnings:
22 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
23 SELECT @@global.delayed_insert_limit = 100;
24 @@global.delayed_insert_limit = 100
25 1
26 Warnings:
27 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
28 '#--------------------FN_DYNVARS_024_03------------------------#'
29 SET @@global.delayed_insert_limit = 1;
30 Warnings:
31 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
32 SELECT @@global.delayed_insert_limit;
33 @@global.delayed_insert_limit
34 1
35 Warnings:
36 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
37 SET @@global.delayed_insert_limit = 10000;
38 Warnings:
39 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
40 SELECT @@global.delayed_insert_limit;
41 @@global.delayed_insert_limit
42 10000
43 Warnings:
44 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
45 SET @@global.delayed_insert_limit = 4294967295;
46 Warnings:
47 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
48 SELECT @@global.delayed_insert_limit;
49 @@global.delayed_insert_limit
50 4294967295
51 Warnings:
52 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
53 SET @@global.delayed_insert_limit = 1;
54 Warnings:
55 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
56 SELECT @@global.delayed_insert_limit;
57 @@global.delayed_insert_limit
58 1
59 Warnings:
60 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
61 '#--------------------FN_DYNVARS_024_04-------------------------#'
62 SET @@global.delayed_insert_limit = 0;
63 Warnings:
64 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
65 Warning 1292 Truncated incorrect delayed_insert_limit value: '0'
66 SELECT @@global.delayed_insert_limit;
67 @@global.delayed_insert_limit
68 1
69 Warnings:
70 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
71 SET @@global.delayed_insert_limit = -1024;
72 Warnings:
73 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
74 Warning 1292 Truncated incorrect delayed_insert_limit value: '-1024'
75 SELECT @@global.delayed_insert_limit;
76 @@global.delayed_insert_limit
77 1
78 Warnings:
79 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
80 SET @@global.delayed_insert_limit = 429496729.5;
81 ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit'
82 SELECT @@global.delayed_insert_limit;
83 @@global.delayed_insert_limit
84 1
85 Warnings:
86 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
87 SET @@global.delayed_insert_limit = ON;
88 ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit'
89 SELECT @@global.delayed_insert_limit;
90 @@global.delayed_insert_limit
91 1
92 Warnings:
93 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
94 SET @@global.delayed_insert_limit = 4294967296;
95 Warnings:
96 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
97 Warning 1292 Truncated incorrect delayed_insert_limit value: '4294967296'
98 SELECT @@global.delayed_insert_limit;
99 @@global.delayed_insert_limit
100 4294967295
101 Warnings:
102 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
103 SET @@global.delayed_insert_limit = 42949672950;
104 Warnings:
105 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
106 Warning 1292 Truncated incorrect delayed_insert_limit value: '42949672950'
107 SELECT @@global.delayed_insert_limit;
108 @@global.delayed_insert_limit
109 4294967295
110 Warnings:
111 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
112 '#-------------------FN_DYNVARS_024_05----------------------------#'
113 SET @@session.delayed_insert_limit = 0;
114 ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL
115 SELECT @@Session.delayed_insert_limit;
116 ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable
117 '#----------------------FN_DYNVARS_024_06------------------------#'
118 SELECT VARIABLE_VALUE FROM performance_schema.global_variables
119 WHERE VARIABLE_NAME='delayed_insert_limit'
120 into @tmp;
121 SELECT @@global.delayed_insert_limit = @tmp;
122 @@global.delayed_insert_limit = @tmp
123 1
124 Warnings:
125 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
126 SELECT VARIABLE_VALUE FROM performance_schema.session_variables
127 WHERE VARIABLE_NAME='delayed_insert_limit'
128 into @tmp;
129 SELECT @@delayed_insert_limit = @tmp;
130 @@delayed_insert_limit = @tmp
131 1
132 Warnings:
133 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
134 '#---------------------FN_DYNVARS_024_07----------------------#'
135 SET @@global.delayed_insert_limit = TRUE;
136 Warnings:
137 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
138 SELECT @@global.delayed_insert_limit;
139 @@global.delayed_insert_limit
140 1
141 Warnings:
142 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
143 SET @@global.delayed_insert_limit = FALSE;
144 Warnings:
145 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
146 Warning 1292 Truncated incorrect delayed_insert_limit value: '0'
147 SELECT @@global.delayed_insert_limit;
148 @@global.delayed_insert_limit
149 1
150 Warnings:
151 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
152 '#---------------------FN_DYNVARS_024_08----------------------#'
153 SET @@global.delayed_insert_limit = 1;
154 Warnings:
155 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
156 SELECT @@delayed_insert_limit = @@global.delayed_insert_limit;
157 @@delayed_insert_limit = @@global.delayed_insert_limit
158 1
159 Warnings:
160 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
161 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
162 '#---------------------FN_DYNVARS_024_09----------------------#'
163 SET delayed_insert_limit = 1;
164 ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL
165 SELECT @@delayed_insert_limit;
166 @@delayed_insert_limit
167 1
168 Warnings:
169 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
170 SET local.delayed_insert_limit = 1;
171 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 'local.delayed_insert_limit = 1' at line 1
172 SELECT local.delayed_insert_limit;
173 ERROR 42S02: Unknown table 'local' in field list
174 SET global.delayed_insert_limit = 1;
175 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 'global.delayed_insert_limit = 1' at line 1
176 SELECT global.delayed_insert_limit;
177 ERROR 42S02: Unknown table 'global' in field list
178 SELECT delayed_insert_limit;
179 ERROR 42S22: Unknown column 'delayed_insert_limit' in 'field list'
180 SELECT @@session.delayed_insert_limit;
181 ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable
182 SET @@global.delayed_insert_limit = @start_value;
183 Warnings:
184 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
185 SELECT @@global.delayed_insert_limit;
186 @@global.delayed_insert_limit
187 100
188 Warnings:
189 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.