sleek icon indicating copy to clipboard operation
sleek copied to clipboard

FULL OUTER JOIN causes confusion

Open petdance opened this issue 1 year ago • 0 comments

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

petdance avatar Nov 25 '24 22:11 petdance