|
V6-QUERY-9758
Incorrect ORDER BY generated when column expression used for some DBMSs
|
In Releases 6.11 and 6.12 of the SAS System, an incorrect ORDER BY
clause may be generated when your access mode is Oracle, ODBC or SYBASE.
The problem occurs when you use BUILD A COLUMN from the SQL QUERY
COLUMNS window to generate a column expression and then use the
expression to arrange the query results using a ORDER BY clause.
For access modes of Oracle or ODBC, the clause will be:
order by sum("a1.columnname)"
where the ending quote incorrectly placed outside the right parenthesis.
When your access is mode is SYBASE, the clause will be:
order by sum a1.columnname)
where the double quotes and left parenthesis are omitted.
This problem is corrected at TSLEVEL 045 of Release 6.12.
| Products: | BASE |
| Component: | QUERY |
| Priority: | HIGH |
| Status: | Outstanding Problem |
| Date: | Wed, 26 Nov 1997 |
| System | Release Reported | Release Fixed |
| AIX/6000 | 6.11 TS020 | 6.12 TS045 |
| HP-UX Operating Systems | 6.11 TS020 | 6.12 TS045 |
| IBM OS/2 | 6.11 TS020 | 6.12 TS045 |
| Solaris | 6.11 TS020 | 6.12 TS045 |
| Windows 3.11 | 6.11 TS020 | 6.12 TS045 |
| 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 |
| Intel ABI | 6.11 TS040 | |
| Silicon Graphics Unix | 6.11 TS040 | |
| Compaq Tru64 Unix | 6.11 TS040 | 6.12 TS040 |
| Windows NT | 6.11 TS040 | 6.12 TS045 |
| Windows 95 | 6.11 TS040 | 6.12 TS045 |
| Compaq Tru64 Unix | 6.12 TS040 | |
| Macintosh | 6.12 TS040 |
No Fixes Available