Incorrect results might be returned when you submit an SQL procedure join with an additional WHERE clause that contains the AND or the OR logical operator followed by parentheses.

In rare cases, SAS/ACCESS^® Interface to Teradata misplaces parentheses in WHERE clauses that are passed to Teradata for evaluation.

For example, suppose you submit the following code:

In this case, the software translates the WHERE clause as follows, which leads to an incorrect result:

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: