1SET @global_start_value = @@global.innodb_compression_pad_pct_max;
2SELECT @global_start_value;
3@global_start_value
450
5'#--------------------FN_DYNVARS_046_01------------------------#'
6SET @@global.innodb_compression_pad_pct_max = DEFAULT;
7SELECT @@global.innodb_compression_pad_pct_max;
8@@global.innodb_compression_pad_pct_max
950
10'#---------------------FN_DYNVARS_046_02-------------------------#'
11SET innodb_compression_pad_pct_max = 1;
12ERROR HY000: Variable 'innodb_compression_pad_pct_max' is a GLOBAL variable and should be set with SET GLOBAL
13SELECT @@innodb_compression_pad_pct_max;
14@@innodb_compression_pad_pct_max
1550
16SELECT local.innodb_compression_pad_pct_max;
17ERROR 42S02: Unknown table 'local' in field list
18SET global innodb_compression_pad_pct_max = 0;
19SELECT @@global.innodb_compression_pad_pct_max;
20@@global.innodb_compression_pad_pct_max
210
22'#--------------------FN_DYNVARS_046_03------------------------#'
23SET @@global.innodb_compression_pad_pct_max = 0;
24SELECT @@global.innodb_compression_pad_pct_max;
25@@global.innodb_compression_pad_pct_max
260
27SET @@global.innodb_compression_pad_pct_max = 75;
28SELECT @@global.innodb_compression_pad_pct_max;
29@@global.innodb_compression_pad_pct_max
3075
31'#--------------------FN_DYNVARS_046_04-------------------------#'
32SET @@global.innodb_compression_pad_pct_max = -1;
33Warnings:
34Warning	1292	Truncated incorrect innodb_compression_pad_pct_max value: '-1'
35SELECT @@global.innodb_compression_pad_pct_max;
36@@global.innodb_compression_pad_pct_max
370
38SET @@global.innodb_compression_pad_pct_max = "T";
39ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max'
40SELECT @@global.innodb_compression_pad_pct_max;
41@@global.innodb_compression_pad_pct_max
420
43SET @@global.innodb_compression_pad_pct_max = 1.1;
44ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max'
45SELECT @@global.innodb_compression_pad_pct_max;
46@@global.innodb_compression_pad_pct_max
470
48SET @@global.innodb_compression_pad_pct_max = 76;
49Warnings:
50Warning	1292	Truncated incorrect innodb_compression_pad_pct_max value: '76'
51SELECT @@global.innodb_compression_pad_pct_max;
52@@global.innodb_compression_pad_pct_max
5375
54SET @@global.innodb_compression_pad_pct_max = " ";
55ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max'
56SELECT @@global.innodb_compression_pad_pct_max;
57@@global.innodb_compression_pad_pct_max
5875
59SET @@global.innodb_compression_pad_pct_max = ' ';
60ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max'
61SELECT @@global.innodb_compression_pad_pct_max;
62@@global.innodb_compression_pad_pct_max
6375
64'#----------------------FN_DYNVARS_046_05------------------------#'
65SELECT @@global.innodb_compression_pad_pct_max =
66VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
67WHERE VARIABLE_NAME='innodb_compression_pad_pct_max';
68@@global.innodb_compression_pad_pct_max =
69VARIABLE_VALUE
701
71SELECT @@global.innodb_compression_pad_pct_max;
72@@global.innodb_compression_pad_pct_max
7375
74SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
75WHERE VARIABLE_NAME='innodb_compression_pad_pct_max';
76VARIABLE_VALUE
7775
78'#---------------------FN_DYNVARS_046_06-------------------------#'
79SET @@global.innodb_compression_pad_pct_max = OFF;
80ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max'
81SELECT @@global.innodb_compression_pad_pct_max;
82@@global.innodb_compression_pad_pct_max
8375
84SET @@global.innodb_compression_pad_pct_max = ON;
85ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max'
86SELECT @@global.innodb_compression_pad_pct_max;
87@@global.innodb_compression_pad_pct_max
8875
89'#---------------------FN_DYNVARS_046_07----------------------#'
90SET @@global.innodb_compression_pad_pct_max = TRUE;
91SELECT @@global.innodb_compression_pad_pct_max;
92@@global.innodb_compression_pad_pct_max
931
94SET @@global.innodb_compression_pad_pct_max = FALSE;
95SELECT @@global.innodb_compression_pad_pct_max;
96@@global.innodb_compression_pad_pct_max
970
98SET @@global.innodb_compression_pad_pct_max = @global_start_value;
99SELECT @@global.innodb_compression_pad_pct_max;
100@@global.innodb_compression_pad_pct_max
10150
102