#163 Recognize field alias in HAVING clause

[Anonymous]

Exported from Bugzilla, issue 3701.

--- Comment added on 8/19/02 11:03:52 AM ---
Rodrigo Gomez, 8/19/2002
Hi there.

I don't know if this is already known, or if this is WAD.

The following statement will give an error (2.1, no patches)

SELECT
Value, COUNT(*) AS Total
FROM
MyTable
GROUP BY Value
HAVING Total > 10

If I change "HAVING Total > 10" for "HAVING COUNT(*) > 10" then it works
as expected

Is this a bug? I searched in the Fixes page but I didn't find it there,
that's why I posted it.

Thanks,

Rodrigo Gómez