Problem Note 17873: Extra WHERE clause may get added to query passed to databases
Using the LIBNAME engines to do an outer join of two DBMS tables can
result in the ON criteria being placed on a WHERE clause in addition to
the ON clause when the query is submitted to the database. This could
result in the incorrect rows being returned.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | Base SAS | Microsoft Windows XP Professional | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.2 TS1M0 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.2 TS1M0 |
| z/OS | 9.1 TS1M3 | 9.2 TS1M0 |
| Linux | 9.1 TS1M3 | 9.2 TS1M0 |
| HP-UX IPF | 9.1 TS1M3 | 9.2 TS1M0 |
| Linux on Itanium | 9.1 TS1M3 | |
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.2 TS1M0 |
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.2 TS1M0 |
| OpenVMS Alpha | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |
| Tru64 UNIX | 9.1 TS1M3 | 9.2 TS1M0 |
*
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: | alert |
| Topic: | SAS Reference ==> Procedures ==> SQL
SAS Reference ==> SQL
|
| Date Modified: | 2006-06-23 13:48:48 |
| Date Created: | 2006-06-14 12:17:02 |
