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.
75SELECT @@global.delayed_insert_limit;
76@@global.delayed_insert_limit
7742949672950
78Warnings:
79Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
80SET @@global.delayed_insert_limit = 429496729.5;
81ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit'
82SELECT @@global.delayed_insert_limit;
83@@global.delayed_insert_limit
8442949672950
85Warnings:
86Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
87SET @@global.delayed_insert_limit = ON;
88ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit'
89SELECT @@global.delayed_insert_limit;
90@@global.delayed_insert_limit
9142949672950
92Warnings:
93Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
94'#-------------------FN_DYNVARS_024_05----------------------------#'
95SET @@session.delayed_insert_limit = 0;
96ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL
97SELECT @@Session.delayed_insert_limit;
98ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable
99'#----------------------FN_DYNVARS_024_06------------------------#'
100SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
101WHERE VARIABLE_NAME='delayed_insert_limit'
102  into @tmp;
103SELECT @@global.delayed_insert_limit = @tmp;
104@@global.delayed_insert_limit = @tmp
1051
106Warnings:
107Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
108SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
109WHERE VARIABLE_NAME='delayed_insert_limit'
110  into @tmp;
111SELECT @@delayed_insert_limit = @tmp;
112@@delayed_insert_limit = @tmp
1131
114Warnings:
115Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
116'#---------------------FN_DYNVARS_024_07----------------------#'
117SET @@global.delayed_insert_limit = TRUE;
118Warnings:
119Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
120SELECT @@global.delayed_insert_limit;
121@@global.delayed_insert_limit
1221
123Warnings:
124Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
125SET @@global.delayed_insert_limit = FALSE;
126Warnings:
127Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
128Warning	1292	Truncated incorrect delayed_insert_limit value: '0'
129SELECT @@global.delayed_insert_limit;
130@@global.delayed_insert_limit
1311
132Warnings:
133Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
134'#---------------------FN_DYNVARS_024_08----------------------#'
135SET @@global.delayed_insert_limit = 1;
136Warnings:
137Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
138SELECT @@delayed_insert_limit = @@global.delayed_insert_limit;
139@@delayed_insert_limit = @@global.delayed_insert_limit
1401
141Warnings:
142Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
143Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
144'#---------------------FN_DYNVARS_024_09----------------------#'
145SET delayed_insert_limit = 1;
146ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL
147SELECT @@delayed_insert_limit;
148@@delayed_insert_limit
1491
150Warnings:
151Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
152SET local.delayed_insert_limit = 1;
153ERROR 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
154SELECT local.delayed_insert_limit;
155ERROR 42S02: Unknown table 'local' in field list
156SET global.delayed_insert_limit = 1;
157ERROR 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
158SELECT global.delayed_insert_limit;
159ERROR 42S02: Unknown table 'global' in field list
160SELECT delayed_insert_limit = @@session.delayed_insert_limit;
161ERROR 42S22: Unknown column 'delayed_insert_limit' in 'field list'
162SET @@global.delayed_insert_limit = @start_value;
163Warnings:
164Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
165SELECT @@global.delayed_insert_limit;
166@@global.delayed_insert_limit
167100
168Warnings:
169Warning	1287	'@@delayed_insert_limit' is deprecated and will be removed in a future release.
170