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

Results from Oracle 9.2.0.3 (9.2 patch 2)

===========
Connected to Oracle9i Release 9.2.0.3.0
Connected as system

SQL>
SQL> DROP TABLE TESTTAB;

DROP TABLE TESTTAB

ORA-00942: table or view does not exist

SQL> create table TESTtab (col integer);

Table created

SQL> select 1 as col from TESTtab having 1=0;

COL
----------

SQL> select 1 as col from TESTtab having 1=1;

COL
----------

SQL> insert into TESTtab values(1);

1 row inserted

SQL> insert into TESTtab values(2);

1 row inserted

SQL> select 1 as col from TESTtab having 1=0;

COL
----------

SQL> select 1 as col from TESTtab having 1=1;

COL
----------
1
1

SQL> DROP TABLE TESTTAB;

Table dropped

SQL>
===========