MSCEWI3071

Set Quantifier Not Supported

Severity
Low
Description
Quantifier 'all' is not supported in Snowflake. The modifier is removed from the source code and a warning is added, the resulting code may behaves unexpectedly.
Example Code
Input Code:
SELECT location_id  FROM locations 
MINUS ALL 
SELECT location_id  FROM departments;
Output Code:
SELECT location_id  FROM PUBLIC.locations
/*** MSC-WARNING - MSCEWI3071 - QUANTIFIER 'ALL' REMOVED FROM THE SOURCE CODE, IT MAY BEHAVES UNEXPECTEDLY ***/
MINUS
SELECT location_id  FROM PUBLIC.departments;
Recommendations
Check alternatives in Snowflake to emulate the functionality of the "all" quantifier.
If you need more support, you can email us at [email protected]​

MSCEWI3070

MSCEWI3072

Last modified 3mo ago