MSCEWI1086

Replaced invalid characters for new identifier

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

The given identifier has invalid characters for the output language. Those characters were replaced with their UTF-8 codes.

Example Code

Input Code:

CREATE PROCEDURE PROC1
AS
    "VAR0" int;
    "VAR`/1ͷ" varchar(20);
    "o*/o" float;
    " . " int;
    ". ." int;
    "123Name" int;
    "return" int;
    yield int;
    ident#10 int;
BEGIN
    NULL;
END;

Output Code:

CREATE OR REPLACE PROCEDURE PUBLIC.PROC1 ()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
    // SnowConvert Helpers Code
    let VAR0;
    let
    //** MSC-WARNING - MSCEWI1086 - IDENTIFIER '"VAR`/1ͷ"' HAS INVALID CHARACTERS. CHARACTERS WERE REPLACED WITH THEIR UTF-8 CODES **
    VAR_u60_u2F1ͷ;
    let
    //** MSC-WARNING - MSCEWI1086 - IDENTIFIER '"o*/o"' HAS INVALID CHARACTERS. CHARACTERS WERE REPLACED WITH THEIR UTF-8 CODES **
    o_u2A_u2Fo;
    let
    //** MSC-WARNING - MSCEWI1086 - IDENTIFIER '" . "' HAS INVALID CHARACTERS. CHARACTERS WERE REPLACED WITH THEIR UTF-8 CODES **
    _u20_u2E_u20;
    let
    //** MSC-WARNING - MSCEWI1086 - IDENTIFIER '". ."' HAS INVALID CHARACTERS. CHARACTERS WERE REPLACED WITH THEIR UTF-8 CODES **
    _u2E_u20_u2E;
    let _123Name;
    let _return;
    let YIELD;
    let IDENT_HASHTAG_10;
    null;
$$;

Recommendations

• No end-user actions are required.

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