SUPPORT / SAMPLES & SAS NOTES
Problem Note 15395: An incorrect table name may be generated in a subquery expression when using implicit Pass-Through causing a performance degradation
 |  |  |  |  |
When using a subquery within PROC SQL, the table name may be interpreted incorrectly. This only occurs when using implicit Pass-through. If it is interpreted wrong then this will cause a performance degradation.
Select 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 | SAS/ACCESS Interface to Sybase | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to Teradata | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to SAP BW | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to PeopleSoft | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to R/3 | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to Oracle | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to Oracle Rdb | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to OLE DB | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to MySQL | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to Informix | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to IMS-DL/I | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to DB2 | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to DB2 Server for VM | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to CA-OpenIngres | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to CA-IDMS | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to Baan | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to CA-Datacom/DB | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| SAS System | SAS/ACCESS Interface to Adabas | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 |
| 64-bit Enabled Solaris | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Linux | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP1 | 9.1 TS1M3 SP3 | ||