Bug #74094 MySQL 5.7.5 m15: ANY_VALUE is not documented
Submitted: 26 Sep 2014 7:55 Modified: 30 Sep 2014 17:50
Reporter: Roland Bouman Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[26 Sep 2014 7:55] Roland Bouman
http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-5.html reads:

A new function, ANY_VALUE(), is available. Its return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL mode. The function does not make a nondeterministic query deterministic, but it can be used to force MySQL to accept queries that it thinks should be rejected with ONLY_FULL_GROUP_BY enabled.

This function is not yet described in the function reference.

How to repeat:
see http://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-5.html

Suggested fix:
Please document ANY_VALUE() in the function reference.

Note that ANY_VALUE is *not* itself an aggregate function. This makes it a bit awkward, since it only means something in combination with GROUP BY.

Perhaps the best place to document this would be in http://dev.mysql.com/doc/refman/5.7/en/group-by-extensions.html since this is a function unique to MySQL which relates exclusively to GROUP BY.
[26 Sep 2014 8:14] MySQL Verification Team
Hello Roland,

Thank you for the bug report.

[26 Sep 2014 8:15] MySQL Verification Team
I could get some hint here but again which are same as in milestone release note - http://dev.mysql.com/worklog/task/?id=2489
[30 Sep 2014 17:50] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly.