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

Last updated