Re: group_concat_max_len

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 Received on Fri Sep 18 2015 - 12:07:19 CEST