Bug #61666 | #1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns | ||
---|---|---|---|
Submitted: | 28 Jun 2011 8:44 | Modified: | 28 Jun 2011 9:01 |
Reporter: | Devang Modi | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | mysql Ver 14.12 Distrib 5.0.45 | OS: | Linux (Red Hat Enterprise Linux Server release 5.3 (Tikanga)) |
Assigned to: | CPU Architecture: | Any | |
Tags: | #1140, GROUP, Mixing |
[28 Jun 2011 8:44]
Devang Modi
[28 Jun 2011 8:48]
Devang Modi
Dear Sir; Sorry I forgot to mention second error that we faced after adding SQL_MODE parameter. Error is "non-grouping field '' is used in HAVING clause" Devang
[28 Jun 2011 9:01]
Valeriy Kravchuk
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug. Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/ Thank you for your interest in MySQL.