Re: group_concat_max_len

On 08-10-15 09:40, Axel Schwenke wrote:
> 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
>

since my OP, there has been an update which should have solved the problem.

i did not test it, because i have the line: group_concat_max_len = 1024
in my /etc/my.cnf.d/my-add.cnf

;) Received on Thu Oct 08 2015 - 21:56:39 CEST