1SET @start_value = @@global.expire_logs_days;
2'#--------------------FN_DYNVARS_029_01------------------------#'
3SET @@global.expire_logs_days = 99;
4SET @@global.expire_logs_days = DEFAULT;
5SELECT @@global.expire_logs_days = 0;
6@@global.expire_logs_days = 0
71
8'#---------------------FN_DYNVARS_029_02-------------------------#'
9SET @@global.expire_logs_days = @start_value;
10SELECT @@global.expire_logs_days = @start_value;
11@@global.expire_logs_days = @start_value
121
13'#--------------------FN_DYNVARS_029_03------------------------#'
14SET @@global.expire_logs_days = 0;
15SELECT @@global.expire_logs_days;
16@@global.expire_logs_days
170
18SET @@global.expire_logs_days = 99;
19SELECT @@global.expire_logs_days;
20@@global.expire_logs_days
2199
22SET @@global.expire_logs_days = 10;
23SELECT @@global.expire_logs_days;
24@@global.expire_logs_days
2510
26SET @@global.expire_logs_days = 21;
27SELECT @@global.expire_logs_days;
28@@global.expire_logs_days
2921
30'#--------------------FN_DYNVARS_029_04-------------------------#'
31SET @@global.expire_logs_days = -1;
32Warnings:
33Warning	1292	Truncated incorrect expire_logs_days value: '-1'
34SELECT @@global.expire_logs_days;
35@@global.expire_logs_days
360
37SET @@global.expire_logs_days = 100;
38Warnings:
39Warning	1292	Truncated incorrect expire_logs_days value: '100'
40SELECT @@global.expire_logs_days;
41@@global.expire_logs_days
4299
43SET @@global.expire_logs_days = 1024;
44Warnings:
45Warning	1292	Truncated incorrect expire_logs_days value: '1024'
46SELECT @@global.expire_logs_days;
47@@global.expire_logs_days
4899
49SET @@global.expire_logs_days = 10000.01;
50ERROR 42000: Incorrect argument type to variable 'expire_logs_days'
51SELECT @@global.expire_logs_days;
52@@global.expire_logs_days
5399
54SET @@global.expire_logs_days = -1024;
55Warnings:
56Warning	1292	Truncated incorrect expire_logs_days value: '-1024'
57SELECT @@global.expire_logs_days;
58@@global.expire_logs_days
590
60SET @@global.expire_logs_days = 42949672950;
61Warnings:
62Warning	1292	Truncated incorrect expire_logs_days value: '42949672950'
63SELECT @@global.expire_logs_days;
64@@global.expire_logs_days
6599
66SET @@global.expire_logs_days = ON;
67ERROR 42000: Incorrect argument type to variable 'expire_logs_days'
68SELECT @@global.expire_logs_days;
69@@global.expire_logs_days
7099
71SET @@global.expire_logs_days = 'test';
72ERROR 42000: Incorrect argument type to variable 'expire_logs_days'
73SELECT @@global.expire_logs_days;
74@@global.expire_logs_days
7599
76'#-------------------FN_DYNVARS_029_05----------------------------#'
77SET @@session.expire_logs_days = 0;
78ERROR HY000: Variable 'expire_logs_days' is a GLOBAL variable and should be set with SET GLOBAL
79SELECT @@expire_logs_days;
80@@expire_logs_days
8199
82'#----------------------FN_DYNVARS_029_06------------------------#'
83SELECT @@global.expire_logs_days = VARIABLE_VALUE
84FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
85WHERE VARIABLE_NAME='expire_logs_days';
86@@global.expire_logs_days = VARIABLE_VALUE
871
88SELECT @@expire_logs_days = VARIABLE_VALUE
89FROM INFORMATION_SCHEMA.SESSION_VARIABLES
90WHERE VARIABLE_NAME='expire_logs_days';
91@@expire_logs_days = VARIABLE_VALUE
921
93'#---------------------FN_DYNVARS_029_07----------------------#'
94SET @@global.expire_logs_days = TRUE;
95SELECT @@global.expire_logs_days;
96@@global.expire_logs_days
971
98SET @@global.expire_logs_days = FALSE;
99SELECT @@global.expire_logs_days;
100@@global.expire_logs_days
1010
102'#---------------------FN_DYNVARS_029_08----------------------#'
103SET @@global.expire_logs_days = 1;
104SELECT @@expire_logs_days = @@global.expire_logs_days;
105@@expire_logs_days = @@global.expire_logs_days
1061
107'#---------------------FN_DYNVARS_029_09----------------------#'
108SET expire_logs_days = 1;
109ERROR HY000: Variable 'expire_logs_days' is a GLOBAL variable and should be set with SET GLOBAL
110SELECT @@expire_logs_days;
111@@expire_logs_days
1121
113SELECT local.expire_logs_days;
114ERROR 42S02: Unknown table 'local' in field list
115SELECT global.expire_logs_days;
116ERROR 42S02: Unknown table 'global' in field list
117SELECT expire_logs_days = @@session.expire_logs_days;
118ERROR 42S22: Unknown column 'expire_logs_days' in 'field list'
119SET @@global.expire_logs_days = @start_value;
120