[BUG]: Transpiler misses Oracle (+) operator essentially converting all outer joins to inner joins

[Tagar]

Is there an existing issue for this?

• I have searched the existing issues

Category of Bug / Issue

TranspileParserError

Current Behavior

[BUG]: Transpiler misses Oracle (+) operator essentially converting all outer joins to inner joins.

Oracle supports two ways to notate outer joins -

• Oracle-specific with the (+) operator -- example

           FROM WEB_STAGE.WCS_CATGROUP a,
                WEB_STAGE.WCS_CATGRPDESC b,
                WEB_STAGE.WCS_CATTOGRP c,
                ecom_dim.webstore d
          WHERE     A.CATGROUP_ID = b.catgroup_id(+)
                AND a.catgroup_id = C.CATGROUP_ID(+)
                AND A.MEMBER_ID = d.wcs_member_id(+)

• and another is the ANSI compliant.

Remorph just skips the (+) for Oracle queries so essentially Oracle converts all outer joins to inner joins when this Oracle specific outer join notation is used.

Trent Shapiro @ Databricks ran into this in a PS project and can provide more details.

Expected Behavior

converted query has explicit OUTER join clause

Steps To Reproduce

No response

Relevant log output or Exception details

Sample Query

Operating System

macOS

Version

latest via Databricks CLI