Debian Codegraph @

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

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