SSC-EWI-0073

Pending Functional Equivalence Review

Severity

Medium

Description

This EWI is added when there is a grammar clause in the input platform that has not been reviewed yet by the SnowConvert developer team, in order to provide support for it in Snowflake. That means the code has not been transformed in any way and therefore, is something that may not work in Snowflake without some manual revision.

Example Code

SQLServer:

Input Code

IN -> SqlServer_01.sql

CREATE OR ALTER PROC SampleProcedure
AS
BEGIN
   INSERT INTO aTable (columnA = 'varcharValue', columnB = 1);
   INSERT exampleTable VALUES ('Hello', 23);
   INSERT INTO exampleTable DEFAULT VALUES;
END

Output Code

OUT -> SqlServer_01.sql

CREATE OR REPLACE PROCEDURE SampleProcedure ()
RETURNS VARCHAR
LANGUAGE SQL
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"transact"}}'
EXECUTE AS CALLER
AS
$$
   BEGIN
      INSERT INTO aTable (columnA = 'varcharValue', columnB = 1);
      INSERT INTO exampleTable VALUES ('Hello', 23);
      !!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'INSERT WITH DEFAULT VALUES' NODE ***/!!!
      INSERT INTO exampleTable DEFAULT VALUES;
   END;
$$;

Notice in line 6 of the input code, that there is a reference to a INSERT statement with DEFAULT VALUES, this is currently a not supported statement by SnowConvert and that is why in lines 11 and 12 the EWI is generated.

Recommendations

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