Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_compression_pad_pct_max_basic.result

raw
1 SET @global_start_value = @@global.innodb_compression_pad_pct_max;
2 SELECT @global_start_value;
3 @global_start_value
4 50
5 '#--------------------FN_DYNVARS_046_01------------------------#'
6 SET @@global.innodb_compression_pad_pct_max = DEFAULT;
7 SELECT @@global.innodb_compression_pad_pct_max;
8 @@global.innodb_compression_pad_pct_max
9 50
10 '#---------------------FN_DYNVARS_046_02-------------------------#'
11 SET innodb_compression_pad_pct_max = 1;
12 ERROR HY000: Variable 'innodb_compression_pad_pct_max' is a GLOBAL variable and should be set with SET GLOBAL
13 SELECT @@innodb_compression_pad_pct_max;
14 @@innodb_compression_pad_pct_max
15 50
16 SELECT local.innodb_compression_pad_pct_max;
17 ERROR 42S02: Unknown table 'local' in field list
18 SET global innodb_compression_pad_pct_max = 0;
19 SELECT @@global.innodb_compression_pad_pct_max;
20 @@global.innodb_compression_pad_pct_max
21 0
22 '#--------------------FN_DYNVARS_046_03------------------------#'
23 SET @@global.innodb_compression_pad_pct_max = 0;
24 SELECT @@global.innodb_compression_pad_pct_max;
25 @@global.innodb_compression_pad_pct_max
26 0
27 SET @@global.innodb_compression_pad_pct_max = 75;
28 SELECT @@global.innodb_compression_pad_pct_max;
29 @@global.innodb_compression_pad_pct_max
30 75
31 '#--------------------FN_DYNVARS_046_04-------------------------#'
32 SET @@global.innodb_compression_pad_pct_max = -1;
33 Warnings:
34 Warning 1292 Truncated incorrect innodb_compression_pad_pct_max value: '-1'
35 SELECT @@global.innodb_compression_pad_pct_max;
36 @@global.innodb_compression_pad_pct_max
37 0
38 SET @@global.innodb_compression_pad_pct_max = "T";
39 ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max'
40 SELECT @@global.innodb_compression_pad_pct_max;
41 @@global.innodb_compression_pad_pct_max
42 0
43 SET @@global.innodb_compression_pad_pct_max = 1.1;
44 ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max'
45 SELECT @@global.innodb_compression_pad_pct_max;
46 @@global.innodb_compression_pad_pct_max
47 0
48 SET @@global.innodb_compression_pad_pct_max = 76;
49 Warnings:
50 Warning 1292 Truncated incorrect innodb_compression_pad_pct_max value: '76'
51 SELECT @@global.innodb_compression_pad_pct_max;
52 @@global.innodb_compression_pad_pct_max
53 75
54 SET @@global.innodb_compression_pad_pct_max = " ";
55 ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max'
56 SELECT @@global.innodb_compression_pad_pct_max;
57 @@global.innodb_compression_pad_pct_max
58 75
59 SET @@global.innodb_compression_pad_pct_max = ' ';
60 ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max'
61 SELECT @@global.innodb_compression_pad_pct_max;
62 @@global.innodb_compression_pad_pct_max
63 75
64 '#----------------------FN_DYNVARS_046_05------------------------#'
65 SELECT @@global.innodb_compression_pad_pct_max =
66 VARIABLE_VALUE FROM performance_schema.global_variables
67 WHERE VARIABLE_NAME='innodb_compression_pad_pct_max';
68 @@global.innodb_compression_pad_pct_max =
69 VARIABLE_VALUE
70 1
71 SELECT @@global.innodb_compression_pad_pct_max;
72 @@global.innodb_compression_pad_pct_max
73 75
74 SELECT VARIABLE_VALUE FROM performance_schema.global_variables
75 WHERE VARIABLE_NAME='innodb_compression_pad_pct_max';
76 VARIABLE_VALUE
77 75
78 '#---------------------FN_DYNVARS_046_06-------------------------#'
79 SET @@global.innodb_compression_pad_pct_max = OFF;
80 ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max'
81 SELECT @@global.innodb_compression_pad_pct_max;
82 @@global.innodb_compression_pad_pct_max
83 75
84 SET @@global.innodb_compression_pad_pct_max = ON;
85 ERROR 42000: Incorrect argument type to variable 'innodb_compression_pad_pct_max'
86 SELECT @@global.innodb_compression_pad_pct_max;
87 @@global.innodb_compression_pad_pct_max
88 75
89 '#---------------------FN_DYNVARS_046_07----------------------#'
90 SET @@global.innodb_compression_pad_pct_max = TRUE;
91 SELECT @@global.innodb_compression_pad_pct_max;
92 @@global.innodb_compression_pad_pct_max
93 1
94 SET @@global.innodb_compression_pad_pct_max = FALSE;
95 SELECT @@global.innodb_compression_pad_pct_max;
96 @@global.innodb_compression_pad_pct_max
97 0
98 SET @@global.innodb_compression_pad_pct_max = @global_start_value;
99 SELECT @@global.innodb_compression_pad_pct_max;
100 @@global.innodb_compression_pad_pct_max
101 50