Problem Note 53732: A PROC SQL query might return incorrect results in dynamic locking domain in SAS® Scalable Performance Data Server
If you use the SQL procedure to submit concurrent queries in dynamic locking domain,
incorrect results might be returned.
The problem occurs when at least two separate client sessions are running.
One session must be querying a SAS Scalable Performance Data Server table
while another session is performing UPDATE or APPEND operations
against the same table.
In addition, the table must have defined indexes, and those indexes must be used in the query.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SPDS | Scalable Performance Data Server | Microsoft® Windows® for x64 | 5.1 HF1 | 5.1 HF2 | | |
Microsoft Windows Server 2003 for x64 | 5.1 HF1 | 5.1 HF2 | | |
Microsoft Windows Server 2008 for x64 | 5.1 HF1 | 5.1 HF2 | | |
Microsoft Windows Server 2012 Datacenter | 5.1 HF1 | 5.1 HF2 | | |
Microsoft Windows Server 2012 R2 Datacenter | 5.1 HF1 | 5.1 HF2 | | |
64-bit Enabled AIX | 5.1 HF1 | 5.1 HF2 | | |
64-bit Enabled Solaris | 5.1 HF1 | 5.1 HF2 | | |
HP-UX IPF | 5.1 HF1 | 5.1 HF2 | | |
Linux for x64 | 5.1 HF1 | 5.1 HF2 | | |
Solaris for x64 | 5.1 HF1 | 5.1 HF2 | | |
*
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.
If you are running more than one client session where one session is querying a table while another is performing UPDATE or APPEND operations, you might see incorrect results.
Type: | Problem Note |
Priority: | alert |
Date Modified: | 2014-08-29 11:24:45 |
Date Created: | 2014-07-24 07:45:34 |