MSCEWI3071
Set Quantifier Not Supported
Low
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.
SELECT location_id FROM locations
MINUS ALL
SELECT location_id FROM departments;
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;
- Check alternatives in Snowflake to emulate the functionality of the "all" quantifier.
Last modified 3mo ago