Re: group by can use alias from select list but not the having clause

The isn’t a bug as we explicitly document our deviation from the standard for group by.  You are correct that you are better off not using output column aliases in the group by specification. But we are not going to make doing so,an error and break countless applications relying upon the documented behavior.  But we are also not going to double-down and allow the undesirable deviation for having.

David J.