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:
SELECT * FROM TABLE1 CONTAINS (TextColumn, 'search term') AS Score;
Output Code:
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]
Last updated