Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

FULL OUTER JOIN causes confusion #81

Open
petdance opened this issue Nov 25, 2024 · 0 comments
Open

FULL OUTER JOIN causes confusion #81

petdance opened this issue Nov 25, 2024 · 0 comments

Comments

@petdance
Copy link

select *
from users u
full outer join departments d on u.deptid = d.id

gets transformed into

SELECT
    *
FROM
    users u FULL
    OUTER JOIN departments d ON u.deptid = d.id

when it should get transformed into

SELECT
    *
FROM
    users u
    FULL OUTER JOIN departments d ON u.deptid = d.id

sleek works correctly if that's a LEFT OUTER JOIN.

SELECT
    *
FROM
    users u
    LEFT OUTER JOIN departments d ON u.deptid = d.id

The table aliases don't seem to affect it one way or the other.

SELECT
    *
FROM
    users FULL
    OUTER JOIN departments ON users.deptid = departments.id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant