1SET @global_start_value = @@global.innodb_max_purge_lag;
2SELECT @global_start_value;
3@global_start_value
40
5'#--------------------FN_DYNVARS_046_01------------------------#'
6SET @@global.innodb_max_purge_lag = 0;
7SET @@global.innodb_max_purge_lag = DEFAULT;
8SELECT @@global.innodb_max_purge_lag;
9@@global.innodb_max_purge_lag
100
11'#---------------------FN_DYNVARS_046_02-------------------------#'
12SET innodb_max_purge_lag = 1;
13ERROR HY000: Variable 'innodb_max_purge_lag' is a GLOBAL variable and should be set with SET GLOBAL
14SELECT @@innodb_max_purge_lag;
15@@innodb_max_purge_lag
160
17SELECT local.innodb_max_purge_lag;
18ERROR 42S02: Unknown table 'local' in field list
19SET global innodb_max_purge_lag = 0;
20SELECT @@global.innodb_max_purge_lag;
21@@global.innodb_max_purge_lag
220
23'#--------------------FN_DYNVARS_046_03------------------------#'
24SET @@global.innodb_max_purge_lag = 0;
25SELECT @@global.innodb_max_purge_lag;
26@@global.innodb_max_purge_lag
270
28SET @@global.innodb_max_purge_lag = 1;
29SELECT @@global.innodb_max_purge_lag;
30@@global.innodb_max_purge_lag
311
32SET @@global.innodb_max_purge_lag = 4294967295;
33SELECT @@global.innodb_max_purge_lag;
34@@global.innodb_max_purge_lag
354294967295
36'#--------------------FN_DYNVARS_046_04------------------------#'
37SET @@global.innodb_max_purge_lag = 4294967296;
38SELECT @@global.innodb_max_purge_lag IN (4294967296,4294967295);
39@@global.innodb_max_purge_lag IN (4294967296,4294967295)
401
41SET @@global.innodb_max_purge_lag = 12345678901;
42SELECT @@global.innodb_max_purge_lag IN (12345678901,4294967295);
43@@global.innodb_max_purge_lag IN (12345678901,4294967295)
441
45SET @@global.innodb_max_purge_lag = 18446744073709551615;
46SELECT @@global.innodb_max_purge_lag IN (18446744073709551615,4294967295);
47@@global.innodb_max_purge_lag IN (18446744073709551615,4294967295)
481
49'#--------------------FN_DYNVARS_046_05-------------------------#'
50SET @@global.innodb_max_purge_lag = -1;
51Warnings:
52Warning	1292	Truncated incorrect innodb_max_purge_lag value: '-1'
53SELECT @@global.innodb_max_purge_lag;
54@@global.innodb_max_purge_lag
550
56SET @@global.innodb_max_purge_lag = -1024;
57Warnings:
58Warning	1292	Truncated incorrect innodb_max_purge_lag value: '-1024'
59SELECT @@global.innodb_max_purge_lag;
60@@global.innodb_max_purge_lag
610
62SET @@global.innodb_max_purge_lag = "T";
63ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag'
64SELECT @@global.innodb_max_purge_lag;
65@@global.innodb_max_purge_lag
660
67SET @@global.innodb_max_purge_lag = "Y";
68ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag'
69SELECT @@global.innodb_max_purge_lag;
70@@global.innodb_max_purge_lag
710
72SET @@global.innodb_max_purge_lag = 1.1;
73ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag'
74SELECT @@global.innodb_max_purge_lag;
75@@global.innodb_max_purge_lag
760
77SET @@global.innodb_max_purge_lag = ' ';
78ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag'
79SELECT @@global.innodb_max_purge_lag;
80@@global.innodb_max_purge_lag
810
82SET @@global.innodb_max_purge_lag = " ";
83ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag'
84SELECT @@global.innodb_max_purge_lag;
85@@global.innodb_max_purge_lag
860
87'#----------------------FN_DYNVARS_046_06------------------------#'
88SELECT @@global.innodb_max_purge_lag =
89VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
90WHERE VARIABLE_NAME='innodb_max_purge_lag';
91@@global.innodb_max_purge_lag =
92VARIABLE_VALUE
931
94SELECT @@global.innodb_max_purge_lag;
95@@global.innodb_max_purge_lag
960
97SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
98WHERE VARIABLE_NAME='innodb_max_purge_lag';
99VARIABLE_VALUE
1000
101'#---------------------FN_DYNVARS_046_07-------------------------#'
102SET @@global.innodb_max_purge_lag = OFF;
103ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag'
104SELECT @@global.innodb_max_purge_lag;
105@@global.innodb_max_purge_lag
1060
107SET @@global.innodb_max_purge_lag = ON;
108ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag'
109SELECT @@global.innodb_max_purge_lag;
110@@global.innodb_max_purge_lag
1110
112'#---------------------FN_DYNVARS_046_08----------------------#'
113SET @@global.innodb_max_purge_lag = TRUE;
114SELECT @@global.innodb_max_purge_lag;
115@@global.innodb_max_purge_lag
1161
117SET @@global.innodb_max_purge_lag = FALSE;
118SELECT @@global.innodb_max_purge_lag;
119@@global.innodb_max_purge_lag
1200
121SET @@global.innodb_max_purge_lag = @global_start_value;
122SELECT @@global.innodb_max_purge_lag;
123@@global.innodb_max_purge_lag
1240
125