SSC-FDM-OR0008

Set Quantifier Not Supported

This FDM is deprecated, please refer to SSC-EWI-OR0071 documentation

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 behave unexpectedly.

Example Code

Input Code:

SELECT location_id  FROM locations 
MINUS ALL 
SELECT location_id  FROM departments;

Output Code:

SELECT location_id  FROM
locations
--** SSC-FDM-OR0008 - QUANTIFIER 'ALL' NOT SUPPORTED FOR THIS SET OPERATOR, RESULTS MAY DIFFER **
MINUS
SELECT location_id  FROM
departments;

In Snowflake, the INTERSECT and MINUS/EXCEPT operators will always remove duplicate values.

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]