Links

MSCEWI2040

The format in a table is not supported.

Severity

Low

Description

The specified format is not supported.

Example Code

Input Code:

CREATE TABLE T_2040
(
C1 VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC FORMAT 'X(50)',
C2 VARCHAR(255) CHARACTER SET LATIN NOT CASESPECIFIC FORMAT 'X(75)'
);

Output Code:

CREATE TABLE PUBLIC.T_2040
(
C1 VARCHAR(255) COLLATE 'en-ci' /*** MSC-WARNING - MSCEWI2040 - FORMAT 'X(50)' NOT SUPPORTED ***/,
C2 VARCHAR(255) COLLATE 'en-ci' /*** MSC-WARNING - MSCEWI2040 - FORMAT 'X(75)' NOT SUPPORTED ***/
);

Recommendations

  • No additional user actions are required.
  • For INTEGER FORMAT '99:99:99' a workaround is to use TIME(6) in Snowflake.
  • If you need more support, you can email us at [email protected]