group_concat_max_len

From: Luuk <luuk_at_invalid.lan>
Date: Fri, 18 Sep 2015 11:57:22 +0200
Message-ID: <55fbdff8$0$23858$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? Received on Fri Sep 18 2015 - 11:57:22 CEST