MSCEWI4030
Warning while OUTER JOIN equivalence is checked.
Low
The current equivalency used to represent the OUTER APPLY in Snowflake is the LEFT OUTER JOIN, but this target statement must be checked and confirm if this transformation rule is accurate.
SELECT TOPS.* from Customers as C
OUTER APPLY (SELECT TOP 1 O.code
FROM Orders AS O
WHERE O.customer_id = C.customer_id
ORDER BY O.code) AS TOPS;
SELECT TOPS.* from Customers as C
LEFT OUTER JOIN (SELECT TOP 1 O.code
FROM Orders AS O
WHERE O.customer_id = C.customer_id
ORDER BY O.code) AS TOPS /*** MSC-WARNING - MSCEWI4030 - Equivalence from OUTER APPLY to LEFT OUTER JOIN must be checked. ***/;
- For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.
Last modified 1yr ago