A query that contains an incorrect WHERE clause might be passed to the Database Management System (DBMS)


When you use Boolean logic in a BOOLEAN COMMENT variable with SAS/ACCESS® Interface to Netezza, an incorrect WHERE clause might be passed to the Netezza DBMS.

Here is an example. SAS does not pass syntax like the following:

SELECT "BOO_VAR" FROM booleantest WHERE "BOO_VAR"

SAS passes syntax like this:

SELECT "BOO_VAR" FROM booleantest WHERE ( "BOO_VAR" IS NOT NULL )

This returns both the "trues" and "falses" and not just the "trues."

The only workaround is to use explicit pass-through processing.