MSCEWI3070

Binary Operation Not Supported

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium

Description

A binary operation is not currently supported, a user defined function is added.

Example Code

Input Code:

-- Unsupported operation: EXCEPT DISTINCT
SELECT someValue MULTISET EXCEPT DISTINCT multiset_except FROM customers_demo;

Output Code:

-- Unsupported operation: EXCEPT DISTINCT
/*** MSC-ERROR - MSCEWI3070 - BINARY OPERATION MULTISET EXCEPT IS NOT SUPPORTED ***/
PUBLIC.MULTISET_EXCEPT_UDF('someValue MULTISET EXCEPT DISTINCT multiset_except')
FROM PUBLIC.customers_demo;

Recommendations

Last updated