Re: group_concat_max_len
From: Jerry Stuckle <jstucklex_at_attglobal.net>
Date: Fri, 18 Sep 2015 08:30:49 -0400
Message-ID: <mth020$pn7$1_at_dont-email.me>
>> According to 'the manual' the default setting for this thing is 1024.
>> (
>> https://mariadb.com/kb/en/mariadb/server-system-variables/#group_concat_max_len
>>
>> )
>>
>> It seems NOT to have the value 1024, but it has the value 4.
>>
>> opensuse:/etc # grep -ir group_concat my*
>> opensuse:/etc # grep -ir group_concat my.cnf
>> opensuse:/etc # cd my.cnf.d/
>> opensuse:/etc/my.cnf.d # grep -ir group_concat *
>> opensuse:/etc/my.cnf.d # mysql test
>> Welcome to the MariaDB monitor. Commands end with ; or \g.
>> Your MariaDB connection id is 19
>> Server version: 5.5.44-MariaDB-log openSUSE package
>>
>> Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>> statement.
>>
>> MariaDB [test]> show variables like 'group_concat%';
>> +----------------------+-------+
>> | Variable_name | Value |
>> +----------------------+-------+
>> | group_concat_max_len | 4 |
>> +----------------------+-------+
>> 1 row in set (0.00 sec)
>>
>> MariaDB [test]>
>>
>> Which place am i overlooking?
Date: Fri, 18 Sep 2015 08:30:49 -0400
Message-ID: <mth020$pn7$1_at_dont-email.me>
On 9/18/2015 6:07 AM, Luuk wrote:
> On 18-09-15 11:57, Luuk wrote:
>> According to 'the manual' the default setting for this thing is 1024.
>> (
>> https://mariadb.com/kb/en/mariadb/server-system-variables/#group_concat_max_len
>>
>> )
>>
>> It seems NOT to have the value 1024, but it has the value 4.
>>
>> opensuse:/etc # grep -ir group_concat my*
>> opensuse:/etc # grep -ir group_concat my.cnf
>> opensuse:/etc # cd my.cnf.d/
>> opensuse:/etc/my.cnf.d # grep -ir group_concat *
>> opensuse:/etc/my.cnf.d # mysql test
>> Welcome to the MariaDB monitor. Commands end with ; or \g.
>> Your MariaDB connection id is 19
>> Server version: 5.5.44-MariaDB-log openSUSE package
>>
>> Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.
>>
>> Type 'help;' or '\h' for help. Type '\c' to clear the current input
>> statement.
>>
>> MariaDB [test]> show variables like 'group_concat%';
>> +----------------------+-------+
>> | Variable_name | Value |
>> +----------------------+-------+
>> | group_concat_max_len | 4 |
>> +----------------------+-------+
>> 1 row in set (0.00 sec)
>>
>> MariaDB [test]>
>>
>> Which place am i overlooking?
> > hmm, it this bug report i was overlooking..... > > > New: MariaDB group_concat_max_len option is set to 4 > http://lists.opensuse.org/archive/opensuse-bugs/2015-08/msg00522.html > >
It's 1024 in MySQL 5.6.11.
-- ================== Remove the "x" from my email address Jerry Stuckle jstucklex_at_attglobal.net ==================Received on Fri Sep 18 2015 - 14:30:49 CEST