Re: We are not following the spec for HAVING without GROUP

>>Comments?  Can anyone confirm whether DB2 or other databases allow
>>ungrouped column references with HAVING?
> 
> Oracle does not allow such references.  It issues "ORA-00979: not a
> GROUP BY expression" when you try to hand it such a reference.
> 
> MS SQL Server does not allow such references either, yielding
> "columnname is invalid in the HAVING clause because it is not
> contained in either an aggregate function or the GROUP BY clause.".
> 
> Can't comment about DB2.

MySQL allows it:

mysql> create table tab (col integer);
Query OK, 0 rows affected (0.01 sec)

mysql> select col from tab having 2 > 1;
Empty set (0.00 sec)

mysql> insert into tab values (1);
Query OK, 1 row affected (0.00 sec)

mysql> select col from tab having 2 > 1;
+------+
| col  |
+------+
|    1 |
+------+
1 row in set (0.00 sec)

Of course, that's not saying much!

Chris