Problem Note 62204: Incorrect SQL code is generated when you use a missing (null) value in combination with a logical OR in a Select node
When you use a Select node in SAS® Customer Intelligence, the expression uses a missing value and a logical OR operator, as follows:
However, the SQL code that is generated by the expression does not contain the missing values in the WHERE clause, as it should.
SELECT table0.CLIENTNUM AS CLIENTNUM LABEL='CLIENTNUM' FORMAT=F12.0
FROM ORADM.CLIENTS table0
WHERE table0.PSTCDAREA='AA'
To work around this problem, do not use the logical OR operator. Instead, select the value (in this case, AA) and (MISSING) at the same time, as shown below:
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Marketing Automation | Microsoft® Windows® for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
64-bit Enabled AIX | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
64-bit Enabled Solaris | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
HP-UX IPF | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Linux for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
Solaris for x64 | 6.5 | 6.6 | 9.4 TS1M3 | 9.4 TS1M6 |
*
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: | 2018-07-16 09:28:38 |
Date Created: | 2018-04-25 12:43:36 |