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 1073741824
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 1073741824
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 Warnings:
21 Warning 1292 Truncated incorrect max_relay_log_size value: '0'
22 SELECT @@global.max_relay_log_size;
23 @@global.max_relay_log_size
24 4096
25 SET @@global.max_relay_log_size = 1;
26 Warnings:
27 Warning 1292 Truncated incorrect max_relay_log_size value: '1'
28 SELECT @@global.max_relay_log_size;
29 @@global.max_relay_log_size
30 4096
31 SET @@global.max_relay_log_size = 1073741824;
32 SELECT @@global.max_relay_log_size;
33 @@global.max_relay_log_size
34 1073741824
35 SET @@global.max_relay_log_size = 1073741823;
36 Warnings:
37 Warning 1292 Truncated incorrect max_relay_log_size value: '1073741823'
38 SELECT @@global.max_relay_log_size;
39 @@global.max_relay_log_size
40 1073737728
41 SET @@global.max_relay_log_size = 65535;
42 Warnings:
43 Warning 1292 Truncated incorrect max_relay_log_size value: '65535'
44 SELECT @@global.max_relay_log_size;
45 @@global.max_relay_log_size
46 61440
47 '#--------------------FN_DYNVARS_082_04-------------------------#'
48 SET @@global.max_relay_log_size = -1;
49 Warnings:
50 Warning 1292 Truncated incorrect max_relay_log_size value: '-1'
51 SELECT @@global.max_relay_log_size;
52 @@global.max_relay_log_size
53 4096
54 SET @@global.max_relay_log_size = 100000000000;
55 Warnings:
56 Warning 1292 Truncated incorrect max_relay_log_size value: '100000000000'
57 SELECT @@global.max_relay_log_size;
58 @@global.max_relay_log_size
59 1073741824
60 SET @@global.max_relay_log_size = 10000.01;
61 ERROR 42000: Incorrect argument type to variable 'max_relay_log_size'
62 SELECT @@global.max_relay_log_size;
63 @@global.max_relay_log_size
64 1073741824
65 SET @@global.max_relay_log_size = -1024;
66 Warnings:
67 Warning 1292 Truncated incorrect max_relay_log_size value: '-1024'
68 SELECT @@global.max_relay_log_size;
69 @@global.max_relay_log_size
70 4096
71 SET @@global.max_relay_log_size = 1073741825;
72 Warnings:
73 Warning 1292 Truncated incorrect max_relay_log_size value: '1073741825'
74 SELECT @@global.max_relay_log_size;
75 @@global.max_relay_log_size
76 1073741824
77 SET @@global.max_relay_log_size = 10737418241;
78 Warnings:
79 Warning 1292 Truncated incorrect max_relay_log_size value: '10737418241'
80 SELECT @@global.max_relay_log_size;
81 @@global.max_relay_log_size
82 1073741824
83 SET @@global.max_relay_log_size = ON;
84 ERROR 42000: Incorrect argument type to variable 'max_relay_log_size'
85 SELECT @@global.max_relay_log_size;
86 @@global.max_relay_log_size
87 1073741824
88 SET @@global.max_relay_log_size = 'test';
89 ERROR 42000: Incorrect argument type to variable 'max_relay_log_size'
90 SELECT @@global.max_relay_log_size;
91 @@global.max_relay_log_size
92 1073741824
93 '#-------------------FN_DYNVARS_082_05----------------------------#'
94 SET @@session.max_relay_log_size = 4096;
95 SELECT @@session.max_relay_log_size;
96 @@session.max_relay_log_size
97 4096
98 '#----------------------FN_DYNVARS_082_06------------------------#'
99 SELECT @@global.max_relay_log_size = VARIABLE_VALUE
100 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
101 WHERE VARIABLE_NAME='max_relay_log_size';
102 @@global.max_relay_log_size = VARIABLE_VALUE
103 1
104 SELECT @@max_relay_log_size = VARIABLE_VALUE
105 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
106 WHERE VARIABLE_NAME='max_relay_log_size';
107 @@max_relay_log_size = VARIABLE_VALUE
108 1
109 '#---------------------FN_DYNVARS_082_07----------------------#'
110 SET @@global.max_relay_log_size = TRUE;
111 Warnings:
112 Warning 1292 Truncated incorrect max_relay_log_size value: '1'
113 SELECT @@global.max_relay_log_size;
114 @@global.max_relay_log_size
115 4096
116 SET @@global.max_relay_log_size = FALSE;
117 Warnings:
118 Warning 1292 Truncated incorrect max_relay_log_size value: '0'
119 SELECT @@global.max_relay_log_size;
120 @@global.max_relay_log_size
121 4096
122 '#---------------------FN_DYNVARS_082_08----------------------#'
123 SET @@global.max_relay_log_size = 5000;
124 Warnings:
125 Warning 1292 Truncated incorrect max_relay_log_size value: '5000'
126 SELECT @@max_relay_log_size = @@global.max_relay_log_size;
127 @@max_relay_log_size = @@global.max_relay_log_size
128 1
129 '#---------------------FN_DYNVARS_082_09----------------------#'
130 SET max_relay_log_size = 6000;
131 Warnings:
132 Warning 1292 Truncated incorrect max_relay_log_size value: '6000'
133 SELECT @@max_relay_log_size;
134 @@max_relay_log_size
135 4096
136 SELECT local.max_relay_log_size;
137 ERROR 42S02: Unknown table 'local' in SELECT
138 SELECT global.max_relay_log_size;
139 ERROR 42S02: Unknown table 'global' in SELECT
140 SELECT max_relay_log_size = @@session.max_relay_log_size;
141 ERROR 42S22: Unknown column 'max_relay_log_size' in 'SELECT'
142 SET @@global.max_relay_log_size = @start_value;
143 SELECT @@global.max_relay_log_size;
144 @@global.max_relay_log_size
145 1073741824