Bug #4550 count(*) query causes invalid 'must group by' error
Submitted: 14 Jul 2004 20:10 Modified: 16 Jul 2004 18:00
Reporter: Matthew Moody Email Updates:
Status: Closed Impact on me:
Category:MySQL Query Browser Severity:S1 (Critical)
Version:1.0.2 Alpha OS:Microsoft Windows (Win2k)
Assigned to: Alfredo Kojima CPU Architecture:Any

[14 Jul 2004 20:10] Matthew Moody
When attempting to perform the following query the resultant error error message is displayed:

SELECT count(*)
FROM Table1

Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause

How to repeat:
With MySQL Query Browser, enter the following query:

SELECT count(*)
FROM Table1
[16 Jul 2004 18:00] Alfredo Kojima
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at