1SET @start_value = @@global.delayed_insert_limit;
2SELECT @start_value;
3@start_value
4100
5'#--------------------FN_DYNVARS_024_01------------------------#'
6SET @@global.delayed_insert_limit = 100;
7SET @@global.delayed_insert_limit = DEFAULT;
8SELECT @@global.delayed_insert_limit;
9@@global.delayed_insert_limit
10100
11'#---------------------FN_DYNVARS_024_02-------------------------#'
12SET @@global.delayed_insert_limit = @start_value;
13SELECT @@global.delayed_insert_limit = 100;
14@@global.delayed_insert_limit = 100
151
16'#--------------------FN_DYNVARS_024_03------------------------#'
17SET @@global.delayed_insert_limit = 10000;
18SELECT @@global.delayed_insert_limit;
19@@global.delayed_insert_limit
2010000
21SET @@global.delayed_insert_limit = 4294967295;
22SELECT @@global.delayed_insert_limit;
23@@global.delayed_insert_limit
244294967295
25SET @@global.delayed_insert_limit = 1;
26SELECT @@global.delayed_insert_limit;
27@@global.delayed_insert_limit
281
29'#--------------------FN_DYNVARS_024_04-------------------------#'
30SET @@global.delayed_insert_limit = 0;
31Warnings:
32Warning	1292	Truncated incorrect delayed_insert_limit value: '0'
33SELECT @@global.delayed_insert_limit;
34@@global.delayed_insert_limit
351
36SET @@global.delayed_insert_limit = -1024;
37Warnings:
38Warning	1292	Truncated incorrect delayed_insert_limit value: '-1024'
39SELECT @@global.delayed_insert_limit;
40@@global.delayed_insert_limit
411
42SET @@global.delayed_insert_limit = 42949672950;
43Warnings:
44Warning	1292	Truncated incorrect delayed_insert_limit value: '42949672950'
45SELECT @@global.delayed_insert_limit;
46@@global.delayed_insert_limit
474294967295
48SET @@global.delayed_insert_limit = 429496729.5;
49ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit'
50SELECT @@global.delayed_insert_limit;
51@@global.delayed_insert_limit
524294967295
53SET @@global.delayed_insert_limit = ON;
54ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit'
55SELECT @@global.delayed_insert_limit;
56@@global.delayed_insert_limit
574294967295
58'#-------------------FN_DYNVARS_024_05----------------------------#'
59SET @@session.delayed_insert_limit = 0;
60ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL
61SELECT @@Session.delayed_insert_limit;
62ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable
63'#----------------------FN_DYNVARS_024_06------------------------#'
64SELECT @@global.delayed_insert_limit =
65VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
66WHERE VARIABLE_NAME='delayed_insert_limit';
67@@global.delayed_insert_limit =
68VARIABLE_VALUE
691
70SELECT @@delayed_insert_limit =
71VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
72WHERE VARIABLE_NAME='delayed_insert_limit';
73@@delayed_insert_limit =
74VARIABLE_VALUE
751
76'#---------------------FN_DYNVARS_024_07----------------------#'
77SET @@global.delayed_insert_limit = TRUE;
78SELECT @@global.delayed_insert_limit;
79@@global.delayed_insert_limit
801
81SET @@global.delayed_insert_limit = FALSE;
82Warnings:
83Warning	1292	Truncated incorrect delayed_insert_limit value: '0'
84SELECT @@global.delayed_insert_limit;
85@@global.delayed_insert_limit
861
87'#---------------------FN_DYNVARS_024_08----------------------#'
88SET @@global.delayed_insert_limit = 1;
89SELECT @@delayed_insert_limit = @@global.delayed_insert_limit;
90@@delayed_insert_limit = @@global.delayed_insert_limit
911
92'#---------------------FN_DYNVARS_024_09----------------------#'
93SET delayed_insert_limit = 1;
94ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL
95SELECT @@delayed_insert_limit;
96@@delayed_insert_limit
971
98SELECT local.delayed_insert_limit;
99ERROR 42S02: Unknown table 'local' in field list
100SELECT global.delayed_insert_limit;
101ERROR 42S02: Unknown table 'global' in field list
102SELECT delayed_insert_limit = @@session.delayed_insert_limit;
103ERROR 42S22: Unknown column 'delayed_insert_limit' in 'field list'
104SET @@global.delayed_insert_limit = @start_value;
105SELECT @@global.delayed_insert_limit;
106@@global.delayed_insert_limit
107100
108