Some parts of the output code are omitted for clarity reasons.
Description
This warning happens when a Subquery Restriction appears in a SELECT Statement.
Example Code
Input Code:
IN -> Oracle_01.sql
SELECT * FROM LATERAL(SELECT * FROM TABLITA WITH READ ONLY CONSTRAINT T);
Output Code:
OUT -> Oracle_01.sql
SELECT * FROM LATERAL(SELECT * FROM
TABLITA
-- --** SSC-FDM-OR0046 - THE SUBQUERY RESTRICTION IS NOT POSSIBLE IN SNOWFLAKE **
-- WITH READ ONLY CONSTRAINT T
);