MSCEWI3081
Snowflake Non-Ansi Outer Join has some functional differences compared to Oracle
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Severity
Low
Description
There are some functional differences between Oracle and Snowflake with the Non-Ansi Outer Join (+) syntax. For more information review the following EWIs: MSCEWI1059, MSCEWI1060, MSCEWI1061.
Example Code
Input Code:
SELECT * FROM
EMPLOYEE e, PRODUCT p WHERE
e.id(+) = p.eid;
Output Code:
SELECT *
/*** MSC-WARNING - MSCEWI3081 - SNOWFLAKE NON-ANSI OUTER JOIN SYNTAX HAS SOME FUNCTIONAL DIFFERENCES COMPARED TO ORACLE. IT COULD CAUSE COMPILATION ERRORS ***/
FROM PUBLIC.EMPLOYEE e, PUBLIC.PRODUCT p WHERE
e.id(+) = p.eid;
Recommendations
No end-user actions are required.
If you need more support, you can email us at [email protected]
Last updated