SUPPORT / SAMPLES & SAS NOTES
Problem Note 19240: Selecting a column that contains null values for autopartitioning when DBSLICEPARM=ALL might generate incorrect data
 |  |  |  |  |
The problem occurs because a set of parentheses is missing in the added autopartitioning WHERE clause that SAS/ACCESS® Interface to Sybase generates. The problem might rarely occur because Sybase does not allow null values by default, and a column with an INT data type that allows null values is the last choice for autopartitioning. However, the problem can occur and produce incorrect results without any warning.
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 | 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.2 TS1M0 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Linux | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.2 TS1M0 | ||