MSCEWI3036
Types resolution issues, the arithmetic operation may not behave correctly between string and date.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Severity
Low
Description
This issue happens when an arithmetic operation may not behave correctly between two certain data types.
Example Code
Input Code:
-- Given the following table
CREATE TABLE TIMES(
AsDate Date,
AsIntervalDaySecond varchar(20)
);
-- An arithmetic operation between two data types that may not behave correctly
SELECT TIMES.AsIntervalYearMonth + TIMES.AsDate FROM TIMES;
Output Code:
-- Given the following table
CREATE OR REPLACE TABLE PUBLIC.TIMES (
AsDate Date,
AsIntervalDaySecond varchar(20));
-- An arithmetic operation between two data types that may not behave correctly
SELECT
/*** MSC-WARNING - MSCEWI3036 - TYPES RESOLUTION ISSUES, ARITHMETIC OPERATION '+' MAY NOT BEHAVE CORRECTLY BETWEEN String AND Date ***/
TIMES.AsIntervalDaySecond + TIMES.AsDate FROM PUBLIC.TIMES;
Recommendations
No additional user actions are required.
If you need more support, you can email us at [email protected]
Last updated