Problem Note 45757: The TSSQL procedure returns incorrect results for outer joins that use Index and Hash Join techniques
 |  |  |  |  |
PROC TSSQL returns incorrect results for outer joins that contain a WHERE clause and that use index or hash join techniques.
The WHERE clause does not evaluate correctly when the index or hash join techniques are used to perform the join.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Linux for x64 | 9.3 TS1M0 | 9.3 TS1M2 |
| Linux | 9.3 TS1M0 | 9.3 TS1M2 | ||
| HP-UX IPF | 9.3 TS1M0 | 9.3 TS1M2 | ||
| 64-bit Enabled Solaris | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Windows 7 Ultimate 32 bit | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Windows 7 Ultimate x64 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Windows Vista | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Solaris for x64 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Windows Vista for x64 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| 64-bit Enabled AIX | 9.3 TS1M0 | 9.3 TS1M2 | ||
| 64-bit Enabled HP-UX | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Windows 7 Professional x64 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Windows 7 Professional 32 bit | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Windows 7 Home Premium x64 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Windows 7 Home Premium 32 bit | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Windows 7 Enterprise x64 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Windows 7 Enterprise 32 bit | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Microsoft Windows XP Professional | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| Z64 | 9.3 TS1M0 | 9.3 TS1M2 | ||
| z/OS | 9.3 TS1M0 | 9.3 TS1M2 | ||
A fix for this issue for SAS Threaded Kernel DS2 and TSSQL Language Processors 9.32 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G39.html#45757| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-03-07 09:00:31 |
| Date Created: | 2012-02-22 10:07:28 |