Problem Note 5744: WHERE statement returns incorrect results
The WHERE statement returns incorrect results when specifying a range
and including additional conditions that fall outside of the range.
For example:
WHERE (a < 5 OR a > 10) AND a NE 8 AND a NE 9;
By modifying the WHERE clause to the following:
WHERE (a < 5 OR a > 10) AND (a NE 8 OR a NE 9);
the WHERE condition returns the correct results.
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#005744
For customers running SAS with Asian Language Support (DBCS), this
hot fix should be downloaded from:
http://www.sas.com/techsup/download/hotfix/82_dbcs_prod_list.html#005744
Operating System and Release Information
| SAS System | Base SAS | Microsoft Windows 2000 Server | 8 TS M0 | 9 TS M0 |
| Microsoft Windows 95/98 | 8 TS M0 | |
| Microsoft Windows NT Workstation | 8 TS M0 | 9 TS M0 |
| Microsoft Windows 2000 Datacenter Server | 8 TS M0 | 9 TS M0 |
| Microsoft Windows 2000 Professional | 8 TS M0 | 9 TS M0 |
| Microsoft Windows 2000 Advanced Server | 8 TS M0 | 9 TS M0 |
| Solaris | 8 TS M0 | 9 TS M0 |
| OpenVMS VAX | 8 TS M0 | 9 TS M0 |
| OS/2 | 8 TS M0 | |
| IRIX | 8 TS M0 | 9 TS M0 |
| 64-bit Enabled Solaris | 8 TS M0 | 9 TS M0 |
| z/OS | 8 TS M0 | 9 TS M0 |
| 64-bit Enabled HP-UX | 8 TS M0 | 9 TS M0 |
| ABI+ for Intel Architecture | 8 TS M0 | 9 TS M0 |
| HP-UX | 8 TS M0 | 9 TS M0 |
| Tru64 UNIX | 8 TS M0 | 9 TS M0 |
| 64-bit Enabled AIX | 8 TS M0 | 9 TS M0 |
| OpenVMS Alpha | 8 TS M0 | 9 TS M0 |
| CMS | 8 TS M0 | 9 TS M0 |
| AIX | 8 TS M0 | 9 TS M0 |
*
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 |
| Date Modified: | 2002-04-25 15:06:56 |
| Date Created: | 2001-08-28 09:53:31 |