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
| 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 |
*
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: | high |
| Topic: | SAS Reference ==> LIBNAME Engines
Data Management ==> Data Sources ==> External Databases ==> Sybase
|
| Date Modified: | 2007-03-28 08:38:33 |
| Date Created: | 2006-12-22 13:47:41 |
