SSC-FDM-PG0013
Function syntactically supported by Snowflake but may have functional differences
Description
This functional difference message indicates that while Snowflake supports the function's syntax (either directly or through an equivalent mapping), its behavior might be different from the original in some situations.
Code Example
Input Code:
SELECT
LISTAGG(skill) WITHIN GROUP (ORDER BY skill) OVER (PARTITION BY
employee_name) AS employee_skills
FROM
employees;
Output Code:
SELECT
--** SSC-FDM-PG0013 - FUNCTION SYNTACTICALLY SUPPORTED BY SNOWFLAKE BUT MAY HAVE FUNCTIONAL DIFFERENCES **
LISTAGG(skill) WITHIN GROUP (ORDER BY skill) OVER (PARTITION BY
employee_name) AS employee_skills
FROM
employees;
Recommendations
Carefully evaluate the functional behavior for unexpected results, as differences may only occur in specific scenarios.
If you need more support, you can email us at [email protected]
Last updated