Debian Codegraph @

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

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