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 Warnings:
8 Warning 4200 The setting 'innodb_purge_rseg_truncate_frequency' is ignored. It only exists for compatibility with old installations and will be removed in a future release
9 SET @@global.innodb_purge_rseg_truncate_frequency = DEFAULT;
10 Warnings:
11 Warning 4200 The setting 'innodb_purge_rseg_truncate_frequency' is ignored. It only exists for compatibility with old installations and will be removed in a future release
12 SELECT @@global.innodb_purge_rseg_truncate_frequency;
13 @@global.innodb_purge_rseg_truncate_frequency
14 128
15 '#---------------------FN_DYNVARS_046_02-------------------------#'
16 SET innodb_purge_rseg_truncate_frequency = 1;
17 ERROR HY000: Variable 'innodb_purge_rseg_truncate_frequency' is a GLOBAL variable and should be set with SET GLOBAL
18 SELECT @@innodb_purge_rseg_truncate_frequency;
19 @@innodb_purge_rseg_truncate_frequency
20 128
21 SELECT local.innodb_purge_rseg_truncate_frequency;
22 ERROR 42S02: Unknown table 'local' in SELECT
23 SET global innodb_purge_rseg_truncate_frequency = 1;
24 Warnings:
25 Warning 4200 The setting 'innodb_purge_rseg_truncate_frequency' is ignored. It only exists for compatibility with old installations and will be removed in a future release
26 SELECT @@global.innodb_purge_rseg_truncate_frequency;
27 @@global.innodb_purge_rseg_truncate_frequency
28 1
29 '#--------------------FN_DYNVARS_046_03------------------------#'
30 SET @@global.innodb_purge_rseg_truncate_frequency = 1;
31 Warnings:
32 Warning 4200 The setting 'innodb_purge_rseg_truncate_frequency' is ignored. It only exists for compatibility with old installations and will be removed in a future release
33 SELECT @@global.innodb_purge_rseg_truncate_frequency;
34 @@global.innodb_purge_rseg_truncate_frequency
35 1
36 SET @@global.innodb_purge_rseg_truncate_frequency = 1;
37 Warnings:
38 Warning 4200 The setting 'innodb_purge_rseg_truncate_frequency' is ignored. It only exists for compatibility with old installations and will be removed in a future release
39 SELECT @@global.innodb_purge_rseg_truncate_frequency;
40 @@global.innodb_purge_rseg_truncate_frequency
41 1
42 SET @@global.innodb_purge_rseg_truncate_frequency = 128;
43 Warnings:
44 Warning 4200 The setting 'innodb_purge_rseg_truncate_frequency' is ignored. It only exists for compatibility with old installations and will be removed in a future release
45 SELECT @@global.innodb_purge_rseg_truncate_frequency;
46 @@global.innodb_purge_rseg_truncate_frequency
47 128
48 '#--------------------FN_DYNVARS_046_05-------------------------#'
49 SET @@global.innodb_purge_rseg_truncate_frequency = -1;
50 Warnings:
51 Warning 4200 The setting 'innodb_purge_rseg_truncate_frequency' is ignored. It only exists for compatibility with old installations and will be removed in a future release
52 Warning 1292 Truncated incorrect innodb_purge_rseg_truncate_fr... value: '-1'
53 SELECT @@global.innodb_purge_rseg_truncate_frequency;
54 @@global.innodb_purge_rseg_truncate_frequency
55 1
56 SET @@global.innodb_purge_rseg_truncate_frequency = -1024;
57 Warnings:
58 Warning 4200 The setting 'innodb_purge_rseg_truncate_frequency' is ignored. It only exists for compatibility with old installations and will be removed in a future release
59 Warning 1292 Truncated incorrect innodb_purge_rseg_truncate_fr... value: '-1024'
60 SELECT @@global.innodb_purge_rseg_truncate_frequency;
61 @@global.innodb_purge_rseg_truncate_frequency
62 1
63 SET @@global.innodb_purge_rseg_truncate_frequency = "T";
64 ERROR 42000: Incorrect argument type to variable 'innodb_purge_rseg_truncate_frequency'
65 SELECT @@global.innodb_purge_rseg_truncate_frequency;
66 @@global.innodb_purge_rseg_truncate_frequency
67 1
68 SET @@global.innodb_purge_rseg_truncate_frequency = "Y";
69 ERROR 42000: Incorrect argument type to variable 'innodb_purge_rseg_truncate_frequency'
70 SELECT @@global.innodb_purge_rseg_truncate_frequency;
71 @@global.innodb_purge_rseg_truncate_frequency
72 1
73 SET @@global.innodb_purge_rseg_truncate_frequency = 1.1;
74 ERROR 42000: Incorrect argument type to variable 'innodb_purge_rseg_truncate_frequency'
75 SELECT @@global.innodb_purge_rseg_truncate_frequency;
76 @@global.innodb_purge_rseg_truncate_frequency
77 1
78 SET @@global.innodb_purge_rseg_truncate_frequency = ' ';
79 ERROR 42000: Incorrect argument type to variable 'innodb_purge_rseg_truncate_frequency'
80 SELECT @@global.innodb_purge_rseg_truncate_frequency;
81 @@global.innodb_purge_rseg_truncate_frequency
82 1
83 SET @@global.innodb_purge_rseg_truncate_frequency = " ";
84 ERROR 42000: Incorrect argument type to variable 'innodb_purge_rseg_truncate_frequency'
85 SELECT @@global.innodb_purge_rseg_truncate_frequency;
86 @@global.innodb_purge_rseg_truncate_frequency
87 1
88 '#----------------------FN_DYNVARS_046_06------------------------#'
89 SELECT @@global.innodb_purge_rseg_truncate_frequency =
90 VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
91 WHERE VARIABLE_NAME='innodb_purge_rseg_truncate_frequency';
92 @@global.innodb_purge_rseg_truncate_frequency =
93 VARIABLE_VALUE
94 1
95 SELECT @@global.innodb_purge_rseg_truncate_frequency;
96 @@global.innodb_purge_rseg_truncate_frequency
97 1
98 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
99 WHERE VARIABLE_NAME='innodb_purge_rseg_truncate_frequency';
100 VARIABLE_VALUE
101 1
102 '#---------------------FN_DYNVARS_046_07-------------------------#'
103 SET @@global.innodb_purge_rseg_truncate_frequency = OFF;
104 ERROR 42000: Incorrect argument type to variable 'innodb_purge_rseg_truncate_frequency'
105 SELECT @@global.innodb_purge_rseg_truncate_frequency;
106 @@global.innodb_purge_rseg_truncate_frequency
107 1
108 SET @@global.innodb_purge_rseg_truncate_frequency = ON;
109 ERROR 42000: Incorrect argument type to variable 'innodb_purge_rseg_truncate_frequency'
110 SELECT @@global.innodb_purge_rseg_truncate_frequency;
111 @@global.innodb_purge_rseg_truncate_frequency
112 1
113 '#---------------------FN_DYNVARS_046_08----------------------#'
114 SET @@global.innodb_purge_rseg_truncate_frequency = TRUE;
115 Warnings:
116 Warning 4200 The setting 'innodb_purge_rseg_truncate_frequency' is ignored. It only exists for compatibility with old installations and will be removed in a future release
117 SELECT @@global.innodb_purge_rseg_truncate_frequency;
118 @@global.innodb_purge_rseg_truncate_frequency
119 1
120 SET @@global.innodb_purge_rseg_truncate_frequency = FALSE;
121 Warnings:
122 Warning 4200 The setting 'innodb_purge_rseg_truncate_frequency' is ignored. It only exists for compatibility with old installations and will be removed in a future release
123 Warning 1292 Truncated incorrect innodb_purge_rseg_truncate_fr... value: '0'
124 SELECT @@global.innodb_purge_rseg_truncate_frequency;
125 @@global.innodb_purge_rseg_truncate_frequency
126 1
127 SET @@global.innodb_purge_rseg_truncate_frequency = @global_start_value;
128 Warnings:
129 Warning 4200 The setting 'innodb_purge_rseg_truncate_frequency' is ignored. It only exists for compatibility with old installations and will be removed in a future release
130 SELECT @@global.innodb_purge_rseg_truncate_frequency;
131 @@global.innodb_purge_rseg_truncate_frequency
132 128