1
SET @start_value = @@global.expire_logs_days;
5
'#--------------------FN_DYNVARS_029_01------------------------#'
6
SET @@global.expire_logs_days = 99;
7
SET @@global.expire_logs_days = DEFAULT;
8
SELECT @@global.expire_logs_days;
9
@@global.expire_logs_days
11
'#---------------------FN_DYNVARS_029_02-------------------------#'
12
SET @@global.expire_logs_days = @start_value;
13
SELECT @@global.expire_logs_days = 0;
14
@@global.expire_logs_days = 0
16
'#--------------------FN_DYNVARS_029_03------------------------#'
17
SET @@global.expire_logs_days = 0;
18
SELECT @@global.expire_logs_days;
19
@@global.expire_logs_days
21
SET @@global.expire_logs_days = 99;
22
SELECT @@global.expire_logs_days;
23
@@global.expire_logs_days
25
SET @@global.expire_logs_days = 10;
26
SELECT @@global.expire_logs_days;
27
@@global.expire_logs_days
29
SET @@global.expire_logs_days = 21;
30
SELECT @@global.expire_logs_days;
31
@@global.expire_logs_days
33
'#--------------------FN_DYNVARS_029_04-------------------------#'
34
SET @@global.expire_logs_days = -1;
35
SELECT @@global.expire_logs_days;
36
@@global.expire_logs_days
38
SET @@global.expire_logs_days = 100;
40
Warning 1292 Truncated incorrect expire_logs_days value: '100'
41
SELECT @@global.expire_logs_days;
42
@@global.expire_logs_days
44
SET @@global.expire_logs_days = 1024;
46
Warning 1292 Truncated incorrect expire_logs_days value: '1024'
47
SELECT @@global.expire_logs_days;
48
@@global.expire_logs_days
50
SET @@global.expire_logs_days = 10000.01;
51
ERROR 42000: Incorrect argument type to variable 'expire_logs_days'
52
SELECT @@global.expire_logs_days;
53
@@global.expire_logs_days
55
SET @@global.expire_logs_days = -1024;
56
SELECT @@global.expire_logs_days;
57
@@global.expire_logs_days
59
SET @@global.expire_logs_days = 42949672950;
61
Warning 1292 Truncated incorrect expire_logs_days value: '42949672950'
62
SELECT @@global.expire_logs_days;
63
@@global.expire_logs_days
65
'Bug # 34837: Errors are not coming on assigning invalid values to variable'
66
SET @@global.expire_logs_days = ON;
67
ERROR 42000: Incorrect argument type to variable 'expire_logs_days'
68
SELECT @@global.expire_logs_days;
69
@@global.expire_logs_days
71
SET @@global.expire_logs_days = 'test';
72
ERROR 42000: Incorrect argument type to variable 'expire_logs_days'
73
SELECT @@global.expire_logs_days;
74
@@global.expire_logs_days
76
'#-------------------FN_DYNVARS_029_05----------------------------#'
77
SET @@session.expire_logs_days = 0;
78
ERROR HY000: Variable 'expire_logs_days' is a GLOBAL variable and should be set with SET GLOBAL
79
SELECT @@expire_logs_days;
82
'#----------------------FN_DYNVARS_029_06------------------------#'
83
SELECT @@global.expire_logs_days = VARIABLE_VALUE
84
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
85
WHERE VARIABLE_NAME='expire_logs_days';
86
@@global.expire_logs_days = VARIABLE_VALUE
88
SELECT @@expire_logs_days = VARIABLE_VALUE
89
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
90
WHERE VARIABLE_NAME='expire_logs_days';
91
@@expire_logs_days = VARIABLE_VALUE
93
'#---------------------FN_DYNVARS_029_07----------------------#'
94
SET @@global.expire_logs_days = TRUE;
95
SELECT @@global.expire_logs_days;
96
@@global.expire_logs_days
98
SET @@global.expire_logs_days = FALSE;
99
SELECT @@global.expire_logs_days;
100
@@global.expire_logs_days
102
'#---------------------FN_DYNVARS_029_08----------------------#'
103
SET @@global.expire_logs_days = 1;
104
SELECT @@expire_logs_days = @@global.expire_logs_days;
105
@@expire_logs_days = @@global.expire_logs_days
107
'#---------------------FN_DYNVARS_029_09----------------------#'
108
SET expire_logs_days = 1;
109
ERROR HY000: Variable 'expire_logs_days' is a GLOBAL variable and should be set with SET GLOBAL
110
SELECT @@expire_logs_days;
113
SET local.expire_logs_days = 1;
114
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 'expire_logs_days = 1' at line 1
115
SELECT local.expire_logs_days;
116
ERROR 42S02: Unknown table 'local' in field list
117
SET global.expire_logs_days = 1;
118
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 'expire_logs_days = 1' at line 1
119
SELECT global.expire_logs_days;
120
ERROR 42S02: Unknown table 'global' in field list
121
SELECT expire_logs_days = @@session.expire_logs_days;
122
ERROR 42S22: Unknown column 'expire_logs_days' in 'field list'
123
SET @@global.expire_logs_days = @start_value;
124
SELECT @@global.expire_logs_days;
125
@@global.expire_logs_days