Re: group_concat_max_len
From: Luuk <luuk_at_invalid.lan>
Date: Fri, 18 Sep 2015 15:04:44 +0200
Message-ID: <55fc0bec$0$23762$e4fe514c_at_news.xs4all.nl>
>>> 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 15:04:44 +0200
Message-ID: <55fc0bec$0$23762$e4fe514c_at_news.xs4all.nl>
On 18-09-15 14:30, Jerry Stuckle wrote:
> 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. >
It's 1024 in MySQL 5.5.x tooo...... Received on Fri Sep 18 2015 - 15:04:44 CEST