MSCEWI2024
Abort statement is not supported due to an aggregate function.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Severity
Low
Description
This warning appears when an AGGREGATE function is part of an ABORT statement inside of a stored procedure. The statement is commented in this case because it is not supported in Snowflake.
Code Example
Input Code:
REPLACE PROCEDURE ABORT_SAMPLE()
BEGIN
ABORT WHERE SUM(TABLE1.COL1) < 2;
END;
Output Code:
CREATE OR REPLACE PROCEDURE PUBLIC.ABORT_SAMPLE ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
{
/*** MSC-WARNING - MSCEWI2024 - ABORT STATEMENT IS NOT SUPPORTED DUE TO AN AGGREGATE FUNCTION ***/
/* ABORT WHERE SUM(TABLE1.COL1) < 2*/
;
}
$$;
Recommendations
If you need more support, you can email us at [email protected]
Last updated