1SET @start_value = @@global.expire_logs_days;
2SELECT @start_value;
3@start_value
40
5'#--------------------FN_DYNVARS_029_01------------------------#'
6SET @@global.expire_logs_days = 99;
7SET @@global.expire_logs_days = DEFAULT;
8SELECT @@global.expire_logs_days;
9@@global.expire_logs_days
100
11'#---------------------FN_DYNVARS_029_02-------------------------#'
12SET @@global.expire_logs_days = @start_value;
13SELECT @@global.expire_logs_days = 0;
14@@global.expire_logs_days = 0
151
16'#--------------------FN_DYNVARS_029_03------------------------#'
17SET @@global.expire_logs_days = 0;
18SELECT @@global.expire_logs_days;
19@@global.expire_logs_days
200
21SET @@global.expire_logs_days = 99;
22SELECT @@global.expire_logs_days;
23@@global.expire_logs_days
2499
25SET @@global.expire_logs_days = 10;
26SELECT @@global.expire_logs_days;
27@@global.expire_logs_days
2810
29SET @@global.expire_logs_days = 21;
30SELECT @@global.expire_logs_days;
31@@global.expire_logs_days
3221
33'#--------------------FN_DYNVARS_029_04-------------------------#'
34SET @@global.expire_logs_days = -1;
35Warnings:
36Warning	1292	Truncated incorrect expire_logs_days value: '-1'
37SELECT @@global.expire_logs_days;
38@@global.expire_logs_days
390
40SET @@global.expire_logs_days = 100;
41Warnings:
42Warning	1292	Truncated incorrect expire_logs_days value: '100'
43SELECT @@global.expire_logs_days;
44@@global.expire_logs_days
4599
46SET @@global.expire_logs_days = 1024;
47Warnings:
48Warning	1292	Truncated incorrect expire_logs_days value: '1024'
49SELECT @@global.expire_logs_days;
50@@global.expire_logs_days
5199
52SET @@global.expire_logs_days = 10000.01;
53ERROR 42000: Incorrect argument type to variable 'expire_logs_days'
54SELECT @@global.expire_logs_days;
55@@global.expire_logs_days
5699
57SET @@global.expire_logs_days = -1024;
58Warnings:
59Warning	1292	Truncated incorrect expire_logs_days value: '-1024'
60SELECT @@global.expire_logs_days;
61@@global.expire_logs_days
620
63SET @@global.expire_logs_days = 42949672950;
64Warnings:
65Warning	1292	Truncated incorrect expire_logs_days value: '42949672950'
66SELECT @@global.expire_logs_days;
67@@global.expire_logs_days
6899
69SET @@global.expire_logs_days = ON;
70ERROR 42000: Incorrect argument type to variable 'expire_logs_days'
71SELECT @@global.expire_logs_days;
72@@global.expire_logs_days
7399
74SET @@global.expire_logs_days = 'test';
75ERROR 42000: Incorrect argument type to variable 'expire_logs_days'
76SELECT @@global.expire_logs_days;
77@@global.expire_logs_days
7899
79'#-------------------FN_DYNVARS_029_05----------------------------#'
80SET @@session.expire_logs_days = 0;
81ERROR HY000: Variable 'expire_logs_days' is a GLOBAL variable and should be set with SET GLOBAL
82SELECT @@expire_logs_days;
83@@expire_logs_days
8499
85'#----------------------FN_DYNVARS_029_06------------------------#'
86SELECT @@global.expire_logs_days = VARIABLE_VALUE
87FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
88WHERE VARIABLE_NAME='expire_logs_days';
89@@global.expire_logs_days = VARIABLE_VALUE
901
91SELECT @@expire_logs_days = VARIABLE_VALUE
92FROM INFORMATION_SCHEMA.SESSION_VARIABLES
93WHERE VARIABLE_NAME='expire_logs_days';
94@@expire_logs_days = VARIABLE_VALUE
951
96'#---------------------FN_DYNVARS_029_07----------------------#'
97SET @@global.expire_logs_days = TRUE;
98SELECT @@global.expire_logs_days;
99@@global.expire_logs_days
1001
101SET @@global.expire_logs_days = FALSE;
102SELECT @@global.expire_logs_days;
103@@global.expire_logs_days
1040
105'#---------------------FN_DYNVARS_029_08----------------------#'
106SET @@global.expire_logs_days = 1;
107SELECT @@expire_logs_days = @@global.expire_logs_days;
108@@expire_logs_days = @@global.expire_logs_days
1091
110'#---------------------FN_DYNVARS_029_09----------------------#'
111SET expire_logs_days = 1;
112ERROR HY000: Variable 'expire_logs_days' is a GLOBAL variable and should be set with SET GLOBAL
113SELECT @@expire_logs_days;
114@@expire_logs_days
1151
116SET local.expire_logs_days = 1;
117ERROR 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.expire_logs_days = 1' at line 1
118SELECT local.expire_logs_days;
119ERROR 42S02: Unknown table 'local' in field list
120SET global.expire_logs_days = 1;
121ERROR 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.expire_logs_days = 1' at line 1
122SELECT global.expire_logs_days;
123ERROR 42S02: Unknown table 'global' in field list
124SELECT expire_logs_days = @@session.expire_logs_days;
125ERROR 42S22: Unknown column 'expire_logs_days' in 'field list'
126SET @@global.expire_logs_days = @start_value;
127SELECT @@global.expire_logs_days;
128@@global.expire_logs_days
1290
130