1
SET @global_start_value = @@global.innodb_max_purge_lag;
2
SELECT @global_start_value;
5
'#--------------------FN_DYNVARS_046_01------------------------#'
6
SET @@global.innodb_max_purge_lag = 0;
7
SET @@global.innodb_max_purge_lag = DEFAULT;
8
SELECT @@global.innodb_max_purge_lag;
9
@@global.innodb_max_purge_lag
11
'#---------------------FN_DYNVARS_046_02-------------------------#'
12
SET innodb_max_purge_lag = 1;
13
ERROR HY000: Variable 'innodb_max_purge_lag' is a GLOBAL variable and should be set with SET GLOBAL
14
SELECT @@innodb_max_purge_lag;
15
@@innodb_max_purge_lag
17
SELECT local.innodb_max_purge_lag;
18
ERROR 42S02: Unknown table 'local' in field list
19
SET global innodb_max_purge_lag = 0;
20
SELECT @@global.innodb_max_purge_lag;
21
@@global.innodb_max_purge_lag
23
'#--------------------FN_DYNVARS_046_03------------------------#'
24
SET @@global.innodb_max_purge_lag = 0;
25
SELECT @@global.innodb_max_purge_lag;
26
@@global.innodb_max_purge_lag
28
SET @@global.innodb_max_purge_lag = 1;
29
SELECT @@global.innodb_max_purge_lag;
30
@@global.innodb_max_purge_lag
32
SET @@global.innodb_max_purge_lag = 4294967295;
33
SELECT @@global.innodb_max_purge_lag;
34
@@global.innodb_max_purge_lag
36
'#--------------------FN_DYNVARS_046_04-------------------------#'
37
SET @@global.innodb_max_purge_lag = -1;
39
Warning 1292 Truncated incorrect max_purge_lag value: '18446744073709551615'
40
SELECT @@global.innodb_max_purge_lag;
41
@@global.innodb_max_purge_lag
43
SET @@global.innodb_max_purge_lag = "T";
44
ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag'
45
SELECT @@global.innodb_max_purge_lag;
46
@@global.innodb_max_purge_lag
48
SET @@global.innodb_max_purge_lag = "Y";
49
ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag'
50
SELECT @@global.innodb_max_purge_lag;
51
@@global.innodb_max_purge_lag
53
SET @@global.innodb_max_purge_lag = 1001;
54
SELECT @@global.innodb_max_purge_lag;
55
@@global.innodb_max_purge_lag
57
'#----------------------FN_DYNVARS_046_05------------------------#'
58
SELECT @@global.innodb_max_purge_lag =
59
VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
60
WHERE VARIABLE_NAME='innodb_max_purge_lag';
61
@@global.innodb_max_purge_lag =
64
SELECT @@global.innodb_max_purge_lag;
65
@@global.innodb_max_purge_lag
67
SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
68
WHERE VARIABLE_NAME='innodb_max_purge_lag';
71
'#---------------------FN_DYNVARS_046_06-------------------------#'
72
SET @@global.innodb_max_purge_lag = OFF;
73
ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag'
74
SELECT @@global.innodb_max_purge_lag;
75
@@global.innodb_max_purge_lag
77
SET @@global.innodb_max_purge_lag = ON;
78
ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag'
79
SELECT @@global.innodb_max_purge_lag;
80
@@global.innodb_max_purge_lag
82
'#---------------------FN_DYNVARS_046_07----------------------#'
83
SET @@global.innodb_max_purge_lag = TRUE;
84
SELECT @@global.innodb_max_purge_lag;
85
@@global.innodb_max_purge_lag
87
SET @@global.innodb_max_purge_lag = FALSE;
88
SELECT @@global.innodb_max_purge_lag;
89
@@global.innodb_max_purge_lag
91
SET @@global.innodb_max_purge_lag = @global_start_value;
92
SELECT @@global.innodb_max_purge_lag;
93
@@global.innodb_max_purge_lag