Debian Codegraph @

mysql-test/suite/sys_vars/r/delayed_insert_limit_basic_64.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 SET @@global.delayed_insert_limit = 18446744073709551615;
62 SELECT @@global.delayed_insert_limit;
63 @@global.delayed_insert_limit
64 18446744073709551615
65 Warnings:
66 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
67 '#--------------------FN_DYNVARS_024_04-------------------------#'
68 SET @@global.delayed_insert_limit = 0;
69 Warnings:
70 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
71 Warning 1292 Truncated incorrect delayed_insert_limit value: '0'
72 SELECT @@global.delayed_insert_limit;
73 @@global.delayed_insert_limit
74 1
75 Warnings:
76 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
77 SET @@global.delayed_insert_limit = -1024;
78 Warnings:
79 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
80 Warning 1292 Truncated incorrect delayed_insert_limit value: '-1024'
81 SELECT @@global.delayed_insert_limit;
82 @@global.delayed_insert_limit
83 1
84 Warnings:
85 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
86 SET @@global.delayed_insert_limit = 429496729.5;
87 ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit'
88 SELECT @@global.delayed_insert_limit;
89 @@global.delayed_insert_limit
90 1
91 Warnings:
92 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
93 SET @@global.delayed_insert_limit = ON;
94 ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit'
95 SELECT @@global.delayed_insert_limit;
96 @@global.delayed_insert_limit
97 1
98 Warnings:
99 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
100 SET @@global.delayed_insert_limit = 18446744073709551616;
101 ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit'
102 SELECT @@global.delayed_insert_limit;
103 @@global.delayed_insert_limit
104 1
105 Warnings:
106 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
107 '#-------------------FN_DYNVARS_024_05----------------------------#'
108 SET @@session.delayed_insert_limit = 0;
109 ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL
110 SELECT @@Session.delayed_insert_limit;
111 ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable
112 '#----------------------FN_DYNVARS_024_06------------------------#'
113 SELECT VARIABLE_VALUE FROM performance_schema.global_variables
114 WHERE VARIABLE_NAME='delayed_insert_limit'
115 into @tmp;
116 SELECT @@global.delayed_insert_limit = @tmp;
117 @@global.delayed_insert_limit = @tmp
118 1
119 Warnings:
120 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
121 SELECT VARIABLE_VALUE FROM performance_schema.session_variables
122 WHERE VARIABLE_NAME='delayed_insert_limit'
123 into @tmp;
124 SELECT @@delayed_insert_limit = @tmp;
125 @@delayed_insert_limit = @tmp
126 1
127 Warnings:
128 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
129 '#---------------------FN_DYNVARS_024_07----------------------#'
130 SET @@global.delayed_insert_limit = TRUE;
131 Warnings:
132 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
133 SELECT @@global.delayed_insert_limit;
134 @@global.delayed_insert_limit
135 1
136 Warnings:
137 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
138 SET @@global.delayed_insert_limit = FALSE;
139 Warnings:
140 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
141 Warning 1292 Truncated incorrect delayed_insert_limit value: '0'
142 SELECT @@global.delayed_insert_limit;
143 @@global.delayed_insert_limit
144 1
145 Warnings:
146 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
147 '#---------------------FN_DYNVARS_024_08----------------------#'
148 SET @@global.delayed_insert_limit = 1;
149 Warnings:
150 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
151 SELECT @@delayed_insert_limit = @@global.delayed_insert_limit;
152 @@delayed_insert_limit = @@global.delayed_insert_limit
153 1
154 Warnings:
155 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
156 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
157 '#---------------------FN_DYNVARS_024_09----------------------#'
158 SET delayed_insert_limit = 1;
159 ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL
160 SELECT @@delayed_insert_limit;
161 @@delayed_insert_limit
162 1
163 Warnings:
164 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
165 SET local.delayed_insert_limit = 1;
166 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
167 SELECT local.delayed_insert_limit;
168 ERROR 42S02: Unknown table 'local' in field list
169 SET global.delayed_insert_limit = 1;
170 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
171 SELECT global.delayed_insert_limit;
172 ERROR 42S02: Unknown table 'global' in field list
173 SELECT delayed_insert_limit;
174 ERROR 42S22: Unknown column 'delayed_insert_limit' in 'field list'
175 SELECT @@session.delayed_insert_limit;
176 ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable
177 SET @@global.delayed_insert_limit = @start_value;
178 Warnings:
179 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.
180 SELECT @@global.delayed_insert_limit;
181 @@global.delayed_insert_limit
182 100
183 Warnings:
184 Warning 1287 '@@delayed_insert_limit' is deprecated and will be removed in a future release.