Debian Codegraph @

mysql-test/suite/sys_vars/r/binlog_cache_size_basic_64.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 SET @@global.binlog_cache_size = 18446744073709547520;
43 SELECT @@global.binlog_cache_size;
44 @@global.binlog_cache_size
45 18446744073709547520
46 '#--------------------FN_DYNVARS_006_04-------------------------#'
47 SET @@global.binlog_cache_size = 4095;
48 Warnings:
49 Warning 1292 Truncated incorrect binlog_cache_size value: '4095'
50 SELECT @@global.binlog_cache_size;
51 @@global.binlog_cache_size
52 4096
53 SET @@global.binlog_cache_size = 1024;
54 Warnings:
55 Warning 1292 Truncated incorrect binlog_cache_size value: '1024'
56 SELECT @@global.binlog_cache_size;
57 @@global.binlog_cache_size
58 4096
59 SET @@global.binlog_cache_size = 10000.01;
60 ERROR 42000: Incorrect argument type to variable 'binlog_cache_size'
61 SET @@global.binlog_cache_size = 0;
62 Warnings:
63 Warning 1292 Truncated incorrect binlog_cache_size value: '0'
64 SELECT @@global.binlog_cache_size;
65 @@global.binlog_cache_size
66 4096
67 SET @@global.binlog_cache_size = -1024;
68 Warnings:
69 Warning 1292 Truncated incorrect binlog_cache_size value: '-1024'
70 SELECT @@global.binlog_cache_size;
71 @@global.binlog_cache_size
72 4096
73 'Bug: Errors are not coming on assigning invalid values to variable'
74 SET @@global.binlog_cache_size = ON;
75 ERROR 42000: Incorrect argument type to variable 'binlog_cache_size'
76 SET @@global.binlog_cache_size = 'test';
77 ERROR 42000: Incorrect argument type to variable 'binlog_cache_size'
78 SET @@global.binlog_cache_size = 18446744073709547521;
79 Warnings:
80 Warning 1292 Truncated incorrect binlog_cache_size value: '18446744073709547521'
81 SELECT @@global.binlog_cache_size;
82 @@global.binlog_cache_size
83 18446744073709547520
84 '#-------------------FN_DYNVARS_006_05----------------------------#'
85 SET @@session.binlog_cache_size = 0;
86 ERROR HY000: Variable 'binlog_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
87 '#----------------------FN_DYNVARS_006_06------------------------#'
88 SET @@global.binlog_cache_size = 4294967295;
89 Warnings:
90 Warning 1292 Truncated incorrect binlog_cache_size value: '4294967295'
91 SELECT @@global.binlog_cache_size = VARIABLE_VALUE FROM performance_schema.global_variables WHERE VARIABLE_NAME='binlog_cache_size';
92 @@global.binlog_cache_size = VARIABLE_VALUE
93 1
94 '#---------------------FN_DYNVARS_006_07----------------------#'
95 SET @@global.binlog_cache_size = TRUE;
96 Warnings:
97 Warning 1292 Truncated incorrect binlog_cache_size value: '1'
98 SELECT @@global.binlog_cache_size;
99 @@global.binlog_cache_size
100 4096
101 SET @@global.binlog_cache_size = FALSE;
102 Warnings:
103 Warning 1292 Truncated incorrect binlog_cache_size value: '0'
104 SELECT @@global.binlog_cache_size;
105 @@global.binlog_cache_size
106 4096
107 'Bug: Errors are not coming on assigning TRUE/FALSE to variable'
108 '#---------------------FN_DYNVARS_006_08----------------------#'
109 SET @@global.binlog_cache_size = 1;
110 Warnings:
111 Warning 1292 Truncated incorrect binlog_cache_size value: '1'
112 SELECT @@binlog_cache_size = @@global.binlog_cache_size;
113 @@binlog_cache_size = @@global.binlog_cache_size
114 1
115 '#---------------------FN_DYNVARS_006_09----------------------#'
116 SET binlog_cache_size = 1;
117 ERROR HY000: Variable 'binlog_cache_size' is a GLOBAL variable and should be set with SET GLOBAL
118 SET global.binlog_cache_size = 1;
119 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
120 SELECT global.binlog_cache_size;
121 ERROR 42S02: Unknown table 'global' in field list
122 SELECT binlog_cache_size;
123 ERROR 42S22: Unknown column 'binlog_cache_size' in 'field list'
124 SELECT @@session.binlog_cache_size;
125 ERROR HY000: Variable 'binlog_cache_size' is a GLOBAL variable
126 SET @@global.binlog_cache_size = @start_value;
127 SELECT @@global.binlog_cache_size;
128 @@global.binlog_cache_size
129 32768