MySQL shouldn't "guess" at the variable names

[Vadim Tkachenko]

(reported by Sheeri K. Cabral )

I did not know how to file a bug report against a Percona build of MySQL (not xtradb, that has a launchpad page...). If there could be a clear place on the Percona Labs page, or the documentation page at http://www.percona.com/docs/wiki/patches:start, that would be helpful.
Anyway, here's the bug. group_concat_max_len for some reason isn't set properly, even when it's explicitly set in the /etc/my.cnf (the default is 1024, and we get these errors no matter what we set the group_concat_max_len value in /etc/my.cnf to):

Version: '5.1.33-percona-log' socket: '/mysql/data/mysql.sock' port: 3306 MySQL Community Server (GPL)
090504 8:26:59 [Warning] option 'group_concat_max_len': unsigned value 0 adjusted to 4

[pythian@db02 avail_mysql]$ grep concat /etc/my.cnf
group_concat_max_len=1024

Please let me know if you need any additional information, or if there's an actual bug tracker that I've missed....

We've also seen this in:
5.0.67-d7-ourdelta-sail44-log
and
5.0.67-percona-highperf-b10-log

[Sheeri K. Cabral (awfief)]

I believe this is actually MySQL's fault:

http://bugs.mysql.com/bug.php?id=45379

The response is:

are you sure this is a bug and not just a confusion. options have always been
recognised by their shortest non-ambiguous versions. "group=mysql" is actually
seen as "group_concat_max_len=mysql".

---------------

which is ridiculous -- if there's confusion, then by definition, it's not "non-ambiguous".

(I'd appreciate it if folks could add a comment to http://bugs.mysql.com/bug.php?id=45379)

[Stewart Smith (stewart)]

I've moved to percona-server project as percona-patches is long obsolete.

[linzuxiong (linzuxiong1988)]

2015-06-29 18:14:22 0 [Warning] Using unique option prefix group instead of group_concat_max_len is deprecated and will be removed in a future release. Please use the full name instead.
2015-06-29 18:14:22 0 [Warning] option 'group_concat_max_len': unsigned value 0 adjusted to 4

2015-06-29 18:14:24 41806 [Warning] 'proxies_priv' entry '@ root@youzan' ignored in --skip-name-resolve mode.
2015-06-29 18:14:24 41806 [Note] /opt/percona-server-5.6.24-72.2/bin/mysqld: ready for connections.

--------------------------------

percona-server 5.6.24-72.2

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1828