Re: group_concat_max_len

Luuk <luuk_at_invalid.lan> 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.

> MariaDB [test]> show variables like 'group_concat%';
> +----------------------+-------+
>| Variable_name | Value |
> +----------------------+-------+
>| group_concat_max_len | 4 |
> +----------------------+-------+

> Which place am i overlooking?

I cannot answer this. But I can tell you how to find out the compiled in defaults: run mysqld with the options --help -v. At the end there is a table listing all server variables and their defaults.

I.e. for MariaDB-5.5.27 (an old bzr build) I get:

/usr/local/mysql/maria-5.5 $libexec/mysqld --no-defaults --help -v \ | fgrep group-concat-max-len
...

group-concat-max-len                              1024

XL Received on Thu Oct 08 2015 - 09:40:19 CEST