MSCEWI1046

Verification of functional equivalence for the function is pending.

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

Severity

Low

Description

After preliminary research, the function was determined to have an equivalent function in Snowflake. The transformation involves only changing the result slightly by using the name of the Snowflake function (or not at all, in some cases).

The warning is added for the user to be aware that there might be some scenarios where the mapped function is not 100% functionally equivalent.

Code Example

Input Code:

SELECT MAX(10);

Output Code:

SELECT MAX(10) /*** MSC-WARNING - MSCEWI1046 - 'MAX' FUNCTION MAPPED TO 'MAX', FUNCTIONAL EQUIVALENCE VERIFICATION PENDING ***/;

Recommendations

• For the most part, these warnings are just informative. If you find that a function that has this warning attached does not work as intended, please contact us.

• If you need more support, you can email us at [email protected]