SSC-EWI-SY0008

Contains clause not supported in Snowflake.

Severity

High

Description

In Sybase the CONTAINS clause following a table name to filter the table and return only those rows matching the full text query specified with contains-query. Every matching row of the table is returned together with a score column that can be referred to using score-correlation-name. Snowflake does not support this behavior.

Code Examples

Input Code:

Sybase

IN -> Sybase_01.sql

SELECT * FROM TABLE1 CONTAINS (TextColumn, 'search term') AS Score;

Output Code:

Snowflake

OUT -> Sybase_01.sql

SELECT
  *
FROM
  TABLE1
         !!!RESOLVE EWI!!! /*** SSC-EWI-SY0008 - CONTAINS CLAUSE NOT SUPPORTED IN SNOWFLAKE ***/!!!
         CONTAINS(TextColumn,'search term') AS Score;

Recommendations

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