Debian Codegraph @

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

raw
1 SET @start_value = @@global.max_binlog_size;
2 SELECT @start_value;
3 @start_value
4 1073741824
5 '#--------------------FN_DYNVARS_072_01------------------------#'
6 SET @@global.max_binlog_size = 5000;
7 Warnings:
8 Warning 1292 Truncated incorrect max_binlog_size value: '5000'
9 SET @@global.max_binlog_size = DEFAULT;
10 SELECT @@global.max_binlog_size;
11 @@global.max_binlog_size
12 1073741824
13 '#---------------------FN_DYNVARS_072_02-------------------------#'
14 SET @@global.max_binlog_size = @start_value;
15 SELECT @@global.max_binlog_size = 1073741824;
16 @@global.max_binlog_size = 1073741824
17 1
18 '#--------------------FN_DYNVARS_072_03------------------------#'
19 SET @@global.max_binlog_size = 4096;
20 SELECT @@global.max_binlog_size;
21 @@global.max_binlog_size
22 4096
23 SET @@global.max_binlog_size = 1073741824;
24 SELECT @@global.max_binlog_size;
25 @@global.max_binlog_size
26 1073741824
27 SET @@global.max_binlog_size = 1073741823;
28 Warnings:
29 Warning 1292 Truncated incorrect max_binlog_size value: '1073741823'
30 SELECT @@global.max_binlog_size;
31 @@global.max_binlog_size
32 1073737728
33 SET @@global.max_binlog_size = 4097;
34 Warnings:
35 Warning 1292 Truncated incorrect max_binlog_size value: '4097'
36 SELECT @@global.max_binlog_size;
37 @@global.max_binlog_size
38 4096
39 SET @@global.max_binlog_size = 65535;
40 Warnings:
41 Warning 1292 Truncated incorrect max_binlog_size value: '65535'
42 SELECT @@global.max_binlog_size;
43 @@global.max_binlog_size
44 61440
45 '#--------------------FN_DYNVARS_072_04-------------------------#'
46 SET @@global.max_binlog_size = -1;
47 Warnings:
48 Warning 1292 Truncated incorrect max_binlog_size value: '-1'
49 SELECT @@global.max_binlog_size;
50 @@global.max_binlog_size
51 4096
52 SET @@global.max_binlog_size = 100000000000;
53 Warnings:
54 Warning 1292 Truncated incorrect max_binlog_size value: '100000000000'
55 SELECT @@global.max_binlog_size;
56 @@global.max_binlog_size
57 1073741824
58 SET @@global.max_binlog_size = 10000.01;
59 ERROR 42000: Incorrect argument type to variable 'max_binlog_size'
60 SELECT @@global.max_binlog_size;
61 @@global.max_binlog_size
62 1073741824
63 SET @@global.max_binlog_size = -1024;
64 Warnings:
65 Warning 1292 Truncated incorrect max_binlog_size value: '-1024'
66 SELECT @@global.max_binlog_size;
67 @@global.max_binlog_size
68 4096
69 SET @@global.max_binlog_size = 1024;
70 Warnings:
71 Warning 1292 Truncated incorrect max_binlog_size value: '1024'
72 SELECT @@global.max_binlog_size;
73 @@global.max_binlog_size
74 4096
75 SET @@global.max_binlog_size = 4294967296;
76 Warnings:
77 Warning 1292 Truncated incorrect max_binlog_size value: '4294967296'
78 SELECT @@global.max_binlog_size;
79 @@global.max_binlog_size
80 1073741824
81 SET @@global.max_binlog_size = 4095;
82 Warnings:
83 Warning 1292 Truncated incorrect max_binlog_size value: '4095'
84 SELECT @@global.max_binlog_size;
85 @@global.max_binlog_size
86 4096
87 SET @@global.max_binlog_size = ON;
88 ERROR 42000: Incorrect argument type to variable 'max_binlog_size'
89 SELECT @@global.max_binlog_size;
90 @@global.max_binlog_size
91 4096
92 SET @@global.max_binlog_size = 'test';
93 ERROR 42000: Incorrect argument type to variable 'max_binlog_size'
94 SELECT @@global.max_binlog_size;
95 @@global.max_binlog_size
96 4096
97 '#-------------------FN_DYNVARS_072_05----------------------------#'
98 SET @@session.max_binlog_size = 4096;
99 ERROR HY000: Variable 'max_binlog_size' is a GLOBAL variable and should be set with SET GLOBAL
100 SELECT @@session.max_binlog_size;
101 ERROR HY000: Variable 'max_binlog_size' is a GLOBAL variable
102 '#----------------------FN_DYNVARS_072_06------------------------#'
103 SELECT @@global.max_binlog_size = VARIABLE_VALUE
104 FROM performance_schema.global_variables
105 WHERE VARIABLE_NAME='max_binlog_size';
106 @@global.max_binlog_size = VARIABLE_VALUE
107 1
108 SELECT @@max_binlog_size = VARIABLE_VALUE
109 FROM performance_schema.session_variables
110 WHERE VARIABLE_NAME='max_binlog_size';
111 @@max_binlog_size = VARIABLE_VALUE
112 1
113 '#---------------------FN_DYNVARS_072_07----------------------#'
114 SET @@global.max_binlog_size = TRUE;
115 Warnings:
116 Warning 1292 Truncated incorrect max_binlog_size value: '1'
117 SELECT @@global.max_binlog_size;
118 @@global.max_binlog_size
119 4096
120 SET @@global.max_binlog_size = FALSE;
121 Warnings:
122 Warning 1292 Truncated incorrect max_binlog_size value: '0'
123 SELECT @@global.max_binlog_size;
124 @@global.max_binlog_size
125 4096
126 '#---------------------FN_DYNVARS_072_08----------------------#'
127 SET @@global.max_binlog_size = 5000;
128 Warnings:
129 Warning 1292 Truncated incorrect max_binlog_size value: '5000'
130 SELECT @@max_binlog_size = @@global.max_binlog_size;
131 @@max_binlog_size = @@global.max_binlog_size
132 1
133 '#---------------------FN_DYNVARS_072_09----------------------#'
134 SET max_binlog_size = 6000;
135 ERROR HY000: Variable 'max_binlog_size' is a GLOBAL variable and should be set with SET GLOBAL
136 SELECT @@max_binlog_size;
137 @@max_binlog_size
138 4096
139 SET local.max_binlog_size = 7000;
140 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_size = 7000' at line 1
141 SELECT local.max_binlog_size;
142 ERROR 42S02: Unknown table 'local' in field list
143 SET global.max_binlog_size = 8000;
144 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_size = 8000' at line 1
145 SELECT global.max_binlog_size;
146 ERROR 42S02: Unknown table 'global' in field list
147 SELECT max_binlog_size;
148 ERROR 42S22: Unknown column 'max_binlog_size' in 'field list'
149 SELECT @@session.max_binlog_size;
150 ERROR HY000: Variable 'max_binlog_size' is a GLOBAL variable
151 SET @@global.max_binlog_size = @start_value;
152 SELECT @@global.max_binlog_size;
153 @@global.max_binlog_size
154 1073741824