Debian Codegraph @

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

raw
1 SET @start_max_binlog_cache_size = @@global.max_binlog_cache_size;
2 SELECT @start_max_binlog_cache_size;
3 @start_max_binlog_cache_size
4 18446744073709547520
5 SET @start_binlog_cache_size = @@global.binlog_cache_size;
6 SELECT @start_binlog_cache_size;
7 @start_binlog_cache_size
8 32768
9 '#--------------------FN_DYNVARS_072_01------------------------#'
10 SET @@global.max_binlog_cache_size = 5000;
11 Warnings:
12 Warning 1292 Truncated incorrect max_binlog_cache_size value: '5000'
13 Warning 1738 Option binlog_cache_size (32768) is greater than max_binlog_cache_size (4096); setting binlog_cache_size equal to max_binlog_cache_size.
14 SET @@global.max_binlog_cache_size = DEFAULT;
15 SELECT @@global.max_binlog_cache_size;
16 @@global.max_binlog_cache_size
17 18446744073709547520
18 '#---------------------FN_DYNVARS_072_02-------------------------#'
19 SET @@global.max_binlog_cache_size = @start_max_binlog_cache_size;
20 SELECT @@global.max_binlog_cache_size = 4294967295;
21 @@global.max_binlog_cache_size = 4294967295
22 0
23 '#--------------------FN_DYNVARS_072_03------------------------#'
24 SET @@global.max_binlog_cache_size = 4096;
25 SELECT @@global.max_binlog_cache_size;
26 @@global.max_binlog_cache_size
27 4096
28 SET @@global.max_binlog_cache_size = 4294967295;
29 Warnings:
30 Warning 1292 Truncated incorrect max_binlog_cache_size value: '4294967295'
31 SELECT @@global.max_binlog_cache_size;
32 @@global.max_binlog_cache_size
33 4294963200
34 SET @@global.max_binlog_cache_size = 4294967294;
35 Warnings:
36 Warning 1292 Truncated incorrect max_binlog_cache_size value: '4294967294'
37 SELECT @@global.max_binlog_cache_size;
38 @@global.max_binlog_cache_size
39 4294963200
40 SET @@global.max_binlog_cache_size = 4097;
41 Warnings:
42 Warning 1292 Truncated incorrect max_binlog_cache_size value: '4097'
43 SELECT @@global.max_binlog_cache_size;
44 @@global.max_binlog_cache_size
45 4096
46 SET @@global.max_binlog_cache_size = 65535;
47 Warnings:
48 Warning 1292 Truncated incorrect max_binlog_cache_size value: '65535'
49 SELECT @@global.max_binlog_cache_size;
50 @@global.max_binlog_cache_size
51 61440
52 '#--------------------FN_DYNVARS_072_04-------------------------#'
53 SET @@global.max_binlog_cache_size = -1;
54 Warnings:
55 Warning 1292 Truncated incorrect max_binlog_cache_size value: '-1'
56 SELECT @@global.max_binlog_cache_size;
57 @@global.max_binlog_cache_size
58 4096
59 SET @@global.max_binlog_cache_size = 100000000000;
60 Warnings:
61 Warning 1292 Truncated incorrect max_binlog_cache_size value: '100000000000'
62 SELECT @@global.max_binlog_cache_size;
63 @@global.max_binlog_cache_size
64 99999997952
65 SET @@global.max_binlog_cache_size = 10000.01;
66 ERROR 42000: Incorrect argument type to variable 'max_binlog_cache_size'
67 SELECT @@global.max_binlog_cache_size;
68 @@global.max_binlog_cache_size
69 99999997952
70 SET @@global.max_binlog_cache_size = -1024;
71 Warnings:
72 Warning 1292 Truncated incorrect max_binlog_cache_size value: '-1024'
73 SELECT @@global.max_binlog_cache_size;
74 @@global.max_binlog_cache_size
75 4096
76 SET @@global.max_binlog_cache_size = 1024;
77 Warnings:
78 Warning 1292 Truncated incorrect max_binlog_cache_size value: '1024'
79 SELECT @@global.max_binlog_cache_size;
80 @@global.max_binlog_cache_size
81 4096
82 SET @@global.max_binlog_cache_size = 4294967296;
83 SELECT @@global.max_binlog_cache_size;
84 @@global.max_binlog_cache_size
85 4294967296
86 SET @@global.max_binlog_cache_size = 4095;
87 Warnings:
88 Warning 1292 Truncated incorrect max_binlog_cache_size value: '4095'
89 SELECT @@global.max_binlog_cache_size;
90 @@global.max_binlog_cache_size
91 4096
92 SET @@global.max_binlog_cache_size = ON;
93 ERROR 42000: Incorrect argument type to variable 'max_binlog_cache_size'
94 SELECT @@global.max_binlog_cache_size;
95 @@global.max_binlog_cache_size
96 4096
97 SET @@global.max_binlog_cache_size = 'test';
98 ERROR 42000: Incorrect argument type to variable 'max_binlog_cache_size'
99 SELECT @@global.max_binlog_cache_size;
100 @@global.max_binlog_cache_size
101 4096
102 SET @@global.max_binlog_cache_size = ' ';
103 ERROR 42000: Incorrect argument type to variable 'max_binlog_cache_size'
104 SELECT @@global.max_binlog_cache_size;
105 @@global.max_binlog_cache_size
106 4096
107 '#-------------------FN_DYNVARS_072_05----------------------------#'
108 SET @@session.max_binlog_cache_size = 4096;
109 ERROR HY000: Variable 'max_binlog_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
110 SELECT @@session.max_binlog_cache_size;
111 ERROR HY000: Variable 'max_binlog_cache_size' is a GLOBAL variable
112 '#----------------------FN_DYNVARS_072_06------------------------#'
113 SELECT @@global.max_binlog_cache_size = VARIABLE_VALUE
114 FROM performance_schema.global_variables
115 WHERE VARIABLE_NAME='max_binlog_cache_size';
116 @@global.max_binlog_cache_size = VARIABLE_VALUE
117 1
118 SELECT @@max_binlog_cache_size = VARIABLE_VALUE
119 FROM performance_schema.session_variables
120 WHERE VARIABLE_NAME='max_binlog_cache_size';
121 @@max_binlog_cache_size = VARIABLE_VALUE
122 1
123 '#---------------------FN_DYNVARS_072_07----------------------#'
124 SET @@global.max_binlog_cache_size = TRUE;
125 Warnings:
126 Warning 1292 Truncated incorrect max_binlog_cache_size value: '1'
127 SELECT @@global.max_binlog_cache_size;
128 @@global.max_binlog_cache_size
129 4096
130 SET @@global.max_binlog_cache_size = FALSE;
131 Warnings:
132 Warning 1292 Truncated incorrect max_binlog_cache_size value: '0'
133 SELECT @@global.max_binlog_cache_size;
134 @@global.max_binlog_cache_size
135 4096
136 '#---------------------FN_DYNVARS_072_08----------------------#'
137 SET @@global.max_binlog_cache_size = 5000;
138 Warnings:
139 Warning 1292 Truncated incorrect max_binlog_cache_size value: '5000'
140 SELECT @@max_binlog_cache_size = @@global.max_binlog_cache_size;
141 @@max_binlog_cache_size = @@global.max_binlog_cache_size
142 1
143 '#---------------------FN_DYNVARS_072_09----------------------#'
144 SET max_binlog_cache_size = 6000;
145 ERROR HY000: Variable 'max_binlog_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
146 SELECT @@max_binlog_cache_size;
147 @@max_binlog_cache_size
148 4096
149 SET local.max_binlog_cache_size = 7000;
150 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.max_binlog_cache_size = 7000' at line 1
151 SELECT local.max_binlog_cache_size;
152 ERROR 42S02: Unknown table 'local' in field list
153 SET global.max_binlog_cache_size = 8000;
154 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.max_binlog_cache_size = 8000' at line 1
155 SELECT global.max_binlog_cache_size;
156 ERROR 42S02: Unknown table 'global' in field list
157 SELECT max_binlog_cache_size;
158 ERROR 42S22: Unknown column 'max_binlog_cache_size' in 'field list'
159 SELECT @@session.max_binlog_cache_size;
160 ERROR HY000: Variable 'max_binlog_cache_size' is a GLOBAL variable
161 SET @@global.max_binlog_cache_size = @start_max_binlog_cache_size;
162 SELECT @@global.max_binlog_cache_size;
163 @@global.max_binlog_cache_size
164 18446744073709547520
165 SET @@global.binlog_cache_size= @start_binlog_cache_size;
166 SELECT @@global.binlog_cache_size;
167 @@global.binlog_cache_size
168 32768