SSC-EWI-OR0020

Negative values not supported for function.

Severity

Medium

Description

Snowflake does not support negative values for the function, then this will cause different behavior when executed.

Example Code

Input Code:

IN -> Oracle_01.sql

SELECT INSTR('CORPORATE FLOOR','OR', -3, 2) FROM DUAL;

Output Code:

OUT -> Oracle_01.sql

SELECT
REGEXP_INSTR('CORPORATE FLOOR','OR', -3, 2) !!!RESOLVE EWI!!! /*** SSC-EWI-OR0020 - NEGATIVE VALUES NOT SUPPORTED FOR FUNCTION ***/!!! FROM DUAL;

Recommendations

• Create a User Defined Function that can handle the negative parameter or look for another alternative.

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