SSC-EWI-0066

Expression not supported in Snowflake.

Severity

High

Description

This error is used to inform that a specific expression is not supported in Snowflake.

Example Code

Input Code:

IN -> Db2_01.sql

SELECT * from T1 where (cast('2016-03-17' as DATE), 
       cast('2016-03-21' as DATE)) OVERLAPS
       (cast('2016-03-20' as DATE), cast('2016-03-22' as DATE));

Output Code:

OUT -> Db2_01.sql

SELECT * from
       T1
where
       !!!RESOLVE EWI!!! /*** SSC-EWI-0066 - EXPRESSION 'OVERLAPS' IS NOT SUPPORTED IN SNOWFLAKE. ***/!!! (cast('2016-03-17' as DATE),
       cast('2016-03-21' as DATE)) OVERLAPS
       (cast('2016-03-20' as DATE), cast('2016-03-22' as DATE));

Recommendations

• If you need more support, you can email us at [email protected]