Last updated
Last updated
This message is added when a pattern-matching condition uses arguments with COLLATE specifications, as they are not currently supported in Snowflake's regular expression function. Consequently, the COLLATE clause must be disabled to use this function, which may result in differences in the results.
Output Code:
If you require equivalence for these scenarios, you can manually add the following parameters to the function to achieve functional equivalence:
For more information please refer to the following .
If you need more support, you can email us at
TRUE
FALSE
FALSE
FALSE
Parameter
Description
c
Case-sensitive matching
i
Case-insensitive matching
The use of the COLLATE column constraint has been disabled for this pattern-matching condition