Debian Codegraph @

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

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