Debian Codegraph @

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

raw
1 SET @start_value = @@global.binlog_cache_size;
2 SELECT @start_value;
3 @start_value
4 32768
5 '#--------------------FN_DYNVARS_006_01------------------------#'
6 SET @@global.binlog_cache_size = 100;
7 Warnings:
8 Warning 1292 Truncated incorrect binlog_cache_size value: '100'
9 SET @@global.binlog_cache_size = DEFAULT;
10 SELECT @@global.binlog_cache_size;
11 @@global.binlog_cache_size
12 32768
13 '#---------------------FN_DYNVARS_006_02-------------------------#'
14 SET @@global.binlog_cache_size = @start_value;
15 SELECT @@global.binlog_cache_size = 32768;
16 @@global.binlog_cache_size = 32768
17 1
18 '#--------------------FN_DYNVARS_006_03------------------------#'
19 SET @@global.binlog_cache_size = 4096;
20 SELECT @@global.binlog_cache_size;
21 @@global.binlog_cache_size
22 4096
23 SET @@global.binlog_cache_size = 4294967295;
24 Warnings:
25 Warning 1292 Truncated incorrect binlog_cache_size value: '4294967295'
26 SELECT @@global.binlog_cache_size;
27 @@global.binlog_cache_size
28 4294963200
29 SET @@global.binlog_cache_size = 10000;
30 Warnings:
31 Warning 1292 Truncated incorrect binlog_cache_size value: '10000'
32 SELECT @@global.binlog_cache_size;
33 @@global.binlog_cache_size
34 8192
35 SET @@global.binlog_cache_size = 21221204;
36 Warnings:
37 Warning 1292 Truncated incorrect binlog_cache_size value: '21221204'
38 SELECT @@global.binlog_cache_size;
39 @@global.binlog_cache_size
40 21217280
41 'Bug: Invalid values are coming in variable on assigning valid values'
42 '#--------------------FN_DYNVARS_006_04-------------------------#'
43 SET @@global.binlog_cache_size = 4095;
44 Warnings:
45 Warning 1292 Truncated incorrect binlog_cache_size value: '4095'
46 SELECT @@global.binlog_cache_size;
47 @@global.binlog_cache_size
48 4096
49 SET @@global.binlog_cache_size = 1024;
50 Warnings:
51 Warning 1292 Truncated incorrect binlog_cache_size value: '1024'
52 SELECT @@global.binlog_cache_size;
53 @@global.binlog_cache_size
54 4096
55 SET @@global.binlog_cache_size = 10000.01;
56 ERROR 42000: Incorrect argument type to variable 'binlog_cache_size'
57 SET @@global.binlog_cache_size = 0;
58 Warnings:
59 Warning 1292 Truncated incorrect binlog_cache_size value: '0'
60 SELECT @@global.binlog_cache_size;
61 @@global.binlog_cache_size
62 4096
63 SET @@global.binlog_cache_size = -1024;
64 Warnings:
65 Warning 1292 Truncated incorrect binlog_cache_size value: '-1024'
66 SELECT @@global.binlog_cache_size;
67 @@global.binlog_cache_size
68 4096
69 'Bug: Errors are not coming on assigning invalid values to variable'
70 SET @@global.binlog_cache_size = ON;
71 ERROR 42000: Incorrect argument type to variable 'binlog_cache_size'
72 SET @@global.binlog_cache_size = 'test';
73 ERROR 42000: Incorrect argument type to variable 'binlog_cache_size'
74 SET @@global.binlog_cache_size = 4294967296;
75 Warnings:
76 Warning 1292 Truncated incorrect binlog_cache_size value: '4294967296'
77 SELECT @@global.binlog_cache_size;
78 @@global.binlog_cache_size
79 4294963200
80 SET @@global.binlog_cache_size = 42949672950;
81 Warnings:
82 Warning 1292 Truncated incorrect binlog_cache_size value: '42949672950'
83 SELECT @@global.binlog_cache_size;
84 @@global.binlog_cache_size
85 4294963200
86 '#-------------------FN_DYNVARS_006_05----------------------------#'
87 SET @@session.binlog_cache_size = 0;
88 ERROR HY000: Variable 'binlog_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
89 '#----------------------FN_DYNVARS_006_06------------------------#'
90 SET @@global.binlog_cache_size = 4294967295;
91 Warnings:
92 Warning 1292 Truncated incorrect binlog_cache_size value: '4294967295'
93 SELECT @@global.binlog_cache_size = VARIABLE_VALUE FROM performance_schema.global_variables WHERE VARIABLE_NAME='binlog_cache_size';
94 @@global.binlog_cache_size = VARIABLE_VALUE
95 1
96 '#---------------------FN_DYNVARS_006_07----------------------#'
97 SET @@global.binlog_cache_size = TRUE;
98 Warnings:
99 Warning 1292 Truncated incorrect binlog_cache_size value: '1'
100 SELECT @@global.binlog_cache_size;
101 @@global.binlog_cache_size
102 4096
103 SET @@global.binlog_cache_size = FALSE;
104 Warnings:
105 Warning 1292 Truncated incorrect binlog_cache_size value: '0'
106 SELECT @@global.binlog_cache_size;
107 @@global.binlog_cache_size
108 4096
109 'Bug: Errors are not coming on assigning TRUE/FALSE to variable'
110 '#---------------------FN_DYNVARS_006_08----------------------#'
111 SET @@global.binlog_cache_size = 1;
112 Warnings:
113 Warning 1292 Truncated incorrect binlog_cache_size value: '1'
114 SELECT @@binlog_cache_size = @@global.binlog_cache_size;
115 @@binlog_cache_size = @@global.binlog_cache_size
116 1
117 '#---------------------FN_DYNVARS_006_09----------------------#'
118 SET binlog_cache_size = 1;
119 ERROR HY000: Variable 'binlog_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
120 SET global.binlog_cache_size = 1;
121 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.binlog_cache_size = 1' at line 1
122 SELECT global.binlog_cache_size;
123 ERROR 42S02: Unknown table 'global' in field list
124 SELECT binlog_cache_size;
125 ERROR 42S22: Unknown column 'binlog_cache_size' in 'field list'
126 SELECT @@session.binlog_cache_size;
127 ERROR HY000: Variable 'binlog_cache_size' is a GLOBAL variable
128 SET @@global.binlog_cache_size = @start_value;
129 SELECT @@global.binlog_cache_size;
130 @@global.binlog_cache_size
131 32768