Bug #8037 COUNT WITH HAVING

• Submitted: 20 Jan 2005 10:45
• Modified: 26 Jan 2005 7:20
• Reporter: Georg Richter
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.3
• OS: Linux (Linux)
• Assigned to: Timour Katchaounov
• CPU Architecture: Any

[20 Jan 2005 10:45] Georg Richter

Description:
SELECT COUNT(*) FROM table HAVING col2=2 fails with
Error: "Unknown column 'b' in having clause"

How to repeat:
CREATE TABLE t1 (a int, b int);
INSERT INTO t1 VALUES (1,2),(2,2);

SELECT COUNT(*) FROM t1 HAVING b=2
or
SELECT COUNT(*) FROM t1 GROUP BY a HAVING b=2