SSC-EWI-TD0024

Abort statement is not supported due to an aggregate function.

Severity

Low

Description

This EWI appears when an AGGREGATE function is part of an ABORT statement inside of a stored procedure. The statement is commented out.

Example Code

Teradata:

IN -> Teradata_01.sql

REPLACE PROCEDURE ABORT_SAMPLE()
BEGIN 
    ABORT WHERE SUM(TABLE1.COL1) < 2;
END;

Snowflake Scripting:

OUT -> Teradata_01.sql

CREATE OR REPLACE PROCEDURE ABORT_SAMPLE()
RETURNS VARCHAR
LANGUAGE SQL
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"teradata"}}'
EXECUTE AS CALLER
AS
$$
    BEGIN
        !!!RESOLVE EWI!!! /*** SSC-EWI-TD0024 - ABORT STATEMENT IS NOT SUPPORTED DUE TO AN AGGREGATE FUNCTION ***/!!!
        ABORT WHERE SUM(TABLE1.COL1) < 2;
    END;
$$;

Recommendations

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