Problem Note 56146: A PROC SQL query with SELECT DISTINCT returns a pass-through error on numeric variables that have a short length
Using the SAS® Scalable Performance Data Server to perform an SQL procedure might cause SQL pass-through errors. The problem occurs if the procedure:
- contains a SELECT DISTINCT statement that contains numeric variables with a length of less than 8
- and it is performed in conjunction with a large SORTSIZE= value.
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 | Solaris for x64 | 4.53 | 5.2 HF1 | | 9.4 TS1M3 |
| Linux for x64 | 4.53 | 5.2 HF1 | | 9.4 TS1M3 |
| HP-UX IPF | 4.53 | 5.2 HF1 | | 9.4 TS1M3 |
| 64-bit Enabled Solaris | 4.53 | 5.2 HF1 | | 9.4 TS1M3 |
| 64-bit Enabled HP-UX | 4.53 | 5.2 HF1 | | 9.4 TS1M3 |
| 64-bit Enabled AIX | 4.53 | 5.2 HF1 | | 9.4 TS1M3 |
| Microsoft Windows Server 2008 for x64 | 4.53 | 5.2 HF1 | | 9.4 TS1M3 |
| Microsoft Windows 8.1 Enterprise x64 | 4.53 | 5.2 HF1 | | 9.4 TS1M3 |
| Microsoft Windows 8 Enterprise x64 | 4.53 | 5.2 HF1 | | 9.4 TS1M3 |
| Microsoft® Windows® for x64 | 4.53 | 5.2 HF1 | | 9.4 TS1M3 |
*
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.
"SPDS_ERROR: SQL passthru expression contained errors" and "ERROR: SPDS Sql Passthru Error" occur when you issue a PROC SQL query with a SELECT DISTINCT. The issue occurs when a numeric variable is fewer than 8 bytes and the procedure is performed in conjunction with a large SORTSIZE= value.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2015-07-15 12:06:12 |
| Date Created: | 2015-07-09 14:01:26 |
