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;
38
SELECT @@global.innodb_max_purge_lag;
39
@@global.innodb_max_purge_lag
41
SET @@global.innodb_max_purge_lag = "T";
42
ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag'
43
SELECT @@global.innodb_max_purge_lag;
44
@@global.innodb_max_purge_lag
46
SET @@global.innodb_max_purge_lag = "Y";
47
ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag'
48
SELECT @@global.innodb_max_purge_lag;
49
@@global.innodb_max_purge_lag
51
SET @@global.innodb_max_purge_lag = 1001;
52
SELECT @@global.innodb_max_purge_lag;
53
@@global.innodb_max_purge_lag
55
'#----------------------FN_DYNVARS_046_05------------------------#'
56
SELECT @@global.innodb_max_purge_lag =
57
VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
58
WHERE VARIABLE_NAME='innodb_max_purge_lag';
59
@@global.innodb_max_purge_lag =
62
SELECT @@global.innodb_max_purge_lag;
63
@@global.innodb_max_purge_lag
65
SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
66
WHERE VARIABLE_NAME='innodb_max_purge_lag';
69
'#---------------------FN_DYNVARS_046_06-------------------------#'
70
SET @@global.innodb_max_purge_lag = OFF;
71
ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag'
72
SELECT @@global.innodb_max_purge_lag;
73
@@global.innodb_max_purge_lag
75
SET @@global.innodb_max_purge_lag = ON;
76
ERROR 42000: Incorrect argument type to variable 'innodb_max_purge_lag'
77
SELECT @@global.innodb_max_purge_lag;
78
@@global.innodb_max_purge_lag
80
'#---------------------FN_DYNVARS_046_07----------------------#'
81
SET @@global.innodb_max_purge_lag = TRUE;
82
SELECT @@global.innodb_max_purge_lag;
83
@@global.innodb_max_purge_lag
85
SET @@global.innodb_max_purge_lag = FALSE;
86
SELECT @@global.innodb_max_purge_lag;
87
@@global.innodb_max_purge_lag
89
SET @@global.innodb_max_purge_lag = @global_start_value;
90
SELECT @@global.innodb_max_purge_lag;
91
@@global.innodb_max_purge_lag