1SET @start_value = @@global.delayed_insert_limit;
2Warnings:
3Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
4SELECT @start_value;
5@start_value
6100
7'#--------------------FN_DYNVARS_024_01------------------------#'
8SET @@global.delayed_insert_limit = 100;
9Warnings:
10Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
11SET @@global.delayed_insert_limit = DEFAULT;
12Warnings:
13Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
14SELECT @@global.delayed_insert_limit;
15@@global.delayed_insert_limit
16100
17Warnings:
18Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
19'#---------------------FN_DYNVARS_024_02-------------------------#'
20SET @@global.delayed_insert_limit = @start_value;
21Warnings:
22Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
23SELECT @@global.delayed_insert_limit = 100;
24@@global.delayed_insert_limit = 100
251
26Warnings:
27Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
28'#--------------------FN_DYNVARS_024_03------------------------#'
29SET @@global.delayed_insert_limit = 10000;
30Warnings:
31Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
32SELECT @@global.delayed_insert_limit;
33@@global.delayed_insert_limit
3410000
35Warnings:
36Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
37SET @@global.delayed_insert_limit = 4294967295;
38Warnings:
39Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
40SELECT @@global.delayed_insert_limit;
41@@global.delayed_insert_limit
424294967295
43Warnings:
44Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
45SET @@global.delayed_insert_limit = 1;
46Warnings:
47Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
48SELECT @@global.delayed_insert_limit;
49@@global.delayed_insert_limit
501
51Warnings:
52Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
53'#--------------------FN_DYNVARS_024_04-------------------------#'
54SET @@global.delayed_insert_limit = 0;
55Warnings:
56Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
57Warning	1292	Truncated incorrect delayed_insert_limit value: '0'
58SELECT @@global.delayed_insert_limit;
59@@global.delayed_insert_limit
601
61Warnings:
62Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
63SET @@global.delayed_insert_limit = -1024;
64Warnings:
65Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
66Warning	1292	Truncated incorrect delayed_insert_limit value: '-1024'
67SELECT @@global.delayed_insert_limit;
68@@global.delayed_insert_limit
691
70Warnings:
71Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
72SET @@global.delayed_insert_limit = 42949672950;
73Warnings:
74Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
75Warning	1292	Truncated incorrect delayed_insert_limit value: '42949672950'
76SELECT @@global.delayed_insert_limit;
77@@global.delayed_insert_limit
784294967295
79Warnings:
80Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
81SET @@global.delayed_insert_limit = 429496729.5;
82ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit'
83SELECT @@global.delayed_insert_limit;
84@@global.delayed_insert_limit
854294967295
86Warnings:
87Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
88SET @@global.delayed_insert_limit = ON;
89ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit'
90SELECT @@global.delayed_insert_limit;
91@@global.delayed_insert_limit
924294967295
93Warnings:
94Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
95'#-------------------FN_DYNVARS_024_05----------------------------#'
96SET @@session.delayed_insert_limit = 0;
97ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL
98SELECT @@Session.delayed_insert_limit;
99ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable
100'#----------------------FN_DYNVARS_024_06------------------------#'
101SELECT @@global.delayed_insert_limit =
102VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
103WHERE VARIABLE_NAME='delayed_insert_limit';
104@@global.delayed_insert_limit =
105VARIABLE_VALUE
1061
107Warnings:
108Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
109SELECT @@delayed_insert_limit =
110VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
111WHERE VARIABLE_NAME='delayed_insert_limit';
112@@delayed_insert_limit =
113VARIABLE_VALUE
1141
115Warnings:
116Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
117'#---------------------FN_DYNVARS_024_07----------------------#'
118SET @@global.delayed_insert_limit = TRUE;
119Warnings:
120Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
121SELECT @@global.delayed_insert_limit;
122@@global.delayed_insert_limit
1231
124Warnings:
125Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
126SET @@global.delayed_insert_limit = FALSE;
127Warnings:
128Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
129Warning	1292	Truncated incorrect delayed_insert_limit value: '0'
130SELECT @@global.delayed_insert_limit;
131@@global.delayed_insert_limit
1321
133Warnings:
134Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
135'#---------------------FN_DYNVARS_024_08----------------------#'
136SET @@global.delayed_insert_limit = 1;
137Warnings:
138Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
139SELECT @@delayed_insert_limit = @@global.delayed_insert_limit;
140@@delayed_insert_limit = @@global.delayed_insert_limit
1411
142Warnings:
143Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
144Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
145'#---------------------FN_DYNVARS_024_09----------------------#'
146SET delayed_insert_limit = 1;
147ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL
148SELECT @@delayed_insert_limit;
149@@delayed_insert_limit
1501
151Warnings:
152Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
153SET local.delayed_insert_limit = 1;
154ERROR 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 'delayed_insert_limit = 1' at line 1
155SELECT local.delayed_insert_limit;
156ERROR 42S02: Unknown table 'local' in field list
157SET global.delayed_insert_limit = 1;
158ERROR 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 'delayed_insert_limit = 1' at line 1
159SELECT global.delayed_insert_limit;
160ERROR 42S02: Unknown table 'global' in field list
161SELECT delayed_insert_limit = @@session.delayed_insert_limit;
162ERROR 42S22: Unknown column 'delayed_insert_limit' in 'field list'
163SET @@global.delayed_insert_limit = @start_value;
164Warnings:
165Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
166SELECT @@global.delayed_insert_limit;
167@@global.delayed_insert_limit
168100
169Warnings:
170Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
171