Links
Comment on page

MSCEWI1086

Replaced invalid characters for new identifier

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]