Links

MSCEWI1074

Suffixes in numeric literals were removed

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.
  • For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.