Bug #29317 COUNT() listed in other functions

• Submitted: 23 Jun 2007 13:42
• Modified: 25 Jun 2007 13:05
• Reporter: Jakub Vrana (Candidate Quality Contributor)
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.0
• OS: Any
• Assigned to: Peter Lavin
• CPU Architecture: Any
• Tags: qc

[23 Jun 2007 13:42] Jakub Vrana

Description:
In the table on Other Functions, there is listed the COUNT() function which belongs to GROUP BY functions. In the table on GROUP BY (Aggregate) Functions, the COUNT() function is missing.

How to repeat:
http://dev.mysql.com/doc/refman/5.0/en/other-functions.html
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html

Suggested fix:
Move COUNT() FROM table in Other functions to the table in GROUP BY functions.

[23 Jun 2007 18:58] Valeriy Kravchuk

Thank you for a reasonable documentation request. While COUNT() should NOT be describe here:

http://dev.mysql.com/doc/refman/5.0/en/other-functions.html

it is already described here:

http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html

So, COUNT()'s description should just be removed from the first page.

[23 Jun 2007 21:46] Jakub Vrana

In the table on GROUP BY functions, there is only COUNT DISTINCT, COUNT is missing.

[25 Jun 2007 13:05] Peter Lavin

The COUNT function now appears in the table at the top of http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html.

Thanks for catching this error.