1
SET @start_value = @@global.delayed_insert_limit;
5
'#--------------------FN_DYNVARS_024_01------------------------#'
6
SET @@global.delayed_insert_limit = 100;
7
SET @@global.delayed_insert_limit = DEFAULT;
8
SELECT @@global.delayed_insert_limit;
9
@@global.delayed_insert_limit
11
'#---------------------FN_DYNVARS_024_02-------------------------#'
12
SET @@global.delayed_insert_limit = @start_value;
13
SELECT @@global.delayed_insert_limit = 100;
14
@@global.delayed_insert_limit = 100
16
'#--------------------FN_DYNVARS_024_03------------------------#'
17
SET @@global.delayed_insert_limit = 10000;
18
SELECT @@global.delayed_insert_limit;
19
@@global.delayed_insert_limit
21
SET @@global.delayed_insert_limit = 4294967295;
22
SELECT @@global.delayed_insert_limit;
23
@@global.delayed_insert_limit
25
SET @@global.delayed_insert_limit = 1;
26
SELECT @@global.delayed_insert_limit;
27
@@global.delayed_insert_limit
29
'#--------------------FN_DYNVARS_024_04-------------------------#'
30
SET @@global.delayed_insert_limit = 0;
32
Warning 1292 Truncated incorrect delayed_insert_limit value: '0'
33
SELECT @@global.delayed_insert_limit;
34
@@global.delayed_insert_limit
36
SET @@global.delayed_insert_limit = -1024;
38
Warning 1292 Truncated incorrect delayed_insert_limit value: '0'
39
SELECT @@global.delayed_insert_limit;
40
@@global.delayed_insert_limit
42
SET @@global.delayed_insert_limit = 42949672950;
44
Warning 1292 Truncated incorrect delayed_insert_limit value: '42949672950'
45
SELECT @@global.delayed_insert_limit;
46
@@global.delayed_insert_limit
48
'Bug # 34837: Errors are not coming on assigning invalid values to variable'
49
SET @@global.delayed_insert_limit = 429496729.5;
50
ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit'
51
SELECT @@global.delayed_insert_limit;
52
@@global.delayed_insert_limit
54
SET @@global.delayed_insert_limit = ON;
55
ERROR 42000: Incorrect argument type to variable 'delayed_insert_limit'
56
SELECT @@global.delayed_insert_limit;
57
@@global.delayed_insert_limit
59
'#-------------------FN_DYNVARS_024_05----------------------------#'
60
SET @@session.delayed_insert_limit = 0;
61
ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL
62
SELECT @@Session.delayed_insert_limit;
63
ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable
64
'#----------------------FN_DYNVARS_024_06------------------------#'
65
SELECT @@global.delayed_insert_limit =
66
VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
67
WHERE VARIABLE_NAME='delayed_insert_limit';
68
@@global.delayed_insert_limit =
71
SELECT @@delayed_insert_limit =
72
VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES
73
WHERE VARIABLE_NAME='delayed_insert_limit';
74
@@delayed_insert_limit =
77
'#---------------------FN_DYNVARS_024_07----------------------#'
78
SET @@global.delayed_insert_limit = TRUE;
79
SELECT @@global.delayed_insert_limit;
80
@@global.delayed_insert_limit
82
SET @@global.delayed_insert_limit = FALSE;
84
Warning 1292 Truncated incorrect delayed_insert_limit value: '0'
85
SELECT @@global.delayed_insert_limit;
86
@@global.delayed_insert_limit
88
'#---------------------FN_DYNVARS_024_08----------------------#'
89
SET @@global.delayed_insert_limit = 1;
90
SELECT @@delayed_insert_limit = @@global.delayed_insert_limit;
91
@@delayed_insert_limit = @@global.delayed_insert_limit
93
'#---------------------FN_DYNVARS_024_09----------------------#'
94
SET delayed_insert_limit = 1;
95
ERROR HY000: Variable 'delayed_insert_limit' is a GLOBAL variable and should be set with SET GLOBAL
96
SELECT @@delayed_insert_limit;
97
@@delayed_insert_limit
99
SET local.delayed_insert_limit = 1;
100
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 'delayed_insert_limit = 1' at line 1
101
SELECT local.delayed_insert_limit;
102
ERROR 42S02: Unknown table 'local' in field list
103
SET global.delayed_insert_limit = 1;
104
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 'delayed_insert_limit = 1' at line 1
105
SELECT global.delayed_insert_limit;
106
ERROR 42S02: Unknown table 'global' in field list
107
SELECT delayed_insert_limit = @@session.delayed_insert_limit;
108
ERROR 42S22: Unknown column 'delayed_insert_limit' in 'field list'
109
SET @@global.delayed_insert_limit = @start_value;
110
SELECT @@global.delayed_insert_limit;
111
@@global.delayed_insert_limit