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 | ||
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#015395A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#015395| Type: | Problem Note |
| Priority: | alert |
| Topic: | SAS Reference ==> Procedures ==> ACCESS |
| Date Modified: | 2005-10-10 08:50:57 |
| Date Created: | 2005-05-27 10:56:45 |