Problem Note 38835: Incorrect results may be returned from SQL GROUP BY query against a SAS® Scalable Performance Data Server table with sort order applied
 |  |  |  |  |
Under the following conditions, SAS® Scalable Performance Data Server can return incorrect results:
- The statement contains a GROUP BY for a single column.
- The table is sorted by the GROUP BY column.
- There is a WHERE clause on the GROUP BY statement.
- The query could not be performed via the SAS Scalable Performance Data Server parallel GROUP BY optimization.
The SQL planner relies on the table being returned in its original order. However, in the case of a WHERE clause being applied to the GROUP BY table, the original sort order is not preserved.
Select the Hot Fix tab to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SPDS | Scalable Performance Data Server | Windows 7 Professional x64 | 4.51 | 4.52 | ||
| Windows 7 Professional 32 bit | 4.51 | 4.52 | ||||
| Windows 7 Home Premium x64 | 4.51 | 4.52 | ||||
| Windows 7 Home Premium 32 bit | 4.51 | 4.52 | ||||
| Windows 7 Enterprise x64 | 4.51 | 4.52 | ||||
| Windows 7 Enterprise 32 bit | 4.51 | 4.52 | ||||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 4.51 | 4.52 | ||||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 4.51 | 4.52 | ||||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 4.51 | 4.52 | ||||
| Solaris for x64 | 4.51 | 4.52 | ||||
| HP-UX IPF | 4.51 | 4.52 | ||||
| 64-bit Enabled Solaris | 4.51 | 4.52 | ||||
| 64-bit Enabled HP-UX | 4.51 | 4.52 | ||||
| 64-bit Enabled AIX | 4.51 | 4.52 | ||||
| Windows 7 Ultimate x64 | 4.51 | 4.52 | ||||
| Linux | 4.51 | 4.52 | ||||
| Linux for x64 | 4.51 | 4.52 | ||||
| Windows 7 Ultimate 32 bit | 4.51 | 4.52 | ||||
A fix for this issue for Scalable Performance Data Server 4.51 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A49.html#38835A fix for this issue for SPD Server 4.4 is available at:
http://www.sas.com/techsup/download/hotfix/spds44.html#038835| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2010-03-03 17:52:43 |
| Date Created: | 2010-02-23 15:36:27 |