MSCEWI1074

Suffixes in numeric literals were removed

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

Severity

Low

Description

This warning is added when a numeric literal comes with a suffix. Any numeric value with suffix won't deploy in Snowflake.

Example Code

Oracle:

INSERT INTO binary_double_data_type_table VALUES(2.22507485850720E-308D);
INSERT INTO binary_double_data_type_table VALUES(1.79769313486231E+308d);

CALL procedure_binary_double(11.11d);

SELECT col1 FROM binary_double_data_type_table WHERE col1 > 33d;

SELECT 420.69d, 666D FROM DUAL;

INSERT INTO binary_float_data_type_table VALUES(1.17549E-38F);
INSERT INTO binary_float_data_type_table VALUES(3.40282E+38f);

CALL procedure_binary_float(11.11f);

SELECT col1 FROM binary_float_data_type_table WHERE col1 > 33f;

SELECT 420.69f, 666F FROM DUAL;

Snowflake:

INSERT INTO PUBLIC.binary_double_data_type_table VALUES(2.22507485850720E-308 /*** MSC-WARNING - MSCEWI1074 - SUFFIX REMOVED FROM NUMERIC LITERAL ***/);
INSERT INTO PUBLIC.binary_double_data_type_table VALUES(1.79769313486231E+308 /*** MSC-WARNING - MSCEWI1074 - SUFFIX REMOVED FROM NUMERIC LITERAL ***/);

CALL procedure_binary_double(11.11 /*** MSC-WARNING - MSCEWI1074 - SUFFIX REMOVED FROM NUMERIC LITERAL ***/);

SELECT col1 FROM PUBLIC.binary_double_data_type_table WHERE col1 > 33 /*** MSC-WARNING - MSCEWI1074 - SUFFIX REMOVED FROM NUMERIC LITERAL ***/;

SELECT
420.69 /*** MSC-WARNING - MSCEWI1074 - SUFFIX REMOVED FROM NUMERIC LITERAL ***/,
666 /*** MSC-WARNING - MSCEWI1074 - SUFFIX REMOVED FROM NUMERIC LITERAL ***/
FROM DUAL;

INSERT INTO PUBLIC.binary_float_data_type_table VALUES(1.17549E-38 /*** MSC-WARNING - MSCEWI1074 - SUFFIX REMOVED FROM NUMERIC LITERAL ***/);
INSERT INTO PUBLIC.binary_float_data_type_table VALUES(3.40282E+38 /*** MSC-WARNING - MSCEWI1074 - SUFFIX REMOVED FROM NUMERIC LITERAL ***/);

CALL procedure_binary_float(11.11 /*** MSC-WARNING - MSCEWI1074 - SUFFIX REMOVED FROM NUMERIC LITERAL ***/);

SELECT col1 FROM PUBLIC.binary_float_data_type_table WHERE col1 > 33 /*** MSC-WARNING - MSCEWI1074 - SUFFIX REMOVED FROM NUMERIC LITERAL ***/;

SELECT
420.69 /*** MSC-WARNING - MSCEWI1074 - SUFFIX REMOVED FROM NUMERIC LITERAL ***/,
666 /*** MSC-WARNING - MSCEWI1074 - SUFFIX REMOVED FROM NUMERIC LITERAL ***/
FROM DUAL;

Recommendations

• No additional user actions are required.

• If you need more support, you can email us at [e-mail]