Links

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]