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 that there is currently no translation rule for such grammar, and therefore the whole code of the grammar clause is decorated with this EWI in order to inform the user that this is something that is likely not going to work in Snowflake.

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 [e-mail]