|
V6-QUERY-D792
Incorrect HAVING clause generated in the SQL Query Window
|
In Release 6.12 of the SAS System, an incorrect HAVING clause may be
generated for a DBMS access mode in the SQL Query Window when the
COUNT function is used. Generally, the quotes around the column name
are incorrect. For example:
HAVING COUNT(A1."COLUMN)"
The problem has been corrected in Release 6.12 TSLEVEL
045 of the SAS System.
| Products: | BASE |
| Component: | QUERY |
| Priority: | HIGH |
| Status: | Outstanding Problem |
| Date: | Wed, 26 Nov 1997 |
| System | Release Reported | Release Fixed |
| AIX/6000 | 6.12 TS020 | 6.12 TS045 |
| HP-UX Operating Systems | 6.12 TS020 | 6.12 TS045 |
| IBM OS/2 | 6.12 TS020 | 6.12 TS045 |
| Solaris | 6.12 TS020 | 6.12 TS045 |
| OpenVMS Alpha | 6.12 TS020 | 6.12 TS045 |
| Windows 3.11 | 6.12 TS020 | 6.12 TS045 |
| Windows NT | 6.12 TS020 | 6.12 TS045 |
| Windows 95 | 6.12 TS020 | 6.12 TS045 |
No Fixes Available