Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.group_concat_max_len;
2 SELECT @start_global_value;
3 @start_global_value
4 1024
5 SET @start_session_value = @@session.group_concat_max_len;
6 SELECT @start_session_value;
7 @start_session_value
8 1024
9 '#--------------------FN_DYNVARS_034_01-------------------------#'
10 SET @@global.group_concat_max_len = 100;
11 SET @@global.group_concat_max_len = DEFAULT;
12 SELECT @@global.group_concat_max_len;
13 @@global.group_concat_max_len
14 1024
15 SET @@session.group_concat_max_len = 200;
16 SET @@session.group_concat_max_len = DEFAULT;
17 SELECT @@session.group_concat_max_len;
18 @@session.group_concat_max_len
19 1024
20 '#--------------------FN_DYNVARS_034_02-------------------------#'
21 SET @@global.group_concat_max_len = DEFAULT;
22 SELECT @@global.group_concat_max_len = 1;
23 @@global.group_concat_max_len = 1
24 0
25 SET @@session.group_concat_max_len = DEFAULT;
26 SELECT @@session.group_concat_max_len = 1;
27 @@session.group_concat_max_len = 1
28 0
29 '#--------------------FN_DYNVARS_034_03-------------------------#'
30 SET @@global.group_concat_max_len = 1;
31 Warnings:
32 Warning 1292 Truncated incorrect group_concat_max_len value: '1'
33 SELECT @@global.group_concat_max_len;
34 @@global.group_concat_max_len
35 4
36 SET @@global.group_concat_max_len = 60020;
37 SELECT @@global.group_concat_max_len;
38 @@global.group_concat_max_len
39 60020
40 SET @@global.group_concat_max_len = 65535;
41 SELECT @@global.group_concat_max_len;
42 @@global.group_concat_max_len
43 65535
44 '#--------------------FN_DYNVARS_034_04-------------------------#'
45 SET @@session.group_concat_max_len = 1;
46 Warnings:
47 Warning 1292 Truncated incorrect group_concat_max_len value: '1'
48 SELECT @@session.group_concat_max_len;
49 @@session.group_concat_max_len
50 4
51 SET @@session.group_concat_max_len = 50050;
52 SELECT @@session.group_concat_max_len;
53 @@session.group_concat_max_len
54 50050
55 SET @@session.group_concat_max_len = 65535;
56 SELECT @@session.group_concat_max_len;
57 @@session.group_concat_max_len
58 65535
59 '#------------------FN_DYNVARS_034_05-----------------------#'
60 SET @@global.group_concat_max_len = 0;
61 Warnings:
62 Warning 1292 Truncated incorrect group_concat_max_len value: '0'
63 SELECT @@global.group_concat_max_len;
64 @@global.group_concat_max_len
65 4
66 SET @@global.group_concat_max_len = -1024;
67 Warnings:
68 Warning 1292 Truncated incorrect group_concat_max_len value: '-1024'
69 SELECT @@global.group_concat_max_len;
70 @@global.group_concat_max_len
71 4
72 SET @@global.group_concat_max_len = 65536;
73 SELECT @@global.group_concat_max_len;
74 @@global.group_concat_max_len
75 65536
76 SET @@global.group_concat_max_len = 65530.34;
77 ERROR 42000: Incorrect argument type to variable 'group_concat_max_len'
78 SELECT @@global.group_concat_max_len;
79 @@global.group_concat_max_len
80 65536
81 SET @@global.group_concat_max_len = test;
82 ERROR 42000: Incorrect argument type to variable 'group_concat_max_len'
83 SELECT @@global.group_concat_max_len;
84 @@global.group_concat_max_len
85 65536
86 SET @@session.group_concat_max_len = 0;
87 Warnings:
88 Warning 1292 Truncated incorrect group_concat_max_len value: '0'
89 SELECT @@session.group_concat_max_len;
90 @@session.group_concat_max_len
91 4
92 SET @@session.group_concat_max_len = -2;
93 Warnings:
94 Warning 1292 Truncated incorrect group_concat_max_len value: '-2'
95 SELECT @@session.group_concat_max_len;
96 @@session.group_concat_max_len
97 4
98 SET @@session.group_concat_max_len = 65530.34;
99 ERROR 42000: Incorrect argument type to variable 'group_concat_max_len'
100 SET @@session.group_concat_max_len = 65550;
101 SELECT @@session.group_concat_max_len;
102 @@session.group_concat_max_len
103 65550
104 SET @@session.group_concat_max_len = test;
105 ERROR 42000: Incorrect argument type to variable 'group_concat_max_len'
106 SELECT @@session.group_concat_max_len;
107 @@session.group_concat_max_len
108 65550
109 '#------------------FN_DYNVARS_034_06-----------------------#'
110 SELECT @@global.group_concat_max_len = VARIABLE_VALUE
111 FROM performance_schema.global_variables
112 WHERE VARIABLE_NAME='group_concat_max_len';
113 @@global.group_concat_max_len = VARIABLE_VALUE
114 1
115 '#------------------FN_DYNVARS_034_07-----------------------#'
116 SELECT @@session.group_concat_max_len = VARIABLE_VALUE
117 FROM performance_schema.session_variables
118 WHERE VARIABLE_NAME='group_concat_max_len';
119 @@session.group_concat_max_len = VARIABLE_VALUE
120 1
121 '#------------------FN_DYNVARS_034_08-----------------------#'
122 SET @@global.group_concat_max_len = TRUE;
123 Warnings:
124 Warning 1292 Truncated incorrect group_concat_max_len value: '1'
125 SELECT @@global.group_concat_max_len;
126 @@global.group_concat_max_len
127 4
128 SET @@global.group_concat_max_len = FALSE;
129 Warnings:
130 Warning 1292 Truncated incorrect group_concat_max_len value: '0'
131 SELECT @@global.group_concat_max_len;
132 @@global.group_concat_max_len
133 4
134 '#---------------------FN_DYNVARS_001_09----------------------#'
135 SET @@global.group_concat_max_len = 10;
136 SELECT @@group_concat_max_len = @@global.group_concat_max_len;
137 @@group_concat_max_len = @@global.group_concat_max_len
138 0
139 '#---------------------FN_DYNVARS_001_10----------------------#'
140 SET @@group_concat_max_len = 100;
141 SELECT @@group_concat_max_len = @@local.group_concat_max_len;
142 @@group_concat_max_len = @@local.group_concat_max_len
143 1
144 SELECT @@local.group_concat_max_len = @@session.group_concat_max_len;
145 @@local.group_concat_max_len = @@session.group_concat_max_len
146 1
147 '#---------------------FN_DYNVARS_001_11----------------------#'
148 SET group_concat_max_len = 1;
149 Warnings:
150 Warning 1292 Truncated incorrect group_concat_max_len value: '1'
151 SELECT @@group_concat_max_len;
152 @@group_concat_max_len
153 4
154 SELECT local.group_concat_max_len;
155 ERROR 42S02: Unknown table 'local' in field list
156 SELECT session.group_concat_max_len;
157 ERROR 42S02: Unknown table 'session' in field list
158 SELECT group_concat_max_len = @@session.group_concat_max_len;
159 ERROR 42S22: Unknown column 'group_concat_max_len' in 'field list'
160 SET @@global.group_concat_max_len = @start_global_value;
161 SELECT @@global.group_concat_max_len;
162 @@global.group_concat_max_len
163 1024
164 SET @@session.group_concat_max_len = @start_session_value;
165 SELECT @@session.group_concat_max_len;
166 @@session.group_concat_max_len
167 1024