MSCEWI3107

Label declaration not supported

This EWI was moved to General Issues. Now: MSCEWI1094.

Severity

Low

Description

Currently there is not equivalent for labels declaration in Snow Scripting so an EWI is added and the label is commented out

Example Code

Input Code:

CREATE OR REPLACE PROCEDURE Example ( grade NUMBER )
IS
BEGIN
	<<CASE1>><<CASE2>>
	CASE grade
		WHEN 10 THEN NULL;
		ELSE NULL;
	END CASE CASE1;
END;

Output Code:

CREATE OR REPLACE PROCEDURE PUBLIC.Example (grade FLOAT )
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
   BEGIN
      /*** MSC-WARNING - MSCEWI3107 - LABEL DECLARATION FOR A STATEMENT IS NOT SUPPORTED BY SNOWFLAKE SCRIPTING ***/
      /*<<CASE1>><<CASE2>>*/
      CASE grade
         WHEN 10 THEN
            NULL;
         ELSE
            NULL;
      END CASE;
   END;
$$;

Recommendations