19240 - Selecting a column that contains null values for autopartitioning when DBSLICEPARM=ALL might generate incorrect data

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

* 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.

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#019240

A 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#019240

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