Skip to content

[BUG]: Conversion of Oracle outer joins with (+) syntax #2170

@mattslack-db

Description

@mattslack-db

Category of Bug / Issue

Conversion (Oracle, Snowflake)

Current Behavior

The Bladebridge converter currently does not support converting Oracle outer joins using the "+" operator, here is an example of this:

FROM
EMPLOYEE, BRANCH
WHERE
EMPLOYEE.BRANCH=BRANCH.BRANCH(+)

This is documented in the Oracle docs here: https://docs.oracle.com/database/121/SQLRF/queries006.htm#SQLRF52354.

Note that they do not recommend using it either! However Snowflake does support it.

Expected Behavior

This should convert to:

FROM
EMPLOYEE LEFT OUTER JOIN BRANCH ON EMPLOYEE.BRANCH=BRANCH.BRANCH

Metadata

Metadata

Assignees

No one assigned

    Labels

    bb converterIssues related to BB converterenhancementNew feature or request

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions