Problem Note 30546: SQL GROUP BY does not handle a missing GROUP BY value
If you specify a numeric missing value (.) in the SELECT list of a GROUP BY statement
and then reference the missing value, SAS SPD Server halts with a segmentation violation
error.
If you run the same query with the SAS System, SAS terminates with a floating point
exception error.
However, if you run the query and reference the missing value in the SELECT list with
a numeric column reference in the GROUP BY, the query succeeds.
Fixes have been made to both the SAS System and SAS SPD Server to correct this problem.
Operating System and Release Information
| SPDS | Scalable Performance Data Server | Tru64 UNIX | 4.4 | 4.4 | | 3.0 TS M0 |
| Solaris for x64 | 4.4 | 4.4 | | 3.0 TS M0 |
| HP-UX IPF | 4.4 | 4.4 | | 3.0 TS M0 |
| 64-bit Enabled Solaris | 4.4 | 4.4 | | 3.0 TS M0 |
| 64-bit Enabled HP-UX | 4.4 | 4.4 | | 3.0 TS M0 |
| 64-bit Enabled AIX | 4.4 | 4.4 | | 3.0 TS M0 |
| Windows | 4.4 | 4.4 | | 3.0 TS M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2007-11-27 18:54:37 |
| Date Created: | 2007-11-13 15:30:06 |
