Debian Codegraph @

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

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