1SET @global_start_value = @@global.innodb_purge_batch_size;
2SELECT @global_start_value;
3@global_start_value
4300
5'#--------------------FN_DYNVARS_046_01------------------------#'
6SET @@global.innodb_purge_batch_size = 1;
7SET @@global.innodb_purge_batch_size = DEFAULT;
8SELECT @@global.innodb_purge_batch_size;
9@@global.innodb_purge_batch_size
10300
11'#---------------------FN_DYNVARS_046_02-------------------------#'
12SET innodb_purge_batch_size = 1;
13ERROR HY000: Variable 'innodb_purge_batch_size' is a GLOBAL variable and should be set with SET GLOBAL
14SELECT @@innodb_purge_batch_size;
15@@innodb_purge_batch_size
16300
17SELECT local.innodb_purge_batch_size;
18ERROR 42S02: Unknown table 'local' in field list
19SET global innodb_purge_batch_size = 1;
20SELECT @@global.innodb_purge_batch_size;
21@@global.innodb_purge_batch_size
221
23'#--------------------FN_DYNVARS_046_03------------------------#'
24SET @@global.innodb_purge_batch_size = 1;
25SELECT @@global.innodb_purge_batch_size;
26@@global.innodb_purge_batch_size
271
28SET @@global.innodb_purge_batch_size = 5000;
29SELECT @@global.innodb_purge_batch_size;
30@@global.innodb_purge_batch_size
315000
32SET @@global.innodb_purge_batch_size = 4294967295;
33Warnings:
34Warning	1292	Truncated incorrect innodb_purge_batch_size value: '4294967295'
35SELECT @@global.innodb_purge_batch_size;
36@@global.innodb_purge_batch_size
375000
38'#--------------------FN_DYNVARS_046_04-------------------------#'
39SET @@global.innodb_purge_batch_size = 0;
40Warnings:
41Warning	1292	Truncated incorrect innodb_purge_batch_size value: '0'
42SELECT @@global.innodb_purge_batch_size;
43@@global.innodb_purge_batch_size
441
45SET @@global.innodb_purge_batch_size = "T";
46ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size'
47SELECT @@global.innodb_purge_batch_size;
48@@global.innodb_purge_batch_size
491
50SET @@global.innodb_purge_batch_size = "Y";
51ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size'
52SELECT @@global.innodb_purge_batch_size;
53@@global.innodb_purge_batch_size
541
55SET @@global.innodb_purge_batch_size = ' ';
56ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size'
57SELECT @@global.innodb_purge_batch_size;
58@@global.innodb_purge_batch_size
591
60SET @@global.innodb_purge_batch_size = " ";
61ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size'
62SELECT @@global.innodb_purge_batch_size;
63@@global.innodb_purge_batch_size
641
65SET @@global.innodb_purge_batch_size = 1.1;
66ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size'
67SELECT @@global.innodb_purge_batch_size;
68@@global.innodb_purge_batch_size
691
70SET @@global.innodb_purge_batch_size = 4294967297;
71Warnings:
72Warning	1292	Truncated incorrect innodb_purge_batch_size value: '4294967297'
73SELECT @@global.innodb_purge_batch_size;
74@@global.innodb_purge_batch_size
755000
76'#----------------------FN_DYNVARS_046_05------------------------#'
77SELECT @@global.innodb_purge_batch_size =
78VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
79WHERE VARIABLE_NAME='innodb_purge_batch_size';
80@@global.innodb_purge_batch_size =
81VARIABLE_VALUE
821
83SELECT @@global.innodb_purge_batch_size;
84@@global.innodb_purge_batch_size
855000
86SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
87WHERE VARIABLE_NAME='innodb_purge_batch_size';
88VARIABLE_VALUE
895000
90'#---------------------FN_DYNVARS_046_06-------------------------#'
91SET @@global.innodb_purge_batch_size = OFF;
92ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size'
93SELECT @@global.innodb_purge_batch_size;
94@@global.innodb_purge_batch_size
955000
96SET @@global.innodb_purge_batch_size = ON;
97ERROR 42000: Incorrect argument type to variable 'innodb_purge_batch_size'
98SELECT @@global.innodb_purge_batch_size;
99@@global.innodb_purge_batch_size
1005000
101'#---------------------FN_DYNVARS_046_07----------------------#'
102SET @@global.innodb_purge_batch_size = TRUE;
103SELECT @@global.innodb_purge_batch_size;
104@@global.innodb_purge_batch_size
1051
106SET @@global.innodb_purge_batch_size = FALSE;
107Warnings:
108Warning	1292	Truncated incorrect innodb_purge_batch_size value: '0'
109SELECT @@global.innodb_purge_batch_size;
110@@global.innodb_purge_batch_size
1111
112SET @@global.innodb_purge_batch_size = @global_start_value;
113SELECT @@global.innodb_purge_batch_size;
114@@global.innodb_purge_batch_size
115300
116