Links

MSCEWI1046

Verification of functional equivalence for the function is pending.

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.
  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.